Script Download: 26702.zip
http://gallery.technet.microsoft.com/Create-a-shortcut-to-Email-bcf779da

This script sample shows how to create a shortcut to Email a Recipient Directly to desktop in Windows 8.

Sometimes we often communicate with some people via Email, so we can create a shortcut on desktop for convenience.

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

Script Download: RemoveEmailAddress.zip
http://gallery.technet.microsoft.com/scriptcenter/Remove-E-Mail-address-with-d716e055

This script could be used to remove E-Mail address with specific domain Name in Microsoft Exchange 2010. This script can remove E-Mail address from mailbox, distribution group and dynamic distribution group.

In a real world, IT Administrators may want to remove new e-mail addresses due to variety of reasons. If an organization has thousands of recipients, it’s impossible to remove e-mail addresses for these recipients one by one. IT administrators do need a script to complete this task.

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

Script Download: LoginUserRolePermission.zip
http://gallery.technet.microsoft.com/scriptcenter/Get-logins-databases-816f66b2/

This script contains three code parts, one to get the result of server level logins and related roles, one to get the result of user databases’ users and related roles, one to get the result of object level permission of specific database.

This script can be used to get the following results:

• Server level logins and related roles
• User databases users and related roles
• Object level permission of specific database

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

Script Download:  
The script is available for download in Microsoft Script Browser for Windows PowerShell ISE. You need to install the Script Browser application first, and search for the script sample title.

This PowerShell script sample shows how to list all volume mount points in Windows.

Some users need a script to list volume point mounts which are created in Disk Management. Otherwise, users need to manually get them from Disk Management one by one. So this script sample can easily help users to do it.

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