C H A P T E R  6



After you have installed or upgraded your environment to SQL Server 2008, we recommend spending some time configuring your instance to ensure that SQL Server runs optimally and is secure. There are many configuration options and different post-installation processes and procedures utilized across the globe by various database administrators. We cannot cover every scenario and describe the best configuration setting for all the different types of applications, but we would like to discuss the more important options and describe situations where you can take advantage of the settings.

SQL Server Configuration ...

Get Pro SQL Server 2008 Administration now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.