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.

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....