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
Michael Otey is the technical director for both Windows IT Pro and SQL Server Magazine. He is the author of all editions of SQL Server Developer's Guide as well as the previous edition of this book.
Keywords: HOW TO USE SQL SERVER, NEW IN SQL SERVER 2008, TRANSPARENT DATA ENCRYPTION, EXTENDED EVENTS, FILTERED INDEXES, RESOURCE GOVERNOR, POLICY-BASED MANAGEMENT FRAMEWORK, T-SQL INTELLISENSE, AND POWERSHELL, HIGH AVAILABILITY, FAILOVER CLUSTERING, DATABASE MIRRORING, PEER-TO-PEER REPLICATION, BACKUP COMPRESSION, TABLE LOCK ESCALATION, ADO.NET ENTITY FRAMEWORK LINQ, NATIVE DATA TYPES, T-SQL, BI, BUSINESS INTELLIGENCE, INTEGRATION SERVICES DATA PROFILING, ANALYSIS SERVICES, CUBE DESIGNER, REPORTING SERVICES, TABLIX, SQL SERVER, MICROSOFT SQL SERVER 2008 HIGH AVAILABILITY WITH CLUSTERING & DATABASE MIRRORING, MICROSOFT SQL SERVER 2008 REPORTING SERVICES, MICROSOFT SQL SERVER 2008 A BEGINNER'S GUIDE, DELIVERING BUSINESS INTELLIGENCE WITH MICROSOFT SQL SERVER 2008, MICROSOFT SQL SERVER 2008 ANALYTICS & DATA VISUALIZATION, DATABASES DEMYSTIFIED, SQL DEMYSTIFIED, SQL A BEGINNER'S GUIDE, SQL THE COMPLETE REFERENCE, ORACLE DATABASE 11G SQL