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.

Speaking at SQL Saturday Denver 2024

It’s just a couple of days away from SQL Saturday Denver 2024. This Saturday, come join me at the Lowry Convention Center in Aurora for some great talks. We...

T-SQL Tuesday #177–Keeping track of database code

This month’s invitation is from Mala Mahadevan, who has hosted 5 times. This latest one is one that is near and dear to my heart as I use source...

A Checklist for Learning

A checklist can be helpful, but it needs to be more than a list of things if it's going to drive your career.

Upgrading Old Instance to SQL Server 2022

A New Word: Hiddled

hiddled – adj.  feeling of loneliness of having to keep a secret to yourself. I don’t know I am often hiddled. I don’t tend to keep secrets by myself....

Send Metrics Not Logs

Rather than moving logs, what about moving the important bits?

Synapse Analytics History II

DevOps Days Minneapolis–Best Practices for Database Deployments

Thanks to everyone who attended, though with one stage I had a fairly captive audience. I enjoyed the event and look forward to coming back to the Twin Cities...