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: LoginUserRolePermission.ziphttp://gallery.technet.microsoft.com/scriptcenter/Get-logins-databases-816f66b2/
This script can be used to get the following results:
You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery
Script Download: RemoveInternetExplorer(VBScript).ziphttp://gallery.technet.microsoft.com/scriptcenter/Script-to-remove-Internet-10785136/
In some situations, customers need to uninstall Internet Explorer 9 to fix crash issue, but they cannot manually uninstall Internet Explorer successfully sometimes.
Script Download: ADAccountBelongsTo.ziphttp://gallery.technet.microsoft.com/scriptcenter/Display-what-OU-the-5e9e19e0/
Many users have ever asked is there any way to list what OU the objects belong to. If we provide a script can do it, obviously this could be done by scripting.
Script Download: Deleteduplicaterows.ziphttp://gallery.technet.microsoft.com/scriptcenter/Delete-duplicate-m-1-rows-ab1c9525
Some people ask for a script to delete duplicate rows and keep only one row in a table. This T-SQL script sample will show you by creating a new table TestTable to imitate your table and a temporary table #TempTable. All the duplicate data will be stored in the temporary table. After executed, it will generate 2 tables, one to show you the duplicate data and a table to show the final result.
Script Download: IndexFragmentation.ziphttp://gallery.technet.microsoft.com/scriptcenter/Check-SQL-Server-a-a5758043
This script can be used for checking index fragmentation percentage of tables in SQL Server user databases. You can specify the database name and fragmentation percent, after you run the script, you will get the result.