Nerding Out

Using a Common Page in App_Code with Session Variables

Whooo that is a humdinger.  Normally, when someone says “I want my class to have access to the current session state!” I look at them funny, but here is the setup… I want to have global.asax set up some session goodies when someone hits my site, then I want all my web pages to work […]

Using a Common Page in App_Code with Session Variables Read More »

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 »