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

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

Temporal Tables – Part 2 – Changing history 30 Jun 2015
After my post yesterday, I had planned to take a break for Independence Day holiday, but a commenter asked a question that piqued my interest. How might you edit history? Well, the answer is simple, but the process isn’t exactly simple. Basically, you have to turn off system versioning, update ...

Presenting at CodeStock 2015! 30 Jun 2015
I’m honored to present two sessions Friday 10 Jul 2015 at CodeStock 2015 ! At 10:15 AM, right after the keynote by THE Scott Hanselman, I’m presenting Designing an SSIS Framework. At 2:40, I’m presenting SSIS 2014 Data Flow Tuning Tips and Tricks. I hope to see you there! :{> Learn more:  ...

ICYMI - Troubleshooting SQL Performance Issues, Missing Indexes, and DROP and TRUNCATE TABLE 30 Jun 2015
Troubleshooting SQL Server CPU Performance Issues This outstanding article from Joe Sack ( b | t ) of SQLskills.com steps you through a methodical and insightful series of DMVs and queries that can pinpoint CPU issues on your SQL Server instances. Don’t just blindly create those "missing" indexes! ...