Adam Machanic : PASS

Query Tuning Mastery at PASS Summit 2012: The Video

Adam Machanic — Tue, 13 Nov 2012 14:49:00 GMT

An especially clever community member was kind enough to reverse-engineer the video stream for me, and came up with a direct link to the PASS TV video stream for my Query Tuning Mastery: The Art and Science of Manhandling Parallelism talk, delivered at...(read more)

Query Tuning Mastery at PASS Summit 2012: The Demos

Adam Machanic — Mon, 12 Nov 2012 04:00:00 GMT

For the second year in a row, I was asked to deliver a 500-level "Query Tuning Mastery" talk in room 6E of the Washington State Convention Center, for the PASS Summit. ( Here's some information about last year's talk, on workspace memory. ) And for the...(read more)

PASS Summit 2011 - Zen and the Art of Workspace Memory - Demos

Adam Machanic — Mon, 17 Oct 2011 00:23:00 GMT

What a rush . Standing on the stage in an almost-full 1,000-person room, I (very) momentarily wondered what I'd been thinking when I submitted a 500-level talk for the biggest SQL Server conference in the world. But despite a rough start--my laptop crashed...(read more)

Where Can You Find Me the Rest of This Year?

Adam Machanic — Mon, 22 Aug 2011 00:28:00 GMT

Autumn is creeping inevitably closer here in the US, and that means that speaking season is about to kick into high gear. Here's my current schedule for the remainder of the year: September 8, 17:00 GMT (online) - 24 Hours of PASS webcast: "Baseline Basics...(read more)

TechEd 2011 - Performance Tuning and Optimization in SQL Server 2008 R2 and SQL Server Code Named "Denali"

Adam Machanic — Wed, 18 May 2011 16:05:00 GMT

Thanks to everyone who took the time out of their conference experience to join Mike Wachal and me for yesterday's session on SQL Server performance tuning! For those who weren't there, we focused in on troubleshooting techniques, highlighting some of...(read more)

PASS 2010 - Change Tracking and Change Data Capture Demos!

Adam Machanic — Thu, 11 Nov 2010 19:29:00 GMT

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...(read more)

Recent Webcasts on Parallel Processing Available for Download

Adam Machanic — Thu, 07 Oct 2010 13:03:00 GMT

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,...(read more)

Webcast - September 28, 2010 - Next-Level SQLCLR: Parallel Processing and Bulk Load

Adam Machanic — Mon, 27 Sep 2010 18:24:00 GMT

Tomorrow at 12:00 p.m. EDT (4:00 p.m. GMT) I'll be doing a webcast for the PASS Application Development Virtual Chapter . Next-Level SQLCLR: Parallel Processing and Bulk Load The power of SQLCLR as a performance tool has been well-documented at this point;...(read more)

PASS Summit 2010 Post-Conference Seminar on Parallel Processing

Adam Machanic — Wed, 04 Aug 2010 16:37:00 GMT

I am honored to have been selected for a second year in a row to present a full-day seminar at the PASS Summit. This year's seminar will be a "post-con", and will be delivered on Friday, November 12 . The title of the seminar is " A Day of Doing Many...(read more)

PASS Performance Virtual Chapter: Parallelize Your Queries!

Adam Machanic — Mon, 02 Aug 2010 15:51:00 GMT

Last month a new PASS Virtual Chapter was introduced, one with a theme that is near and dear to much of what I like to work on: performance . Tomorrow, Tuesday August 3rd at noon Eastern time , the chapter will have its second meeting, and I will be doing...(read more)

24 Hours of PASS: 15 Powerful Dynamic Management Objects - Deck and Demos

Adam Machanic — Wed, 19 May 2010 18:57:00 GMT

Thank you to everyone who attended today's 24 Hours of PASS webcast on Dynamic Management Objects! I was shocked, awed, and somewhat scared when I saw the attendee number peak at over 800. I really appreciate your taking time out of your day to listen...(read more)

Speaking Season About to Begin: MCM, Roadshow, PASS, and SQLCLR Precon at DevTeach

Adam Machanic — Tue, 21 Oct 2008 20:20:00 GMT

Fall is now in full swing, and after a relatively quiet several months my speaking schedule is about to jump into fairly-packed mode. Following is a list of where I'll be headed over the next couple of months:

Next week I'm really excited to be teaching a day of the Microsoft Certified Master: Microsoft SQL server 2008 program's beta rotation. I'll be teaching developer topics including ADO.NET, XML, and SQLCLR. Should be a good time!

November 12, the SQL Server 2008 Roadshow hits Boston, and I'll be presenting a half day on all sorts of SQL Server 2008 topics. This one is free, so if you're in the Boston area you have nothing to lose by checking it out.

November 19-21 is the PASS Summit, and I'm excited to be involved in three presentations. I'm doing a spotlight presentation on programmatic/application concurrency topics, a duo with Peter DeBetta called "[Anti]patterns and [Mal]practices", and a duo with James Luetkehoelter on performance metrics.

December 1 and 2 I'll be in Montreal, speaking at the always-fun DevTeach/SQLTeach conference. Aside from speaking in the regular conference program, on December 1 I will be doing a full-day preconference on SQLCLR development. In this preconference I will start with SQLCLR beginner topics and take you all the way through to some really advanced use cases. So this one should be of interest even if you've been using SQLCLR for some time. Best practices will be stressed, and you might just learn about some of the dusty corners you've not yet had a chance to touch. I'm also upgrading the content to cover what changes SQL Server 2008 brings to the table, so this will be a complete session on the topic. I think that SQLCLR, while not used much in SQL Server 2005, will really pick up adoption in SQL Server 2008 and beyond. So now is the time to pick up what will be a key skill going forward.