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: 22231.zip
http://gallery.technet.microsoft.com/Security-hardening-for-c425db1d

This PowerShell script shows how to check required ports status in SharePoint 2010.

To help the SharePoint admin, we need to come-up with a script that would check all the ports required by SharePoint and provide an output with details as to which all ports are open or block, along with a line that would describe the need of these ports.

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

Script Download: 21998.zip
http://gallery.technet.microsoft.com/scriptcenter/Find-inefficient-query-88f4611f

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.his PowerShell script will demo how to back up a SSAS database.

The script will check the plan cache for the top 25 inefficient query plans. 

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

Script Download: 22121.zip
http://gallery.technet.microsoft.com/scriptcenter/Check-the-frequency-of-a-26609dc9

This T-SQL script will check the frequency of all the reports visited on the report manager during the latest week, latest month and latest year.

You can use this script for reference when you want to know the frequency of reports visited. 

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

Script Download: 22118.zip
http://gallery.technet.microsoft.com/scriptcenter/Backup-SQL-Server-Analysis-37016bec

This PowerShell script will demo how to back up a SSAS database.

Some people asked how to back up a database by PowerShell. And this script will demo how to back up a SSAS database by PowerShell.

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