Thank you to @MrDenny

I wanted to take a quick moment to thank Denny Cherry for selecting me for Speaker Idol this year.

For...

Why I don’t love SELECT INTO

Long ago there were locking / blocking problems with the SELECT INTO statement. That’s not the case anymore and for AdHoc...

Read this before using SQL 2016 Temporal Tables

I’ve been testing the new Temporal Tables feature over the past day to see about using it in one of...

A quick note comparing ISNULL vs COALESCE

There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also...

Off-topic: If you’re in Texas and 18+ yrs old

Today is the last day to register to vote in Texas. I’m not sure about other states in the US...

Making the case for CamelCase naming

Coding and database standards like a religion or politics. Some people are fanatics and others really don’t care whatsoever. Getting...

Understanding the new MAXDOP settings in SQL 2016

If you have just begun using SQL Server 2016 or you have been using it for a while now you...

SQL 2016 SSMS memory leak?

Has SSMS (SQL Server Management Studio) been crashing on you? Have you been getting Out of Memory messages when attempting...

An observation about Unicode in SQL Server Management Studio

A week or so ago I read a blog post and tweet about using an emoji in SQL Server. This...

I’m speaking at SQL PASS 2016 (Speaker Idol)

It’s always been my dream to speak at SQL PASS Summit. It’s a tough egg to crack. In my experience...