CTP3 of SQL Server Code 2012, code name “Denali”, was made available for download this morning. You can download the 32-bit and 64-bit versions here. Official announcement from the SQL Server team blog and the announcement from the Analysis Services and PowerPivot Team Blog. Note that there was not a publically available CTP2. Microsoft went from CTP1 last November to CTP3.
Aaron Bertrand has some install notes and a Installation Walk-Through. Check out the official Microsoft CTP3 release notes and the Community Technology Preview 3 (CTP 3) Product Guide.
Jamie Thomson has a post about the SSIS enhancements in Denali CTP3, and Microsoft’s Wiki lists What’s New in Master Data Services (MDS) in Denali CTP3.
For technical questions about CTP3, go to the MSDN SQL Server (Pre-release) Forums. The link for feedback specifically for SQL Server (including Denali): https://connect.microsoft.com/sqlserver/feedback. Also find lots of help on twitter with the hashtag #SQLDenali.
Also check out Brent Ozar’s CTP3 is Here! Five Things to Know About the Next Version of SQL Server and How to Set Up SQL Server Denali Availability Groups (Brent obviously has been using CTP3 for a while..lucky guy!).
Mark Tabladillo’s post SQL Server Denali CTP3 and Data Mining has installation tips and explains that Microsoft has a “Technology Adoption Program” (abbreviated TAP) which has allowed the lucky few to obtain CTP1 before the public (as well as CTP2 which was not released to the public).
There is a cool new feature in CTP3 called “Product Update”: It integrates the latest product updates with the main product installation so that the main product and its applicable updates are installed at the same time. See Product Update” in SQL Server code-named “Denali and Product Update Frequently Asked Questions and My Denali First Glance – Product Update Feature.
And the sample AW databases have been updated: Adventure Works for SQL Server Denali CTP3.
Important SSAS note: During installation, when you are on the “Analysis Services Configuration” screen, you are given a choice of which server mode to use: “Multidimensional and Data Mining Mode” or “Tabular Mode”. You can’t install both on one instance. This means if you want to use both, you will need to install two instances of SSAS. To do that, you need to run the setup again after the first instance setup (you cannot install two instances in the same setup).
Denali also introduces a new version of SQL Express called SQL Express LocalDB.
Check out a new tool in CTP3 called “Recovery Advisor”. Recovery Advisor helps DBAs in creating a correct and optimal restore sequence. More info at Recovery Advisor: An Introduction.
Nice post on the Top 10 BI Reasons to Upgrade to SQL Server ‘Denali’ (SQL11) and the Top 10: New Features in SQL Server Denali.
For more details on Denali, check out my other blog posts: