SSWUG vConference, Day One

The first day of the SSWUG vConference has come and gone. Despite a handful of technical issues, the day must be considered a rousing success. The quality of the content, the quality of the video, and the quality of the live chat sessions was far above average. Now, since I have participated before, I have come … Read more

Book Reviews

While looking over the SQL Blogger Rankings a thought crossed my mind: Why not do something similar with books? So, I have decided to create a new page with some widgets that display books related to various topics. Right now, there are two libraries to choose from, a technical library and a professional development library. … Read more

What Causes Deadlocks?

Application code, that’s what causes deadlocks. Well, perhaps a combination of application code on top of database design, and access patterns, and transaction isolation levels, and… OK, here’s the point I need to make clear: the database engine does not suddenly seize up and start deadlocking transactions arbitrarily because it is tired one day. No, certain … Read more

SSWUG vConference Starts Tomorrow!

If you have ever dreamed about having me talk to you on all things SQL, then your chance starts tomorrow. The SSWUG vConference starts tomorrow morning and I have received a discount code for the. You can register for the conference here. And the code you want to use is: SPVTLASP09 If you have never … Read more

SQL 2005 Install Error

We have about eighty or so SQL 2005 instances running in our shop. Up until last week we had zero problems installing SQL 2005 on any of these instances. That all changed last week, when we were greeted with this error message: The SQL Server service failed to start. For more information, see the SQL … Read more