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

Adding and Updating