I’ve decided to chronicle things I learn about replication (above and beyond the normal things to learn in the documentation) after a very hard lesson yesterday during an upgrade which lasted a lot longer than necessary.  Read →

We had a major problem last week when someone ran a query manually that was only ever designed to be run once under controlled conditions. To put this right we decided to add some protection to the stored procedure that would prevent it from running twice in a row however, because we don’t employ a transaction around the whole stored procedure (it does too much for that) we couldn’t use the simplest option sp_getapplock which requires a transaction.  Read →

I noticed a blog entry that neatly summarised the exam tracks available at Microsoft but more importantly linked the Visual Studio 2008 exam tracks that should be released imminently - register now and you get a 40% discount!  Read →