We return to Barcelona for TechED 2006! Of course I will be doing some sessions (see below) as well as judging the “Speaker Idol” contest.
See you in Spain!
SQL312 T-SQL Querying: Tips and Techniques
Stephen Forte , Richard Campbell
Wed Nov 8 10:45 - 12:00
Take your queries to the next level! This interactive session focuses solely on advanced querying techniques to get the most out of your SQL Server. See a series of real-world examples to extract data from your databases in ways you've never seen before. Techniques demonstrated include an ultra-fast way to do crosstab queries in SQL Server, running totals and ranking. Along the way you'll get some insight into how SQL Server works and the new capabilities in SQL Server 2005.
SQL407 XQuery Deep Dive: How to Write and Optimize Your XQuery
Stephen Forte
Thu Nov 9 09:00 - 10:15
SQL Server 2005 provides deeply integrated native support of XML. Besides storing the data as XML, it provides XQuery support as the key to unlock the information stored inside the XML document. This session gives you an introduction to SQL Server's XML and XQuery support and it demonstrates how to write and optimize your XQuery expressions. In particular, it discusses the use of XML Indices and how to read XQuery generated query plans.
SQLWD04 The Query Governor: SQL CLR in Action
Richard Campbell , Stephen Forte
Thu Nov 9 17:30 - 18:45
See how .NET takes SQL Server 2005 to a whole new level! In this Whiteboard Discussion learn how to build a query governor, a set of tools for evaluating whether or not a query should be run. Most query governors are simple limiters, automatically cancelling queries when they run too long or aborting queries with too high of a cost. The CLR makes it possible to programmatically evaluate the cost of a query without executing it! Combined with some techniques for determining the state of the server, you can build a governor is flexible and smart. This interactive Whiteboard Discussion makes it easy to explore different applications of this technology beyond the query governor.
