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.

Check owners, collations and backups

A script to check the owners, collations and backups on the server.

2005 unused indexes

Shows unused indexes compared to nr of modifications

You need to perform a restore operation as...