The free version of SQL Server 2005 is the “Express” edition. Its a cut down version of SQL Server 2005 and is ideal as an upgrade from Access, for desktop use or small multi-user databases. Its not designed for large scale production use, and comes with a number of limitations. The most notable limitations are: […]
You are browsing archives for
Month: December 2006
ITS HERE!: Visual Studio Team Edition for Database Professionals (Data Dude) RTM Available now in MSDN Downloads
MSDN Downloads updated this morning with the release of Database Professional aka “Data Dude”. Download the 20MB trial from here which is really a full version if you have a full license of Team Suite already installed. The development manager explains the difference between the full DVD download and the trial: The full product download […]
Rss Feed Logo #1
I thought maybe having a logo appear in my rss feed might be cool. Here’s the first design I came up with. Please feel free to comment on it and let me know what you think. Julian
Setting Schema Compare Options in VSTS for Database Professionals (DataDude)
Changing the comparison rules for the Schema Compare is not as obvious as it should be. You need to go into the Tools -> Options menu to make changes. Click on the Tools Menu -> Options Expand Database Tools in the tree Select Schema Compare. I’m waiting to see if this has changed in v1.0, […]
Setting Data Compare Options in VSTS for Database Professionals (DataDude)
Changing the comparison rules for the Data Compare is not as obvious as it should be. You need to go into the Tools -> Options menu to make changes. Click on the Tools Menu -> Options Expand Database Tools in the tree Select Data Compare. I’m waiting to see if this has changed in v1.0, […]
Using Expressions with SSIS Maintenance Tasks and SelectedDatabases
Its been noted by a few people that Expressions cannot be used to configure the Shrink Database Task at runtime. The problem is that the SelectedDatabases property is a collection which cannot be created by an expression. The same problem occurs in most of the Maintenance Task items of SSIS. Maintenance Plan Task components are […]
RELEASED: Visual Studio Team System Database Professional v1.0 (AKA “Data Dude”)
Data Dudes Development Manager Gert Drapers has announced Visual Studio Team System Database Professional v1.0 (build x251) has been released. It should become available in MSDN Downloads around Dec 7 or 8th 2006. Congratulations Microsoft on releasing an exciting new tool for database development.