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

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 ...

What's New in Master Data Services - SQL2016 CTP2.2(July) Release 23 Jul 2015
SQL Server 2016 Community Technology Preview 2.2 is publicly released and the latest bits can be found at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 In CTP2.2 MDS introduced following changes: 1. Custom Indexes You can create a non-clustered index on one attribute (single ...

Professional Development - Set the Bar High 23 Jul 2015
Originally appearing at ForITPros.com . Henry Ford is reported to have once said, “Whether you think you can or think you can’t - you’re right.” That’s great insight. Too often people place self-imposed and artificial limitations on themselves. They tell themselves that they cannot accomplish ...

Utility to reset a sequence next value based on a table/sequence relationship 22 Jul 2015
So I was building a database the other day, and I used sequence objects for all of the defaults because it was FAR easier to load data into the table not needing to set identity_insert on and off over and over and over. Worked great. Went through all of my tests, everything was great. Got out ...