1 & 1 Customer Service Horror Story If you are using or thinking about using 1&1 hosting read this post. http://jeffcroft.com/blog/archives/2006/02/11_internet_is.php

Microsoft Database Projects [rant] VS 2005 Database projects suck. Where is the support for version of control of database schema. Where is the support for intellisense inside of SQL statements. There is all of this wonderful stuff happening in the LINQ world and all I want is some T-SQL love. [/rant] So here is what I want. I want the database project to do the following

1. Let me take snapshots of the database schema and store them in user named folders. Please assume they are in chronological order. V2 can make this a little more flexible.
2. If I have a V1 snapshot the V2 snapshot should should have two subfolders (Fresh and Diff). The fresh folder has the SQL to create the database from scratch. The diff has the upgrade scripts.
3. MS Build Upgrade Scripts. The DB Project also generates the MS Build script that I will run to upgrade or install the databases. This project will allow developers to put their own special needs hooks in and get the tedious crap work done.
4. The database project should also have a way to enter lookup style data, in a way that is as easy as excel. I hate writing dumb insert statements when this could be done for me.