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

ICYMI - Avoiding Performance Tuning, Wait Statistics, Incremental Statistics 07 Jul 2015
Some of my favorite articles originally appearing at SQLPerformance.com . Avoiding Knee-Jerk Performance Tuning Paul Randal of SQLskills.com starts a new series on knee-jerk troubleshooting, discussing many areas where SQL Server folks jump to conclusions when trying to fix a performance issue. ...

24 Hours of PASS (June 2015): Session recordings now available! 06 Jul 2015
Sessions of the event 24 Hours of PASS: Growing Our Community (which was held on last June 24-25) were recorded and now they are available for online streaming!If you have missed one session in particular or the entire event, you can view it or review your preferred sessions.All details are ...

#SQLVacation Follow-up Resources and Contest Details 02 Jul 2015
Kevin Kline (@KEKline) gives a recap of the #SQLVacation and links to all of his slide decks and SQL scripts....(read more)

Professional Developement - Digging for Gold 02 Jul 2015
Andrew Carnegie, once the wealthiest man on earth, came from humble beginnings. As a young boy, he worked a number of odd jobs. His hard work, industrious nature, and persistence eventually led him to become the largest steel manufacturer in the United States. Once, during an interview, Carnegie ...

DBTA - Russian Hackers Steal 1.2b Internet Credentials: Or, Why the Heck Does this Keep Happening?! 01 Jul 2015
I'm decidedly old-school in a few of my habits. My morning routine, barring anything out of the ordinary, is one such example. Typically, I'll get up between 6:30 to 7:00 am, grab my first cup of coffee, and then chat with my daughters for a few minutes before seeing them off to school. Next, I ...