Adam Machanic

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)

INSERT SELECT is Broken. Ask Microsoft to Fix It.

Adam Machanic — Wed, 15 May 2013 16:42:00 GMT

Imagine that you're moving thousands or millions of rows between two tables . Maybe it's between a staging table and a data warehouse in an ETL process. Maybe you're manipulating some data via a temp table as you're preparing lookup data for your OLTP...(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)

More Fun in Atlanta: Parallelism at SQL Saturday 220

Adam Machanic — Mon, 25 Feb 2013 19:25:00 GMT

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

Capturing Attention: Writing Great Session Descriptions

Adam Machanic — Fri, 22 Feb 2013 14:00:00 GMT

One of the best ways we can differentiate ourselves and further our careers is to get out of the office… and onto a stage . Presenting can give you name recognition; open doors to new opportunities; help you gain a deeper understanding of technology (teaching...(read more)

Itzik Ben-Gan in Atlanta: May 13-17

Adam Machanic — Tue, 05 Feb 2013 21:10:00 GMT

This year Data Education is offering a few more classes with Itzik Ben-Gan, the world's foremost T-SQL instructor . Our first offering has just been announced: Atlanta, May 13-17 . Neither Itzik nor his class needs much introduction, but click through...(read more)

[New England] SQL Saturday #203: April 5-6, Cambridge MA

Adam Machanic — Tue, 29 Jan 2013 16:10:00 GMT

SQL Saturday returns to the Boston area this April , with what is certain to be an exceptional speaker and session lineup . (The actual schedule will be posted soon, but in the meantime you can see the submitted sessions .) The free event ($10 if you'd...(read more)

[New England] Mark Souza on Big Data and Cloud at NESQL

Adam Machanic — Sun, 13 Jan 2013 18:33:00 GMT

This Thursday, January 17, at New England SQL Server we'll be featuring Mark Souza , General Manager of the Data Platform Group at Microsoft. Most of you are probably familiar with that name; he's the guy who founded the CAT team , and he's been in a...(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)

CloudSeeder: CLR Stored Procedures For Creating CPU Pressure

Adam Machanic — Tue, 23 Oct 2012 19:49:00 GMT

Sometimes, in the interest of testing various scenarios that your server might encounter, it's useful to be able to quickly simulate some condition or another. I/O, memory, CPU pressure, and so on. This latter one is something I've been playing with a...(read more)

SQL in Boston -- Red Gate Style

Adam Machanic — Thu, 16 Aug 2012 19:03:00 GMT

You might have heard of Red Gate's famous SQL in the City events: free, full-day educational events where you can learn from Red Gate's own evangelists in addition to various MVPs and other guests. With just a tiny bit of marketing thrown in for good...(read more)

Excellent Job Opportunity: SQL Developer in Boston MA

Adam Machanic — Thu, 09 Aug 2012 16:09:00 GMT

Want to do interesting, in-depth SQL Server development work for a great company? If the answer is yes, you should drop me a line immediately. Send me your resume at [my first name] @ [the name of this site]. More information: This job is working on a...(read more)

Your Transaction is in Jeopardy -- and You Can't Even Know It!

Adam Machanic — Wed, 27 Jun 2012 01:10:00 GMT

If you're reading this, please take one minute out of your day and vote for the following Connect item : https://connect.microsoft.com/SQLServer/feedback/details/444030/sys-dm-tran-active-transactions-transaction-state-not-updated-when-an-attention-event-occurs...(read more)

SQL Saturday 111: Manhandling Parallelism - Demos

Adam Machanic — Mon, 16 Apr 2012 01:30:00 GMT

Another year, another fantastic Atlanta SQL Saturday. Hats off to the team that created the event for delivering a top notch day for the attendees. Thanks to everyone who attended my "Query Tuning Mastery: The Art and Science of Manhandling Parallelism"...(read more)