Chapter VIII.1. Configuring SQL Server
With each new release of SQL Server, Microsoft continues to improve and simplify the daily tasks of the database administrator. However, it's still not possible to run the database on autopilot, or replace the DBA with a robot. Given that reality, this chapter aims to help administrators make sense of all the server-wide settings and properties that they encounter each day.
We begin by giving you a brief overview of a collection of SQL Server's configuration tools and technologies. However, from the day-to-day perspective of a database administrator, most configuration tuning is controlled via the SQL Server Management Studio. Consequently, the lion's share of this chapter is dedicated to understanding how that tool allows you to fine-tune the dozens of parameters that influence SQL Server's behavior. Finally, we show you how to generate scripts so that you can further automate the maintenance and administration of your SQL Server environment.
Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
