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

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 ...

Data Mining Algorithms – Pluralsight Course 30 Jul 2015
This is a bit different post in the series about the data mining and machine learning algorithms. This time I am honored and humbled to announce that my fourth Pluralsight course is alive. This is the Data Mining Algorithms in SSAS, Excel, and R course. besides explaining the algorithms, I also ...

DBTA - IT Employers Must Adapt to the Looming DBA Shortage 29 Jul 2015
Originally appearing in my monthly column at Database Trends & Applications magazine . In the first of this three-part series, I described some of the findings contained in an intriguing new survey published by Unisphere Research, a division of Information Today, Inc. In that article, I covered ...

Presenting Using Biml as an SSIS Design Patterns Engine at Hampton Roads .Net UG 11 Aug 29 Jul 2015
I am honored to present Using Biml as an SSIS Design Patterns Engine at the Hampton Roads .Net Users Group ( @HRNUG ) 11 Aug 2015! Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design ...