http://www.sqlservercentral.com/blogs/vinaythakur/2012/05/12/denali-day-12-more-manageability-features/

Printed 2014/12/22 12:33PM

Denali – Day 12: More Manageability Features

2012/05/12

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



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.