Power BI Custom Visuals Class (Module 54 – Route Map)
In this module you will learn how to use the Route Map Power BI Custom Visual. The Route Map uses...
2017-06-06
754 reads
Blog Posts
Reverse It
Recently I had a conversation with a colleague that wasn’t aware of the REVERSE function in SQL Server. I had...
2017-06-06
143 reads
Reverse It
Recently I had a conversation with a colleague that wasn’t aware of the REVERSE function in SQL Server. I had...
2017-06-06
368 reads
SQL Server 2016 What's New With TSQL
DROP IF EXISTS
This allows us to drop objects without first having to check if they exist. It works on pretty...
2017-06-06
51 reads
SSRS Subscription Schedules
Reporting Services
Reporting Services (SSRS) is a tool that permits you to create and deliver feature rich reports. The reports can...
2017-06-06 (first published: 2017-05-23)
4,110 reads
T-SQL Tuesday #091 – Databases and DevOps
Implementing DevOps with databases presents a unique set of challenges. However, just because something might be hard doesn’t mean that...
2017-06-06
424 reads
var Microsoft_Data_Platform_MVP = “Yip.”;
The 2nd June 2017 will always be something of a special day for me.
It was the day I was awarded...
2017-06-06
651 reads
Working with Data in Always Encrypted
In this post we’re going to create some encrypted columns in a table in a test database and look at...
2017-06-06
10,669 reads
An Unexpected Side-Effect of Invoke-WebRequest
Recently I was working on a bit of PowerShell to download the awesome First Responder Kit from Brent Ozar Unlimited. The canonical URL for the FRK is http://firstresponderkit.org/ but...
2017-06-05
12 reads
Backup to NUL
Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In...
2017-06-05
6,241 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers