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

My Toolbox - SSMS

No matter how hard Azure Data Studio (ADS) is pushed by Microsoft, most DBAs still use SQL Server Management Studio (SSMS). In this blog post, I’ll go through my...

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

Speaking at SQL Saturday Syracuse 2024

I’m happy to announce that I will be speaking at the first-ever SQL Saturday Syracuse on September 7th, 2024. I will be presenting Answering the Auditor’s Call with Automation

Move to WordPress.com, and We’ll Handle the Migration for Free

For a limited time, we’ll move your existing WordPress site from any host to WordPress.com for free. 

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

Data (and Humans) At Rest

We talk a lot about data in the data world – imagine that! Sometimes, we talk about data at rest, but when do we all rest? Do we even...

Regular Expressions to Generate Disable/Drop Index Scripts

Earlier this year, I embarked on a bit of a project to tidy up the indexes in a sizeable database. This database has over 900 tables, and there are...

T-SQL Tuesday 177 - Managing Database Code

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Mala Mahadevan
(blog) asks how we manage our database-related code.

Where do you keep...

Your SQL Server is Slow, What To Look At

As a data professional, you’ll often get a phone call, email, or trouble ticket that says “SQL Server is slow, my query is slow, or things are slow”. This...