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

700 22 May 2015
Adam Machanic ( Blog | @AdamMachanic ) emailed me way back in July 2007 and asked if I’d be interested in joining the awesome crew blogging at SQLBlog.com . I was honored to be asked and loved the idea of joining the bloggers here (“A group of really smart SQL Server bloggers… plus me”). And wow – ...

BI on your terms with SQL Server 2016 22 May 2015
The last few years Microsoft strategy was all about cloud first (or cloud only?), releasing new BI products and updates to existing products to the cloud in high pace without almost any investments in on-premises BI. In 2015 Microsoft seems to change its course, they now aim more on the ...

Geek City: What rows have been updated under snapshot isolation? 22 May 2015
So here it is, the bits and bytes post I’ve been promising…. This post is not about Hekaton (in-memory OLTP). This is about the snapshot-based isolation levels that were introduced in SQL 2005, which was called optimistic concurrency at the time. With the advent of Hekaton’s truly optimistic ...

Heading to SQL Sat NYC! 21 May 2015
I will be speaking at SQL Sat 380 in NYC on the topic of Basic Performance Monitoring with Perfmon. I have delivered this session many times and is usually well attended. The session is geared for the person who has heard of Perfmon but not used it. This is very much a 100 level offering. The last ...

Want to Learn More About SSIS and Biml? Upcoming Training Opportunities! 21 May 2015
Here’s a list of upcoming training opportunities for people wanting to learn more about SQL Server Integration Services (SSIS) and Business Intelligence Markup Language ( Biml ): Office Hours: Is Biml Right for You ? Live Q & A Webinar 27 May 2015 at 12:00 PM EDT. Register , it’s FREE! Advanced ...