-
Find and Delete Duplicates in SQL
We all know we shouldn’t have duplicates in the database. And despite my best efforts, somehow they sneak in from some legacy code, or from the hyper-active-compulsory-submit-the-form-fifty-times-in-five-seconds-bloke. So now and then I find myself writing the same SQL to track them down. Most solutions online say that you have to use a temporary table or…
-
.Text to Community Server 2.0
I made the leap and upgraded my blog to Community Server (CS) 2.0. It took about 4 hours researching, downloading, uploading, converting and fixing. I couldn’t find a way to directly upgrade my .Text Version .95 directly to CS 2.0, so I decided to first upgrade from .95 to CS 1.1, then use the standard upgrade…
