Manage any data, any place, any time!
SQL Server 2008 delivers on Microsoft's Data Platform vision by helping your organization manage any data, any place, any time. It enables you to store data from structured, semi-structured, and unstructured documents, such as images and music, directly within the database. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze. Your data can be stored and accessed in your largest servers within the data center all the way down to desktops and mobile devices, enabling you to have control over your data no matter where it is stored.
Features
Protect valuable information:
Transparent Data Encryption
Extensible Key Management
Auditing
Ensure business continuity:
Enhanced Database Mirroring
Automatic Recovery of Data Pages
Log Stream Compression
Enable predictable response:
Resource Governor
Predictable Query Performance
Data Compression
Hot Add CPU
Manage by policies:
Policy-Based Management
Streamlined Installation
Performance Data Collection
Simplify application development:
Language Integrated Query (LINQ)
ADO.NET Object Services
Store any information:
DATE/TIME
HIERARCHY ID
FILESTREAM Data
Integrated Full Text Search
Sparse Columns
Large User-Defined Types
Spatial Data Types
Integrate any data:
Backup Compression
Partitioned Table Parallelism
Star Join Query Optimizations
Grouping Sets
Change Data Capture
MERGE SQL Statement
SQL Server Integration Services (SSIS) Pipeline Improvements
SQL Server Integration Services (SSIS) Persistent Lookups
Deliver relevant information:
Analysis Scale and Performance
Block Computations
Writeback
Drive actionable insights:
Enterprise Reporting Engine
Internet Report Deployment
Manage Reporting Infrastructure
Report Builder Enhancements
Built-In Forms Authentication
Report Server Application Embedding
Microsoft Office Integration
Predictive Analysis
