adam_machanic.jpg

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.
http://sqlblog.com http://sqlblog.com/blogs/MainFeed.aspx

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

The ALLSELECTED function under the cover #dax #tabular #powerpivot #powerbi 05 Aug 2015
I and Alberto Ferrari recently completed the writing of The Definitive Guide to DAX, and we spent months to correctly describe the internals of evaluation context in this language. There are many details that make data model working with both DAX and MDX, and sometime there are behaviors that are ...

My MVA course about Machine Learning is available! 05 Aug 2015
So I did it again!  The new MVA course is ready :) and waiting for you. This time I briefly explain what and what for the Azure Machine Learning is J Just visit the link http://bit.ly/1M4fDi4 and enjoy. Watch out - it's in Polish :) The topics ...

ICYMI - Predicate Logic, Four Things I Wish I'd Known Sooner, Transact-SQL Bad Habits, Rewriting Queries to Improve Performance 04 Aug 2015
Some of my favorite articles originally appearing at SQLPerformance.com . Why Not Seek Predicate Paul White ( b | t ) proves, once again, why he is the best in the business when it comes to debugging a SQL Server query. In this post, Paul gives you a step-by-step breakdown of a query that goes ...

Own the SSIS Design Patterns E-Book for $10–Today Only! 30 Jul 2015
Own the SSIS Design Patterns (2nd edition - updated for SSIS 2014) ebook today for just $10! :{> Learn more:  Stairway to Biml Linchpin People Blog: SSIS Stairway to Integration Services...(read more)

Professional Development - What a Difference 60 Years Makes 30 Jul 2015
Originally appearing at ForITPros.com . In 1957, the Soviet-made Sputnik streaked across the sky in low earth orbit. It was clearly visible to millions of concerned Americans. The Soviet government had leapfrogged America technologically. The dot that traversed the nighttime sky marked a change in ...