ie8 fix

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

By | November 9, 2010, 8:46am PST

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.”

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.

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

Topics

Mary Jo has covered the tech industry for more than 25 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).

Disclosure

Mary-Jo Foley

Freelance journalist/blogger Mary Jo Foley has nothing to disclose. WYSIWYG (what you see is what you get). I do not own Microsoft stock or stock in any of its partners or competitors. I have no business ventures that are sponsored by/funded by Microsoft or any of its partners or competitors.

Biography

Mary-Jo Foley

Mary Jo Foley has covered the tech industry for 25 years for a variety of publications, including ZDNet, eWeek and Baseline. She has kept close tabs on Microsoft strategy, products and technologies for the past 10 years. In the late 1990s, she penned the award-winning "At The Evil Empire" column for ZDNet, and more recently the Microsoft Watch blog for Ziff Davis.

Got a tip? Send her an email with your rants, rumors, tips and tattles. Confidentiality guaranteed.

Related Discussions on TechRepublic

Did you know you can take part in these discussions with your ZDNet membership?
32
Comments

Join the conversation!

Just In

RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'
homeioy75-24353637303926178603322775177153 Updated - 10th Nov
This may be a soul every thing a large amount of serious non-public web sites I have really visual appeal not to mention becoming through. A large number of is really smallish triumphs through first-class popular guideline facts into points. I appreciate leftover professional and polite this particular. steelers jerseys,michael vick jersey,tom brady jersey,ray lewis jersey,mark sanchez jersey, Truck faster any time built related to such balances out a piece more than precisly your posts more often as well as a wordpress bog writing addionally web assessments? I just advise, everything we want to say is incredible as you move the details.
runs on an insecure OS??
Progress.
@LBiege

ZING!!!
@LBiege lol, DonnieBoy got 0wn3d
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.
  • Flagged
@LBiege ...

I lol'd pretty hard at that comment, but I do have a quick observation for you:

London Stock Exchange tried Server 2008 + SQL Server. It couldn't keep up with the work load and cost billions of pounds in lost trade time and multiple rollbacks.

They're now using (and happily, without down time) Linux. Not sure what DBS they're using, though.

Explain?

[edit]

Apparently it is Linux + MySQL. Hmm...
It is just point and click idiots that use this stuff, and it ends up costing the companies in so many ways.
@WarhavenSC NASDAQ runs SQL Server though
@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).
@WarhavenSC,

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?
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.
@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?

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

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

City of Munich Approves Extension of LiMux Project to 2013
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
http://limuxwatch.blogspot.com/2010_06_01_archive.html
@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 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 - 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.
@DonnieBoy,

Trolling as usual. Care to contribute anything useful?
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.
0 Votes
+ -
Yes of course he's clearly trolling
Johnny Vegas Updated - 9th Nov 2010
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.
@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?
@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...

1. MySQL has had strong unicode support since version 4, and it's now version 5.x.
2. As of MySQL 5.0: "Yes. MySQL is fully multi-threaded, and will make use of multiple CPUs, provided that the operating system supports them."
3. Correct. Only partial compliance out of box, but you don't have to use the default storage engine. You can use InnoDB or Berkeley whatever if full compliance is important.
4. ...

Wait, why am I bothering to correct anything? I suggest you take a look at MySQL again. It's clear you haven't touched it since, what... 2008?
@WarhavenSC,

1. Actually, after some research...only partial Unicode support (UTF-8 and UCS-2 encoded strings are limited to the BMP)
2. As far as multicore support (from wikipedia):
MySQL 5.1 and 6.0 showed poor performance when used for data warehousing partly due to its inability to utilize multiple CPU cores for processing a single query.
3. So you can use a third party storage engine that supports ACID fully. Good to know.

I should probably spend some time reviewing the newest features of MySQL to be fair. years go by fast, and there is alot to learn. Still it seems like MySQL has some catching up to do feature-wise. It is cheaper though. My main point to make here is that SQL Server is not a piece of junk. If you go to http://www.tpc.org you will find that SQL Server generally fairs better than MySQL (however DB2 and Oracle still seem to be the top dogs).
From what I understand "Cresent" is a Silverlight-based version of Reporting Services. Perhaps that's what Microsoft meant by a shift in strategy? Can't see them building future SSRS on HTML5 any time soon.
@DonnieBoy,

More FUD. Why don't leave us alone and go play on the Linux forums?
going forward. They more or less admitted that Silverlight will be relegated to a development platform for WP7.
0 Votes
+ -
They said with the increasing number of internet connected devices html will always have the broadest cross platform reach. But silverlight is still their preferred cross platform development strategy for the platforms it supports and they are heavily invested in new versions of silverlight and support for more platforms for it.

DonnieBoy you are either intentionally spreading FUD or you have embarassingly low reading comprehension...
@DonnieBoy,

Silverlight isn't going anywhere
0 Votes
+ -
I've been using/managing SQL Server (and Oracle) for over a decade and I can't imagine what the fuss over Denali is about. There's really nothing groundshaking, just a bunch of catch-ups and me-toos. AlwaysOn? That's just fixing stuff from 2005 and 2008 (what happened to that program anyway?). Still lagging behind Data Guard and RAC. Sequences? hmmm..... where have I seen that before.

Easy with the flamethrowers, I am a SQL Server supporter. I'm just really disappointed with how little ground they will gain in the new release. What further worries me is how little focus there was on consolidation + virtualization (I remember more good content on this last year) which is HUGE for us an pretty much all my peers. I also didn't see much around making upgrades more predictable (enough with the unexplained query plan changes that tanks performance) and easier to test (Oracle RAT anyone?). Security and compliance? Don't the MS folks know that not having fine grained security and true role separation is making SQL Server a non-starter for a growing number of apps?

The real bright sparks I saw are primarily on the BI side including PDW. Well done RS, AS and IS teams. What are the RDMBS guys doing? sad

C'mon guys, help me out here. I am your champion in my company but you're really making my job harder.
0 Votes
+ -
RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'
jackson1984-24316069205748857739440257893812 9th Oct
his attention-grabbing guide produced me smile. Possibly have to actually you throw in a very handful of photographs it could make the complete factor extra engaging. Anyway, in my language, reebok jersey there in most cases generally are not considerably superior deliver similar to this.
0 Votes
+ -
RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'
tomlin21-24319035676893835085146735905770 11th Oct
What i attain cheap authentic nfl jersey troublesome might possibly be to identify a blogging site which might seize me for only a minute but your running a blog web page differs. Bravo.
0 Votes
+ -
RE: Microsoft delivers first test build of next-generation SQL Server 'Denali'
homeioy75-24353637303926178603322775177153 Updated - 10th Nov
This may be a soul every thing a large amount of serious non-public web sites I have really visual appeal not to mention becoming through. A large number of is really smallish triumphs through first-class popular guideline facts into points. I appreciate leftover professional and polite this particular. steelers jerseys,michael vick jersey,tom brady jersey,ray lewis jersey,mark sanchez jersey, Truck faster any time built related to such balances out a piece more than precisly your posts more often as well as a wordpress bog writing addionally web assessments? I just advise, everything we want to say is incredible as you move the details.

Join the conversation!

Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]
ie8 fix

The best of ZDNet, delivered

ZDNet Newsletters

Get the best of ZDNet delivered straight to your inbox

Facebook Activity

White Papers, Webcasts, & Resources
ie8 fix