SQL Server Automatic Tuning in the Real-World

In SQL Server 2016 we saw Query Store.  Query Store was a game changer to help database administrators identify troublesome queries. Query Store helps DBAs make those queries run...

PASS Summit 2018 – Scheduled Released

The “full” PASS Summit 2018 schedule has been released. This includes the regular sessions along with the pre-conference sessions which...

PASS Summit 2018 – Scheduled Released

The “full” PASS Summit 2018 schedule has been released. This includes the regular sessions along with the pre-conference sessions which were released a couple of months ago.

Wednesday thru Friday...

Azure Data Warehouse and 60 Servers

In today’s segment of Azure Every Day, I’d like to talk about Azure Data Warehouse and to help you understand...

Best Way to Fix Corrupted SQLite Database

Corruption is one of the common scenarios nowadays. It can occur in any platform or file format, for that matter. Similarly, Android SQLite database can be corrupted due to...

Best Way to Fix Corrupted SQLite Database

Corruption is one of the common scenarios nowadays. It can occur in any platform or file format, for that matter....

External Access to Azure Storage

There are multiple ways to allow external access to Azure storage accounts, some better (and more secure) than others. Today,...

FizzBuzz and Multiple Recursive Member CTEs

Watch this week’s episode on YouTube.
Last week I needed to write a recursive common table expression.  I’ve written them before,...

I will be speaking at SQL Saturday # 788 – Denver

I’m very thrilled to announce that I will be participating as speaker in Denver’s SQL Saturday that will take place on...

Rant: There Is No NoSQL Data Storage Engine

Do I need relational or NoSQL? How does NoSQL help me scale? Will I get paid better with NoSQL or...