Denali – Day 12: More Manageability Features

Denali – Day 12: – More Manageability Features:

  1. -K switch

    With new feature added in an engine to use that feature with different way you may have to add options to use it, as HADRon – AlwaysON feature where secondary server is read-only and active, there is an option -K added in bcp.exe and sqlcmd.exe which can specifies this.

 

  1. Powershell Enhancement:

    As stated earlier now Powershell 2.0 is mandatory but need to install separately.

    Sqlps is default to load Powershell.

    Two new cmdlets: backup-sqldatabase and restore-sqldatabase.

 

  1. DTA Enhancement:

    Now you can specify Query Plan Cache in DTA with that we do not need to have a workload for suggestion, DTA will automatically check last 1000 events(can be changes using –n option).

     

  2. Support of Server Message Block

    So far Windows supports Drive letters are limited to 23 so SMB enhance that way you could increase it.

     

  3. Management Studio Shortcuts:

    New management studio several shortcuts and some of the shortcuts has changed.

    For more detailed:

    http://msdn.microsoft.com/en-us/library/ms174205.aspx

About these ads
This entry was posted in Denali, Whats New and tagged . Bookmark the permalink.

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