News

Microsoft Releases SQL Server 'Denali' CTP3, SQL Server 2008 R2 SP1

Microsoft this week released a pair of updates for SQL Server, including a third community technology preview (CTP3) of the next version of the company's flagship database management system, code-named "Denali." The Denali CTP3 can be downloaded here.

Also released this week was SQL Server 2008 R2 SP1, a service pack of update of Microsoft's shipping SQL Server product. The SP1 downloaded can be found here. The service pack provides greater supportability in "dynamic management views," improved query performance through a "ForceSeek" feature, improved upgrades via Data-tier Application Component Framework and better disk space control for PowerPivot, Microsoft's data analysis tool for Excel. Developers can find release notes for SQL Server 2008 R2 SP1 at this wiki page.

Microsoft described the availability of Denali CTP3, as well as SP1 for SQL Server 2008 R2, at this SQL Server team blog post.

Denali CTP3 Features
Some new Denali CTP3 features got showcased during a Tuesday session talk at the WPC by Robert Wahbe, Microsoft's corporate vice president for server and tools marketing. He boasted that Gartner has ranked SQL Server at the top for its business intelligence capabilities. He also touted SQL Server Denali's security capabilities, although the database management system is still relatively new on the scene.

"One thing that's very amazing about this release is that we've had zero, literally zero security vulnerabilities, so [it's] the most secure database in the world of any of the major vendors," Wahbe claimed.

Wahbe listed a few other Denali highlights during the talk, including AlwaysOn, which is designed to enable high availability for SQL Server.

"We now have a new feature in Denali called 'AlwaysOn'," Wahbe said. "It allows with a very simple wizard, small number of clicks, [that] you can have multiple secondaries for disaster recovery," he explained.

Wahbe also noted a new "column index" feature in Denali for running data warehouse queries. Possibly, that's the code-named "Apollo" feature that Microsoft described when it first announced Denali back in November.

"We have now new in Denali a column index, which improves the performance of data warehouse queries 10x," Wahbe claimed. "So literally, [the performance is] 10x faster for the most large and complex data warehouse queries."

Perhaps the most exciting Denali feature shown at the WPC was its "Crescent" analytical mashup capability, which can produce charts with a high degree of interactivity and drill-down capability. Wahbe described Crescent as part of Microsoft's general approach of enabling business intelligence capabilities for information workers.

"We are a leader in BI, with our solutions between Excel and PowerPivot, SharePoint for sharing of those BI scenarios, and then SQL Server powers all of that with reporting services and analysis services," Wahbe said. "And Denali takes an even bigger step forward with technologies like Crescent, which allows ad hoc exploration."

Crescent Demo
Amir Netz, a Microsoft distinguished engineer, showed off Denali's Crescent capabilities in a demo during the session talk. The demo charted application performance vs. service level agreement uptime. With Crescent, Netz could click on a graph and drill down to see specific performance information, and the performance of the mashup was supported by using AlwaysOn.

"In SQL Server Denali, we have a new capability that is called AlwaysOn," Netz said. "And AlwaysOn is a great way to get the right set of nines out of your applications for both performance and availability. Setting up AlwaysOn in an application is just a five-step wizard, and when you set it up, you have a host of features, including for example, active secondary. And with active secondary, you not only get availability from the secondary, but you can also use the hardware that is using them for the backup to get better performance."

During the Tuesday keynote earlier in the day, Netz showed a different Crescent demo that plotted car sales against gas prices, with the aggregated gas price data being pulled down from Windows Azure storage. Netz demonstrated how Crescent can display the data in a slideshow-like format, with graph lines showing car-model sales rising or falling relative to gas price data. For instance, Netz's demo showed a hybrid car model gaining traction over an SUV model over time as gas prices increased.

The gas price vs. car price Crescent demo is an example of a business intelligence mashup that incorporates data from Microsoft's Windows Azure Marketplace. Last fall, Microsoft started to provide data access services through the marketplace. Now, Microsoft has added applications to it, including direct services such as full software-as-a-service-type applications. The apps, currently numbering in the hundreds, are available only in the United States today, but availability will be expanded to additional markets in the coming months, according to Amy Barzdukas, general manager of communications for the Server and Tools Business Group at Microsoft.

About the Author

Kurt Mackie is senior news producer for 1105 Media's Converge360 group.

comments powered by Disqus

Featured

  • Mastering Blazor Authentication and Authorization

    At the Visual Studio Live! @ Microsoft HQ developer conference set for August, Rockford Lhotka will explain the ins and outs of authentication across Blazor Server, WebAssembly, and .NET MAUI Hybrid apps, and show how to use identity and claims to customize application behavior through fine-grained authorization.

  • Linear Support Vector Regression from Scratch Using C# with Evolutionary Training

    Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the linear support vector regression (linear SVR) technique, where the goal is to predict a single numeric value. A linear SVR model uses an unusual error/loss function and cannot be trained using standard simple techniques, and so evolutionary optimization training is used.

  • Low-Code Report Says AI Will Enhance, Not Replace DIY Dev Tools

    Along with replacing software developers and possibly killing humanity, advanced AI is seen by many as a death knell for the do-it-yourself, low-code/no-code tooling industry, but a new report belies that notion.

  • Vibe Coding with Latest Visual Studio Preview

    Microsoft's latest Visual Studio preview facilitates "vibe coding," where developers mainly use GitHub Copilot AI to do all the programming in accordance with spoken or typed instructions.

  • Steve Sanderson Previews AI App Dev: Small Models, Agents and a Blazor Voice Assistant

    Blazor creator Steve Sanderson presented a keynote at the recent NDC London 2025 conference where he previewed the future of .NET application development with smaller AI models and autonomous agents, along with showcasing a new Blazor voice assistant project demonstrating cutting-edge functionality.

Subscribe on YouTube