The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P11: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 32 Chapter 2 Installing SQL Server 2008 Introduction This chapter covers the installation of SQL Server 2008. SQL Server 2008 comes in different editions and you should be sure you understand the features and limitations of each. It s important to consider the edition during the planning stage. In this chapter we will review the capabilities of each of the different editions as well as the options available when installing SQL Server 2008. We will also review planning your installation and discuss best practices for hardware utilization when it comes to installing SQL Server 2008. For best practices we will discuss the tools used to install or upgrade SQL Server 2008. SQL Versions Requirements Features and Differences A critical component of installing SQL Server 2008 is understanding the various components editions and versions of the SQL Server 2008 product sets to meet a specific set of business requirements. The challenge with SQL Server 2008 is in choosing between many options. Test Day Tip Make sure that you are familiar with the components and management tools with SQL Server 2008. Similar to earlier versions SQL Server 2008 has a number of server components and management tools that can be installed. The SQL Server 2008 includes the following components SQL Server Database Engine which contains the core services to store process manage and secure relational and XML data as well as services for full-text search and data replication. Analysis Services which contains the services for creating processing and managing Online Analytical Processing OLAP analysis and data mining models for Business Intelligence. Reporting Services a server-based reporting platform that provides tools and services to generate interactive tabular graphical or free-form reports. Installing SQL Server 2008 Chapter 2 33 Integration Services a platform containing tools and services for building extract transform and load ETL operations for data warehousing data integration and workflow .
