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

SQL Server 2016 Video Pills 28 Jul 2015
This is my first curation since Microsoft Curah! has been moving to a new Microsoft platform named docs.com.SQL Server 2016 Video Pills is a collection of videos about the most important features of SQL Server 2016; speakers are Engineers and Program Manager of the SQL Server Team!Would ...

ICYMI - Recommended Intel Processors For SQL '14, Should Indexes Be In The Key Or Included, Comparing Windows Azure VM Performance 28 Jul 2015
Some of my favorite articles originally appearing at SQLPerformance.com . Grouped Concatenation in SQL Server and Grouped Concatenation: Ordering and Removing Duplicates In these two related blog posts, Aaron Bertrand ( b | t ) of SQL Sentry takes on the safest and most efficient ways to perform ...

VertiPaq Analyzer for Analysis Services #ssas #tabular #powerpivot #powerbi 28 Jul 2015
During the writing of The Definitive Guide to DAX I wanted a simple way to analyze the content and distribution of data compressed in the VertiPaq engine, used by Analysis Services Tabular, Power Pivot and Power BI models. I always relied on BISM Memory Report (thanks Kasper!), but when you focus ...

Finding the number of the day in the year 25 Jul 2015
I needed to find the number of the current day of the year. It wasn’t related to SQL Server at all, so I did a search. Coincidentally, I saw several bad examples of how to do this using T-SQL. Bad examples sometimes prompt me to post and this is another one of those times. If you work with dates in ...

The new Power BI Desktop is here #powerbi #dax 24 Jul 2015
After months of public preview, Microsoft today is releasing the Power BI service to general availability. The preview was really a beta that evolved in these months, and I personally liked the approach that MS developers have now. I did not read the “it’s by design” answer to the many comments and ...