Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.
This has been a truly intense week at the PASS Summit, as evinced by the multitude of blog posts on the topic here on SQLblog and elsewhere. My breakout session on Tuesday was entitled "What Happened?" and those of you who attended may be asking that question of me at this point. It's now Thursday and I promised that demo scripts would be posted on Wednesday.
So without further ado, here they are. Enjoy!
By the way, if you weren't there, the session was recorded, as was my five-minute Lightning Talk on the worst error in SQL Server, and as will be tomorrow's post-conference seminar on parallelism. You will be able to purchase DVDs with all of this material from PASS sometime in the coming months.
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About 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.