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

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

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

It greatly pleases me to announce, HAL0003!

I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal...

Reload a table quickly.

Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload....

SQLSkills waits and latches library

SQLSkills is an amazing resource for the SQL Server community. Between their blogs, white papers, and the SQLSkills Insider emails...

When was my index created or at least last updated?

SQL Server stores a create date and a change date for each object in the sys.objects system view.

Unfortunately while...

Is it safe to grant Administer Bulk Operations?

First I guess we had best start with definitions right? The permission Administer Bulk Operations and the role bulkadmin are...