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:QueryWindows8ActivationStatus.ziphttp://gallery.technet.microsoft.com/scriptcenter/Script-to-list-Windows-8-5fe0b049
In a large enterprise, it is not convenience to check each computer's activation status one by one.
You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery
Script Download:CheckEncryptionCertificates.ziphttp://gallery.technet.microsoft.com/scriptcenter/Check-SQL-Server-4feff69f/
This script can be used to identify the certificates used in TDE (Transparent Data Encryption) which have not been backed up and then list the affected databases.
Script Download:GetAllStoredProcedures.ziphttp://gallery.technet.microsoft.com/scriptcenter/How-to-retrieve-all-the-7e2e5287/view/Reviews
A lot of people asked for methods to get the codes of stored procedures in a specified database. Some people want to save the codes so that they can run these codes in other databases.
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.
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.