I needed to create a tool that would do some backing up and restoring of databases as part of a long-running
job this week. I had heard it was fairly simple C# code, but I was pleasantly surprised when I realised just
HOW simple it is.
[Read More]
I’ve always used nDoc for building code documentation, and then (around 2 years ago) I shifted to Sandcastle
Help File Builder. We’re wanting to start documenting code at work, so today I downloaded the latest version
(along with Sandcastle to give the latest versions a whirl.
[Read More]
Being able to see what is blocking or waiting on a SQL Server machine is essential for most developers these
days. I find myself using the following queries almost daily at the moment, so I thought I’d post them here:
[Read More]
IDENTITY columns can be a real pain in the ass when data gets out of sync. GUIDs are generally a much better
option when it comes to replication, but you aren’t always in control of data structures and sometimes you
inherit old systems that weren’t designed to be replicated.
[Read More]