Monthly Archives: August 2012

Identity Insert and Table Variables – CONNECT issue

Posted on August 3, 2012 by way0utwest

I was running some code the other day and was surprised by the result. DECLARE @tmp TABLE (myID INT IDENTITY,MyChar VARCHAR(200)) INSERT INTO @tmp(MyChar) Values(‘Apple’) INSERT INTO @tmp(MyChar) Values(‘Peach’) INSERT INTO @tmp(MyChar) Values(‘Pear’) DELETE FROM @tmp WHERE myID = 2 … Continue reading →

Posted in Blog | Tagged , | 4 Comments

The Copy Cat Poll

Posted on August 3, 2012 by way0utwest

One of the interesting facts I saw a few years ago talked about storage in enterprise environments. There was research that showed many enterprise applications had 6 or 7 copies of their large databases inside the organization. In addition to … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Copy Cat Poll

Who’s Responsible

Posted on August 3, 2012 by way0utwest

This is really scary. Someone being sued for downloading a porn movie illegally. I have nothing against porn, and I certainly think that downloading stuff that’s a copyright violation shouldn’t be mainstream as in Amazon giving away movies for free … Continue reading →

Posted in Blog | Tagged , | Comments Off on Who’s Responsible

No Limits

Posted on August 2, 2012 by way0utwest

We’ve had Amazon Web Services (AWS) available for some time, and used for some interesting projects that wouldn’t be possible if groups had to purchase their own equipment. From password cracking to cancer research, there are some amazing possibilities. Windows Azure works as … Continue reading →

Posted in Editorial | Tagged | Comments Off on No Limits