Microsoft SQL Server 2008 New Features

Microsoft SQL Server 2008 New Features by Michael Otey
Date Released

Out Of Print

Other Titles by Michael Otey

Maximize the New Capabilities of Microsoft SQL Server 2008

Take immediate advantage of all the innovative features and benefits available in SQL Server 2008 with help from this expert guide. Written by the technical director for SQL Server Magazine, this book offers a concise yet in-depth look at the new and improved enterprise data management capabilities, developer functions, Business Intelligence tools, and security enhancements of SQL Server 2008. This is the perfect resource for decision-makers, developers, and DBAs preparing for upgrades or migration. Get details on:

The new Transparent Data Encryption, Extended Events, filtered indexes, and auditing features

The new Resource Governor, policy-based management framework, T-SQL IntelliSense and debugging, and PowerShell integration

Availability enhancements-Failover Clustering, Database Mirroring, peer-to-peer replication, backup compression, and the new table lock escalation

The new ADO.NET Entity Framework

LINQ (Language Integrated Query)

The new native DATE, TIME, FILESTREAM, and Geospatial data types

T-SQL enhancements, such as the new DECLARE, MERGE, and GROUPING SETS statements

The more powerful BI toolset, including Integration Services Data Profiling, Analysis Services new Cube Designer, and Reporting Services new tablix controls

Improved Microsoft Office integration capabilities
Publication Date:
23 / 12 / 2008

You might also like