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: 

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 T-SQL script will demo how to combine multiple rows into one row by a same column value in SQL Server.

As many people asked how to combine multiple rows into one row by a same column value. The script will demo how to combine by creating a table.

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

Script Download: 31686.zip
http://gallery.technet.microsoft.com/How-to-batch-change-the-47e310b4

This PowerShell script sample shows how to batch change the content type of Windows Azure blob storage. 

In some cases, a lot of media files stored on blob are in different formats - mp4, image file, etc. Sometimes, all these files are set as one content type: application/octet-stream, which causes issues in media playback and progress bar. Many users would like to know how to set the appropriate Content-type for files stored on blob (like - video/mp4, video/ogg, video/webm)—not to do it manually for each file through blob interface. This script will help users easily batch change the content type of blob storage. It allows users to change content type of blob storage to any data type.

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 Windows PowerShell script will prepopulate a batch of user passwords to a specified Read-only Domain Controller. It will leverage the capability of the native command, repadmin. The script will also strictly check the parameters for avoiding any potential human error.

Currently, IT Professionals can only prepopulate user password for one account each time.  If IT Professionals have to prepopulate 200 or more user passwords within a very short period of time, the job will turn out to be very stressful and tedious.

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

Script Download: 29331.zip
http://gallery.technet.microsoft.com/How-to-Export-the-list-of-f81ea5e1

This script will generate a report about the status of Exchange Active Sync devices.

This script is to help Exchange Administrators to generate a report about Exchange Active Sync Devices of mailboxes in organization, a group of mailboxes or a single mailbox.

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