In the beginning of my career, I learned IBM's Assembly language by muddling through mainframe core dumps and the System/360 Reference pamphlet. I believe that discipline helped guide me through the...

I've worked with developers that over-engineer a solution just because they can. Excellent article!

Note: This has only been tested in SQL Server 2008 SP3

I tested this in SQL 2005 and your correct answer does not work. Are we to imply that you...

Sarah, you almost lost me at "Java developer" :-), but then you pulled me back in.

Very nice article, well written, and sprinkled with a little reverence to some of the...

When I built my SaaS application, I had no DBA. Therefore, I became an accidental DBA by learning everything I could about database design, stored procedures, etc.

Personally, I believe a...

Hakim - this script is excellent. It will help me to locate "no longer needed" procedures in my development process. Thanks for posting!

As always, Jeff turns complex problems into simple solutions. I'm still looking for "SQL Spackles" by Jeff Moden at Barnes & Noble.