Data Professionals at Work Book

Working as a Data Professional

An old friend Malathi Mahadevan (b | t) asked me one day if I would be interested...

SQL Server Guide To NULL Handling

Every language handles null equality differently and understanding this is crucial as a misunderstanding here can lead to some quite...

Tips for Attending a SQL Saturday

Matt (blog | twitter) is preparing for his first SQL Saturday presentation next weekend in Washington, DC. He’s asked:
I wanted to get an idea of some good, bad, and...

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