What would be the downside of restoring a local copy of the database from backups? That would be very simple to implement and would have no impact on the architecture...

TDE and encryption of personal identifying columns should be standard database design practice today, and the keys held only by a handful of need to know executives. A sysadmin, even...

...Humans make mistakes. We make inadvertent ones when we're tired or distracted. We make malicious mistakes we regret; we make emotional mistakes by overreacting to a situation. We make...

During those periods where readers appear to be blocked, have you run sp_who2 to confirm blocked spids?

I use Siri sometimes in the car, but it's only helpful only when I can get a specific answer to a question like: "Siri, where is the nearest gas station?",...

 I've seen some interesting interactions with Slack, including one company that allows limited developer access to systems through a Slack bot that handles some provisioning work, including raising and closing...