Belated SQL Server Upgrade Retains Its Appeal to Testers
Microsoft launches new database release after two-year delay
November 7, 2005 12:00 PM ETComputerworld -
Microsoft Corp. is finally set to launch its SQL Server 2005 database today. And despite a two-year delay, several users who have tested the software cited the improved performance and new functionality it brings as positive developments that likely will convince them to upgrade soon.
For example, beta tester Mayur Raichura, managing director of information services at The Long & Foster Cos. in Fairfax, Va., said he is "hoping that with the five years they have spent developing and tightening this product, this is truly not a 1.0 version." Raichura added that he wants to avoid the need for "some serious patch management" or deployment of service packs.
But he said that based on the features he has tested so far in the beta version, SQL Server 2005 could rival the databases of market leaders Oracle Corp. and IBM within a year. Long & Foster plans to begin using a production version of the database in the spring, when the real estate company is due to launch a new version of its corporate Web site.
SQL Server 2005 supports database encryption and other new security features, as well as full-text search, native storage and querying of XML documents, and added business intelligence functionality. The database is also integrated with Visual Studio 2005, which lets developers write applications in C# or Visual Basic instead of doing SQL programming.

![]()
Fabio Catassi, chief technical officer at Mediterranean Shipping Co.
![]()
Fabio Catassi, the shipping company's chief technical officer, said end users experienced a "dramatic reduction" in the time needed to run queries after Mediterranean Shipping upgraded to a 64-bit version of SQL Server 2005 running on a Unisys ES7000 server. The performance gains were also a result of high-availability features such as the database's online index-rebuilding capability, he said.
SQL Server 2005 doesn't have everything Catassi is looking for. Some promised capabilities, most prominently database mirroring for automatic backups of information, aren't due to be available until next year. Meanwhile, his personal wish list still includes features such as the ability to load and compare multiple performance monitoring logs from different systems.
Benefit to Developers
Craig Steele, a senior network engineer at Progent Corp., an IT consulting firm in San Jose, said the most tangible improvements in SQL Server 2005 likely will benefit developers more than database administrators. For example, he pointed to the integration of the database with Visual Studio 2005, which is also being launched this week.
Databases
Additional Resources



Learn the important issues you must consider before starting your next mobility initiative. Get your mobility white paper from IDC now, compliments of Sybase.
White Papers & Webcasts
Essential Archive Requirements for E-Discovery
Register Now!
Extending Client Refresh - 11 Steps to Maximize Savings
Register Now!
Mitigating Litigation Risk with Email Management Tools
Register Now!
Consolidate Your Servers and Storage to Lower Costs with Oracle Database 11g
Register for this webcast!
Looking for a fast payback?
Register Now!
Key Findings: Accelerating ROI with BPM
Click here to watch now!
Architecting Business Intelligence Applications for Change: The Open Solution
Register for this webcast today!

