Browse by Tags

• audit
• CDC
• change data capture
• change tracking
• errors
• exception handling
• row_number
• Scripts
• SQLCLR
• TechEd

• 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 | 2 Comments Filed under: audit, change data capture, change tracking, demos, OVER clause, SQLCLR, TechEd Attachment(s): Adam_Machanic_TechEd_2010.zip

• 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: audit, CDC, change tracking, demos, errors, exception handling, OVER clause Attachment(s): machanic_connections09_demos.zip

• Demos From Cape Cod .NET: T-SQL Power! Presentation

  On Tuesday night I was honored to present a new talk to the Cape Cod .NET Users Group that meets in Plymouth, MA. The talk is called "T-SQL Power! Learning to Harness the Under-Used OVER Clause". Following is the abstract for the talk: First introduced Read More... Posted Thursday, June 18, 2009 1:05 PM by Adam Machanic | 0 Comments Filed under: demos, OVER clause, row_number, Scripts Attachment(s): T_SQL_Power_Demos.zip