We offer two things:
1. Hundreds of automation script samples based on IT Pros' frequently asked IT tasks
2. Script Browser & Script Analyzer tools to ease and improve the script writing
Script of the Day
Script Download: GuestUserCheck.ziphttp://gallery.technet.microsoft.com/scriptcenter/Guest-user-permission-ac9eecdb
Knowing about guest user in Sql server is a frequent security requirement. This can also be a source of confusion since many a times guest user is disabled in Sql Server msdb's Sql server and results in issues indicated in below mentioned KB.
Some forums for such requirements are below:http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/04940880-85c4-419a-a859-8a6bd58a18f0
Such a script should also help in below mentioned KB (KB has script for single database):http://support.microsoft.com/kb/2539091
You should not disable the guest user in the msdb database in SQL Server
Script does below:
You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery
Script Download: FixPublishingPages.ziphttp://gallery.technet.microsoft.com/scriptcenter/Fix-Publishing-Pages-which-1e0deb22
Script Download: ScriptPack.ziphttp://gallery.technet.microsoft.com/scriptcenter/Update-Owner-of-a-Group-1a205289
The action can be performed from UI but is often time taking if needed to be done in bulk.
Script Download: CheckEncryptionCertificates.ziphttp://gallery.technet.microsoft.com/scriptcenter/Check-SQL-Server-b328b4f6
We can use Get-OSCEncryptionCertificates to identify the certificates used in TDE (Transparent Data Encryption) which have not been backed up and then list the affected databases. By default, this script use Windows Authentication to connect to your SQL Server. If you want to use SQL Server Authentication, just uncomment some code in this script.
Script Download: CheckSQLServerFragmentation.ziphttp://gallery.technet.microsoft.com/scriptcenter/Check-SQL-Server-average-f96a1088
By default, we can use New-OSCSqlConnection to create a SqlConnection and then use Get-OSCFragmentationInfo to get fragmented tables. Also, you can use Windows Authentication or SQL Server Authentication to connect your SQL Server. If you want to use SQL Server Authentication, just need to uncomment some code in this script.