17th - 19th July 2014

The International Centre, Telford

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

Azure Automation – the beginning of cloud ETL on Azure? 24 Apr 2014
I have maintained a watching brief on what I refer to as “cloud ETL”, that is the ability build ETL routines in a cloud environment and therefore leverage all the benefits that the cloud model brings*. Thus far my main opinion piece in this area is What would a cloud-based ETL tool look like? in ...

Top Clause and Other Factors in Problematic Execution Plans 23 Apr 2014
Three years ago, I conducted an extensive investigation on a SQL Server system running kCura's Relativity document e-discovery application. It was fascinating to see the broad range of problematic queries all from one application. This provided good material for my presentation Modern Performance ...

Yes, you can install SQL Server 2014 Books Online locally 23 Apr 2014
I've seen people complain that SQL Server 2014 did not ship with documentation you could install locally. While true, it is just because the publication lagged; the local Books Online option is available now. First, make sure you have the documentation components installed. (Note that these use the ...

Cars, Databases, and Benchmarks 22 Apr 2014
Over the last few months we have migrated some functionality from Sql Server to PostgreSql, and developed a couple of new systems powered by PostgreSql. So far I do not see that either of these two products is better than another - they are different. Even though I guess this is the right time to ...

Windows 8.1 Start Menu partial workaround 22 Apr 2014
I want a Windows 7 Start Menu when I’m in desktop mode on Windows 8.1 without installing third party applications or going to a lot of trouble. I implemented a simple workaround that provides some of the functionality I’m seeking. It’s limited to operating system specific features. I’ll call it a ...