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...

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...

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...

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...

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...