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.
|
This T-SQL sample script illustrates how to check index fragmentation of a specified database in SQL Server.
|
(14)
Updated 7/29/2013
Released 4/16/2013
5,848
Downloads
|
|
|
To search the whole database for a string in the tables. This stored procedure will return the tables and result set with the matching search string.
|
(33)
Updated 10/29/2013
Released 4/28/2011
8,511
Downloads
|
|
|
This script contains three code parts, one to get the result of server level logins and related roles, one to get the result of user databases’ users and related roles, one to get the result of object level permission of specific database.
|
(2)
Updated 7/29/2013
Released 4/26/2013
2,108
Downloads
|
|
|
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,173
Downloads
|
|
|
This article is about multiple ways of splitting a column with delimited string into multiple columns .If the number of delimiters are 3 or less than that then PARSENAME function can be used to Split a column with delimited string into multiple columns like shown below : To make
|
(4)
Updated 8/3/2013
Released 8/3/2013
307
Downloads
|
|
|
If you already have data in excel sheet, the data is structured in tabular format in the excel, and you want to upload all this data in SQL Server, the attached guide shows the steps to upload the entire data from the excel to SQL Server table using C#.Net
|
(1)
Updated 2/13/2013
Released 2/13/2013
1,608
Downloads
|
|
|
This is a utility procedure which gives the details like parameters , Datasources , Datasets etc of the given report by querying ReportServer database tables.
|
(18)
Updated 5/31/2011
Released 5/30/2011
2,415
Downloads
|
|
|
This T-SQL sample script illustrates how to check tempdb configuration per best practices. Tempdb is a system database is highly used by Sql Server and an optimal tempdb configuration is generally important for smooth running of the Sql instance.
|
(4)
Updated 7/29/2013
Released 11/14/2012
974
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
748
Downloads
|
|
|
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 |
(5)
Updated 12/24/2012
Released 3/16/2012
987
Downloads
|
|
|
This PowerShell script will check the state of all instances in a SQL Server. It will list the name, start mode, state and status of all the instances in a local machine. If there is no instance installed, it will remind you that there is no instance.
|
(0)
Updated 11/6/2013
Released 11/6/2013
119
Downloads
|
|
|
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.
|
(16)
Updated 10/19/2011
Released 10/19/2011
3,710
Downloads
|
|
|
This is a frequent troubleshooting requirement for individual sp_configure values during most SQL performance troubleshooting
|
(8)
Updated 7/29/2013
Released 11/14/2012
570
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)
Updated 11/27/2011
Released 11/27/2011
3,939
Downloads
|
|
|
This code will work from SQL Server 2005 and above version . PARSENAME function is the key behind this code.I have developed this code to answer the MSDN forumn thread - http://social.m
|
(2)
Updated 7/27/2013
Released 5/4/2013
297
Downloads
|
|