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

Archiving Azure Automation logs to Azure BLOB Storage 25 Nov 2014
For the past few months at work I’ve been diving headlong into a service on Microsoft Azure called Azure Automation which is, to all intents and purposes, a service for hosting and running Powershell scripts (properly termed “runbooks”). I’ve got a lot to say and a lot to share about Azure ...

SQL Server 2014 Overview on DBTA.com 25 Nov 2014
Haven't upgraded late? Well, SQL Server 2014 is a great place to start! Perhaps this is your first time reading my column on DBTA.com or you don’t know much about SQL Server. If either of those are true, then it might be a surprise to you that Microsoft has accelerated the release cadence for SQL ...

Rett Syndrome Research needs help 25 Nov 2014
Very proud of my daughters this week. As some of you will know, one of my daughters has Rett syndrome. It's a rare chromosomal disorder that basically only impacts girls. (Boys can get it but they usually do not survive long after birth). Girls develop fairly normally up to about 12 to 18 months of ...

Perth SQL Server User Group this Thursday 5PM 25 Nov 2014
Looking forward to seeing the Perth locals at the SQL Server user group this Thursday night at 5PM. The topic that the group has chosen is an Introduction to SQL Server High Availability Options. It’s on at the BHP offices at 125 St Georges Terrace. If you are coming, please ping Jenny to let ...

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