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 some interesting fixes included if you browse through them.  But at least on first glance and […]

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 typing with one raised eyebrow (wanting to ask, but it wouldn't fit in 140 characters, "why […]

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 tried to run the old app (which was working perfectly before), we received this big, ugly […]