SQL Saturday 71: My Slide Deck

1

April 2, 2011 by Mike Hillwig

I’m speaking at SQL Saturday today. Here is my slide deck.

SQL Sat 71 Virtualization Success Story

One thought on “SQL Saturday 71: My Slide Deck

  1. Rich Mechaber says:

    Hey Mike, great talk on your virtualization project yesterday! I liked the Q@A/round robin format it morphed into.

    I saw your post from December about missing IDENTITY values in your PK column in an audit trail. This script will give you a third possible reason what might be occurring (other than “off your rocker” or “some explaining to do”):

    Yours,
    Rich

    USE dev;
    GO

    IF EXISTS (SELECT * FROM sys.tables WHERE [Name]=’Junk’ AND [Type]=’U’)
    DROP TABLE junk;

    CREATE TABLE junk (id INT IDENTITY(1,1));
    GO

    BEGIN TRAN
    INSERT INTO junk DEFAULT VALUES;
    GO 10

    ROLLBACK TRAN;

    INSERT INTO junk DEFAULT VALUES;

    SELECT *
    FROM junk;

Leave a Reply

Your email address will not be published. Required fields are marked *