Notes from SQLSaturday #801 (2018)

We wrapped up our 12th SQLSaturday here in Orlando two weeks ago. Overall things went well. Registration was just a...

SQL Server 2019

I have written about 2017 here, Last month at Microsoft Ignite FL on September 2018, Microsoft announce they are going to...

Sharding: Horizontal Scaling in Azure SQL Database

David has produced a talk all about Sharding. Or if you prefer  horizontally scaling your Azure SQL database.

You can view...

SQL Server – Reading BACPAC Files

If you have been reading my blog for a while now you would know that a common technique to move...

Contextual View Part II or how to hide sensitive data

In this article I continue to explore the ways to secure the data via contextual views and describe the technique...

Creating Wait stats widget on Azure Data Studio for macOS

A couple of weeks ago, Microsoft released a new multi-platform tool called Azure Data Studio, this tool is the final...

Step-by-Step: How to Trigger an Email Alert from Windows Performance Monitor

Windows Performance Counter Alerts can be configured to be triggered on any Performance Monitor (Perfmon) Counter through the use of...

The Project Graveyard

This post is a response to this month’s T-SQL Tuesday #107 prompt by Jeff Mlakar.  T-SQL Tuesday is a way...

Fix SQL Server with one click

Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration...

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...