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

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

Simulate the SQL WHERE condition in DAX–#dax #powerpivot #ssas 29 Sep 2014
I recently wrote a short article about filtering data in DAX. In the last month I’ve seen a growing number of people with a SQL background going to Tabular, without having a previous experience of MDX. In my opinion, learning DAX is easier if you try to match its features to SQL rather than to ...

PASS SQL Saturday #356 Slovenia Pre-Conference Seminars 29 Sep 2014
I am proud and glad I can announce two top pre-conference seminars at the PASS SQL Saturday #356 Slovenia conference. The speakers and the seminars titles are: Stacia Misner - Power Up Your Data with Excel and Power BI Kevin Boles - Tune Like A Guru! Both seminars will take place on ...

SQL Server 2008 R2 Service Pack 3 is available! 28 Sep 2014
Microsoft has released a final service pack for SQL Server 2008 R2: Service Pack 3. The build # is 10.50.6000.34 and you can download it here . This is essentially a rollup of all of the fixes from the 13 cumulative updates for this branch (if you want to get a complete list of fixes, start at KB ...

Well Done, PASS Leadership 28 Sep 2014
I am impressed with the response of PASS leadership to the controversy surrounding the 2014 Board of Directors election. Others have covered the topic much better than I will here, but a short version is PASS responded to the PASS Board 2013 election controversy (members with multiple email ...