Transaction Logs

The Ultimate Dupe Finder & Performance Test Parameter Set Researcher

Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!

Introduction to Profiler

This article introduces Profiler presenting what it is, how to use it, and why you might want to use it.

Dropping multiple objects with a single DROP statement

Most SQL Server users drop one object at a time using either SSMS or a single drop statement. In many scenarios we may need to drop several objects of the same type. Is there a way to drop several objects through less lines of code?

Spring Clean Your Database Schema

The utility described in this article allows you to quickly identify which columns have mismatched data types across tables in a database. Correcting these will improve performance etc.

Managing many SQL Servers?

Here's an article from Rudy Panigas on how to more effectively manage multiple servers.

Scope: The drastic caveat with Logon Triggers.

In this article, Johan Bijnens shows how logon triggers can bite you in the back.

Waiting on a KILL

SQL Server Browser

SQL Server Preproduction Tasks

What are some of the things that you need to do before you sign off and hand it over to production? What do you need to do to keep the server running smoothly?