>
Repository

Script resources for IT professionals

Download resources and applications for Windows 8, Windows 7, Windows Server 2012, 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: rss
723 SQL Server results [Clear]
Denzil Ribeiro
  SQL Server 2012 provides a host of diagnostics  in the form of the System Health extended events session which includes sp_server_Diagnostics collection Here  are a set of Sample reports provide a ‘dashboard’ over the events collected in this session. Key data points covered in
(11)
Updated 4/29/2013
Released 4/29/2013
3,878 Downloads
SQL
SathyanarrayananS
In SQL Server , we can generate Index script in the following ways :1.) Under Object Explorer -> Databases -> Database -> Tables - > Indexes -> right-click on index - > Create Script as ..2.) Using Generate SQL Server Scripts Wizard - > setting Script Indexes to True 3.) Using In
(7)
Updated 9/7/2013
Released 9/7/2013
2,104 Downloads
SQL
Prashanth Jayaram
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage.Download the file and save as SQLInventoryExcel.PS1.
It has five mandatory parameters 

InputFileName - Text File contains a list of
(4)
Updated 2/17/2014
Released 2/4/2014
2,098 Downloads
Olaf Helper
This Transact-SQL script list all existing subscriptions with the schedule data.
(12)
Updated 9/6/2011
Released 9/6/2011
2,739 Downloads
SQL
Mayur-DEW
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.
(5)
Updated 10/25/2012
Released 10/25/2012
3,314 Downloads
SQL
PowerShell Team - Microsoft
The xDatabase module is a part of the Windows PowerShell Desired State Configuration (DSC) Resource Kit. This module contains the xDatabase and xDBPackage resources.
(0)
Updated 8/7/2015
Released 3/28/2014
1,583 Downloads
Olaf Helper
This PowerShell script exports all (or filtered) reports, data sources and images directly from the ReportServerdatabase to a specified folder. For the file name the complete report path is used; for file name invalid characters arereplaced with a -.
(6)
Updated 9/7/2011
Released 9/6/2011
3,705 Downloads
Chrissy LeMaire
Migrates databases with simple or complex file structures via backup & restore or detach & attach. Also migrates users with passwords, SIDs, server & db permission sets, server & db roles, server configuration settings, SQL Agent objects, user objects in systems databases.
(15)
Updated 8/5/2015
Released 8/21/2014
2,212 Downloads
ganeshkuppuswamy
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
(3)
Updated 11/28/2012
Released 11/23/2012
1,868 Downloads
SQL
Manjunath C Bhat
Couple of day back i was working on something very important which will run

some stored procedures to accomplish the task. Now there can be many

transactions or different piece of codes in a Stored Procedure. Now just think

that you come across a weird situation where yo
(1)
Updated 6/27/2013
Released 6/27/2013
1,394 Downloads
SQL
Ch. Rajen Singh
Below example demonstrate how we can access file properties using TSQL. The stored procedure retrives all the files properties (i.e file name, size in KB and last modified date) within a specific folder.This can be achieved using T-SQL & OLE automation object i.e Shell Applicatio
(0)
Updated 4/4/2014
Released 8/7/2013
1,691 Downloads
SQL
Mohammad Abdul Majeed
We had requirement to capture all the details from SQL server, I am attaching the script which will give you almost all the information from the SQL server. This script will give you the below information from SQL server and databases. 1. Windows Server version and Service
(8)
Updated 10/10/2013
Released 10/8/2013
2,547 Downloads
SQL
Kev Riley
SQL script that iterates over all online databases for an instance and produces a list of databases and the count of Virtual Log Files (VLFs). The SQL Server Database Engine divides each physical log file internally into a number of virtual log files.
 having too many or too fe
(8)
Updated 1/24/2014
Released 3/15/2012
1,732 Downloads
SQL
Olaf Helper
This Transact-SQL script returns the values from DMV sys.dm_exec_query_stats to rate SQL statements by their costs.
These "costs" can be "Average CPU execution time "Average logical operations" or the total values of these measures.
(14)
Updated 7/15/2012
Released 9/1/2011
3,763 Downloads
SQL
Olaf Helper
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.
(11)
Updated 8/23/2011
Released 8/23/2011
3,625 Downloads
SQL

Couldn't find the script you were looking for?

16 - 30 of 723 Items