• Categories

  • Recent Posts

  • Archives

  • Copyright Notice

    Copyright © Nancy Hidy Wilson, 2010-2013. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Nancy Hidy Wilson and nancyhidywilson.wordpress.com with appropriate and specific direction to the original content.

My SQL Server Denali CTP3 First Glance


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
    • dm_os_volume_stats
    • dm_os_windows_info
    • dm_server_memory_dumps
    • dm_server_services
    • dm_server_registry
  • AlwaysOn

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?

Advertisements

One Response

  1. […] My SQL Server Denali CTP3 First Glance (nancyhidywilson.wordpress.com) […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: