July, 2014

July 15

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-find-inneficient-7242d286.  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 T-SQL script will check the plan cache for the top 25 inefficient query plans. It will list total CPU time, CPU time per execution, total read IOs, average read IOs per execution, total recompiles and average recompiles per execution.

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

July 16

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-modify-send-75ac2030.  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 updates address space for specific send connectors in Microsoft Exchange Server 2010.

Send connectors create a logical connection to remote e-mail systems and are responsible for outbound transmission of e-mail messages. If your organization requires a Send connector with specific configuration options, or if you don't use the EdgeSync process, you have to manually configure Send connectors. Sometimes, you need to add or remove dozens of domains in the address spaces. So you want a script to complete this task more efficiently.

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

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 18

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-convert-xlr-file-to-45c07dbe.  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 Convert Microsoft Works Spreadsheet file XLR to Microsoft Excel file XLS.

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

July 21

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-Send-a-Warning-9d8e503f.  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 find senders that have sent large numbers of e-mails, then look for consistent use of same subject and recipient, finally send a warning email to a particular User.

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