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.
Adam Machanic's Training Days
Better Performance Through ParallelismSQLBits 2015
This full-day seminar will teach you the ins and outs of Windows scheduler internals, SQLOS, intra-query parallelism, and patterns that can make your parallel queries many times faster. After attending you will be in full control of your CPUs.
Better Performance Through ParallelismSQLBits 2015
This full-day seminar will teach you the ins and outs of Windows scheduler internals, SQLOS, intra-query parallelism, and patterns that can make your parallel queries many times faster. After attending you will be in full control of your CPUs.
Better Performance Through ParallelismSQLBits 2015
This full-day seminar will teach you the ins and outs of Windows scheduler internals, SQLOS, intra-query parallelism, and patterns that can make your parallel queries many times faster. After attending you will be in full control of your CPUs.
Better Performance Through ParallelismSQLBits 2015
This full-day seminar will teach you the ins and outs of Windows scheduler internals, SQLOS, intra-query parallelism, and patterns that can make your parallel queries many times faster. After attending you will be in full control of your CPUs.
Better Performance Through ParallelismSQLBits 2015
This full-day seminar will teach you the ins and outs of Windows scheduler internals, SQLOS, intra-query parallelism, and patterns that can make your parallel queries many times faster. After attending you will be in full control of your CPUs.
Better Performance Through ParallelismSQLBits 2015
This full-day seminar will teach you the ins and outs of Windows scheduler internals, SQLOS, intra-query parallelism, and patterns that can make your parallel queries many times faster. After attending you will be in full control of your CPUs.
No More Guessing! Enlightened Performance TroubleshootingSQLBits 2012
Finding the root cause of most performance issues is a simple exercise, once you understand where to look and when. In this full day seminar, you will learn a proven methodology that can be used to approach virtually any performance problem.
Adam Machanic's Sessions
Query Tuning Mastery: Clash of the Row GoalsSQLBits 2015
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.
Query Tuning Mastery: The Art of Manhandling ParallelismSQLBits 2012
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.
Query Tuning Mastery: Workspace Memory InternalsSQLBits 2012
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.