Browse by Tags

• adventureworks
• audit
• best practices
• bigAdventure
• CDC
• change data capture
• change tracking
• demo database
• errors
• exception handling
• OVER clause
• row_number
• Scripts
• sql server connections
• SQLCLR
• TechEd
• vegas

• SQL Server Connections Fall 2011 - Demos

  Today is the last day of the annual SQL Server Connections show in Vegas, and I've just completed my third and final talk. (Now off to find a frosty beverage or two.) This year I did three sessions: SQL302: Parallelism and Performance: Are You Getting Read More... Posted Thursday, November 03, 2011 5:12 PM by Adam Machanic | 3 Comments Filed under: demos, sql server connections, vegas Attachment(s): machanic_connections_fall_2011_demos.zip

• Thinking Big (Adventure)

  If the title of this post doesn't have you scratching your head, you may have been paying very rapt attention last time you saw me speak. I love the portability of AdventureWorks and the fact that anyone can download it. Since it was released I've used Read More... Posted Monday, October 17, 2011 1:56 PM by Adam Machanic | 7 Comments Filed under: demos, adventureworks, demo database, bigAdventure Attachment(s): make_big_adventure.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: 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 | 4 Comments Filed under: demos, errors, exception handling, OVER clause, CDC, audit, change tracking 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: Scripts, demos, row_number, OVER clause Attachment(s): T_SQL_Power_Demos.zip

• 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