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.

Blog posts RSS

Why I am not going to PASS this year 25 Oct 2014
This is going to be one of my toughest non-technical posts ever. And the reason it will be difficult will have an ancillary relationship to the Lortabs I have been taking for the last two days. It has everything to do with me being at home while the 2014 PASS Summit is going on. Previously, the ...

Two Presentations This Weekend at #SQLSaturday349 in Salt Lake City 24 Oct 2014
I have the privilege of being selected to fill two slots this weekend at #SQLSaturday349 in Salt Lake City.  The venue is simultaneously hosting the Big Mountain Data event. My talks are: To the Cloud, Infinity, & Beyond: Top 10 Lessons Learned at MSIT & Columnstore Indexes ...

SQL File Layout Viewer on Codeplex … and in Minneapolis 24 Oct 2014
I'm so pleased to be presenting on file internals again at SQL Saturday Minneapolis 2014 . I have also moved the source for SQL File Layout Viewer into Codeplex, both for safekeeping and on the off chance a kind soul passionate about SQL Server wants to help me out. https://sqlflv.codeplex.com/ ...

Execution plans, laundry, and a giveaway 24 Oct 2014
In just a week from now, SQL Saturday #337 will kick off in Portland, Oregon. And I will be there – the third time already for me to be speaking in Portland. For a European, Portland is not the most logical location. But the organization over there is a pretty smart bunch of people. They figure ...

In The Cloud: Creating Your First Azure SQL Database 23 Oct 2014
Creating your first SQL Database in Azure is quick and easy. There are a few things I’ve discovered that might help you be successful faster. Many people have asked me how to get started, so I’ve provided these steps to success. The steps I show you aren’t the only way to achieve success. This is ...