Platinum Sponsor
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

Four New Slide Decks for SQL Server and IT Pros from the DevLink 2014 Conference 29 Aug 2014
Get slides about Microsoft SQL Server: Internals & Architecture, Top 10 DBA Mistakes, Ten SQL Coding Practices, and Persuasion Techniques for IT Pros...(read more)

SSIS Dashboard v 0.6.1 29 Aug 2014
Yesterday I’ve released the latest SSIS Dashboard update. There quite a lot of new features included that I found to very useful when you have a server full of packages and logs. Here the complete list: Highlighted the feature I think worth the most: Updated Morris.js to v 0.5.1 Updated ...

On Agile Data Warehousing 28 Aug 2014
In the last month, I’ve been working on the slide deck of my Agile Data Warehousing workshop. In order to give to it additional value that goes beyond the pure technical aspects, and since now the “Agile” approach is becoming more and more mainstream also (and finally!) on BI, I did a small ...

Attitudes I Wish I Had Earlier 28 Aug 2014
Mike Walsh ( blog | @Mike_Walsh) tagged me in his post, 4 Attitudes I Wish I Had Earlier as a DBA . You should read Mike’s post, it’s filled with helpful and good advice and tells cool (and not-so-cool) stories. I admire Mike’s transparency. I struggle with the four areas Mike already covered – ...

Presenting on Biml to the SQL Midlands in Birmingham (UK) 11 Sep 2014! 27 Aug 2014
I am honored to present “Using Biml as an SSIS Design Patterns Engine” to SQL Midlands in Birmingham 11 Sep 2014 starting at 18:15! As at SQL Supper the evening before, the other presenter is my esteemed friend, Chris Webb ( @TechniTrain ). Chris’ session is titled, “Everything you wanted to know ...