Today, I am embarking upon my global search and replace to change 13,000 lines of code.  But I have had a problem with VS 2003 on my Vista machine -- it likes to hang when I use Find in Files or Replace in Files. Google to the rescue.  I very... [Read More]

Just in case you want to do this, here's a step by step guide. Start VS 2008 (no need to open a project or file) Click on Tool->Attach to Process... Select wininit.exe and click Attach Wait for the debugger to initialize Click the Stop Debugging button When you attempt to... [Read More]

I just tackled a problem using SQL's ROW_NUMBER() function, and I'm happy with how it turned out.  It would have been pretty tricky in SQL 2000. The problem at hand was merging 2 sets of data, copying data from one account into another account, where the records don't already exist. ... [Read More]

I cranked out a bunch of code tonight for my new nullable types approach.  This is a .NET 1.1 solution, so it's pretty old school, but it was still fun. I explained the problem with our existing methods the other day.  Basically, we have a ton of helper functions for... [Read More]

I don't know why I hadn't taken the time to do this before, but I just invested 5 minutes into SQL Profiler to make my life much easier when debugging stored procedures. When I'm faced with stored procedure debugging, especially procedures that take awhile to run, or require a series... [Read More]