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

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

Getting most recent transaction log backup time irrespective of where the transaction log backup is performed in always on availability groups

I should mention outright that this post applies to SQL Server version 2016 and up.Over the years I have relied on the backup history tables in msdb to check...

Interesting Note in SQL Server 2019 Release Notes

A wonderful reader of my blog sent me a note (thanks Jess!) about a single line notation in the latest SQL Server release notes. The notes is as follows....

Practical Personal Cybersecurity at Activate Conference Lightning Night

Thanks to the organizers and many attendees of tonight's Activate Conference Lightning Night at LSU, the first of many series of short-format talks on technology put on by the creatives...