Monthly Archives: July 2024

Midsummer Fun

Yesterday was Independence Day in the US and a day off for me. Today, I’m back to work. Same for my rocket engineer son, one day off. My wife remembers a few of her companies giving a 4-day weekend when … Continue reading

Posted in Editorial | Tagged | Comments Off on Midsummer Fun

A New Word: Symptomania

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly captures the kind of person you are, tying together your many flaws and contradictions into a single theme – which wouldn’t necessarily sort out the mess … Continue reading

Posted in Blog | Tagged , | Comments Off on A New Word: Symptomania

Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory

I had a customer that was looking to document a restore that had occurred on one of their systems and didn’t see it. They had concerns about SQL Server accurately tracking history across time and noted they hadn’t cleaned any … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Xp_cmdshell Use Cases

I had someone ask me recently how to run xp_cmdshell on a Linux version of SQL Server. I told them you can’t, as it’s an unsupported feature and not one that I expect to see released. I had to double-check, … Continue reading

Posted in Editorial | Tagged , | Comments Off on Xp_cmdshell Use Cases