Introducing The Undercover Catalogue

In this video, David give a quick introduction into the Undercover Catalogue.

First Time SQL Saturday Speaker Tips

A few years ago, I wrote about my first experience speaking at SQL Saturday. Recently I had a conversation with one of our first-timers speaking at SQL Saturday Rochester...

How I passed the 70-761 certification exam

FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over 20 years. Second FUN FACT: the last time I took a Microsoft certification exam was...

How I passed the 70-761 certification exam

FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over 20 years. Second FUN FACT: the last time I took a Microsoft certification exam was...

Controlling who commits code to a given database schema in Git with Azure DevOps

One of most the fun things about working as an Advocate at Redgate is getting to help clients determine their preferred workflow for database DevOps. Teams often have unique...

Changing MaxDop For Resumable Index Create Operations

I’ll admit it, sometimes I’m wrong. Recently I blogged about the usefulness of a newer feature that was enhanced with the release of SQL Server 2019.  Resumable Indexes operations...

Azure Storage tips

As a followup to my blog post Azure Data Lake Store Gen2 is GA, I wanted to give some pointers when using ADLS Gen2 as well as blob storage,...

Managing Agent Jobs on Availability Group Servers

As always, the scripts in this post can also be found on our Git Hub repo, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/CatagoryControlledAgentJobs.sql Agent jobs, they can be a right pain to manage when you’re...

Permissions required for row counts to show up on Object Explorer Details

I ran into a rather obscure permissions problem the other day. Since I wasn’t able to figure it out on ... Continue reading

Running SQL Server in Docker

Updated 2020-05-05

...