News

Next SQL Server Reaches CTP Stage

Improvements coming to Web-based data viewing, high availability and query performance.

Microsoft has opened up the first community technology preview (CTP) of the next version of SQL Server, which is code-named "Denali."

Microsoft very briefly described a few of Denali's new features in an announcement last month. One of those features is called "Crescent," which is the code name for an interactive, Web-based method of viewing data. "AlwaysOn" is designed to enable high availability for SQL Server. There's also a column-store technology, code-named "Apollo," designed to boost the performance of queries.

Database and application developers will have a tool in Visual Studio, code-named "Juneau," that supports both SQL Server and SQL Azure. Finally, Microsoft announced "data quality services" to work with Denali that provide tools to "profile, cleanse, match and merge data."

"[Crescent] effectively works to take data from a data warehouse and turn it into information that a typical knowledge worker can quickly and easily work with," says Wes Miller, a Directions on Microsoft analyst. "In many ways, it's the next step for PowerPivot after enabling Excel power users -- an important segment, but still just a fraction of the knowledge-worker space."

About the Author

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

Featured

  • Microsoft Announces Positive Q4 Revenue Results of $46.2B

    Microsoft on Tuesday reported $46.2 billion in total revenue during its fiscal-year 2021 Q4 period, up 21% from the same quarter last year.

  • The 2021 Microsoft Product Roadmap

    From Windows 10X to the next generation of Microsoft's application server products, here are the product milestones coming down the pipeline in 2021.

  • Kaseya Unlocking REvil-Encrypted Data Using Universal Key

    IT solutions firm Kaseya is now using a "universal decryptor key" for customers affected by a REvil ransomware attack.

  • Microsoft Unveils Plans To End Microsoft Stores for Business and Education

    The online Microsoft Store for Business and Microsoft Store for Education will be ending in the "first quarter of 2023," per a Microsoft document as well as a Wednesday announcement.