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

Product codes
E32-00674
Page of 8
Trusted
Run your most mission-critical applications on a highly secure, reliable, 
and scalable platform.
Protect Your Data
Dynamically encrypt your valuable data within an entire database, data 
files, or log files, without the need for application changes. Simplify 
increasing regulatory compliance by using the advanced data auditing 
abilities of SQL Server 2008. Minimize exposure to security attacks 
by using the SQL Server Configuration Manager to enable only the 
services you require and Policy-Based Management to enable only the 
features you require.
Ensure Business Continuity
Seamlessly increase the reliability of applications with Database  
Mirroring. Simplify the recovery of applications from storage failures. 
Transfer operational data between the active operational systems and 
backup systems. Add system resources, like CPU and memory, without 
affecting applications.
Provide Predictable Response
Ensure consistent performance by using Resource Governor to define 
resource limits and priorities for different workloads and enable 
consistent performance. Reduce your storage costs and improve 
performance of large I/O bound workloads by using data compression.
Top New Features
Use Resource Governor to manage  
 ▪
concurrent workloads
Enforce policy compliance consistently 
 ▪
across the enterprise with the Policy-Based 
Management
Reduce storage requirements and increase 
 ▪
query performance with data compression  
and Sparse Columns
Protect sensitive data with Transparent Data 
 ▪
Encryption and advanced auditing
Troubleshoot, tune, and monitor SQL Server 
 ▪
2008 instances across the enterprise with 
Performance System Analysis
Build high performance analysis solutions 
 ▪
with scalability, performance, data mining, 
and user interface enhancements in SQL 
Server Analysis Services
Take advantage of improved performance, 
 ▪
usability, visualization, and integration with 
the 2007 Microsoft Office system in SQL 
Server Reporting Services
Integrate location-enabled applications  
 ▪
through support for spatial data
Looking at the efficiencies and time savings we’ll be gaining, [SQL Server 2008]  
Policy-Based Management has an enormous potential for cost savings.
Claudia Schrammel  
Project Manager and BI Architect,  
Austrian Broadcasting Corporation Radio & Television (ORF)
Resource Governor