A First Look at Microsoft SQL Server 2005 for Developers

Bob et al. Beauchemin0321180593, 9780321180599

Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005 (“Yukon”). Now, three SQL Server insiders deliver the definitive hands-on preview – accurate, comprehensive, and packed with examples. A First Look at SQL Server 2005 for Developers starts where Microsoft’s white papers and Web articles leave off, showing working developers how to take full advantage of Yukon’s key innovations. It draws on exceptional cooperation from Microsoft’s Yukon developers and the authors’ hands-on access to Yukon since its earliest alpha releases. You’ll find practical explanations of Yukon’s new data model, built-in .NET hosting, improved programmability, SQL-99 compliance, and much more. Virtually every key concept is illuminated via sample code tested with Microsoft’s public beta. Key coverage includes:* Yukon as .NET runtime host: enhancing security, reliability, and performance* Writing procedures, functions, and triggers in .NET languages* Leveraging powerful new enhancements to T-SQL* The XML data type and XML query languages* SQL Server 2005 as a Web Services platform* Client-side coding: ADO/ADO.NET enhancements, SQLXML, mapping, ObjectSpaces, and more * Using SQL Server 2005’s built-in application server capabilities”