I recently setup a SQL server, running Microsoft SQL Server 2005 Developer Edition. Installation was smooth, with a prettier interface than SQL 2000. The disk space requirement was a bit high, but not unreasonable.

The suite now includes a special management studio that uses the VS IDE. In the past, developers needed to use an MMC snap-in to manage databases. It was usable, but generic. Features weren’t obvious and the interface was clumsy. The new feature-rich interface is much more friendly and intuitive.

But the IDE does, however, carry the same massive footprint as Visual Studio. I would have preferred it if they had kept the MMC snap-in for server use. Needing to install the IDE on the server seems silly, considering the amount of use it would get. Overall, though, I’m impressed with the software.