>
Repository

Script resources for IT professionals

Download resources and applications for Windows 10, 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
790 SQL Server results [Clear]
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
(9)
Updated 9/7/2013
Released 9/7/2013
2,781 Downloads
SQL
Chrissy LeMaire
Import-CsvToSql takes advantage of .NET's super fast SqlBulkCopy class to import CSV files into SQL Server at up to 90,000 rows a second.
(1)
Updated 9/7/2015
Released 9/4/2015
745 Downloads
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
(12)
Updated 4/29/2013
Released 4/29/2013
5,045 Downloads
SQL
Chrissy LeMaire
Uses PowerShell and SMO to migrate SQL logins. Logins are completely migrated and maintain their: SIDs, passwords, server/database roles, server/database permission sets & securables, default database and login attributes. Works on SQL Server 2000 and above.
(7)
Updated 4/18/2016
Released 9/7/2014
1,833 Downloads
Satheesh Variath
This SQL script will compare table columns, Index and foreign keys in two databases. This will show a result with missing objects and the objects with definition mismatch
(7)
Updated 9/30/2013
Released 6/14/2012
6,275 Downloads
SQL
Olaf Helper
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.
(20)
Updated 10/19/2011
Released 10/19/2011
9,705 Downloads
PowerShell Team - Microsoft
The xSqlPs module is a part of the Windows PowerShell Desired State Configuration (DSC) Resource Kit. This module contains the xSqlServerInstall, xSqlHAService, xSqlHAEndpoint, xSqlHAGroup, and xWaitForSqlHAGroup resources.
(2)
Updated 8/7/2015
Released 2/7/2014
6,882 Downloads
Chrissy LeMaire
This function allows administrators to regain access to local or remote SQL Servers by either resetting the sa password, adding sysadmin role to existing login, or adding a new login (SQL or Windows) and granting the login sysadmin privileges. Windows admin access required.
(4)
Updated 4/7/2016
Released 6/7/2015
1,030 Downloads
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.
(6)
Updated 10/25/2012
Released 10/25/2012
3,982 Downloads
SQL
Sorna Kumar Muthuraj
Audit is always a kind of standard requirement in all the trasactional system. For auditing a particular table ,we need to create a similar structure audit table and create Insert , Update and Delete triggers to keep track of the changes in the table. This is utility procedure w
(15)
Updated 3/26/2016
Released 3/16/2012
3,958 Downloads
SQL
Olaf Helper
Transact-SQL script to analyse the database size growth using backup history.
(7)
Updated 8/18/2011
Released 8/3/2011
4,248 Downloads
SQL
Chrissy LeMaire
Gets, Sets and Recommends SQL Max Memory.
(5)
Updated 5/22/2015
Released 5/22/2015
788 Downloads
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
2,363 Downloads
SQL
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
4,453 Downloads
DennisCruise

 This is a simple Powershell script to allow for running an SSIS package from Powershell.This allows either a FileName\Path or can call the execute of the SSIS Package from a SQL Server Store.The requirements vary based upon the type of execution needed.Did not see this type of
(1)
Updated 2/23/2015
Released 2/23/2015
494 Downloads

Couldn't find the script you were looking for?

16 - 30 of 790 Items