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

What Do You Drop?

Time is a valuable resource in your lives, and when you decide to tackle something, something else gets dropped.

Database Options and Numeric Roundabort