July, 2014

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 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

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

July 4

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. 

Sometimes, a standard user will be able to use the "runas /savecred" command to run any command as administrator without entering a password. Perhaps user wants to allow a child's standard user account to run a game as Administrator without asking you, etc. This script can easily help you do it.

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