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.

Are your big queries using every available clock tick, or are they lagging behind? And if your queries are already going parallel, can they be rewritten for even greater speed? In this session you will learn how to take full advantage of parallelism.
Large, complex queries need memory in which to work--workspace memory--and understanding the how's, when's, and why's of this memory can help you create queries that run in seconds rather than minutes.
Attend this session to learn how to take charge of optimization, expertly mold your query plans, and gain a new set of tools for eliminating bottlenecks in even your most complex problem queries.

Blog posts RSS

Mixing UNION and UNION ALL and other oddities seen in consulting 27 May 2015
I always say that one of the things that I love about consulting or mentoring work is that I see things (mostly code) that I would have never have thought of, both good and bad. You could spend all day dreaming up bizarre ideas and never come close to the ones that I just happen to come across. A ...

What's New in MDS SQL2016 CTP2 Release 27 May 2015
SQL Server 2016 CTP2 is now available for public download. We are looking forward to your feedback! What’s New for MDS Improved Performance Performance improvements enable you to create larger models, load data more efficiently, and get better overall performance. This includes improvement the ...

24 Hours of PASS (June 2015) 27 May 2015
The most important free on-line event on SQL Server and Business Intelligence is back!The 24 Hours of PASS is coming back with a great edition that will provide best practices, expert tips, and demos, from new and up-and-coming Speakers. Don't take commitments on 24 and 25 of June ...

Data Camp Sydney (Free) 25 May 2015
Hi Folks, on the 5th June (yes that’s Friday next week), I’m running a Data Camp day for the local Microsoft team. It’s being held at Cliftons in the city. We’ve got four topics for  the day: Azure SQL DB Azure DocumentDB Azure Machine Learning Azure Stream Analytics If you ...

701 24 May 2015
It’s your turn. You start blogging. You cannot start in July 2007 like I did – even if you have a Delorean . But you can start in July 2015. Here’s the thing: In 2023, eight more years will have passed. Will you have posted 700 blog posts by then? You can. How to I know? It’s possible. “What Do I ...