SQL Server 2005 (Yukon)

Day 1 .NET CLR Integration CLR Hosting Using .NET inside SQL Server Creating Stored procedures, user-defined functions, triggers using .NET Cataloging .Net Assemblies in SQL Server 2005 Cataloging SP, UDF and Triggers Using Visual Studio .Net 2005 to create and test SP, UDF, Triggers The SQL Server programming models The new System.Data.SqlServer provider Using .NET SQL Server data provider inside the DB Using the SqlContext, SqlPipe, SqlDefinition classes .Net user-defined types (UDT) Why UDT s? Creating and cataloging User Defined Types NULL values and comparison Conversion to string and XML Adding Accessors and Mutators to UDT Serialization choices Customizing serialization for the UDT User Defined Aggregates (UDA) Creating and cataloging UDA Usage of UDA Day 2 Security Improvements New login functions and policies Logins Roles Password policy application Separating schemas from users Permissions All permissions grantable Permissions and .Net objects Execution context for procedural code Execution context and ownership chains Using Execute As New Database Engine Features New Data Types Varchar(MAX), NVarchar(MAX), VarBinary(MAX) Snapshot Isolation Level Transaction Isolation and Versioning Transaction Level Snapshot Statement Level Snapshot Extended Triggers and Notifications DDL Triggers Triggers on System events EventData() function Event Notifications New Transact SQL Features Exception Handling Common Table Expressions Used for hierarchical queries Used for recursive queries PIVOT / UNPIVOT operators Ranking Functions and Partitioning Cross-Outer Apply TOP enhancements Using Output clause on action statements XML Data Types XML as a native data type Using the XML type in Tables, Variables, and Parameters Creating and using Schema Collection Schema validated and untyped xml XML type indexes FOR XML and OpenXML enhancements XQuery Introduction to XQuery Using XQuery with the XML data type Methods on XML Type Using FLWOR expressions Updating the XML data type with XQuery DML Day 3 HTTP Endpoints and Web Services Architecture WebService Hosting Managing WebServices Declaring HTTP endpoints WSDL generation XML input and output in web services message headers Accessing HTTP endpoints in .NET clients Service Broker Architecture SQL Server Broker objects Message Types / Contract / Services Messaging extensions in Transact-SQL Service Broker SQL Server Usage Client Libraries and enhancements SNAC (SQL Native Client) Multiple Active Resultsets (MARS) Dependencies and Notifications on the client Snapshot isolation support Asynchronous Support