Business Intelligence Features

Many of the business intelligence capabilities of SQL Server 2000 have been improved in SQL Server 2005, and in some cases these capabilities have been completely rearchitected. (SQL Server 2005 Enterprise Edition is required to support most of the advanced functionality.) An important new feature is the addition of Business Intelligence Development Studio, which supplies a set of templates for developing business intelligence projects in an integrated development environment. Integration Services replaces Data Transformation Services with better performance, greater flexibility and portability, and improved support for complex data management and integration activities. While Analysis Services did not undergo a ...

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