Why you should NOT multiply SQL Server instances
Consolidating SQL Server instances is better than installing several of them on the same server.
Administration
How to perform common tasks in SQL Server.
Compress tables and indexes
How and why to compress tables and indexes.
Remove backup messages from the error log
The error log records every successful backup, which is of no use. Here is how to turn those messages off.
SQL Server Monitoring
How to monitor SQL Server to ensure it is functioning properly.
Get the size of your tables
How to find the size of your tables, and the largest ones in particular.
Import and export with BCP
How to import and export table data with BULK COPY.
Managing the SQL Server Transaction Log
A transaction log filling up the disk is a classic DBA problem. Learn how to diagnose blocking issues and properly configure your recovery models.