Generate Scripts to Compare Tables

Generate the scripts that will allow you to compare tables pass/fail.

Becoming A DBA, Part 1

Buck Woody examines examines some of the decisions you'll need to make when embarking on your DBA career, and some the character traits and skills that will help you succeed and progress.

Get record count for a specific database

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.

Differential Backups

Differential Backups Internals

Describes how data changes for differential backups are recorded using dbcc page

Moving the tempdb database

Moving the tempdb database in SQL Server is a simple process but does require the service to be restarted.

Fixing Orphaned Users

Migrating databases between production, test, development and train servers is something that a DBA needs to deal with constantly. During migration, one of the inevitable issues we need to deal with is concept of Orphaned Users.

So You're the New DBA

In a new DBA role, Daryl Quadros brings us a list of the first tasks you should perform.

Locate specific columns used in procs

SP to find object and line number that references column(s) of interest.

Featured Blog: CHECKDB From Every Angle: Can CHECKDB repair everything?

What can't be fixed by CHECKDB? Read this great entry from the former SQL Server Storage Engine lead.