You'll find practical explanations of the new SQL Server 2005 data model, built-in .NET hosting, improved programmability, SQL:1999 compliance, and much more. Virtually every key concept is illuminated via sample code that has been fully updated for and tested with the shipping version of the product.

Key coverage includes

• Using SQL Server 2005 as a .NET runtime host: extending the server while enhancing security, reliability, and performance
• Writing procedures, functions, triggers, and types in .NET languages
• Exploiting enhancements to T-SQL for robust error-handling, efficient queries, and improved syntax
• Effectively using the XML data type and XML queries
• Implementing native SQL Server 2005 Web Services
• Writing efficient, robust clients for SQL Server 2005 using ADO.NET, classic ADO, and other APIs
• Taking full advantage of user-defined types (UDTs), query notifications, promotable transactions, and multiple active result sets (MARS)
• Using SQL Management Objects (SMO), SQL Service Broker, and SQL Server Notification Services to build integrated applications

Bob Beauchemin is a database-centric application practitioner and architect, DBA, instructor, course author, and writer. He's Director of Developer Skills at SQLskills, and teaches his SQL Server 2005 courses around the world. Bob has written extensively on SQL Server and other databases, database security, ADO.NET, and OLE DB.

Dan Sullivan runs his own consulting company, does training for Pluralsight, and has worked with SQL Server since it was first distributed by Microsoft and ran on OS/2. Dan speaks and writes widely on SQL Server.