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.

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

Data Mining Algorithms – K-Means Clustering 17 Apr 2015
Hierarchical clustering could be very useful because it is easy to see the optimal number of clusters in a dendrogram and because the dendrogram visualizes the clusters and the process of building of that clusters. However, hierarchical methods don’t scale well. Just imagine how cluttered a ...

SQL Server 2014 Service Pack 1 is available 15 Apr 2015
Microsoft has released Service Pack 1 for SQL Server 2014. However, do not install it if you use the SSIS catalog (SSISDB) . From the Release Services team blog : Notice: The SQL SSIS team has found an issue with SP1 installation if SSIS catalog is present in the SQL Server instance.They are ...

On Kindness 15 Apr 2015
Do you remember time kindness backfired? Do you remember kindness letting you down? Me neither. Kindness never fails. I can hear you thinking, “Yeah, Andy? Well there was this time I was kind and…” The thing you’re going to finish that sentence with, the thing that didn’t happen? That wasn’t going ...

How to cleanup transaction logs, Validation issues and Staging tables 14 Apr 2015
Master Data Services till recently didn’t have a supported way to clean the transaction logs, validation issues history and Staging tables. For a MDS system with lot of data changes and ETL processes over the period these tables can grow exponentially and lead to performance degradation and storage ...

Azure Machine Learning Course–First Melbourne Offering 14 Apr 2015
Hi Folks, we’ve been working hard on a new Azure Machine Learning course. Come and spend a solid day finding out why Azure Machine Learning should be part of your arsenal. Our first Melbourne offering of Azure Machine Learning Core Skills is 31st July. I’d love to see you there: ...