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.

Blog posts RSS

The state of Multidimensional and Tabular adoption 23 Oct 2014
SQL Server Analysis Services is a product that does not have its own product code, being sold as part of SQL Server. I think that also Microsoft does not know (and cannot know) the exact number of users. For this reason, it’s also more difficult to analyze the effective usage of the two different ...

SQL Server 2014 CU4 is available for downloading 22 Oct 2014
The SQL 2014 CU4 is available :)There are some interesting facts:·         66 issues were solved BI\Analysis Services 10 BI\Collaborative Insights 1 BI\Reporting Services 11 ...

SQL Server 2014 Cumulative Update #4 is available! 21 Oct 2014
Microsoft has released Cumulative Update #4 for SQL Server 2014. KB Article: KB #2999197 66 fixes total (54 fixes listed publicly at time of publication), including several fixes for Management Studio. Build number is 12.0.2430 Relevant for @@VERSION 12.0.2000 through 12.0.2429...(read more)

A strange behavior of AutoExist for MDX on Tabular models #powerpivot #ssas #tabular 21 Oct 2014
Alberto Ferrari wrote an interesting article about a strange behavior of AutoExist in normalized data models. I always say that a star schema is the best practice in Power Pivot and Tabular data modeling. The issue described by Alberto is another good reason to avoid snowflake schemas. I think ...

Hey, Windows 10, fix this! 17 Oct 2014
So I hear that in Windows 10 they’re making improvements to the DOS window. You’ll be able to resize it now. And use Shift plus the arrow keys to select text. That’s great. Stunning in fact. Now here’s some more things they might want to have a go at at the same time. Make the environment variable ...