Upcoming Schedule of webcasts
There have been a few questions about the upcoming topics, and I know MSDN only show a few weeks out at a time. So here is the rest of the schedule. Each webcast is scheduled for every other week, so you can figure out the dates.
6. New SQL Engine Features -
SQL Server 2005 includes snapshot isolation, in which versioning rather than locking is used to ensure multiuser semantics. We examine the details and implementation. Common table expressions and using them with recursive queries are covered. The new DML syntax enhancements and extended triggers round out this module.
7. New Transact-SQL Features
SQL Server 2005 includes a number of Transact-SQL enhancements. Exception handling using TRY-CATCH syntax has been added. Common table expressions and using them with recursive queries are covered. The ranking and partitioning functions and other new DML syntax enhancements round out this module.
8. The XML Data Type
SQL Server 2005 supports native XML storage, schema validation, and indexing using a SQL-2003 compliant data type. We'll not only show how to use the datatype, but discuss when to use native XML as an adjunct to relational data. We also explore enhancements in XML composition and decomposition functions.
9. XQuery
This module begins with a brief overview of the XQuery language for the uninitiated. Then we explore the implementation of XQuery using the native XML data type in SQL Server 2005. Finally we see how to mix relational data and parameters with in-database XQuery.
10. SQL Server Service Broker
SQL Server 2005 introduces asynchronous queuing inside the database through the SQL Server Service Broker. We'll set up a simple Service Broker-based application using the new broker DDL and objects, then program the application using DML extensions. We'll also discuss how Service Broker solves some very difficult problems in producing stateful but scalable applications.
11. SQL Server And Web Services
SQL Server 2005 can be used to directly expose industry-standard web service functionality from inside the database. In this module we go over the details of this functionality and then define and build stored procedures that are exposed as web services. Finally we'll build a web service consumer using Visual Studio 2005.
|
12. SqlClient and the new Data Types
The new user-defined type and XML data type must be useable on the client to be useful for application programmers. This module shows how to use the new types in ADO.NET and System.Xml as well as classic ADO and MSXML. We discuss when to do user-defined type processing on database or client. Finally we explore using SqlTypes on the client.
|
|
13. SqlClient Provider - New Features
The client side ADO.NET data provider, SqlClient contains many new features to enhance ASP.NET and Windows Forms programming. Some are SQL Server 2005 specific, while some can be used with other versions of SQL Server.
|
|
14. ADONET2
ADO.NET 2.0 shifts the managed provider access model from an interface-based model to a base class-based model. We'll discuss the new model, which includes provider registration, provider factories, data source enumerators, connection string handling, and generalizatart. |
15 - TBD - This is one I have left open and we are discussing what we should cover - Any suggestions?