• [Script of Mar. 10] How to detect system health extended event session incorrect event specification

    Posted 10 months ago
    by Huilin zhu}

    Script Download: CheckIncorrectEventSpecification.zip 
    http://gallery.technet.microsoft.com/How-to-detect-system-40857284

    This T-SQL script will demo how to detect system health extended event session incorrect event specification in SQL Server 2012. 

    Every instance of SQL Server has a default extended event session created that has the name system_health. This session captures information about the wait_info and wait_info_external events. The definition of the system_health session in SQL Server 2012 contains incorrect map_key specified for the wait_types of interest. The script will help check system health extended event session incorrect event specification in SQL Server 2012.

    image image
    image

    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

  • [Script of Mar. 7] How to change the OneNote screen capturing shortcut key in Windows 8.1(VBScript)

    Posted 10 months ago
    by Huilin zhu}

    Script Download: SetShortcutKeyForOneNote(VBScript).zip
    http://gallery.technet.microsoft.com/How-to-change-the-OneNote-b80bef2e

    This VBScript sample shows how to change the OneNote screen capturing shortcut key in Windows 8.1

    New in Windows 8.1, Windows + S brings up a Search experience designed to help users find things more quickly from any application. We know how useful the old Windows + S shortcut key is in OneNote, so this script can provide a workaround in the meantime, it can help you custom a shortcut key for OneNote screen.

    image image
    image

    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

  • [Script of Mar. 6] How to detect trace flag 834 and column store indexes in SQL Server (T-SQL)

    Posted 10 months ago
    by Huilin zhu}

    Script Download: CheckTF834CSI.zip
    http://gallery.technet.microsoft.com/How-to-detect-trace-flag-1ce1152a

    This T-SQL script will demo how to detect if trace flag 834 is enable and column store indexes are used in SQL Server.

    If trace flag 834 is enabled and column store indexes are used, you may encounter performance issues with applications. This script will demo how to detect this problem. If it exists, the script will warn you.

    image image
    image

    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

  • [Script of Mar. 5] How to change the OneNote screen capturing shortcut key in Windows 8.1

    Posted 10 months ago
    by Huilin zhu}

    Script Download: SetShortcutKeyForOneNote(PowerShell).zip
    http://gallery.technet.microsoft.com/How-to-change-the-OneNote-09f269b6 

    This PowerShell script sample shows how to change the OneNote screen capturing shortcut key in Windows 8.1

    New in Windows 8.1, Windows + S brings up a Search experience designed to help users find things more quickly from any application. We know how useful the old Windows + S shortcut key is in OneNote, so this script can provide a workaround in the meantime, it can help you custom a shortcut key for OneNote screen.

    image image
    image

    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

  • [Script of Mar. 4] How to find locked out user account location (PowerShell)

    Posted 10 months ago
    by Huilin zhu}

    Script Download: GetLockoutLocation.zip 
    http://gallery.technet.microsoft.com/How-to-find-locked-out-1d964f6b

    This PowerShell script shows How to find locked out user account location in domain.

    There are many reasons caused account locked out. The user has logged onto another machine, and not logged off. Then, if the user has changed their password while the other machine is logged in, it could be requesting resources using the old (and now incorrect) password. Every time it tries to get a network resource that requires authentication it will cause a bad password attempt. This script can scan where the locked out user account location.

    image image
    image

    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery