May 18, SQL Saturday returns yet again to the Atlanta area. At this point I've become a bit of a regular at Atlanta's events; this will be my third one in a row. The team that puts them together is amazing, and produces top quality, super fun and educational days every time. Plus: Taco Mac. Friday, May 17, the event is running a few ...

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 the PASS Summit last Thursday. I'm not sure how long this link will work, but I'd like to share ...

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 second year in a row, I had to deliver said talk at 10:15 in the morning, in a room used as ...

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

QueryParallelizer is a .NET component designed to assist with parallel processing and ETL of SQL Server-based data. It can be used either hosted in the SQL Server process as a SQLCLR module, or in an external .NET application. Full documentation forthcoming.

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 LoadThe power of SQLCLR as a performance tool has been well-documented at this point; certain queries, when re-written the right way using SQLCLR components, can run an order of ...

Just a quick note to let you know that I did an interview with my friend Richard Campbell for his IT podcast, RunAs Radio. The topic is -- of course -- the common theme of my blog as of late: parallelism. Check it out!

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 Things at Once: Multitasking, Parallelism, and Process Distribution,'' and the focus is on ...

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 the presentation. The topic is Parallelism and Performance. Here's the abstract:In ...

Congratulations! You've made it back for the the third and final installment of Parallelism Week here at SQL University. So far we've covered the fundamentals of multitasking vs. parallel processing and delved into how parallel query plans actually work. Today we'll take a look at the settings and options that influence intra-query parallelism and ...