The Wait for SQL Server 2005 Ends

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.

Resource Library:

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.