• [Script of Sep. 16] T-SQL script to capture topology of an AlwaysOn configuration in SQL Server

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: AlwaysOnDataCollection.zip
    http://gallery.technet.microsoft.com/T-SQL-script-to-capture-add13e98

    This T-SQL sample script quickly captures topology of an AlwaysOn configuration in SQL Server.

    Knowing a topology is a frequent ask in TechNet forums and in CSS for troubleshooting.  IT professionals want to understand the topology so as to quickly understand help in troubleshooting. There are multiple dynamic views (DMVs) to get this data so getting this data manually is possible but can take longer. This script has been tested in SQL Server 2012.
    This script queries Dynamic Management Views DMVs and draws out the AlwaysOn topology. It helps us understand the topology and displays various other details that we need to understand the issue and thus helps us to troubleshoot the issue faster.
    image image
    image

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

  • [Script of Sep. 17] Remove hard drive disks from Storage Pool (PowerShell)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: RemoveHardDriveDisksFromStoragePool.zip
    http://gallery.technet.microsoft.com/scriptcenter/Remove-hard-drive-disks-cc8042c0

    This PowerShell Script shows how to remove hard drive disks from Storage Pool.

    It admins want to use PowerShell scripting to remove hard drive disks from Storage Pool, this script can do it.

    image image
    image

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

  • [Script of Sep. 18] Creating SharePoint 2010 site collection based on custom web templates

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: CreateSiteFromCustomWebTemplates.zip
    http://gallery.technet.microsoft.com/scriptcenter/Creating-SharePoint-2010-5969ba16

    This script can be used to create new site collections based on the templates that are saved on the disk.

    We have saved the existing team site as template. The template is saved into the disk. We want to create new site collection based on this template using PowerShell.

    image image
    image

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

  • [Script of Sep. 19] Enable or disable Control Panel in windows 8 (VBScript)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: DisableControlPanel(VBScript).zip
    http://gallery.technet.microsoft.com/scriptcenter/Enable-or-disable-Control-547d6169

    The goal of this script is to enable or disable Control Panel on Windows 8.

    Sometimes administrators want to prevent the access to Control Panel for ensuring security.

    image image
    image

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

  • [Script of Sep. 20] Enable or disable Control Panel in windows 8 (PowerShell)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: DisableControlPanel(PowerShell).zip
    http://gallery.technet.microsoft.com/scriptcenter/Enable-or-disable-Control-d6d33550

    The goal of this script is to enable or disable Control Panel on Windows 8.

    Sometimes administrators want to prevent the access to Control Panel for ensuring security.

    image image
    image

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