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

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

Interested in Training - From Zero To SSIS? 29 Jul 2015
I’ve received a couple inquiries recently about SSIS training for people new (or new-ish) to data integration. I have delivered a course called From Zero To SSIS in the past, but not recently. If you are interested in this training, please contact me by clicking the Email link in the upper right ...

SQL Server 2016 Video Pills 28 Jul 2015
This is my first curation since Microsoft Curah! has been moving to a new Microsoft platform named docs.com.SQL Server 2016 Video Pills is a collection of videos about the most important features of SQL Server 2016; speakers are Engineers and Program Manager of the SQL Server Team!Would ...