No more than an output to me, but it sure was to SQL Server! This issue kept me busy over the weekend, and most definitely gave me a case of Saturday Night SQL Fever (as opposed to "SQL Saturday Night Fever", for which the only cure is more karaoke). When executing a stored procedure with an OUTPUT parameter, …

Read More

This post is my contribution to T-SQL Tuesday #007, hosted this month by the SQLChicken himself, Jorge Segarra (Blog | Twitter). Since I'm a bad DBA and have yet to get my hands on a copy of R2, I'll make use of the rule that we can discuss any feature from 2008. My favorite is filtered indexes, as they were the …

Read More

At my previous employer I took part in several projects that involved migrating databases not only to new hardware but also to new versions of SQL Server. We upgraded machines running the 2000 and 2005 versions of SQL Server to 2008. Here's how we went about doing it, and some helpful hints we figured out along the …

Read More

When preparing to take certification exams, I always purchase test preparation materials no matter how ready I feel that I am. I do this for two reasons: There's no such thing as being too prepared (being a Boy Scout taught me this many times over) I can be sure of what topics will be covered As I was getting ready to …

Read More

While I wasn't explicitly tagged for participation in this meme, Wendy Pastrick (blog | twitter) was kind enough to tag everyone else who hasn't been tagged already. Being in need of a first topic for a blog post, this seemed like a good one to start with! Since a lot of things have already been spoken for, here's 3 …

Read More