Recent Posts

Attaching Database Using SMO & Powershell

less than 1 minute read

Steve Jones wrote a great article on using this automation here titled The Demo Setup-Attaching Databases with Powershell. I threw together a completed scrip...

Parallel Powershell for Running SQL

1 minute read

This is just a quick look. I plan on diving into this in the future more, as I’m still working through some of the changes being made in the main parallel mo...

Get Backup History for All Databases in Server

less than 1 minute read

Here’s a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions provided a single backup listing, but not the ...

Pizzicato Pizza

1 minute read

Had a blast making this song. Unfortunately, creating video of slow motion pizza cutting was going to be a bit awkward to do, as I didn’t feel like asking a ...

Data Compare on Temporal Tables

3 minute read

I hadn’t seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went through the exercise to compare current to historical...