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.

Greg Low, Architecture & Configuration Editor

Welcome to the Architecture & Configuration section of the wiki.

Greg is an internationally recognised consultant, developer and trainer. He has been working in development since 1978, holds a PhD in Computer Science and a host of Microsoft certifications. Greg is the country lead for Solid Quality, a SQL Server MVP and one of only three Microsoft Regional Directors for Australia. Greg also hosts the popular SQL Down Under podcast (www.sqldownunder.com), organises the SQL Down Under Code Camp and co-organises CodeCampOz. He is a board member of PASS (the Professional Association for SQL Server). He speaks regularly at SQL Server events around the world.