Platinum Sponsor

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.

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

[Re-] Updated: Creating a Custom SSIS 2012 Task 01 Oct 2014
Apologies. My first edition of this post copied outdated links to this series. I have corrected the links but left the comments pointing out my earlier error. Thank you to those who let me know! :{> A while back I asked myself: “Self, do you think it is possible to create a custom SSIS 2012 task ...

Declarative, Model Driven Development (10 days of SSDT – day 9) 01 Oct 2014
SQL Server Data Tools (SSDT) was released in Spring 2012 and I have been using it to build SQL Server databases nearly every day since then. In that time I’ve learnt a lot about how to make best use of the tool and I want to share that experience in a new series of blog posts called “10 days of ...

SQL Server 2008 Service Pack 4 is available! 30 Sep 2014
Microsoft has released the final Service Pack (SP4) for SQL Server 2008. Build # 10.00.6000 KB Article: KB #2979596 ( Download ) 6 public fixes, including important security fixes from MS14-044 Relevant for builds < 10.00.6000 NOT for SQL Server 2008 R2 (10.50.xxxx) Once more, this is the last ...

Advanced DAX Workshops in the upcoming months –#dax #tabular #powerpivot 30 Sep 2014
The adoption of DAX is slowly growing and we can see that from comments to article, blog posts, web site traffic (including DAX Formatter usage). For this reason, the demand for more advanced training about DAX is also increasing. We had great feedback from our last white papers (Using Tabular ...

Reminder: If You Want to Vote in the PASS Board of Directors Election, You Have 6 Days… 29 Sep 2014
Per Thomas LaRock’s post titled Board of Directors Election Update on the PASS Blog : All PASS members who have not yet received a ballot and who had an existing profile as of June 1, 2014, will be given the opportunity to receive a ballot by updating their profiles before October 5, 2014, at ...