[Script of Nov. 29] Security hardening for SharePoint 2010 farms (PowerShell)

Posted over 1 year ago

by

Huilin zhu

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 of Nov. 28] Find inefficient query plans

Posted over 1 year ago

by

Huilin zhu

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 of Nov. 27] Check the frequency of a report access (T-SQL)

Posted over 1 year ago

by

Huilin zhu

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 of Nov. 26] Backup SQL Server Analysis Service database (PowerShell)

Posted over 1 year ago

by

Huilin zhu

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 of Nov. 25] Check the state of all instances in a SQL Server (PowerShell)

Posted over 1 year ago

by

Huilin zhu

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