Monthly Archive: September 2010

This time it's for real – SQL Server 2008 Service Pack 2 is available!

This time it's for real – SQL Server 2008 Service Pack 2 is available!

I'm not going to blab about the speculation, or how Microsoft seems to like making their promised deadlines by the skin of their teeth.  I'm too busy preparing how we're going to deploy and...

A SQL Server 2008 update is available – but it's not SP2

A SQL Server 2008 update is available – but it's not SP2

Last night Microsoft released Service Pack 1 Cumulative Update #10: KB #2279604 : Cumulative update package 10 for SQL Server 2008 Service Pack 1 The build number is 10.00.2799 and there seem to be...

Updating a table with HTML data from a file

Updating a table with HTML data from a file

On the #SQLHelp hash tag today, @zippy1981 asked the following question: Is there an easy one-liner (powershell,sqlcmd/SSMS/etc) to load a single html file on the local filesystem to a field in the DB? While...

A quick workaround to a misleading ASPState problem

A quick workaround to a misleading ASPState problem

This morning we were attempting to test an existing app on a server where we had recently made some AppPool and other changes to IIS (installing a newer application to run side-by-side).  When we...