New Resumable Online Index Create SQL Server 2019

SQL Server 2019 brings a very exciting new feature that, is long overdue. Resumable online index create is one of...

Adding the Constraint Name to the PK at the End of Create Table–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Price increase for Azure in Canadian dollars

On 1 December 2018, Microsoft is increasing Azure subscription prices in Canadian dollars by 5%. The following is taken directly...

A curious case of case when and Null values

For some reason I have always written my Case statements using the following logic:

SELECT
CASE
WHEN @Priority = 1 THEN 'Very High'
WHEN @Priority...

How to be an MVP Book

When it comes to characteristics of an MVP, the two groups (geek and jock) are no longer at the opposite ends of the spectrum. Rather, they are very similar...

How to be an MVP Book

How to be an MVP in LIFE
One of the fun things about being involved in the community is the opportunity...

Oh Query, Query, Query

I thought I would post this a bit early so everyone can memorize the words before Hanukka starts next week.
I...

Early Bird SQL Bits Pricing

You can register today and save for the next few days. It’s only £799 for the full SQL Bits 2019...

Gathering all the Logs and Running the Availability Group Failover Detection Utility with PowerShell

30/11/2018 – Function has been updated to deal with named instances.
Last week the Tiger Team released their Availability Group Failover Detection...

PASS Summit 2018 - A Lesson in Personal Branding

Last year at PASS Summit 2017, I heard a number of comments related to people not recognizing me without the hat in my social media photo/avatar. The linked post...