• [Script Of Auguest 1] How to check VLF information in SQL Server

    image image
    Aug.
    1
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-check-VLF-5bf8597f.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

    This script will list the actual log size, used log space, number of actual VLFs, number of used VLFs and other related information of all databases in an instance. Besides, the script will proactively list potential log size and the number of potential VLFs.

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

  • [Script Of August 4] How to prevent a group of users from changing their passwords in AD

    image image
    Aug.
    4
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-prevent-a-group-of-5a915d54.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

    This PowerShell script sample shows how to prevent a group of users from changing their passwords in Active Directory.

    Sometimes admins want to restrict all the users of a group from changing their password. This script is to achieve that.

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

  • [Script Of August 5] Add "Send to SkyDrive" to the Windows Explorer context menu in Windows 8.1

    image image
    Aug.
    5
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/Add-Send-to-SkyDrive-to-aa19aaa7.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

    The goal of this script is to add "Send to SkyDrive" to the Windows Explorer context menu in Windows 8.1.

    Windows 8.1 is integrated with SkyDrive. If we want to copy some files or folders to SkyDrive folder, we need to copy and paste them. If there is an item "send to SkyDrive" in context menu, it will be more convenient for users to achieve this target.

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

  • [Script Of August 6] Get the information of used/free space of all databases in a SQL Server instance

    image image
    Aug.
    6
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-get-the-information-c5b047ed.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

    This PowerShell script will demo how to get the information of used or free space of all SQL Server databases in an instance.

    As some people asked how to get the used or free space of all databases in a SQL Server, this script will demo how to get the following information:

    • total size of data file(s)
    • total size of log file(s)
    • used space size of data file(s) +log file(s)
    • free space size of data file(s) + log file(s)
    • size of every data file and log file

     

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

  • [Script Of August 7] How to input or change Office 2013 product key

    image image
    Aug.
    7
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-input-or-change-849d1053.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

    This script sample shows how to input or change Office 2013 product key in Windows 8.

    Sometimes due to some error, people cannot input or change their Office product key. This script can solve this problem.

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