July 17

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-send-account-cdae5b39.  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 shows how to automatically send an email notification to Administrator when there is a user locked out.

When there is a user locked out, and then sends an email to domain admin. There are many users ask this issue, and this could be done by schedule task, we could also create a script to do the job.​

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 31

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-rebuild-or-12b01775.  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 rebuild or reorganize indexes in a specified database.

This script will list all the indexes in a database. We can choose to rebuild or reorganize the indexes according to their defragmentation. If avg_fragmentation_in_percent_value is higher than 30 and page_cout is more than 1000, we can rebuild the indexes. If avg_fragmentation_in_percent_value is between 5 and 30 and page_count is more than 1000, we can reorganize the indexes.

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

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 7

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-export-all-URLs-of-13033519.  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 can get all current url of tabs in Internet Explorer and supports automatically open the last opened urls.

When you opened many tabs in Internet Explorer but need to stop for the day, or maybe you just updated your computer followed by the inevitable 'Restart your computer to finish installing updates' message. At this point, you must close the browser session with gazillion tabs, you have to temporarily record the URL of each IE tabs that you want to open in the next session. We usually manually copy of each tab URL, it's really time-consuming. This script will help users to export all Internet Explorer tabs and tab titles. It's really useful for users.

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