I’d forgotten the syntax for moving an object to a different schema: [Read More]

This is a query I use often to check what active connections exist for a specified database: [Read More]

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]