TF30042: The database is full. Contact your Team Foundation Server administrator.

Today I received the following error while trying to check in some code after a marathon night of coding: TF30042: The database is full. Contact your Team Foundation Server administrator. I got one of those "oh crap" sinking feelings, that some how my TFS server had decided to just die…

Deadlocked!: "read committed snapshot" Explained

I just recently read Jeff Atwood's Deadlocked! article. I just wanted to give some more insight in to the read committed snapshot so that it is not perceived as "magic". It has some definite advantages when dealing with deadlocks, however if your code relies on row level locking you are…

MySQL Officially Declared Microsoft SQL Server Compeditor

I have been a huge fan of MySQL for a long time.  It is the perfect database for when the budget is tight or you are not working in a Microsoft Environment.  It performs well, and has a huge following of dedicated professional programmers that use it day in and…

How To: Change Instance Name Of SQL Server

Recently I change the network name of one of my servers at work, because the box changed its job from a virtual machine server to the database server. Everything was going great until I decided to setup the server for replication and received the following error message. New Publication Wizard…

SQL Server 2008 Will Have 7 New Datatypes

I haven't even herd of a new version of SQL Server 2008, coming out, but according to this blog the new version has some very interesting and new data types that will come in useful for geography processing. DATE - ANSI-compliant date data type TIME - ANSI-compliant time data type…

Using Distributed Transactions in your Data Layer

Many developers use a pattern called ORM or Object Relation Mapping to generate data layers for their application. Many other developers choose to create their own data layers by hand. I have done both and I don't have a preference of one over the other. With an ORM generator you…