Some customers privy to an early kick of the tires on the refashioned database say the product is a major leap forward in terms of enhanced business intelligence tools, application development integration, and management visibility from its previous SQL Server 2000 incarnation.
With the extra time afforded to its engineers, product developers and end users to compare and work various kinks out of SQL Server 2005, Microsoft made sure the product featured improved "enterprise readiness" capabilities such as table partitioning, extended online operations and vastly beefed up online diagnostics, said Paul Flessner, senior vice-president for SQL Server at Microsoft, based in Redmond, Wash.
Flessner said the new database is designed to offer significant data management visibility, allowing users to more easily examine current activities inside the server than prior versions.
Built with strong ties to Microsoft Visual Studio 2005 and with the application developer in mind, SQL Server 2005 gives developers the ability to have language-independent code run outside or inside of the database. That will allow developers to write code in whatever language theyre comfortable with, to be decided at run-time and performance tuning.
"We think the database is a technology that is too complicated. We can make it much simpler in terms of auto-tuning, and we can do more to make the database developer more productive," Flessner said.
"Theres a host of things we did in this area, and extending enterprise abilities in our mind pushed the product to the next level and toward most mission-critical applications. The last bastion for IBM and Oracle [Corp.] in terms of their market has been that Tier One application, and I think [SQL Server] 2005 pushes us inside that space."
Currently running SQL Server 2005 and taking advantage of its new 64-bit support, Kirk Pothos, software development manager for Xerox Corp., based in Rochester, N.Y., said the new database server has made leaps and bounds in terms of its management tools in areas such as online indexing, tuning wizards and best practices.
For example, Pothos said he is seeing some of his organizations intensive queries run anywhere from 25 to 45 percent faster, which was a big surprise for him. In addition to the unexpected performance boost, Pothos said SQL Server 2005s native encryption has removed security worries from the minds of developers. But the biggest improvement, he said, is with Microsofts Report Builder functionality.
"Customers are always asking for different cuts and slices of the data. We dont have to have a DBA everywhere in the world; analysts can use Report Builder to slice some of those things in a cost effective manager. Thats one area where Microsoft has really done a good job: Reporting is great but the building tool is fantastic," Pothos said.
Xerox is primarily using SQL Server 2005 Enterprise Edition to power its XOS (Xerox Office Services) solution. The service, which can be hosted if the customer chooses, manages a Xerox customers printing operation globally, including supply replenishment and deployment, and necessary technology support is available. The XOS application is built on the Microsoft Visual Studio.NET platform.
Interestingly, Xerox is also actively migrating to Microsoft SQL Server 2005 Express, a downsized version of the database, for its branch-based customers. Pothos said the diminutive SQL Server tool is a perfect and cheap fit to help remote branch office customers, in terms of linking and managing printing operations with a centralized enterprise.
"We feel that SQL Server 2005 gives us a lot more headroom in terms of new features," Pothos said. "Xerox leads with technology. We didnt want simply a better SQL Server 2000. If they were only going to release a better version, that was not compelling for us. When we pick a platform we understand customers are very demanding and want new services. We needed headroom to grow and SQL Server will provide that for us."