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

In The Cloud: Creating Your First Azure SQL Database 23 Oct 2014
Creating your first SQL Database in Azure is quick and easy. There are a few things I’ve discovered that might help you be successful faster. Many people have asked me how to get started, so I’ve provided these steps to success. The steps I show you aren’t the only way to achieve success. This is ...

Are you ready for PASS Summit 2014? 23 Oct 2014
I wanted to re-publish an old blog post that is still fairly accurate. It is actually a summary of blog posts I did back in 2011. http://sqlblog.com/blogs/rick_heiges/archive/2011/09/19/pass-summit-2011-what-you-can-expect-at-the-conference-summary.aspx A great deal of the information is still ...

SQL Saturday #356 Slovenia Schedule Is Alive! 23 Oct 2014
We are approaching the PASS SQL Saturday #356 Slovenia event. Today, we published the schedule. With so many submissions, we had a hard time to select only 24 sessions. Unfortunately, we could not accommodate all of the speakers who submitted sessions. However, we decided to invite to speakers ...

The state of Multidimensional and Tabular adoption 23 Oct 2014
SQL Server Analysis Services is a product that does not have its own product code, being sold as part of SQL Server. I think that also Microsoft does not know (and cannot know) the exact number of users. For this reason, it’s also more difficult to analyze the effective usage of the two different ...

SQL Server 2014 CU4 is available for downloading 22 Oct 2014
The SQL 2014 CU4 is available :)There are some interesting facts:·         66 issues were solved BI\Analysis Services 10 BI\Collaborative Insights 1 BI\Reporting Services 11 ...