Spark Delta Lake, Updates, Deletes and Time Travel

When you use delta lake there are a couple of interesting things to note based around the fact that the data is stored in parquet files which are read-only...

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

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

Help! My restore has finished but the database still has a status of recovering.

I’ve been thinking about writing this for a bit and then a co-worker actually had this problem recently, so, well, ... Continue reading

My Desktop Setup

Every once in awhile when I’m recording a Pluralsight course, I’ll take a photo of my desk to let people see the behind the scenes of the process. Well,...

DevOps for databases: “DataOps”

DevOps, a set of practices that combines software development (Dev) and information-technology operations (Ops), has become a very popular way to shorten the systems development life cycle and provide continuous delivery of...

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

Memory Optimized Tables in SQL Server

Sometimes when I try to learn about a concept my brain blocks out everything about it. Talking about anything that uses the “In Memory” concept tends to do this...

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