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

Software Economics and Testing 01 Apr 2015
“ There are two types of developers: those who test their software and those who will. ” – Andy, circa 2015 It’s April Fool’s Day in the US, but I’m going to act like it’s Halloween. Software testing is no joke, and not testing should scare you. In 1996 (yes kids, years used to begin with a “1”), ...

New Challenges Ahead! 01 Apr 2015
I just joined the team at DB Best Technologies as a Principal Solutions Architect. Check out their website at . DB Best is probably best known for providing the SQL Server Migration Assistant (SSMA) tool and associated support for it. The SSMA tool was just recently updated to ...

Optimizing Dynamic Search Screens – Fixing the Performance of Common Code Paths 31 Mar 2015
One of the common challenges that arises in many applications is around how to optimize the SQL Server performance of dynamic search queries. For example, we've all seen applications with screens like this: Often, there will be many, many more fields to be searched. What I often hear from ...

Microsoft is Hiring for HoloLens 31 Mar 2015
If you go to and use HoloLens as your search term, you’ll see that Microsoft is serious about this product. As of today, I found 100 job openings for HoloLens in the United States alone. Don’t know what HoloLens is? Take a look here: ...

Create API for Power BI Designer #powerbi 31 Mar 2015
In the last months, I’ve been trying to suggest a direction for Power BI, but I start to realize that in these days Microsoft is really prioritizing features based on customer feedback. This can make things harder for a new idea to be prioritized, because nobody ask for something completely new. A ...