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?

SQL Server Browser

DBCC

Extract User-Role Mapping

This short script will list all the users along with their Roles.

The Ultimate PK-Less / CLIDX-Less Table Finder

Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.

The Ultimate Table Searcher Mk2

Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.

Managing Transaction Logs

A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs.