Download Windows Server 2012TechNet Gallery - resources for IT professionals
Download resources and applications for Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office, and other products. Find resources written in VB Script, PowerShell, SQL, JavaScript, or other script languages. New resources are added frequently so check often and see what's new.
Each contribution is licensed to you under a License Agreement by its owner, not Microsoft. Microsoft does not guarantee the contribution or purport to grant rights to it.
Sort by:
|
This SQL script will helpful for daily checklist, incase of no any third party tool is available for database monitoring. script will produce the all database size, status, recovery model, data & log file size, spaceused & free space details.
|
(12)
Updated 1/14/2013
Released 8/29/2012
2,139
Downloads
|
|
|
This SQL script is used for maintenance task of reorganizing & rebuilding of indexes task. I have inclued the fragmentation level of indexes is >5 & <30 for reorganizng & above 30 is for rebuild. Result will display as on which indexes task is executed.
|
(6)
Updated 9/7/2012
Released 9/7/2012
730
Downloads
|
|
|
SQL server all jobs details:-This query is provide you the sql server all jobs details. you will get job name, job status, Last run date of job & job execution status (failed or successfull) , you can add or modify fields as per requirement. This query is running on versions of s
|
(1)
Updated 1/4/2013
Released 1/4/2013
383
Downloads
|
|
|
From long time I want to create a one query which will give me a required output of sql server logins, inshort sql server security audit report.Finally I have developed one query which will generate a report in one table having separate details for each task.
|
(3)
Updated 10/25/2012
Released 10/25/2012
1,200
Downloads
|
|
|
This SQL script will provide you all databases Index fragmentation details. It would be helpful while scheduling or determining maintenance task of reindexing.
|
(8)
Updated 9/6/2012
Released 9/6/2012
964
Downloads
|
|
|
This SQL script will use for any database having Autogrowth is unrestricted & data & log files resides on same drive.Alert will raise when size grows beyond the threshold value.Threshold value is determined on the basis of disk drive space.
|
(1)
Updated 9/24/2012
Released 9/24/2012
188
Downloads
|
|
|
Compare the objects from a database which is present on both servers & will produce comparison result in excel sheet.
|
(0)
Updated 9/7/2012
Released 9/7/2012
303
Downloads
|
|
|
I have alerady uplodated query for daily database checklist for SQL 2005 & 2008 but when i am going to execute it then it would be a problem because it won't work for 2000, hence i have developed a new SQL server 2000 query which will provide all databases necessary information.
|
(0)
Updated 1/23/2013
Released 1/23/2013
120
Downloads
|
|
|
This script will Create an instance-level trigger to notify the Operations team whenever a new database is added.
Trigger will raise an alert when new database is created either database is created by query or using GUI. Just Replace the email id from the script with your des |
(0)
Updated 8/29/2013
Released 8/29/2013
55
Downloads
|
|
|
This SQL script will useful for to setup alert for data & log file (which has restriced size property) if it grows beyond threshold value.SQL script will apply only for those databases which has autogrowh property is restriced.
|
(1)
Updated 9/21/2012
Released 9/21/2012
145
Downloads
|
|
|
This script will work for all version of sql server & all default & named instances. It will show sql server & agent service startup id which is currently used by both database engine & agent engine services.Incase if its not show for Named instance then this key will be named as
|
(0)
Updated 6/11/2013
Released 6/11/2013
49
Downloads
|
|
|
This query will give you the total time & total backup size of databases & backup type of perticular date.You need to specify the perticular date,month & year in this script. With the help of that you can also find out that on that date any backup has been done or not. for that
|
(1)
Updated 12/10/2012
Released 12/10/2012
88
Downloads
|
|