THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Adam Machanic

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.

Recent Webcasts on Parallel Processing Available for Download

While preparing the material for my PASS Summit post-con on parallelism and parallel processing I realized that I could easily take a few chunks out, modify them a bit, and create some nice standalone webcasts. So I did just that, and delivered two sessions, one for the PASS Performance Virtual Chapter and another for the PASS Application Development Virtual Chapter.

Both of these sessions were recorded and are available for your viewing pleasure:

And speaking of the post-con, I've now finished prepping it and I have to say that it came out quite well. Weighing in at a massive 178 slides and 25 demos it will be a dense day to be sure, but I can promise you that it will be a day absolutely packed with interesting material for my core audience: the hardcore DBAs, developers, and -- of course -- geeks.

We'll start with a bit of 200-level history and theory then ramp up quite quickly and spend most of the day in 300-level and 400-level internals land. You'll leave with a deep understanding of how parallelism works, options and tradeoffs for various settings, and I'll show you some fascinating query patterns and techniques that will help you immediately speed up big queries and batch processes.

Check out the webcasts for a preview of some of the material that will be covered. It's not too late to register and I hope you'll join me in Seattle!


Published Thursday, October 7, 2010 10:03 AM by Adam Machanic

Comment Notification

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 RSS



Yaroslav said:

Hi Adam, the PASS link to the Parallelism webcast keeps returning an error since couple of days ago: "Our server is currently busy, please try again shortly. We apologize for any inconveniences caused. Thank you for your patience. If this problem persists, please contact PASSHQ". I wrote to them but still no answer. Is there any other place were to watch the webcast? I tried youtube/vimeo without luck. Thanks!

January 30, 2014 2:45 AM

Adam Machanic said:


Unfortunately I have no clue. Did you try contacting @sqlpass on Twitter? Sadly they're often more responsive there than via e-mail :-(


January 30, 2014 9:05 AM

Yaroslav said:

Hi, thanks for answering. I contacted them and recieved an answer from Ryan Adams. The answer is: "The link is now fixed.  Please note that this was recorded with LiveMeeting back in 2010.  Microsoft has closed LiveMeeting as it is EOL and replaced with Lync so there is a chance that the download will not work." And indeed the link is still broken :(

The other link to the "Next-Level SQLCLR..." still works. Strange, as seems that they both where recorded with small time difference between them.

Maybe you have a copy of the video you could share? Dropbox, GoogleDrive, Mega?

Thanks a lot for your help and for your whoIsActive script ;)

February 3, 2014 2:57 AM

Adam Machanic said:


No copies on this end. I don't care to watch my own video and anyway I've updated the content since then ... hopefully you can catch me at a user group or conference sometime! :-)



February 3, 2014 11:32 AM

Leave a Comment


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.

This Blog


Privacy Statement