Browse by Tags

• atlanta
• audit
• best practices
• change data capture
• change tracking
• demos
• errors
• exception handling
• extended events
• New England
• no more guessing
• Optimization
• OVER clause
• PASS
• Performance
• Speaking
• sql saturday
• sql server connections
• SQLCLR

• Where Can You Find Me the Rest of This Year?

  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... Posted Sunday, August 21, 2011 9:28 PM by Adam Machanic | 0 Comments Filed under: Performance, Optimization, New England, TechEd, Speaking, PASS, sql saturday, no more guessing, atlanta, sql server connections

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

  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... Posted Wednesday, May 18, 2011 1:05 PM by Adam Machanic | 2 Comments Filed under: Performance, Optimization, TechEd, PASS, no more guessing Attachment(s): Machanic_TechEd2011_Demos.zip

• TechEd 2010 Thanks and Demos

  Thank you to everyone who attended my three sessions at this year's TechEd show in New Orleans. I had a great time presenting and answering the really great questions posed by attendees. My sessions were: DAT317 T-SQL Power! The OVER Clause: Your Key Read More... Posted Thursday, June 10, 2010 2:00 PM by Adam Machanic | 3 Comments Filed under: SQLCLR, demos, TechEd, OVER clause, audit, change tracking, change data capture Attachment(s): Adam_Machanic_TechEd_2010.zip

• Demos - TechEd DAT402 - Microsoft SQL Server 2008: Performance Profiling and Troubleshooting with Extended Events

  Whew! Another TechEd session completed, and now I'm done for the week. Thanks to everyone who joined me today; I had a fantastic time talking about the ins and outs of Extended Events. Demos are attached. I realize how complex some of these topics are, Read More... Posted Thursday, May 14, 2009 3:52 PM by Adam Machanic | 3 Comments Filed under: TechEd, extended events Attachment(s): TechEd09_DAT402_XEvents_Demos.zip

• Demos - TechEd DAT305 - Best Practices for Exception Handling and Defensive Programming in Microsoft SQL Server

  A huge thank you to everyone who attended today's session on exception handling! I had a great time and got some very good, on-point questions from the audience. As promised, the demos are attached to this blog post. Please let me know in the comments Read More... Posted Wednesday, May 13, 2009 8:46 PM by Adam Machanic | 4 Comments Filed under: errors, exception handling, TechEd Attachment(s): TechEd09_DAT305_SQL_Exceptions_Depmos.zip

• TechEd Coming Up - Recommended Background for My Extended Events Talk

  TechEd North America 2009 is just a few short weeks away, and I'm really looking forward not only to the show, but also the opportunity to visit Los Angeles for the first time in several years. I'm busy putting the finishing touches on my Extended Events Read More... Posted Wednesday, April 22, 2009 10:46 PM by Adam Machanic | 4 Comments Filed under: TechEd, extended events

• Demos from my TechEd session (DAT302: Best Practices for Exception Handling and Defensive Programming in Microsoft SQL Server 2005 and 2008)

  If you attended my session this morning, thank you ! It's always flattering when people are willing to wake up before 8:00 a.m. just so that they can hear a talk about SQL Server. I had a great time doing the talk, and I think it went well. My sincerest Read More... Posted Thursday, June 05, 2008 11:48 AM by Adam Machanic | 1 Comments Filed under: demos, best practices, errors, exception handling, TechEd Attachment(s): Machanic_DAT302_Demos.zip