TechEd 2010 Thanks and Demos

Adam Machanic — Thu, 10 Jun 2010 17:00:00 GMT

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 Server 2008

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.

Thanks again!

Search results matching tags 'TechEd' and 'change data capture'

TechEd 2010 Thanks and Demos