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

T-SQL Tuesday #173–The AI Job Helper

This month I had a new host, Pinal Dave. I was surprised to see he hadn’t hosted, but I didn’t see him in the list. His invite is interesting,...

Announcements from the Microsoft Fabric Community Conference

(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh” has dropped on Amazon to its...

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