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

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