Camping presents a unique insight into problem management, and can also present a powerful metaphor about how people solve problems. If you've done much real camping, i.e. out in a semi-wilderness area as opposed to being in a groomed state-run/private campground, you've had to figure out how you're going to keep your fire going; and this is ...

It's so easy to hose yourself with SQL Server. Especially when it comes to security. Right now I'm playing around with some Double-Hop Delegation issues on some of my production Servers. It's tricky getting it to all to work CORRECTLY; and correctly means: getting it to work adhering to the principle of least privilege. My current endeavors made ...

tap, tap... tap... is  this thing on? In T-SQL the option: SET NOCOUNT OFF is used to enable 'chatty' communication with the Server while stored-procedures are being executed. In other words, this is going to be a chatty post which should be fine as it's my first post to sqladvice, and I want to use it to try and introduce myself a ...