• [Script of Nov.15] Change upload file limit in specified Webapllication in SharePoint (PowerShell)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: 22203.zip
    http://gallery.technet.microsoft.com/scriptcenter/Change-upload-file-limit-89502ff2

    This script could be used to change upload file limit in specified Webapllication in SharePoint.

    Changing the upload file limits need several steps by using GUI. So a script will be better instead. 

    image image
    image

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

  • [Script of Nov. 28] Find inefficient query plans

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: 21998.zip
    http://gallery.technet.microsoft.com/scriptcenter/Find-inefficient-query-88f4611f

    This T-SQL script will check the plan cache for the top 25 inefficient query plans. It will list total CPU time, CPU time per execution, total read IOs, average read IOs per execution, total recompiles and average recompiles per execution.his PowerShell script will demo how to back up a SSAS database.

    The script will check the plan cache for the top 25 inefficient query plans. 

    image image
    image

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

  • [Script of Nov.11] Copy Files with version and metadata using PowerShell

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: ListLibrary_ExportImport.zip
    http://gallery.technet.microsoft.com/scriptcenter/Copy-Files-with-version-f2af7001

    This script can copy a List / Library from one web to another web while maintaining versions and metadata.

    In a real world, a lot of people ask copying just one List / Library from one web to another web while retaining versions, security info and metadata; this script would help to facilitate that.

     

    image image
    image

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

  • [Script of Nov.13] Check instantaneous and historical wait types (T-SQL)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: Wait.zip
    http://gallery.technet.microsoft.com/scriptcenter/Check-instantaneous-and-3a2ed244

    This script will check wait types and related information. It waits for a minute and then collects historical and instantaneous wait on the server. You can run this script and troubleshoot based on the results.

    You can use this script for troubleshooting when you want to check wait in SQL Server. 

    image image
    image

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

  • [Script of Nov.19] Convert .XLR file to .XLS file

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: 21704.zip
    http://gallery.technet.microsoft.com/scriptcenter/Convert-XLR-file-to-XLS-8748cad9

    This script will Convert Microsoft Works Spreadsheet file XLR to Microsoft Excel file XLS.

    This script is to help users to convert .XLR file to .XLS file via PowerShell.

    image image
    image

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