Azure SQL Database Managed Instance

As of October 2018, Azure SQL Database Managed Instance is now generally available in the general purpose tier. Business Critical...

Generate a random number of children for each parent

I was asked an interesting question the other day.
Is it possible to get a different random number of rows...

Query to determine XE Session status

On a previous post, we discussed what is an extended event (XE) and how to create one.

With the following T-SQL...

how to embed a PowerBI report into HTML code

PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the...

Data Factory V2 Activity Dependencies are a Logical AND

Azure Data Factory V2 allows developers to branch and chain activities together in a pipeline. We define dependencies between activities as...

Why Wont SQL Server Use My Filtered Index?

As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can...

Why Wont SQL Server Use My Filtered Index?

As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can...

Checking for Membership of a Specific Active Directory Group

As part of my job I manage a bunch of SQL instances for Development and Test.
Access is managed though Active...

Go Green with Blue Using Azure

Is your company working on ways to become more environmentally friendly? Taking care of the environment is an important topic,...

Starting SSMS with a specific connection and script file

Have you ever wanted SSMS to start and automatically and establish a connection to your DBA \ hub server and have...