Microsoft is bringing its next SQL Server release, code-named Yukon, in line with its .Net and Web services vision, with new data unification and integration technology.
NEW ORLEANS--Microsoft Corp. is bringing its next SQL Server release, code-named Yukon, in line with its .Net and Web services vision, with new data unification and integration technology.
Microsoft plans to embed .Net CLR (Common Language Runtime) in the SQL engine, as well as provide deeper and richer XML support. With .Net CLR integrated, developers will be able to write stored procedures in 23 languages in addition to Microsofts
T-SQL, said Stan Sorensen, director of SQL Server, at the companys TechEd conference here last week.
IT executives said they are more interested, however, in new features that will improve scalability and reliability. While they said the enhancements touted by Microsoft will help in application development for SQL Server, they want to see more improvement in core database areas as well.
"I want to hear about the work theyre doing in the database and not the interface into the database," said Darrell Starnes, deputy CIO at Houston-based Ashford.com, a division of Global Sports Interactive Inc. "By far, our big focus is scalability and reliability. Were worried about more clustering services, disaster recovery and replication."
Yukon is slated for release next year, and a beta version is due by the end of this year, officials said.
"[The CLR support] will give us symmetry between our programming environment in the midtier and the database," said Paul Flessner, senior vice president of the .Net enterprise server group. "Now a developer can make a run-time decision about where they want their code to run based on performance or scalability rather than having to make a design-time decision."
Yukon will also provide technology that enables a better way to store and retrieve XML data of all kinds, which has been referred to internally as Storage+. Yukon will provide native XML support inside the SQL Server engine and support XQuery, a proposed standard query language for XML documents.
The Redmond, Wash., company does not plan to incorporate SQL Server directly into its other software products but does plan to incorporate some of the data unification and other technologies planned for Yukon into additional products over time.
"Were not going to take this great asset we have in SQL Server and drop it into a bunch of other products," Sorensen said, adding that the goal is to be able to search and find structured and unstructured data, whether within a relational database or in a file system or e-mail.
Announcements about Yukon so far, however, do not take into account an area where analysts say that SQL Server lags: its lack of functionality for a clustered database environment compared with competitors such as Oracle Corp.
Ashford.coms Starnes said that additional clustering functionality in Yukon would be an incentive for his enterprise to upgrade from SQL Server 7.0.
Lee Margulin, director of database administration at MGM Mirage, of Las Vegas, said SQL Server 2000 vastly improved clustering but he, like Starnes, would like load balancing capabilities built into SQL Server to ease management across multiple servers.
"They improved clustering aspects in SQL Server 2000, which was a big problem in SQL [Server] 7.0," Margulin said. "We do get into situations where it would be nice to put multiple servers on a database and load balance across the servers. Now it takes hoops to get to that point."
Microsofts Sorensen said Yukon will address improved clustering along with other issues such as disaster recovery but said it was too early to provide details.
As an online reporter for eWEEK.com, Matt Hicks covers the fast-changing developments in Internet technologies. His coverage includes the growing field of Web conferencing software and services. With eight years as a business and technology journalist, Matt has gained insight into the market strategies of IT vendors as well as the needs of enterprise IT managers. He joined Ziff Davis in 1999 as a staff writer for the former Strategies section of eWEEK, where he wrote in-depth features about corporate strategies for e-business and enterprise software. In 2002, he moved to the News department at the magazine as a senior writer specializing in coverage of database software and enterprise networking. Later that year Matt started a yearlong fellowship in Washington, DC, after being awarded an American Political Science Association Congressional Fellowship for Journalist. As a fellow, he spent nine months working on policy issues, including technology policy, in for a Member of the U.S. House of Representatives. He rejoined Ziff Davis in August 2003 as a reporter dedicated to online coverage for eWEEK.com. Along with Web conferencing, he follows search engines, Web browsers, speech technology and the Internet domain-naming system.