Different Ways to Handle Deadlock in SQL Server

Introduction To Deadlock
Deadlock in SQL server is a condition in which two or more system server processes IDS (SPIDs) are...

Hello Cloud Goodbye DBA

No, not quite. I have had many interesting conversations around this topic and I don’t think (personal opinion) that DBAs...

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

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

Only one Log Reader Agent can connect to a database at a time error – Transaction Replication/CDC

An interesting issue regarding SQL Server Transaction Replication/CDC log reader agent job can’t be started with the following error:

Msg 18752, Level...

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

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

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

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

Watch My Keynote: Adapt and Thrive (25 minutes)

Do you know where your career is going? Do you know what skills you need to be successful in the current climate? In this 25 minute keynote, I discuss the...