Aug. 22

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-grant-everyone-full-aaf82d47.  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 is used to help administrator to assign the full access permission of a shared mailbox to the organization mailbox or a single mailbox.

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

Aug. 5

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

Aug. 1

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

Aug. 26

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

DBA sometimes found SQL Server had a lot of idle connection and want to free these connection resources, but it is a terrible effort to kill these session one by one. This T-SQL script will bring DBA an easy way to manage idle session.

DBA will use the T-SQL script to manage idle session. If the SQL Server resource is tight and too many connection already cause the new connection failure, then DBA could use this script to kill these idle connection to let new request could be handled.

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

Aug. 6

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