Download Windows Server 2012Script 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:
|
After a timespan of idle SSRS falls asleep;the first request will be extremly slow,up to several minutes.This PowerShell script performs a simple HTTP request to the SSRS-RM url,to simulate a normal activity.If you run it frequently you avoid the SSRS worker shutdown.
|
(15)
10/19/2011
3,125
Downloads
|
|
|
For DBAs to maintain multiple database and monitoring the disk fragmentation and rebuilding the indexes for individual database is quite time consuming task. Rebuilding an index drops and re-creates the index. This removes fragmentation, reclaims disk
space by compacting the pa |
(1)
1/8/2013
291
Downloads
|
|
|
SQL Server 2012 provides a host of diagnostics in the form of the System Health extended events session which includes sp_server_Diagn
|
(0)
4/29/2013
205
Downloads
|
|
|
This SQL script will provide you all databases Index fragmentation details. It would be helpful while scheduling or determining maintenance task of reindexing.
|
(7)
9/6/2012
640
Downloads
|
|
|
This PoSh script tries to enumerate SQL Server instances in your network using SMO and creates an inventory as a Html document.It's similar to MS MAP,but only as a simple plain script and dedicated for SQL Server instances.With this info you could plan a SQL Server consolidation.
|
(11)
11/27/2011
3,410
Downloads
|
|
|
PowerShell script using SMO to script out all tables and optional all related objects like indexes etc.
|
(17)
8/4/2011
2,209
Downloads
|
|
|
Whenever I need to get the IP address of SQL server then I need to execute some script of XP_cmdshell but in some environment I don't have this feature enabled or I need to execute the IPconfig of machine name in commend prompt to find the IP address .Use the attached script to g
|
(1)
11/23/2012
237
Downloads
|
|
|
Transact-SQL script to analyse the database size growth using backup history.
|
(16)
8/3/2011
2,122
Downloads
|
|
|
This Transact-SQL statements filters the cached query plans for existing table scan operators and returns the statement and query statistics.
An additional filter is set on the attribute "EstimateRows * @AvgRowSize" = "Estimate size" to filter out scans on small tables. |
(8)
8/23/2011
1,674
Downloads
|
|
|
This Transact-SQL statements lists all SSIS packages stored in the msdb system database with detailed information.It gives a brief overview which packages exists, who created them and which is the actual version of it.Works with SQL Server 2005 and higher versions in all editions
|
(7)
8/26/2011
1,435
Downloads
|
|
|
Modeled after SQL Server 2008 Invoke-Sqlcmd, but fixes bug in QueryTimeout.
|
(8)
10/5/2010
|
|
|
Transact-SQL to query when will a SQL login password expire and some more information.
|
(5)
8/12/2011
1,148
Downloads
|
|
|
Transact-SQL Statement to list all objects and their dependencies (SQL Server 2008).
|
(3)
8/9/2011
1,210
Downloads
|
|
|
This stored procedure generates the foreign key relationship to "n" level in tree structure. Also it generates delete / select scripts for all the dependent tables.
|
(4)
5/10/2011
761
Downloads
|
|
|
This Transact-SQL statement links orphaned user like "sys.sp_change_
|
(3)
9/8/2011
1,282
Downloads
|
|
.png)