• [Script of May 17] Guest user permission check for multiple databases per security best practices

    Posted over 1 year ago
    by Huilin zhu}
    Script Download: GuestUserCheck.zip http://gallery.technet.microsoft.com/scriptcenter/Guest-user-permission-ac9eecdb This T-SQL sample script checks permissions for guest user in all databases. This script applies to system and to user databases. Knowing about guest user in Sql server is a frequent...

  • [Script of May 16] Fix Publishing Pages which reference bad page layout within a site collection

    Posted over 1 year ago
    by Huilin zhu}
    Script Download: FixPublishingPages.zip http://gallery.technet.microsoft.com/scriptcenter/Fix-Publishing-Pages-which-1e0deb22 This script will scan all publishing pages in a given site collection and check if the pages in the pages library have a valid url for the page layout. The script runs in a...

  • [Script of May 15] Update Owner of a Group with another Group in a Web in Microsoft SharePoint 2010

    Posted over 1 year ago
    by Huilin zhu}
    Script Download: ScriptPack.zip http://gallery.technet.microsoft.com/scriptcenter/Update-Owner-of-a-Group-1a205289 The script can be used to update Group owner of a web with another group in the same web. The action can be performed from UI but is often time taking if needed to be done in bulk...

  • [Script of May 14] Check SQL Server encryption certificates present without a backup issue

    Posted over 1 year ago
    by Huilin zhu}
    Script Download: CheckEncryptionCertificates.zip http://gallery.technet.microsoft.com/scriptcenter/Check-SQL-Server-b328b4f6 This script can be used to check your SQL Server encryption certificates without backup issue. We can use Get-OSCEncryptionCertificates to identify the certificates used...

  • [Script of May 13] Check SQL Server average percent fragmentation using PowerShell

    Posted over 1 year ago
    by Huilin zhu}
    Script Download: CheckSQLServerFragmentation.zip http://gallery.technet.microsoft.com/scriptcenter/Check-SQL-Server-average-f96a1088 This script can be used to check your SQL Server average percent fragmentation and list the fragmentation between 5 and 30 or more than 30 percent. By default, we...