Thank you to everyone who attended my three sessions at this year's TechEd show in New Orleans. I had a great time presenting and answering the really great questions posed by attendees.
My sessions were:
DAT317 T-SQL Power! The OVER Clause: Your Key to No-Sweat Problem Solving
Have you ever stared at a convoluted requirement, unsure of where to
begin and how to get there with T-SQL? Have you ever spent three days
working on a long and complex query, wondering if there might be a
better way? Good news: The OVER clause, first introduced in Microsoft
SQL Server 2005, can be used to quickly and easily solve a number of
problems that were previously very difficult or seemingly impossible. In
this session, learn to leverage aggregations and windowing operations
to gain insight without losing information, enabling you to answer a
number of interesting business problems with ease. Several demos are
shown to highlight the utility of the OVER clause for solving a large
number of difficult--yet common--query problems, including custom paging
schemes, data de-duplication, "top-N" problems, and complex statistical
calculations. You also learn how to creatively apply the feature to
help with performance optimization of certain classes of tough queries.
If you're tired of writing queries that just don't seem good enough,
attend this session to get to the next level.
DAT318 Auditing, Tracking, and Change Monitoring Technologies in Microsoft SQL
Regulatory bodies...end-users...your boss. They all want answers. Many
questions are easy enough to deal with: "Did someone drop my view?"
Others are a bit trickier: "What was the previous value of this row?"
And some are seemingly impossible: "Who selected the data from this
table over the past week?" For many DBAs, the answer to some or all of
these questions is often "Umm..." But don't blame yourself; getting this
information in SQL Server has never been especially easy—until now. SQL
Server 2008 ships with several new technologies designed to help you
track and report on exactly what happened, who did it, and when. In this
session, learn about SQL Server 2008 features: Change Tracking, Change
Data Capture, and SQL Server Audit, each of which provides a distinct
set of capabilities and has specific strengths and weaknesses. Looking
at each of these technologies in turn, you will see how they work and
where you might want to leverage them in your SQL Server infrastructure.
If you're used to saying "Umm..." get ready to say "I'll be right back
with the answer."
DAT03-INT Best Practices for Integrating Common Language Runtime in Microsoft SQL Server (co-presented with Pedro DeRose)
This session provides best practices, tips, and pros and cons of using
SQL Server CLR integration.
The attached ZIP file contains demos from each of the sessions. Enjoy, and as usual let me know if you have questions.