Lead Blocker

Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and...

What is COPY_ONLY?

You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up...

Why won’t my SQL Logins work?

I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a...

Connect suggestion to add included columns to sp_helpindex

I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the...

A detailed view into your Azure resources

I’ve been studying Azure recently and came across a really interesting Azure site.
resources.azure.com

To give you an idea why I find...

sp_refreshsqlmodule_internal – The user does not have permission to perform this action.

Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found...

A semester’s worth of Backup and Recovery blogs – The TSQL Tuesday 85 Rollup

I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery...

sp_helptext vs object_definition()

I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I...

:OUT :OUT darn results!

Years ago I worked for a company that had a rather cool way of handling requests. When we ran the...

An interview with me

The other day I received an email asking for some help with a school project. Would I please answer some...