Adam Machanic : best practices

Bad Habits to Kick: Inconsistent Indentation

Adam Machanic — Sat, 10 Oct 2009 20:25:00 GMT

My last post in Aaron's series drew a mixed review from some readers, and I'm sure this one will do the same. But that's part of the fun! One of the biggest threats to maintainability is code that's not properly formatted. When I'm called in by a customer...(read more)

Bad Habits to Kick: Not Using "AS"

Adam Machanic — Fri, 09 Oct 2009 02:33:00 GMT

Aaron has recently been doing an absolutely fantastic series of posts detailing various "bad habits" that many of us pick up somewhere along the way. These coding anti-patterns aren't going to crash your server, but they will make your code more difficult...(read more)

Demos from my TechEd session (DAT302: Best Practices for Exception Handling and Defensive Programming in Microsoft SQL Server 2005 and 2008)

Adam Machanic — Thu, 05 Jun 2008 14:48:00 GMT

If you attended my session this morning, thank you! It's always flattering when people are willing to wake up before 8:00 a.m. just so that they can hear a talk about SQL Server. I had a great time doing the talk, and I think it went well. My sincerest apologies to the person I accidentally hit in the head with the t-shirt; I will work on my throwing arm and hopefully do a better job with the swag tossing next time!

I had a few requests for the demo scripts, and they are attached to this post. Please let me know if you have any questions or issues with them. And thanks again for attending.

For those who were not there, the presentation was recorded, and I believe it will be posted online at some point, so keep your eyes open for that.