Adam Machanic is coming up Thursday, June 21 to give the following presentation. As always please visit the eventbrite page for this meeting to RSVP so we can plan appropriately. This should be an excellent talk for DBAs, Developers and BI folks. Too many people aren’t taking advantage of these powerful functions – some of which have been available since SQL Server 2005…
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 SQL Server 2005 and greatly enhanced in SQL Server 2012, can be used to quickly and easily solve a number of problems that were previously very difficult or seemingly impossible. In this session you will 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 will be 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 will 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.
Adam Machanic is a Boston-based database consultant, writer, and speaker, as well as the founder of Data Education. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications.
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 user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, Microsoft Certified IT Professional (MCITP), and a member of the INETA North American Speakers Bureau.