4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

adam_machanic.jpg

Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. 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 conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus 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

Clustered columnstore index rebuild script–updated 30 Jan 2015
Recently I published a series of blog posts that provided scripts for rebuilding clustered columnstore indexes. Niko Neugebauer sent me a suggested update to the latest version of those scripts and it makes sense. The change will help to filter out row groups that are not compressed and Niko noted ...

Consulting 101: Viewing the Field 30 Jan 2015
It’s important for a consultant to be able jump into a situation and quickly evaluate and assess the dynamics involved, in order to serve the client efficiently and effectively and economically. While a lot of people dislike military metaphors, there are a lot of good lessons to learn from military ...

SQL Saturday on Monday 29 Jan 2015
“No, no! The adventures first, explanations take such a dreadful time.” ― Lewis Carroll. Alice's Adventures in Wonderland   The idea to organize SQL Saturday is so exiting and scary at the same time. For me - this is my first SQL Saturday. For SQL Saturday - this is a first time in ...

Hello, World! Encore Edition aka Good-bye, Microsoft 28 Jan 2015
Moving On After nearly nine years at Microsoft, I’ve chosen to move on. I’ve accepted a position at Fusion-io—now a SanDisk company—as Worldwide SQL Server Solutions Architect where I’ll be evangelizing, documenting best practices, collaborating directly with the Windows & SQL product teams ...

Interpreting Communication 28 Jan 2015
One important thing about which to be self-aware is how you interpret communication. Communication is a two-phase commit. The first part lies with the person communicating. She has an idea she wishes to communicate, and she communicates it – in writing or verbally. The second part is with the ...