Chapter I.4. Setting Up SQL Server 2008

There was a time when installing and configuring a highly capable relational database management system meant clearing your calendar for a week, clearing your desk to hold a batch of weighty manuals, and clearing your mind in anticipation of a long and challenging job. Fortunately, that's no longer the case. However, installing and setting up a product like SQL Server 2008 does require some planning and preparation, which is what this chapter aims to tell you about.

We start by walking through the entire SQL Server installation process, pointing out several important things that you should do before, during, and after this crucial stage. After the product is installed, the next mission is to ensure that everything is shipshape. We then show you how to set your initial configuration parameters and how easy it is to make changes. The chapter closes with some guidance on establishing solid administration practices and policies.

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.