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

Revised File & Wait Statistics Procedures 02 Sep 2015
For many years I have been using a set of stored procedures to capture and report on both the file and wait statistics inside of SQL Server and I just recently did some more modifications that I wanted to make available. Since many of you have received copies of the past revisions via conferences ...

SQL 2014 queries under a strobe light 31 Aug 2015
I just wrote a post about Live Query Statistics. Let me show you how this technology in SQL Server 2014 can be used for some amazingly cool (nerdy cool, at least) stuff. Behind the scenes, LQS uses a DMV called sys.dm_exec_query_profiles. When you run a query with SET STATISTICS PROFILE ON, the ...

Power BI Desktop & Excel 31 Aug 2015
The August 2015 update of Power BI Desktop added two important features for existing Excel and Analysis Services users:Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop fileLive Analysis Services Connections: Ability to change the database from Edit ...

SQL Server 2016 CTP 2.3 - available for download 31 Aug 2015
HelloThe CTP2.3 is ready and waiting for you, SQL Folks! The official statement (by Kevin Farlee), is  as follow:This release includes enhancements to Analysis Services, Database Engine, Integration Services and Master Data Services. The build also includes stability and bug fixes ...

Live Query Statistics in SQL 2014, not just SQL 2016 31 Aug 2015
One of the coolest things in SQL Server 2016 is Live Query Statistics (LQS). But did you know that it’s available in SQL 2014? (Edit: Needs SP1) The thing is that we haven’t been able to view it effectively before now, before SQL Server Management Studio 2016 became available. LQS provides the ...