Microsoft delivers first test build of next-generation SQL Server 'Denali'

Microsoft delivers first test build of next-generation SQL Server 'Denali'

Summary: Microsoft is making available for download by MSDN and TechNet subscribers on November 9 the first test version of its next-generation SQL Server release, code-named "Denali."

SHARE:

Microsoft is making available for download on November 9 the first test version of its next-generation SQL Server release, code-named "Denali."

The company announced the availability of the Community Technology Preview (CTP) build -- available to TechNet and MSDN subscribers today -- at the PASS (Professional Association for SQL Server) Summit in Seattle. The first Denali CTP is slated to be available at 11:45 a.m. ET on November 9, Microsoft officials said.

Microsoft said in February that its next release of SQL Server would be codenamed Denali, but declined to say anything more about the release at that time. Now the Softies are sharing more. Here's a list of some of what is on tap to be included in Denali:

  • SQL Server AlwaysOn, a new high-availability "solution that will deliver "increased application availability, lower TCO (total cost of ownership)  and ease of use, according to the Softies
  • Project codename “Apollo”, new column-store database technology aiming to provide greater query performance
  • Project codename “Juneau”, a single development environment for developing database, business intelligence (BI) and web solutions
  • Project codename “Crescent”, a web-based, data visualization and presentation solution, and follow-on to the PowerPivot technology that is part of SQL Server 2008 R2
  • SQL Server Data Quality Services (based on technology from Microsoft's 2008 Zoomix acquisition)
  • Other data integration and management tools

Like the SQL Server 2008 and SQL Server 2008 R2 releases, Denali will be focused on providing users with more high-availability, self-service and BI functionality, officials said.

SQL Server isn't just a database, but an entire "information platform," said Ted Kummert, Senior Vice President of Microsoft's Business Platforms Division. Information platform implies the ability to handle structured data, unstructured data, XML and more, as well as offering customers tools and services like analytics and reporting to interpret this data.

Going forward, the SQL Server team will be focusing on three things, Kummert said: Incorporating more mission-critical features into the platform (on the data warehousing side and beyond); making BI available for every end user; and insuring that the platform continues to evolve as a cloud service.

In addition to making the first Denali CTP available, Microsoft also is making available today a first CTP of the SQL Azure Reporting Services and the SQL Azure Dat Sync Service (based on Sync Framework), plans for which were announced a couple of weeks ago at the Professional Developers Conference. (The Data Sync Service is meant to allow developers to build apps with geo-replicated SQL Azure data and synchronize on-premises with cloud and mobile applications.) The company also announced immediate general availability of SQL Server 2008 R2 Parallel Data Warehouse, an appliance for customers with data warehouses of hundreds of terabyes of data.

Microsoft also launched a first beta today of a new service, codenamed "Atlanta." Atlanta is a configuration monitoring cloud service that aims to help customers to reduce downtime and improve the performance of Microsoft SQL server deployments. The service monitors the configuration of SQL deployments to help database administrators proactively avoid configuration problems and to resolve identified issues.The target ship date for Atlanta is first half of calendar 2011.

Microsoft is not providing a ship-date target for the final version of Denali. Given SQL Server 2008 R2 was released to manufacturing this past spring, I was thinking it would be a 2012 deliverable. But it seems, there's talk of Q3 2011 as a possibility.

Topics: Servers, Data Centers, Data Management, Enterprise Software, Microsoft, Software

About

Mary Jo has covered the tech industry for 30 years for a variety of publications and Web sites, and is a frequent guest on radio, TV and podcasts, speaking about all things Microsoft-related. She is the author of Microsoft 2.0: How Microsoft plans to stay relevant in the post-Gates era (John Wiley & Sons, 2008).

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Talkback

30 comments
Log in or register to join the discussion
  • Man, what a joke. Who would pay hard earned money for a junk database that

    runs on an insecure OS??
    DonnieBoy
    • Now you've figured out why MySql Linux combo sux

      Progress.
      LBiege
      • RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'

        @LBiege

        ZING!!!
        Loverock Davidson
      • RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'

        @LBiege lol, DonnieBoy got 0wn3d
        OxBAADFOOD
      • Actually, I much prefer PostgreSQL running on Linux, now that Oracle is

        screwing with MySQL, and the future is less certain. Just stay from Windows and SQL Server. They both cost you a small fortune to deploy, and are less secure and stable than PosgreSQL or MySQL running on Linux.
        DonnieBoy
      • RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'

        @LBiege ...<br><br>I lol'd pretty hard at that comment, but I do have a quick observation for you:<br><br>London Stock Exchange tried Server 2008 + SQL Server. It couldn't keep up with the work load and cost <b>billions</b> of pounds in lost trade time and multiple rollbacks.<br><br>They're now using (and happily, without down time) Linux. Not sure what DBS they're using, though.<br><br>Explain?<br><br>[edit]<br><br>Apparently it <i>is</i> Linux + MySQL. Hmm...
        WarhavenSC
      • WarhavenSC: Yes, the problems of SQL Server running on Windows are many.

        It is just point and click idiots that use this stuff, and it ends up costing the companies in so many ways.
        DonnieBoy
      • RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'

        @WarhavenSC NASDAQ runs SQL Server though
        OxBAADFOOD
      • RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'

        @WarhavenSC LSE had many different systems integrated, do you have information that it was specifically the SQL Server + .NET combo that failed? (They were running SQL Server 2000, not 2008).
        OxBAADFOOD
      • RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'

        @WarhavenSC,<br><br>So do you have any info from the LSE debacle that specifically calls out SQL Server as the culprit? Or is the just more ABM trolling? What specific fault is there with SQL Server?
        bmonsterman
      • Guys, any way you look at it, SQL Server is over priced junk, and costs a

        fortune to deploy. Adding insult to injury, you also have to buy Windows server licenses, and introduce an insecure OS. They whole package is a one big joke.
        DonnieBoy
      • RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'

        @Donny, Warhaven et al:

        Nearly forgot to ask. If Linux is so full of win, why then are so many large-scale Linux migrations failing or experiencing massive overruns costing tax payers millions of unnecessary dollars?

        [b]Swiss canton of Soluturn abandons attempted Linux migration after nine years of failure[/b]
        http://linux.slashdot.org/story/10/09/18/0239243/Swiss-Canton-Abandons-Linux-Migration

        [b]Vienna "Soft Migration" Failed Softly[/b]
        http://limuxwatch.blogspot.com/2009/03/vienna-soft-migration-failed-softly_31.html

        [b]City of Munich Approves Extension of LiMux Project to 2013[/b]
        [i]The IT project for LiMux is extended until 2013 and the project budget to the estimated additional expenditure of ? 5.9 million increases. The extra work falls between 2012 and 2013 in and does not pose a burden on the city's budget[/i]
        http://limuxwatch.blogspot.com/2010_06_01_archive.html
        bitcrazed
      • RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'

        @bitcrazed ...

        FFS, guys. I'm not attacking SQL Server. That'd be DonnieBoy. I merely pointed out that LSE switched (or is switching to) Linux after LBiege said it was a shite platform. Why aren't you all up in LBiege's grill, asking for links and supportive arguments?
        WarhavenSC
    • RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'

      @WarhavenSC London Stock exchange delays switch to Linux http://bit.ly/b5LafV

      Traders concerned over network capacity of Linux system http://bit.ly/caszfA
      Mr. Dee
      • RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'

        @Mr. Dee - Donnie? Warhaven? Anyone? No pithy replies? How about that? I'd have expected them to leap to the defense of Linux/MySQL here. Sigh!

        I know some of those directly involved in the implementation of the .NET/SQL Exchange and ... well ... let's just say that one can recognize a pattern in the fact that the LSE screwed up the .NET/SQL implementation and now they've screwed up the Linux/MySQL one too.
        bitcrazed
    • RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'

      @DonnieBoy,

      Trolling as usual. Care to contribute anything useful?
      bmonsterman
      • You can start by contributing an argument. MySQL and PostgreSQL are better

        databases, and run on Linux, and cost a small fraction of what it costs to deploy SQL Server. Using Linux and MySQL or PostgreSQL, you end up with a stable, secure system.
        DonnieBoy
      • Yes of course he's clearly trolling

        He very well knows that W2008R2 is far more secure and stabel than linux, as is SQL more so in both regards that mysql. It's also very well established fact from the LSE postmortems that neither Windows, .NET, nor SQL had anything to do with any of the porblems they experienced which were pretty quickly identified as application logic problems. In fact that system ran the exchange very well while it was in use including several of it's top trading volume days in it's history. It's replacement was an assinine and purely political move by new management and the new linux system has been a complete waste of money over the several years they've been working on it and it still hasn't been able to match the Windows/SQL/.NET verison despite extensive costly hardware expansion.
        Johnny Vegas
      • RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'

        @DonnieBoy
        Argument to what? You haven't supported any of your statements with any specific facts. MySQL licensing is not free (not for commercial use), so you haven't discussed licensing options and the cost differential. You claim stability, yet you haven't talked about the features of MySQL as they pertain to stability. You tow the same line about security as most Linux guys do, but you haven't talked about security as it relates to a database environment (which is not the same as desktop computing). What makes MySQL better?
        bmonsterman
      • RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'

        @DonnieBoy

        One more thing: Why MySQL is a fine choice for mom and pop LAMP sites, it's not a good choice for enterprise applications:

        1. No support for unicode.
        2. Doesn't scale on multi-core systems.
        3. Only partial ACID compliance, reducing stability and increasing the risk of loss of data.
        4. MyISAM based tables don't include checkpoint save during transactions. This could lead to loss of data in the event of system failure.
        5. If you need to do data integration (ETL) or Reporting, you'll need to purchase a seperate tool. These tool often cost (after purchasing a license for every developer) more than the licensing for SQL Server alone. A license that includes these tools for as part of the product.
        bmonsterman