February 2009 - Posts

• T-SQL Challenge: Grouped String Concatenation

  It's been quite a while since the LIKE vs ? Puzzle , and I feel like it's time for another one. Response was overwhelming last time, and I'm back with a much tougher puzzle and a much bigger prize. So get ready, because I'm going to really make you stretch Read More... Posted Friday, February 27, 2009 2:22 PM by Adam Machanic | 42 Comments Filed under: T-SQL, puzzle, contest, challenge, grouping, concatenation Attachment(s): grouped_string_concatenation_output.zip

• Who is Active? v7.30

  Who is Active? is a comprehensive DMV-based monitoring script, designed to tell you at a glance what processes are active on your SQL Server and what they're up to. It has a number of optional features so that you can get results quickly, or monitor deeply, Read More... Posted Wednesday, February 18, 2009 11:34 AM by Adam Machanic | 5 Comments Filed under: Scripts, DMVs, who is active, monitoring Attachment(s): who_is_active_v7_30.zip

• [New England] FYI: Andy Leonard Rocks!

  Just a quick note to say thanks to Andy Leonard for coming all the way to Boston to do a talk at the New England SQL Server Users Group last night. Andy's topic was Change Data Capture and SSIS 2008, and in addition to those core areas he showed the group Read More... Posted Friday, February 13, 2009 4:40 PM by Adam Machanic | 3 Comments Filed under: New England, nesql