Back to Syracuse for SQL Saturday

Syracuse is having their first SQL Saturday on Sept 7, 2024. I’ll be there and hope to see you there as well. If you’re anywhere close, come on over...

Concatenating Strings

Grouping by Object Type in SQL Compare

A customer recently was asking about grouping objects by type to see all the differences in two databases for one set of objects, like all stored procedures. This post...

A Lack of Architecture and Planning

Today Steve talks about how we end up with software systems that don't appear to be well engineered.

Monday Monitor Tips- Enabling Index Tracking in Redgate Monitor

There is a new index feature in Redgate Monitor, but it’s disabled by default. This post shows how to enable things. This is part of a series of posts...

Monday Monitor Tips: Changing the Fragmentation Alert

I had a customer that was concerned about the fragmentation alert for indexes and wanted to know how to change it. This post discusses the change. This is part...

Trigger Ordering I

SQL Saturday Denver 2024 Resources

Here are the resources from my talks today. Best Practices for Seamless Database Deployments PPTX slides Architecting Zero Downtime Deployments git repo:  https://github.com/way0utwest/ZeroDowntime  PPTX slides Some good questions today,...

Analyzing Breached Data

After a recent data breach, Steve read about an analysis of the data. He has a few thoughts on the process that Troy Hunt went through to dig into the data.

A New Word: Povism

povism – n. the frustration of being stuck inside your own head, unable to see your face or read your body language in context, only ever guessing how you...