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

In The Cloud: Manually Migrating a Hyper-V VM to the Azure 27 Nov 2014
Azure is great for sharing reproductions on difficult problems. I managed to reproduce an application problem in a virtual machine on my laptop. It’s really not reasonable to ask for others to help me after following a long set of steps to build a matching test environment. Besides, something could ...

A Biml Case Study 26 Nov 2014
Business Intelligence Markup Language (Biml) is a SQL Server Integration Services (SSIS) design patterns engine. A Story of Productivity A while back I was contacted by a client experiencing a familiar issue. The Production SQL Server instance was experiencing performance issues due to conflicts ...

Put Your New Leadership Knowledge Into Practice 26 Nov 2014
Have you ever tried to hit a golf ball toward the pin, toss a dart at the bull's-eye, or chuck a fly at a trout? If you're like most people, your first attempt didn't come anywhere close to hitting the mark. Your golf ball may have found the woods, your dart may have sunk into the wall, and your ...

Some Thoughts on Event Speaker Selection 26 Nov 2014
I write this from the perspective of experience. I’ve helped organize dozens of events over the past ten years. Feel free to take the parts of this advice that help and discard the parts that don’t. Enjoy! Planning an event is hard work. If you’ve never volunteered to help your local User Group or ...

Mastering Execution Plan Analysis - Melbourne 6 Feb 2015 26 Nov 2014
Over the years I have spent working with SQL Server, the personal time investment that has repaid itself more than any other is becoming intimately familiar with execution plans and how they can be used to diagnose and correct performance problems. There is nothing I enjoy more than talking about ...