4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London


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

In The Cloud: Using InPrivate Browsing 23 Jan 2015
Periodically people post looking for an answer to the following error message which is also shown in Figure 1. Frequently zebra diagnoses are presented as the response. In healthcare, a zebra diagnosis is when you overlook the simple and the obvious. If you hear hoof beats, you should think of ...

Self-Awareness – Feedback 23 Jan 2015
Self-awareness is an important trait. I believe it is especially important for consultants. For each of us, there is some gap between reality and what we perceive. I believe one measure of humility (or pride) is this self-awareness delta. I also believe we can narrow this gap by engaging in ...

Backup Basics–Doing it Faster 22 Jan 2015
Several customers have told me that the time it takes to back up their databases is taking longer than they are comfortable with. Others have told me their backups take a long time but they don’t mind. Whatever the case, getting things done more quickly is usually worth at least a quick look. There ...

Managing Geeks Now Available for the Kindle! 22 Jan 2015
Managing Geeks – A Journey of Leading by Doing is now available at Amazon in paperback and Kindle editions! Many people have expressed interest in obtaining an electronic copy of Managing Geeks. I’m sorry it took this long, but it is finally available. On a related note, I now know a lot more about ...

Dynamic ABC Classification in DAX #powerpivot #dax #ssas #tabular 22 Jan 2015
Less than one year ago I published a pattern about ABC Classification in DAX. Such a pattern was static, so an item (e.g. customer, product) is classified statically when you process a Power Pivot or Tabular model, so filters and slicers querying data do not affect the classification’s results. In ...