Finding the Latest Backup Timestamps for Your Databases

Finding the Latest Backup Timestamps for Your Databases

I wanted to find out the most recent date and time each database was last backed up, focusing specifically on full, differential,...

Slides from SQL Saturday SLC 2024 – Zero Downtime

Thanks to everyone that came to my presentation at SQL Saturday SLC 2024. This post has a few links for you: Code and repo: https://github.com/way0utwest/ZeroDowntime Slides: Architecting Zero Downtime.pptx...

A New Word: Alazia

alazia– n. the fear that you’re no longer able to change.. I don’t have alazia. I’m always thinking I change, sometimes even when I don’t want to. Certainly my...

Apr 9 Webinar: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise

UPDATE: This moved to Apr 9 Join me Tuesday, Apr 9 for a webinar, 10:00am CDT. You can register here and then come watch live with questions or get...

Using SQL Elastic Pools

We use SQL elastic pools at work. I needed to learn more about their nuances and help you with some of their challenges. Setting Up Elastic Pools Here‘s some...

Webinar Apr 9: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise

On Tuesday I have a webinar with a Redgate sales engineer: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise. This will cover You can register here. In this...

Spring 2024 Speaking Engagements

I will be presenting Answering the Auditor’s Call with Automation at two upcoming events, one virtual and one in-person.
DBA Fundamentals Virtual User Group Tuesday, April 9 2024 at Noon...

SQL Compare Force Column Order in a Table

I had a client that was concerned about SQL Compare behavior when a developer adds a column to the middle of a table. I wanted to reassure them, so...

Off to SQL Saturday Salt Lake City … on Friday

I’m off on Thursday for Salt Lake City and a SQL Saturday on Friday. SQL Saturday Salt Lake City 2024 is happening, and I’m glad I get to go....

Power Query ODBC bug affecting date calculations

I was working on an imported Power BI semantic model, adding some fiscal year calculations to my date table. The date table was sourced from a view in Databricks...