Becoming a Microsoft MVP

I was awarded the Microsoft MVP (data platform) award on Saturday.
On the four days a year (one per quarter) when...

Pinned Tabs

It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b)...

Nil to Speaker: Improving your PowerPoint skills

As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve...

A quick fix for a full identity column.

A while back I wrote a post on everything I knew about identity columns. In it I mentioned the following:
Negative...

Using an ORDER BY in a view

For many years it’s been a best practice to never put an ORDER BY in a view. The idea is...

Emojis in SQL Server

I blame Aaron Bertrand (b/t) and Kevin Kline (b/t). Aaron who posted a great #BackToBasics blog about naming stored procedures...

Azure: Creating a BACPAC from an On-Premises SQL Server Database

So to start, what’s a BACPAC?

Per the Azure documentation
When you need to create an archive of an Azure SQL database,...

SA Spoof

This is nothing new but it’s still a fun idea.

The problem:
The vendor app we just purchased (and are told we...

Accidental DBAs, the Developer Edition

I recently spoke at the OKC SQL Saturday. I had an wonderful time and the organizers, volunteers and other speakers...

The new Data Migration Assistant has been released!

Monday Bob Ward (b/t) announced on twitter that the new Data Migration Assistant had been released.

First things first the DMA...