Skip to main content

Limitations of SQL Server 2005 Express Edition

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: […]

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 […]

Using Expressions with SSIS Maintenance Tasks and SelectedDatabases

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 […]