adam_machanic.jpg

Adam Machanic

Adam Machanic is a Boston-based independent database consultant, writer, and speaker. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications. 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 user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, Microsoft Certified IT Professional (MCITP), and a former member 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

Hey, Windows 10, fix this! 17 Oct 2014
So I hear that in Windows 10 they’re making improvements to the DOS window. You’ll be able to resize it now. And use Shift plus the arrow keys to select text. That’s great. Stunning in fact. Now here’s some more things they might want to have a go at at the same time. Make the environment variable ...

Passing credentials between Azure Automation runbooks 16 Oct 2014
Update: Turns out there's an even easier way of achieving this than the method I've described in this blog post. Joe Levy explains all in the comments below. I’ve been doing a lot of work lately using Azure Automation to run (what are essentially) Powershell scripts against Azure. Recently the ...

PASS SQL Saturday #356 Slovenia – Speakers and Sessions Submitted Breakdown by Country Final 16 Oct 2014
So this is the final analysis of the speakers and the sessions submitted for the PASS SQL Saturday #356 Slovenia event, December 13th, Ljubljana, Slovenia. Call for speakers closed on October 15th. The number of proposed sessions and speakers is impressive. I am really honored and humbled by the ...

T-SQL Tuesday #59: My Hero! 15 Oct 2014
This month's edition of T-SQL Tuesday is being hosted by Tracy McKibben ( T | B ). I was challenged by Aaron Bertrand ( T | B ) to participate in this T-SQL Tuesday. I instantly knew what and who I wanted to write about, but my schedule being what it is prevented me from writing the blog entry ...

Heroes of SQL 13 Oct 2014
Every story has heroes. Some heroes distinguish themselves by their superpowers; others by extraordinary bravery or compassion; some are simply heroes because of what they do in their jobs. We picture the men and women who work in the emergency departments of hospitals, soldiers who go back into ...