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.

SMS Script

This script will modify INI file on destops through SMS push to point server connection from A to B.

Distributing SQL Server Databases

Longtime SQL Server author Raj Vasant brings us a technique for delivering databases along with an application. As more and more systems take advantage of SQL Server or Express, this is a technique that can come in very handy.