November, 2013

The yearly Microsoft MVP Global Summit will lift its curtain on Nov 17th in Bellevue, WA.  This year, we have prepared three new apps and many new samples in response to MVPs’ feedbacks last year.  If you are attending this year’s Microsoft MVP Global Summit, you will have the privilege to kiss or bite their development team  

• Sample Browser Windows Phone app – with 6000+ MSDN code samples which will be at your fingertips anytime and anywhere.
• Script Explorer for PowerShell ISE – with 8000+ script sample which will be at your fingertips when you are writing scripts in PowerShell ISE.
• PowerShell checkin policy for TFS – automatically checks your PowerShell script code against best practices of PowerShell.

Interested?  Please open your Schedule Builder for the MVP Summit 2013, and register for the event called “OneCode & OneScript” on Nov 17th.  We look forward to seeing you and learning your feedback.

Script Download: 22221.zip
http://gallery.technet.microsoft.com/scriptcenter/Retrieve-a-list-of-Active-90c533a2

This PowerShell script sample shows how to get a list of active directory Sam Account name based on display name.

This PowerShell script sample shows how to get a list of active directory Sam Account name based on display name.

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

Script Download: 22165.zip
http://gallery.technet.microsoft.com/scriptcenter/How-to-add-credentials-to-c8e9bd5f

This PowerShell script shows how add credentials for specific users.

There is no need to manually add credentials using control userpasswords2>Advanced>Manage Passwords>Add a windows credential. A script for administrator to add credentials for specific users is more convenient.

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

Script Download: CheckPre-requisiteFixesSQLServer2012AlwaysOn.zip
http://gallery.technet.microsoft.com/scriptcenter/Check-pre-requisite-fixes-d5843842

This sample script checks pre-requisite fixes for AlwaysOn in SQL Server 2012. These fixes are publicly documented in http://technet.microsoft.com/en-us/library/ff878487.aspx (Prerequisites, Restrictions, and Recommendations for AlwaysOn Availability Groups (SQL Server)), in section “Windows Hotfixes that Support AlwaysOn Availability Groups (Windows System)”.

Installing prerequisite fixes is not checked during configuration of SQL Server AlwaysOn, however may result in unexpected issues later.

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

Script Download: ConvertTxtToWord(VBA).zip
http://gallery.technet.microsoft.com/scriptcenter/Batch-convert-txt-files-to-8b945d5e

This VBA sample shows how to convert ‘.txt’ files (in a folder) to Word documents.

Batch converting ‘.txt’ files to Word documents is a frequently asked question in many public forums.

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

Script Download: 22123.zip
http://gallery.technet.microsoft.com/scriptcenter/Check-the-state-of-all-1ad2f8d2

This PowerShell script will check the state of all instances in a SQL Server. It will list the name, start mode, state and status of all the instances in a local machine. If there is no instance installed, it will remind you that there is no instance.

Some people asked how to list the state of all instances in a machine. They need get all the instances in their machine and check if they are running or stopped.

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