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

SQL Server 2014 Cumulative Update #7 is available! 23 Apr 2015
Microsoft has released Cumulative Update #7 for SQL Server 2014. See this blog post for more information. KB Article: KB #3046038 41 fixes listed publicly at time of publication (47 total) Build number is 12.0.2495 Relevant for @@VERSION 12.0.2000 through 12.0.2494 Note: This cumulative update is ...

Geek City: Point in Time Recovery for Operations on Memory—Optimized Tables 22 Apr 2015
In my class in Budapest last week, someone asked if point-in-time recovery was supported for transactions on memory-optimized tables. I couldn’t think of a reason why not, but I had never tried it. And just because there is not a technical inhibitor to allow certain functionality, it is often the ...

Transaction IO Performance on Violin 20 Apr 2015
Back in Feb, I went on a diatribe-rant against the standard SAN Vendor configuration practice. The Problem with Standard SAN Configuration IO Performance , article and accompanying post , showed IO performance metrics for a batch driven transaction processing workload on a SAN managed by a data ...

My MVA course about SQL Server on Azure - PaaS or Iaas? 18 Apr 2015
If you are tired today maybe you could take your time and spend the whole weekend with the SQL Server 2014 and Azure? The new MVA course is ready :) and waiting for you. Just visit the link and enjoy. Watch out - it's in Polish :) The topics covered: ...

More Useful MVA Training Options 18 Apr 2015
I find many of the MVA courses great for quickly getting across concepts or areas that I haven’t worked with before. This month, the local MVP program has asked me to highlight the following MVA courses. The first two in particular look useful for SQL folk. The third one provides good background: ...