SQL Server Code Name “Denali” CTP3 and SQL Server 2008 R2 SP1 are HERE!

SQL Server Code Name “Denali” CTP3 and SQL Server 2008 R2 SP1 are HERE!

Rate This
  • Comments 8

Today we are excited to announce the release of SQL Server Code Name “Denali” Community Technology Preview 3 (CTP3). This CTP release represents a significant milestone for customers and partners looking to experience the extensive new value delivered in Denali.

SQL Server Code Name “Denali” CTP3 brings a huge number of new capabilities for customers to explore and test. Product highlights for this CTP include:

  • Greater availability. Deliver the required 9s and data protection you need with AlwaysOn which delivers added functionality over CTP1.
  • Blazing-fast performance. Get unprecedented performance gains with Project “Apollo,” a new column store index that offers 10-100x star join or similar query performance improvements available for the first customer preview.
  • Breakthrough insight. Unlock new insights with rapid data exploration across your organization with Project “Crescent,” available to customers for the first time. Get your hands on the data exploration and visualization tool that everyone is talking about and enables end users to explore data at the speed of thought.
  • Credible, consistent data. Provide a consistent view across heterogeneous data sources with the BI Semantic Model (BISM) a single model for Business Intelligence applications, from reporting and analysis to dashboards and scorecards. Make data quality a part of everyday life with the Master Data Services add-in for Excel and new Data Quality Services that is integrated with third party data providers through Windows Azure Marketplace. Customers can test this functionality for the first time and put data management and cleansing tools in the hands of those who need it.  Available integrated Marketplace providers include:
  • Cdyne: CDYNE Phone Verification will validate the first 7 digits of your phone number(s) and return what carrier the phone number id is assigned to, whether it is a cellular number or a land line, the telco, and additional information including time zone, area code and email address if it is a cellular number
  • Digital Trowel: Powerlinx  allows users to send data for refinement and enhancement and receive back cleansed and enriched data. The database contains 10 million company website addresses, 25 million detailed company profiles, and 25 million executives, including 5 million in-depth profiles with email addresses and phone numbers. 
  • Loqate: The Loqate Verify  enables users to parse, standardize, verify, cleanse, transliterate, and format address data for 240+ world countries.
  • Loqate: The Geocode enables a latitude-longitude coordinate to be added to any world address with worldwide coverage to city or postal code for over 120 countries
  • Melissa Data: WebSmart Address Check parses, standardizes, corrects and enriches U.S. and Canadian addresses to increase deliverables, reduce wasted postage and printing, and enhance response
    • Productive development experience. Optimize IT and developer productivity across server and cloud with Data-tier Application Component (DAC) parity with SQL Azure and SQL Server Developer Tools code name “Juneau” for a unified and modern development experience across database, BI, and cloud functions. Additionally, Express customers can test a new LocalDB version for fast, zero-configuration installation.

Today, you have the chance to preview and test these marquee capabilities and the upgrade or migration experience. CTP3 is a production quality release that includes access to upgrade and migration tools like Upgrade Advisor, Distributed Replay and SQL Server Migration Assistant (SSMA). Upgrade Advisor and Distributed Replay allow you to perform thorough analysis and testing of your current SQL Server applications before upgrading so you know what to expect. You can also use SSMA to automate migrate non-SQL Server databases to SQL Server Code Name “Denali”. For more detailed information about the new SQL Server Migration Assistant v5.1, visit the SSMA team blog.

Download the bits here, test the new functionality and submit feedback back to us to help us deliver a high-quality release!

But wait – there’s more…

…SQL Server 2008 R2 SP1 is also available!

In addition to the CTP3 for SQL Server Code Name “Denali,” today we’re also excited to release SQL Server 2008 R2 SP1 to customers.

SQL Server 2008 R2 SP1 contains cumulative updates for SQL Server 2008 R2 and fixes to issues that have been reported through our customer feedback platforms.  These include supportability enhancements and issues that have been reported through Windows Error Reporting. The following highlight a few key features with enhancements in this CTP:

  • Dynamic Management Views for increased supportability
  • ForceSeek for improved querying performance
  • Data-tier Application Component Framework (DAC Fx) for improved database upgrades
  • Disk space control for PowerPivot

Customers running SQL Server 2008 R2 can download SP1 starting today!


Abhishek Sinha & Tamara Gillest
Program Managers
Microsoft SQL Server Release Services

Leave a Comment
  • Please add 1 and 4 and type the answer here:
  • Post
  • "SQL Server 2008 R2 SP1" I swear, everything I think Microsoft has peaked in terms of awful, unintelligible naming schemes for it products, you guys manage to top yourselves. Kudos!

  • @Jon: They have always referred to service packs using the 'SP' abbreviation... Were they supposed to come up with a different name for them simply because the name of the product ends in 'R2'?

  • R2 was a really poor name. I see people almost *daily* thinking that 2008 and 2008 R2 are the same version. I've even seen a customer ask, "you want me to pay HOW MUCH to upgrade to a SERVICE PACK?" when contemplating an R2 migration. I'm hoping that Microsoft's marketing department has learned from this mistake, but my hope is probably ill-conceived.

  • I think they added R2 after a group of products like SQL Server 2008 since the new version did not change a lot the core application. SQL2008R2 actually had enhancements related with BI tools, etc not the server engine itself. Am I wrong?

  • Yes, that is part of it, but given the confusion this has caused in the market ("What is wrong with this thing? Why can't I apply SQL Server 2008 Service Pack 2 to my SQL Server 2008 R2 instance?") I think it has been proven that that reasoning does not warrant the actual outcome. I pray that they don't make such a mistake again.

  • If SQL Server 2008 R2 SP1 **CTP** has been installed, what is the recommendation now that SP1 is released? Should the SP1 CTP be uninstalled so the released version can be installed, or are the CTP and actual release the same build?

    I have reviewed the release notes and readme files without finding any guidance on this.

    Thank you.

  • You say "downlaod the bits here" but there is no link. Where's the download?

  • Hi guys all mans programmers$$$$$;;;;;;:)))

    Where's the download?

    Link need usuer all auto e-mail pls.!

Page 1 of 1 (8 items)