SQL Server bulks up
Microsoft's beefy remake brings hefty new capabilities and a slew of new tools to master
If you are currently pushing DTS to the limit, converting to SSIS will ultimately streamline operations but may not be as easy as you’d like. Proper planning will be essential. The best way to go about it is to put a dedicated SSIS server in place and upgrade your packages one at a time. This method will give you an opportunity to upgrade and test at your leisure.
If you’re concerned about compliance, the new security features and the DDL triggers will whip your database into shape very quickly. Here again, though, implementing password policies can cause some grief in your environment, so you’ll have to plan appropriately.
For shops without these pressing problems, SQL Server 2005 offers plenty of other reasons to consider it. From management to development, just pick your woe and chances are SQL Server 2005 will help alleviate it.
SQL Server 2005 is an excellent release that will gain Microsoft some real respect in the high-end database market. SQL Server’s tools now lead Oracle and DB2 in pretty much every area -- management, monitoring, and especially development -- and of the three vendors, Microsoft seems to be the most concerned about improving them. Maybe those other guys should start hitting the weights.
Read more about data management in InfoWorld's Data Management Channel.