Adam Machanic

SQL Server Connections Fall 2011 - Demos

Adam Machanic — Thu, 03 Nov 2011 20:12:00 GMT

Today is the last day of the annual SQL Server Connections show in Vegas, and I've just completed my third and final talk. (Now off to find a frosty beverage or two.) This year I did three sessions: SQL302: Parallelism and Performance: Are You Getting...(read more)

Thinking Big (Adventure)

Adam Machanic — Mon, 17 Oct 2011 16:56:00 GMT

If the title of this post doesn't have you scratching your head, you may have been paying very rapt attention last time you saw me speak. I love the portability of AdventureWorks and the fact that anyone can download it. Since it was released I've used...(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)

Data Education: Food For Your Brain

Adam Machanic — Tue, 16 Aug 2011 13:20:00 GMT

I've written here before about Data Education , the training company I recently launched, building off my previous company Boston SQL Training. Things have moved along quickly, and I and the rest of the Data Education staff are very happy to announce...(read more)

A Computer Scientist Meets T-SQL

Adam Machanic — Wed, 10 Aug 2011 00:58:00 GMT

There I was. A freshly printed bachelor's degree in Computer Science tucked under my arm, I walked into my First Real Job. I'd never touched the technologies I was going to work with--ASP 3.0 and SQL Server--but my employer knew that, and I figured I'd...(read more)

T-SQL Tuesday #21 - A Day Late and Totally Full of It

Adam Machanic — Wed, 03 Aug 2011 18:38:00 GMT

“This ugly hack is only temporary,” you think. Six months later, a coworker curses your name, sacrificing a chicken to any deity that will help expedite your getting struck down by lightning, a school bus, or both. Crap code. We’ve all seen it. We’ve...(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)

Twenty Nine Days of Activity Monitoring (A Month of Activity Monitoring, Part 30 of 30)

Adam Machanic — Sat, 30 Apr 2011 14:00:00 GMT

This post is part 30 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the...(read more)

Access for All! (A Month of Activity Monitoring, Part 29 of 30)

Adam Machanic — Fri, 29 Apr 2011 14:00:00 GMT

This post is part 29 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the...(read more)

Who is Active's Hidden Gems (A Month of Activity Monitoring, Part 28 of 30)

Adam Machanic — Thu, 28 Apr 2011 14:00:00 GMT

This post is part 28 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the...(read more)

Who is Active v11.00 (A Month of Activity Monitoring, Part 27 of 30)

Adam Machanic — Wed, 27 Apr 2011 14:00:00 GMT

This post is part 27 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the...(read more)