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

Tabular Data Packages and a BIML challenge 27 Mar 2015
In February 2014 I joined a company called Conchango and had the pleasure of working with some very very smart people (Mick Horne, Dan Perrin, Pete Spencer, Paul Mcmillan amongst others) who schooled me in the ways and means of building data integration solutions. One piece of IP that Conchango had ...

After Ten Years... 27 Mar 2015
Life goes on and sometimes it is just time to move on. I am no longer with Scalability Experts. Looking back at all of the time that I spent with them, I realize how fortunate that I was to be part of it. I am writing this because I wanted to thank Scalability Experts for supporting me in my ...

Why won’t you implement my little feature request, Microsoft? 27 Mar 2015
I’ve been an active member of the Microsoft developer community* for many years now and in that time one of my frustrations has been numerous futile attempts to get new features into SQL Server and SQL Server Integration Services. As of today, 27th March 2015, I’ve submitted 109 bugs and 289 ...

Power BI Designer March Update includes Google Analytics Connector 26 Mar 2015
The Power BI team have released details of their March update to the standalone Power BI designer. You’ll find details of the update here: The first thing I noticed is just how much ...

Varigence Announces Biml Hero Certification 26 Mar 2015
“Do we get a super suit ?” was Kent Bradshaw’s first response after reading the Biml Hero announcement from Varigence. Short answer: Yes. Well, not an entire suit, “a complementary Biml Hero t-shirt, polo, and jacket.” (Sorry Kent, no capes … yet…) But cool! From Varigence’s press release : Earning ...