Feeds

MS SQL Server man lets betas have it

CTP or bust

Next gen security for virtualised datacentres

With the first service pack for SQL 2005 Server due in the next two weeks, Microsoft has been laying down the law on future development plans for the database.

In short, that means no return to beta editions for new versions of its database and regular product updates every two- to two-and-a-half years, according to the vice president of Microsoft's server applications group. Paul Flessner was speaking after Microsoft last week outlined four key themes for investment in the SQL Server roadmap, that included a re-branded edition of SQL Server Mobile Edition called SQL Server Everywhere Edition due later this year.

According to Flessner, investments in SQL Server will now focus on availability and automation, going beyond storage of purely relational data, synchronization, and end-to-end insight. As such, SQL Server Everywhere Edition is promised as a small footprint, client - not merely mobile device - database that can store data locally and replicate with server-side editions of SQL Server when an online connection is resumed. The first community technology preview (CTP) is due this summer.

In many ways, Microsoft is late to the game with SQL Server Everywhere Edition. IBM helped feed today's growing demand for light-weight, client-side databases when it open sourced its Cloudscape database to the Apache community as Project Derby in 2004. Oracle, meanwhile, this year bought Sleepycat to add a popular, small footprint, embedded alternative to its existing enterprise database line.

IBM has also been setting the trend in others areas. The up-coming edition of DB2 codenamed Viper is slated to become the industry's first database with native support for XML. Viper will allow users to store, search and retrieve unstructured data - in addition to structured data - for use in business analytics, without breaking the XML data down into rows or columns, a move that slows performance and causes a loss in the fidelity of data. IBM believes 35 per cent of business data is currently stored in an unstructured XML format.

IBM has been releasing full versions of DB2 roughly every two years. Flessner, though, last week dismissed IBM's track record saying the company had issued what he considered to be "feature updates."

Flessner appears to be placing his faith in plans to deliver updates of SQL Server every two- to two-and-a-half years. A key part of that is to streamline delivery of SQL Server using small, feature-specific CTPs instead of bigger code drops epitomized by the beta process. SQL Server was one of the first Microsoft products to adopt the CTP approach, an approach now spreading across other Microsoft groups, even though the CTP approach didn't avert delays to SQL Server 2005. The database finally shipped last November, more than four years after its predecessor.

"I'm convinced we can do it," Flessner said of the new delivery cycle. "The key is keeping the main product build stable. The CTP is the key. The beta process was very large, but the CTP is much smaller. As long as I'm in charge of SQL Server, we will never go back to betas."®

The essential guide to IT transformation

More from The Register

next story
Munich considers dumping Linux for ... GULP ... Windows!
Give a penguinista a hug, the Outlook's not good for open source's poster child
The Return of BSOD: Does ANYONE trust Microsoft patches?
Sysadmins, you're either fighting fires or seen as incompetents now
Microsoft cries UNINSTALL in the wake of Blue Screens of Death™
Cache crash causes contained choloric calamity
Time to move away from Windows 7 ... whoa, whoa, who said anything about Windows 8?
Start migrating now to avoid another XPocalypse – Gartner
You'll find Yoda at the back of every IT conference
The piss always taking is he. Bastard the.
HANA has SAP cuddling up to 'smaller partners'
Wanted: algorithm wranglers, not systems giants
prev story

Whitepapers

Endpoint data privacy in the cloud is easier than you think
Innovations in encryption and storage resolve issues of data privacy and key requirements for companies to look for in a solution.
Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Top 8 considerations to enable and simplify mobility
In this whitepaper learn how to successfully add mobile capabilities simply and cost effectively.
Solving today's distributed Big Data backup challenges
Enable IT efficiency and allow a firm to access and reuse corporate information for competitive advantage, ultimately changing business outcomes.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.