THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Adam Machanic

Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.

TechEd 2010 Thanks and Demos

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!

Published Thursday, June 10, 2010 2:00 PM by Adam Machanic


Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Rob Volk said:

Thanks Adam!  Are you making the slides available as well?

June 10, 2010 3:33 PM

Adam Machanic said:

Hi Rob,

Perhaps I'll expert them to a PDF and post them later. The talks are pretty demo-heavy so the slides aren't especially interesting anyway :-)

June 10, 2010 5:38 PM

Leave a Comment


About Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

This Blog


Privacy Statement