May 2009 - Posts

• Grouped String Concatenation: ... The Winner Is ...

  After weeks of putting it off, I finally found the time and spent the last day and a half judging the Grouped String Concatenation Challenge . I would like to congratulate the winner, Peter Larsson , who submitted a great query and walks away with a shiny Read More... Posted Sunday, May 31, 2009 5:07 PM by Adam Machanic | 18 Comments Filed under: challenge, concatenation, T-SQL Attachment(s): GroupedString.zip

• Peter DeBetta and I Rock .NET

  ... or something like that. We're featured on this week's .NET Rocks! show , discussing some of the intricacies of database design with Richard and Carl. Enjoy! Read More... Posted Tuesday, May 19, 2009 11:10 AM by Adam Machanic | 0 Comments Filed under: .NET Rocks

• 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: extended events, TechEd 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 | 3 Comments Filed under: errors, exception handling, TechEd Attachment(s): TechEd09_DAT305_SQL_Exceptions_Depmos.zip

• I Swallowed the Twitter-Colored Pill

  I'm not entirely certain what color that is, but follow me here (if you dare) . In keeping with the Twitter mentality I'll keep this post ultra-short. Read More... Posted Wednesday, May 06, 2009 10:14 PM by Adam Machanic | 10 Comments Filed under: twitter