Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-manage-Inbox-Rules-0ddf3503.  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 get or increase the Inbox Rules Quota of end users' mailbox.

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

July 9

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-get-index-usage-0c34ba21.  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 find all the user_seek, user_scans, user_lookups, user_updates information in the user tables from the last time SQL Server starts.

Some people ask how to find indexes usage from the last time SQL Server starts. This script will demo how to find all the indexes usage numbers and last time of usage.

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

July 10

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-check-if-SQL-Server-af01ebb9 (SQL) and http://gallery.technet.microsoft.com/How-to-check-if-SQL-Server-23bace0c (powershell).  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

Only files associated with a database snapshot should be marked as sparse files. If a regular database is marked as a sparse file, you might encounter unexpected performance degradation and errors during normal activities. This script will find all the database files marked as sparse files in an instance.

Some people asked how to check if SQL Server database files marked as sparse files. This script will help demo how to find out all the database files marked as sparse files.

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

July 11

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/scriptcenter/How-to-easily-run-an-0c0eb47a/.  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 demonstrate how to list tables with the following index issues in a database:

• Tables with no index
• Tables with no clustered index but with non-clustered index
• Tables with more indexes than columns

We provide this script for people to reference. If you want to know tables with no index or clustered index, or tables with more indexes than columns, this script will provide some help.

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

July 14

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-assign-License-to-a920873d.  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 auto assign License to unlicensed users if there's only one type of SKU in an organization. If an organization has multi-type SKUs, an excel sheet will be popped out for edition after you run the script. Then the script will assign license based on the excel file.

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