Configuring SQL Server

• Server-Level Configuration
• Database-Level Configuration Options
• Connection-Level Configuration Options
• SQL Server Consolidation - combining multiple SQL Server databases and/or instances into less hardware or instances.
• Very Large Databases (VLDBs) - configuration tips for servers over a terabyte or a billion rows.
• Using SQLIOSIM to isolate DB corruption

System Databases and Tables

• Overview
• Distribution Databases
• Dynamic Management Objects
• Master Databases
• Model Database
• MSDB Databases
• System Tables in Every Database
• TempDB

Managing Vendor Application Databases

• Planning and Questions - Proper planning with some questions to start a conversation before you own a new database.