The Wait for SQL Server 2005 Ends

By Lisa Vaas  |  Posted 2005-11-04 Print this article Print

News Analysis: After five long years in development, after the miraculously rubbery feature list contracted and expanded like Gumby on a rabid bronco, it's here: SQL Server 2005.

Its here. After five long years in development, after delay upon delay, after the Blaster worm threw the SQL Server team for a paradigm-shifting tizzy, after the miraculously rubbery feature list contracted and expanded like Gumby on a rabid bronco, its here: SQL Server 2005. Microsoft will launch officially on Monday the three products that together compose its "application platform" for the future: its SQL Server 2005 database, Visual Studio 2005 tool suite, and its BizTalk Server 2006 integration server.
SQL Server 2005 (code-named Yukon) and Visual Studio 2005 (code-named Whidbey) are shipping now.
BizTalk Server 2006 is on tap to ship in the early part of 2006, as will the Team Server edition of Visual Studio 2005. Of the triumvirate, SQL Server 2005, Microsofts next-generation database, is the beating heart. Its the encapsulation of Microsofts plans to bust out of the departmental closet. Its Microsofts attempt to expand beyond the humble ranks of the inexpensive, easy-to-use database used on the departmental level but rarely in the aristocracies of high-end data centers, where databases have to scale like mad to earn their place at the end of a power cord. Heres how it now stands: Gartner Groups database market stats from May showed Microsoft in third place, with a 20 percent share of the overall relational DBMS (database management system) market. IBM and Oracle Corp., in contrast, were neck-and-neck, with both holding about 34 percent of the market. Microsoft owns the low end of the database market, with the SMB market neatly tied up. The only place to go, the only place to change its third-place status, is up the food chain, into the realm of the enterprise. Hows it getting there? This database release comes packed with enterprise goodies. Feature breakthroughs include scalability and performance boosts such as 64-bit support and partitioning; high-availability features include database mirroring and failover clustering; security enhancements will bring data encryption and key management; programmability benefits include T-SQL enhancements and integration with CLR (Common Language Runtime) and .Net, along with XQuery, native XML and Web services integration; and one of the tastiest slices of the pie, the BI (Business Intelligence) capabilities and integration with Office 12. When it comes to scaling the enterprise walls, the BI piece of the puzzle is crucial. Much of the 10.3 percent growth in the 2004 database market came from BI, data warehousing and data analysis. Hence we see Microsoft responding to the increasing hunger to analyze geometrically expanding data stores by tying in powerful tools to its overall BI platform, including data integration, analysis, reporting and Report Builder, the end user ad hoc reporting tool that, Microsoft says, is its customers most frequently requested BI functionality. Microsofts BI plans dont stop there. The company is set to revolutionize use of the insanely popular Excel spreadsheet, setting it up so that Office 12 has new server-side Excel capabilities called Excel Services. Click here to read more about Microsofts business intelligence plans. With Excel Services, Excel will be able to be used as a BI interface sitting on top of SQL Server. What will that do? For the first time, it will give administrators the power to centrally secure, share and manage spreadsheets on the server, as opposed to the all-too-familiar scenario of having knowledge walk out the door when employees with mission-critical data stored on their desktops leave the company. Understandably, when it comes to SQL Server 2005, BI vendors are none too pleased. Hardware vendors, on the other hand, are ecstatic. SQL Server 2000 has supported a 64-bit version for Itanium for some time. Thats nice, but Itanium serves a high-end, niche server market. The majority of databases Microsoft sells are on X86-based platforms, not Itanium. SQL Server 2005, on the other hand, is plugging into AMDs Opteron. SQL Server 2005 running on top of Opteron-based servers are benchmarking at comparable performance to proprietary, RISC-based platforms. That means that for comparable performance, businesses will now be able to pay about half the amount of money. Next Page: Addressing customers worries.

Lisa Vaas is News Editor/Operations for and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel