Rollback Gotchas – Part 1

Most people understand what a transaction is and how to set them up. The scope of this post is not to explain how transactions work within SQL Server, but for completeness sake I’ll provide a brief overview: The basic premise is that SQL Server will run each statement as an implicit transaction unless the BEGIN […]

Microsoft 70-433 exam review

In my last post “January Goals Update” I promised that I would write a few lines on my experience of taking the 70-433 SQL Server 2008 Database Development MCTS exam. I know not everybody is a big fan of the certification process but it does have it’s merits, Brad McGehee summed them up very well […]