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

...

Running SQL Server in Docker

Why Use Docker for MSSQL Say you have an onboarding and need to get a new developer up to speed. Have you gone through the setup process for SQL...

Don’t install SQL Server from a mounted ISO

Here’s something that seems to keep coming up, but not frequently enough for me to write a blog post about until now: You should not install SQL Server from...