Microsoft SQL Server Developer Edition 2008, DVD, SP E32-00674 User Manual

Intelligent

Drive business intelligence throughout your organization, manage reports 
and analysis of any size or complexity, and empower users by providing 
powerful visualization and integration with the Microsoft Office system.

Integrate Any Data
Scale and manage large numbers of users and data with improved query 
performance on large tables. Optimize queries for data warehousing 
scenarios, and increase I/O performance with efficient and cost effective 
data storage. Integrate growing volumes of data from disparate systems 
with the scalable data integration features of Integration Services. 
Consolidate real-time data into the data warehouse with Change Data 
Capture functionality.

Deliver Relevant Information
Empower users to answer complex questions by providing the relevant 
information through reports with powerful visualizations and rendered 
in Microsoft Office Word 2007 and Microsoft Office Excel

®

 2007. Enable 

users to create complex reports and share them internally and externally 
with customers and partners.

Drive Actionable Insight
Provide a consistent set of key performance indicators (KPIs) and business 
metrics to all users by using the comprehensive and scalable analysis 
platform of SQL Server Analysis Services that has intuitive access through 
Office Excel 2007. Integrated Data Mining enables predictive analysis so 
you can investigate common issues like forecasting and identifying key 
influencers for decisions. Develop scalable analysis models with enhanced 
designers that incorporate best practices into the design experience. 
Increase the scale and performance of analysis by using enhanced 
analytical capabilities and complex computations and aggregations.

Productive

Reduce the cost of managing your data infrastructure while streamlining 
development of data applications.

Spend Less Time on Operations
Manage your enterprise data infrastructure easily with Policy-
Based Management. Reduce the time spent on daily maintenance 
operations by defining a common set of policies for most database 
operations like query optimizations, naming conventions, backup 
and restore operations, and index management. Apply policies to 
many servers for consistent management across the enterprise. 
Enable Performance System Analysis by collecting performance data 
from your system and storing it in a centralized data repository. View 
reports to benchmark and analyze system performance and health.

Accelerate Development
Access data by defining business entities instead of tables and 
columns with the ADO.NET Entity Framework. Query and retrieve 
these entities natively within any .NET language with Language 
Integrated Query (LINQ). Enable developers to work with the 
logical entity model, and administrators to define the physical 
implementation of the model as tables and columns.

Access Your Data from Anywhere
Create flexible, occasionally connected applications that can function 
when disconnected from the network. Create a next generation of 
applications that can work on a local data store and automatically 
synchronize the local store with a central store when a connection  
is available.

Store and Consume Any Type of Data
Use the new FILESTREAM data type to manage unstructured data such 
as documents and images outside the database. Store XML efficiently 
and enable easy access with XQuery. Improve the handling of temporal 
data by using new date and time data types.

Deliver Location Intelligence
Consume, use, and extend location-based data through spatial-enabled 
applications. Build location-aware applications by using new spatial data 
capabilities in SQL Server 2008.