• [Script of Feb. 7] Lists all the shared folder permissions or NTFS permissions (PowerShell)

    Script Download: ListAllSharedFolderPermission.zip  
    http://gallery.technet.microsoft.com/scriptcenter/Lists-all-the-shared-5ebb395a 

    This PowerShell script illustrates how to list all the shared folder permissions and NTFS permissions.

    In many cases, users want to check many share folders permission one by one. If we can use the script to list these share folders permission, it will really useful.  

    image image
     image

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

  • [Script of Feb. 6] Script to validate Tempdb configuration in SQL Server

    Script Download: ValidateTempdbConfig.zip 
    http://gallery.technet.microsoft.com/scriptcenter/Script-to-validate-Tempdb-4c988afa 

    This T-SQL sample script illustrates how to check tempdb configuration per best practices. Tempdb is a system database is highly used by Sql Server and an optimal tempdb configuration is generally important for smooth running of the Sql instance.

    Ideal tempdb configuration is a frequently asked question by IT administrators in the TechNet forums.  IT professionals want to check tempdb best practices by script, for example,

    • Checking current number of tempdb data files
    • Suggesting ideal number of tempdb data files (subject to testing).
    • Checking if tempdb files are created of equal size.
    • Checking if tempdb files are created of equal growth (increment and type).
    • Checking if tempdb trace flag (for uniform extent allocation) is enabled and required depending on Sql version
    • Suggesting if tempdb configuration is healthy if no suggestions were made
    • Ability to run script in Sql 2005/2008/2008R2/2012.
    • Properly switching users in Windows 8 without a Start button can be a bit of a chore. Many users may want to switch users in just one click. This script enables users to click a tile to switch user on the Start menu.
    image image
     image

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

  • [Script of Feb. 5] Script to review non-default SQL configuration settings (sp_configure)

    Script Download: NonDefaultSpConfigure.zip 
    http://gallery.technet.microsoft.com/scriptcenter/Script-to-review-non-d5c1a6ae 

    This is a frequent troubleshooting requirement for individual sp_configure values during most SQL performance troubleshooting. We've hundreds of known cases which have this settings check as among first step of SQL performance troubleshooting.

    Quickly checking sp_configure values is a frequently asked question by IT administrators in the TechNet forums.  IT professionals want to validate the non-default SQL Server configuration values so as to quickly identify these values using T-SQL scripts, for example,
    • Encountering a performance issue.
    • Validating SQL instance configuration settings.
    • Running same script across multiple versions (SQL Server 2005/2008/2008R2/2012)
    • When automating this collection across multiple server using scripts
    • Checking Sql instance configuration settings with respect to http://support.microsoft.com/kb/319942 (How to determine proper SQL Server configuration settings).
    image image
     image

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

  • [Script of Feb. 4] Change window border,desktop icon spacing,desktop background color and wallpaper

    Script Download: ChangeDesktopIconSize.zip
    http://gallery.technet.microsoft.com/scriptcenter/Change-window-borderdesktop-609a6fb2  

    This sample demonstrates how to change the window border, desktop icon spacing, desktop background color, and wallpaper by using PowerShell script. This script completes the tasks by using P/Invoke to call Windows API functions.

    IT administrators can use this script to adjust desktop appearance for a group of computers to keep a consistent user experience.

    image image
     image

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

  • [Script of Feb. 3] How to verify if an OU exists (VBScript)

    Script Download: VBSFindOU.zip 
    http://gallery.technet.microsoft.com/scriptcenter/How-to-verify-if-an-OU-b0317c33 

    This VBScript illustrates how to check or verify if an Active Directory (AD) Organizational Unit (OU) exists.

    If we bind to a particular OU that does not exist using VBScript, the script terminates with object not found exception. Using this sample script we can verify the existence of required OU before we perform some operation on respective OU.

    image image
     image

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