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

Finding Where xp_cmdshell is Used

I saw a post recently where someone was concerned about where xp_cmdshell was in use inside their system. They felt it was a security risk, and decided to get...

Prevent SQL Injection

SQL Injection continues to be a problem and Steve has a few thoughts today on how to reduce your vulnerabilities.