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.
1 Introduction
2 Hosting the Runtime : SQL Server as a Runtime Hist
3 Procedures and Functions in .Net Languages
4 The In-Process Data Provider
5 User-Defined Types and Aggregates
6 Security
7 T-SQL Enhancements
8 XML in the Database : The XML Data Type
9 XML Query Languages : XQuery and XPath
10 SQL Server as a Platform for Web Services
11 ADO and ADO.NET Enhancements
12 SQL Client Enhancements
13 Client-Side XML : SQLXML and Mapping
ect.