Chapter 2. Deploying Microsoft SQL Server 2005

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 2005 will be used in your environment. When you have decided on the role SQL Server 2005 will have, you can plan for your deployment and then roll out SQL Server.

SQL Server Integration Roles

SQL Server 2005 is designed as a comprehensive Business Intelligence platform that can be used for:

  • Extraction, Transformation, and Loading (ETL)

Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant 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.