CTP3 of Microsoft SQL Server Code Name “Denali” was released recently. I’ve been skimming the latest documentation to determine which new general and database engine features I will want to examine more closely. There are many interesting features added in all the components (especially in the BI stack) of this SQL Server version, but given my focus on deploying and managing SQL Server databases in the enterprise environment, my initial concentration will start with this feature list:
- Product Updates
- Contained Databases
- PowerShell Improvements
- Uses the new PowerShell 2.0 modules feature to import the sqlps module
- New cmdlets: backup-sqldatabase and restore-sqldatabase
- New DMVs
If you, too, are ready to start investigating Microsoft’s next version of SQL Server, then I’d recommend starting with the current Release Notes which includes links to the CTP download, the Denali SQL Server Books Online, and Denali forums.
Which features are you looking forward to investigating?