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

September 2014 Cumulative Updates for SQL Server 2012 15 Sep 2014
The SQL Server team has released two cumulative updates for SQL Server 2012. SQL Server 2012 Service Pack 2 Cumulative Update #2 KB Article: KB #2983175 Build # is 11.0.5548 Currently there are 50 public fixes listed Relevant for builds 11.0.5058 -> 11.0.5547. Do not attempt to install on SQL ...

SQL Saturday Dublin and Pre-Conference Seminars 15 Sep 2014
One of my favorite events is just around the corner! It's just a few days until SQL Saturday Dublin , Ireland’s largest SQL Server conference on the 19th/20th September, run as a community event by the SQL Ireland User Group. Have You Seen the Schedule? The schedule is complete with an amazing line ...

Sketch notes from 24 Hours of PASS 14 Sep 2014
24 Hours of PASS has passed and, beside the slides, demo and video (that will come soon on, this time, thanks to Matt Penny (@salisbury_matt) you can also have very nice and well done sketch notes that summarizes the concept of the ...

Azure SQL Database Hourly Billing 14 Sep 2014
There were a number of great announcements from Scott Guthrie today: One that particularly caught my eye was a subtle change to the billing for Azure SQL Database. Databases ...

Updated offline SQL Server 2014 Books Online install now includes T-SQL Reference 13 Sep 2014
Many customers want to install Books Online (BOL) when working with SQL Server. Generally I always think it’s a good idea. Not all environments though, allow external connectivity for the systems where the clients want to install BOL. A friend of mine Rob Sanders documented how to install BOL in ...