• [Script of Nov. 26] Backup SQL Server Analysis Service database (PowerShell)

    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 of Nov.4] Set PictureUrl as default unless another picture is present (PowerShell)

    Script Download: SetSPUserPicture.zip http://gallery.technet.microsoft.com/scriptcenter/Set-PictureUrl-as-default-9e0123ca This script shows how to Set PictureUrl as default unless another picture is present. This script will set a default picture for the PictureUrl in a list where all user information...
  • [Script of Nov.20] Send a Warning Report of a Mail Storm

    Script Download: 22205.zip http://gallery.technet.microsoft.com/scriptcenter/Send-a-Warning-Report-of-a-1ad183ae 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. ...
  • [Script of Nov. 29] Security hardening for SharePoint 2010 farms (PowerShell)

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

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