Chapter 2. Deploying SQL Server 2008

With SQL Server Setup, you can create new instances of SQL Server, add components, rebuild the SQL Server registry, uninstall SQL Server, and perform other common setup tasks. Prior to setup and configuration, you need to decide how SQL Server 2008 will be used in your environment. When you decide on the role that SQL Server 2008 will have, you can plan for your deployment and then roll out SQL Server.

SQL Server Integration Roles

SQL Server 2008 is designed as a comprehensive business intelligence platform that can be used for the following:

  • Extraction, transformation, and loading (ETL)

  • Relational data ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition 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.