Table of Contents

Overview of SQL Server.- SQL Server 2008 Overview.- SQL Server Installation and Configuration.- Enterprise Data Platform.- Policy Management.- High Availability.- Performance.- Security.- SQL Server Encryption.- Automation and Monitoring.- Service Broker.- Integrated Full-Text Search.- Development in SQL Server.- New Datatypes in SQL Server 2008.- T-SQL Enhancements for Developers.- T-SQL Enhancements for DBAs.- .NET Integration.- Programming Assemblies.- SQL Server and XML.- SQL Server XML and XQuery Support.- LINQ to SQL.- Business Intelligence in SQL Server.- Reporting Services.- Analysis Services.- Integration Services.

About the Author

Michael Coles has more than a decade's experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He graduated magna cum laude with a bachelor of science degree in information technology from American Intercontinental University in Georgia. A member of the United States Army Reserve, he was activated for two years following 9/11.