November 2009 - Posts

• Invitation to Participate in T-SQL Tuesday #001: Date/Time Tricks

  T-SQL Tuesday is the SQL Server blogosphere's first recurring, revolving blog party . The idea is simple: Each month a blog will host the party, and about a week before the second Tuesday of the month a theme will be posted. Any blogger that wishes to Read More... Posted Monday, November 30, 2009 1:47 PM by Adam Machanic | 57 Comments Filed under: datetime, date, T-SQL Tuesday, time

• Demos: Connections, Fall 2009, Las Vegas

  Thanks to everyone who attended my sessions this week at SQL Server Magazine Connections in Las Vegas. Attached to this post you will find the demos for the following sessions: SDV301: Best Practices for Exception Handling and Defensive Programming in Read More... Posted Thursday, November 12, 2009 6:15 PM by Adam Machanic | 2 Comments Filed under: demos, errors, exception handling, OVER clause, CDC, audit, change tracking Attachment(s): machanic_connections09_demos.zip

• PASS Summit 2009: Extended Events Demos

  Thanks to everyone who attended my talk on Advanced Extended Events at the PASS Summit this last week in Seattle. I just went to the PASS web site and noticed that they still haven't put the demos up for download. So just in case you're dying to play Read More... Posted Monday, November 09, 2009 11:32 PM by Adam Machanic | 3 Comments Filed under: Performance, extended events, PASS 2009 Attachment(s): MACHANIC_PASS09_XE.zip