2009

BLOBs – The AIG of Data Integrity

OK – so there is no one-size-fits-all way to define the use of BLOBs in your database.  But this crazy bandwagon of putting file storage into BLOBs really has me baffled.  I think it is…well…down right stupid.  Why the metaphor with AIG – because people are treating BLOBs like they represent an additional layer of

BLOBs – The AIG of Data Integrity Read More »

SQL Server 2008: Adding an Identity to Existing Column

No. You are probably not.  Here is a SHORT ANSWER (just to show the concept) for putting an IDENTITY on an existing column, based on what I’ve seen: Use All Tasks -> Generate Scripts to script the schema of the table(s) you want to alter.  Script it to an SSMS query window. Go through the

SQL Server 2008: Adding an Identity to Existing Column Read More »

The Dark Side of Cloud Computing

Cloud Computing is the whole new buzzword… but what about Dark Cloud Computing? What is it?  WHAT IS IT, YOU SAY? Let me tell you a tale.  THE GROUND WORK As the mad dash goes on to reuse components across the enterprise and indeed across multiple enterprises and even the world-wide web itself, there exists

The Dark Side of Cloud Computing Read More »