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 ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond 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.
