May 2010
Intermediate to advanced
815 pages
21h 55m
English
book
SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond
by Tom Carpenter
Content preview from SQL Server® 2008 Administration: Real World Skills for MCITP Certification and BeyondBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter Essentials
Understanding and Implementing Analysis Services Analysis Services provides rapid data analysis of complex and large data systems. Analysis Services is the primary BI and decision-support component in SQL Server. It may be installed as a default or named instance, and the instance may include other SQL Server components as well. SSMS is used to manage and work with data cubes and data models, and BIDS is used to create them.
Understanding and Implementing Integration Services SQL Server Integration Services is used to perform ETL tasks in SQL Server environments. Integration Services was first introduced with SQL Server 2005. Before this, it was known as Data Transformation Services. You install Integration Services as part ...