Monthly Archives: June 2011

Why Two Devices

I used to travel with two laptops, one as a backup, however lately I’ve switched to taking the iPad and a laptop. The iPad doesn’t double as a backup, but it does let me do things like take notes at … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Five Lines of Code

An interesting story on how a database speeds up by changing some application code. Worth the read for sure. I caught this from Andy Warren’s blog, and it shows why we need developers to think for themselves and ask relevant … Continue reading

Posted in Blog | Tagged , | Comments Off on Five Lines of Code

Regular Audit Analysis

I was reading over a digital supplement that I received from Dark Reading recently, which details some of the issues in the Epsilon, Gawker Media, and a few other data breaches. It was light on details, but there were some … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Regular Audit Analysis

Setting a Unique Index on a Bit Field

Can you set a unique index on a bit field? Well, you can, but you’d end up with a very short table of two (or three) rows. I defined this table: CREATE TABLE [dbo].[BitTest]( [MyBit] [bit] NULL, [MyName] [varchar](50) NULL … Continue reading

Posted in Blog | Tagged , | Comments Off on Setting a Unique Index on a Bit Field