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

PASS Program Committee - Comments and Action 30 Mar 2015
Once again, I am serving on the PASS Program Committee this year for the App Dev Track. As we are about to start the reviewing process, I had some thoughts that I wanted to share. Last year, we had approximately 200 abstracts to review. It should be a similar volume this year. For me, abstracts ...

ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior - SQL Server Performance 30 Mar 2015
Here are some oldies, but goodies that I recommend you read: Two Partitioning Peculiarities and Aggregates and Partitioning Most of us know that partitions are one of the best ways to scale very large databases or very large IO workloads. However, there are risks, two of which are explored in ...

Data Mining Algorithms – Hierarchical Clustering 28 Mar 2015
Clustering is the process of grouping the data into classes or clusters so that objects within a cluster have high similarity in comparison to one another, but are very dissimilar to objects in other clusters. Dissimilarities are assessed based on the attribute values describing the objects. There ...

Tabular Data Packages and a BIML challenge 27 Mar 2015
Update. The challenge set below has been responded to by Scott Currie who also happens to be the inventor of BIML. He has made his work  available at https://github.com/bimlscript/BETDPI In February 2004 I joined a company called Conchango and had the pleasure of working with ...

After Ten Years... 27 Mar 2015
Life goes on and sometimes it is just time to move on. I am no longer with Scalability Experts. Looking back at all of the time that I spent with them, I realize how fortunate that I was to be part of it. I am writing this because I wanted to thank Scalability Experts for supporting me in my ...