Use SQL to drop a column, if it exists in a table

05 Apr 2016 Databases, SQL, Stored Procedures No Comments

I recently needed to write a script for a customer to run against their database, to delete a column from a table. I wanted to make sure it would only run if that column existed, especially as the column had originally been created by a script that failed to complete

Continue reading →

App Offline page that refreshes when the site is back online

08 Jul 2013 JQuery, Server 2008 No Comments

I created an app_offline.htm page to place in my site's folder while I was deploying a new version, but I didn't want to put a 'click this link to refresh' or a suggestion to refresh the page. That seemed to be pushing my problem onto the user.

I decided that jQuery

Continue reading →

Fixed: Error when deploying a .Net 4.0 project (that was downgraded from .Net 4.5) to a .Net 4.0 server

25 Jun 2013 .Net, Server 2008, Visual Studio No Comments

I recently had to downgrade a .Net 4.5 project to .Net 4.0 so that it could run on MS Server 2003. I had many warnings and errors which I managed to clear up, as detailed in my previous post Downgrading an

Continue reading →