• [Script of Jun. 9] How to change the Power button behavior in Windows

    Script Download:  
    The script is available for download in Microsoft Script Browser for Windows PowerShell ISE. You need to install the Script Browser application first, and search for the script sample title.

    The goal of this script is to change the power button behavior in Windows 7.

    Sometime users do not want to shut down the computer, and want the computer to sleep or hibernate. However, the default action in Power button "Shut down". This script is to change the power button behavior.

    image image
     image

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

  • [Script of Jun. 10] How to configure the size limit for both (.pst) and (.ost) files in Outlook

    Script Download:  
    The script is available for download in Microsoft Script Browser for Windows PowerShell ISE. You need to install the Script Browser application first, and search for the script sample title.

    This VBscript sample shows how to configure the size limit for both (.pst) and (.ost) files in Outlook 2013.

    In Outlook, as the recommended PST file size is less than 2GB, some users want to increase thier Outlook achive files size, but according to the MSKB 832925, the steps seems significantly complicated. The script can help user configure the size limit for .pst and ost files in Outlook, it could save the tedious process.

    image image
     image

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

  • [Script of Jun. 11] How to change the Power button behavior in Windows

    Script Download:  
    The script is available for download in Microsoft Script Browser for Windows PowerShell ISE. You need to install the Script Browser application first, and search for the script sample title.

    The goal of this script is to change the power button behavior in Windows 7.

    Sometime users do not want to shut down the computer, and want the computer to sleep or hibernate. However, the default action in Power button "Shut down". This script is to change the power button behavior.

    image image
     image

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

  • [Script of Jun. 12] How to get index usage information in SQL Server databases

    Script Download:  
    The script is available for download in Microsoft Script Browser for Windows PowerShell ISE. You need to install the Script Browser application first, and search for the script sample title.

    This T-SQL script will demo how to find all the user_seek, user_scans, user_lookups, user_updates information in the user tables from the last time SQL Server starts.

    There are some people asking how to find index usage from the last time SQL Server starts. This script will demo how to find all the index usage numbers and the last time of usage.

    image image
     image

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

  • [Script of Jun. 13] How to find logins without user mapping in a specified SQL Server database (T-SQL)

    Script Download:  
    The script is available for download in Microsoft Script Browser for Windows PowerShell ISE. You need to install the Script Browser application first, and search for the script sample title.

    This T-SQL script will demo how to find all the logins without user mapping in a specified SQL Server database. Besides, it will list all the users and logins, except for server roles and server principals with names enclosed by double hash marks “##” which are for internal system use only.

    Some people may encounter an error "The login already has an account under a different user name" when creating a user account for a specified database. So they need to create a user with another login. If there are many logins, it is not easy for them to try one by one. It will be better if there is a script to find all the available logins.

    image image
     image

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