Adam Machanic : Performance

SQL Saturday #220 (Atlanta): Demos

Adam Machanic — Sat, 18 May 2013 18:33:00 GMT

Today at SQL Saturday #220 in Atlanta I presented a new brand new session , "SQL Server Query Plan Analysis: The 5 Culprits That Cause 95% of Your Performance Headaches." This session is designed to help people quickly analyze query plans and find likely...(read more)

SQLCLR Performance Session at TechEd US

Adam Machanic — Wed, 08 May 2013 16:14:00 GMT

I am super-excited to visit New Orleans next month for Microsoft TechEd; it will be my sixth time speaking at the show. My session takes an in-depth look at some of the techniques I've developed for using SQLCLR modules -- and some of the great performance...(read more)

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)

SQL Saturday 89 - Atlanta GA - Materials

Adam Machanic — Sat, 24 Sep 2011 16:57:00 GMT

Last Saturday, September 17, I was lucky to be able to present two sessions at an excellent SQL Saturday in the Atlanta area. The day drew a large crowd and had a great speaker lineup. All in all, a huge success, and a very well-managed event. Congratulations...(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)

Performance, Discounts, and an Excuse to Visit New York City

Adam Machanic — Thu, 02 Jun 2011 14:21:00 GMT

A couple of weeks ago I announced a two-day advanced performance seminar in New York City, which will be delivered in July. This seminar will cover SQLCLR and parallelism techniques to help you take performance well beyond the levels that typical tuning...(read more)

Two Days of Advanced Performance Techniques - July 14-15, New York City

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

I am pleased to announce that I will be delivering two days of training in New York City, July 14 and 15. This seminar focuses on achieving "next-level" performance--going beyond that which you can gain via normal tuning methodologies . The vehicles for...(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 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)

Revisiting ISNULL, COALESCE, and the Perils of Micro-Optimization

Adam Machanic — Wed, 30 Jun 2010 17:12:00 GMT

Almost six years ago--in November of 2004--I posted what would turn out to be one of my most popular blog posts in terms of number of reads, " Performance: ISNULL vs. COALESCE ." (If you're curious, the post is dated July 2006 because I was too lazy it...(read more)

A Warning to Those Using sys.dm_exec_query_stats

Adam Machanic — Fri, 23 Apr 2010 02:15:00 GMT

The sys.dm_exec_query_stats view is one of my favorite DMVs. It has replaced a large chunk of what I used to use SQL Trace for--pulling metrics about what queries are running and how often--and it makes this kind of data collection painless and automatic....(read more)

World Class Training For Them, an Amazon Gift Certificate For You

Adam Machanic — Mon, 15 Mar 2010 15:40:00 GMT

We have just two weeks to go before Paul Randal and Kimberly Tripp touch down in the Boston area to deliver their famous SQL Server Immersions course . This is going to be a truly fantastic SQL Server learning experience and we're hoping a few more people...(read more)