A collection of links and resources related to my PASS Data Community Summit 2021 presentation Backup Basics with PowerShell and dbatools including bonus content! Resources dbatools main site dbatools documentation How to remove old versions of dbatools from your system SQL Server Community Slack (join #dbatools) Learn dbatools in a Month of Lunches GitHub repository…

Read More PASS Data Community Summit 2021 Presentation Resources

Over the summer, I spent some (a lot of) time working on updates to a script at work which runs multiple processes in parallel. Everything seemed to work OK for a while, but then everything broke. It broke right around the time dbatools 1.1 dropped, so I started thinking that something must have changed there.…

Read More Lesson Learned From Multi-Threading with dbatools

Kind of a diversion into a Visual Studio Code/Azure Data Studio tip here (this works in both, as well as SQL Server Management Studio). I’m not a regular expression guru – far from it. I use them occasionally, but usually find myself fumbling around for a bit trying to figure out just the right expression…

Read More Regular Expression Search & Replace in Visual Studio Code

I am thrilled to announce that I will be speaking at this year’s PASS Data Community Summit! This year’s event runs November 8th through 12th. I am thrilled to announce that I will be speaking at this year’s PASS Data Community Summit! As November approaches, the schedule as well as the details of my session…

Read More PASS Data Community Summit 2021 – I’m Speaking!

For years, I thought that native backups of databases using Transparent Data Encryption (TDE) couldn’t be compressed. Between TDE being limited to Enterprise Edition until SQL Server 2019 and my own lack of experience with TDE in prior positions, I hadn’t really experimented with this myself. Some people have even gone so far as to…

Read More Troubleshooting Backup Compression for Encrypted Databases

I will be presenting my session “Backup Basics with Powershell and dbatools” this Thursday, February 18th at 2:30 PM Central Time at the Kansas City SQL Server User Group. I’m looking forward to getting this demo-rich session out in front more of folks to show how easy dbatools makes some of these common backup-related tasks.…

Read More Speaking at the Kansas City SQL Server User Group

While presenting Backup Basics with Powershell and dbatools at ONDT, I mentioned a caveat with the -ReplaceExisting switch for Install-DbaMaintenanceSolution. This switch drops all of the objects installed by the Maintenance Solution, including the CommandLog table. If you use that table to produce evidence that the various maintenance tasks are being performed on a regular…

Read More Upgrading Ola Hallengren’s Maintenance Solution with dbatools