Friday, May 29, 2009

SQL Server 2008 What's New

http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx
 

Enterprise Data Platform


Policy-Based Management



Performance Data Collection (Data Collector)



Data Compression



Resource Governor



Transparent Data Encryption



External Key Management / Extensible Key Management



Data Auditing



Hot-Add CPUs and Hot-Add Memory



Streamlined Installation



Server Group Management



Upgrade Advisor



Partition Aligned Indexed Views



Backup Compression



Extended Events


Dynamic Development


Grouping Sets



MERGE Operator



LINQ



Change Data Capture



Table-Valued Parameters



ADO.NET Entity Framework and the Entity Data Model



Synchronization Services for ADO.NET



CLR Improvements



Conflict Detection in Peer-to-Peer Replication



Service Broker Priorities and Diagnostics



ADO.NET Data Services


Beyond Relational


Spatial data with GEOGRAPHY and GEOMETRY data types



Virtual Earth Integration



Sparse Columns



Filtered Indexes



Integrated Full-Text Search



FILESTREAM Data



Large User-Defined Types (UDTs)



Large User-Defined Aggregates (UDAs)



DATE / TIME Data Types



Improved XML Support



ORDPATH


Pervasive Insight


Fixed Query Plan Guides (Plan Freezing)



Star Join Query Optimization



Enterprise Reporting Engine



Report Builder Enhancements



Improving Rendering for Microsoft Office® Word and Excel



Partitioned Table Parallelism



IIS Agnostic Report Deployments



Persistent Lookups



Analysis Services Query and Writeback Performance



Best Practice Design Alerts



Analysis Services Dimension Design



Analysis Services Time Series



Data Profiling

 
 
 
 


Insert movie times and more without leaving Hotmail®. See how.

No comments: