It's easy to be overwhelmed by the raft of new features in SQL Server 2005. In fact, many users are, but once they delve a bit deeper, that sense of shock turns to pleasant surprise at the functionality and performance of Microsoft's new enterprise-class database management system.
SQL Server 2005's new SQL Server Management Studio (SSMS), its revamped Reporting Services, granular security controls, native Web services and XML support are just some of the new features that have users talking -- that and its speedy performance. Although most are taking a cautious approach to fully implementing SQL 2005 -- citing a lack of good documentation and strong migration tools (see SQL Server 2005 Wish List) -- many have no qualms about an eventual upgrade. Most say the investment in both time and money will be worthwhile.
