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.

Blog posts RSS

What are useful tools and resources for DAX developers? #dax #powerpivot #tabular 20 Nov 2014
At the last PASS Summit I received an interesting question: is there a list of all the useful (I would say necessary…) tools for DAX developers? My answer was… “no, but this is an interesting topic for a blog post”. In the meantime, I thought that a page to keep updated would have been better, and ...

SQLDay 2015 - should we plan it now? Yes - check out who will join us :) 19 Nov 2014
SQL Folks, SQL Geeks and others.... Is it the right time  to plan the next conference when the previous was finished last week? YES!!!! It is the right time!!! The PLSSUG is planning to have the biggest community conference ever. It will start at 11th May (Monday - preconf) and will be till ...

Allowing specific non-sysadmin users to query group membership for a login 18 Nov 2014
I had a lot of good feedback about my post the other day about how to query group membership for a given login. One tricky question was about how you could let a specfic user be able to find the group membership for another login, without the user being a sysadmin to run the code. Doing that is a ...

Conference - ITAD Bielsko Biała 18 Nov 2014
Good evening Today I had a lecture on the academic conference ITAD (http://www.itadbb.pl/). That is amazing that 300  people came and took part in the event.  I was talking about the SQLCLR which seems to be my main topic in the last months. That is because I use it over and over ...

November 2014 Cumulative Updates for SQL Server 2012 18 Nov 2014
Microsoft has released Cumulative Updates for SQL Server 2012 Service Pack 1 and Service Pack 2. Note that RTM is no longer supported and you should be moving to the SP2 branch soon. SQL Server 2012 Service Pack 1 Cumulative Update #13 KB #3002044 Build #11.0.3482 13 fixes (10 public) Relevant for ...