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

DBA Myths: You can only restore one differential backup

Ok, I know I’m hosting T-SQL Tuesday this month but I still had post I wanted to share.

 
The basic steps...

Fixing Data Migration Assistant timeouts

I’ve been really excited about the new Data Migration Assistant (DMA) since I first heard about it. One of the...

TSQL Tuesday #85 Invite – Backup and Recovery

Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...

Easy to read CHECKDB

If you ask a senior DBA what are the top 5 most important commands in T-SQL you’ll probably see DBCC...

Using OUTPUT with a field list.

I recently wrote an article for SQL Server Central about using OUTPUT. In case you aren’t aware OUTPUT is a...