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?

SQL Server Browser

DBCC

Extract User-Role Mapping

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