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.
|
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.
|
(47)
Updated 2/21/2014
Released 4/28/2011
19,663
Downloads
|
|
|
This T-SQL sample script illustrates how to check index fragmentation of a specified database in SQL Server.
|
(28)
Updated 7/29/2013
Released 4/16/2013
16,573
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.
|
(9)
Updated 7/29/2013
Released 4/26/2013
8,675
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
|
(11)
Updated 8/3/2013
Released 8/3/2013
1,884
Downloads
|
|
|
This function looks up SQL Instance information via the registry on local and remote systems. Information looked up is Version, Edition type, whether the SQL Instance is part of a cluster and the other nodes in the cluster and
the full name that can be used in another script to |
(10)
Updated 8/19/2014
Released 9/16/2013
3,653
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.
|
(23)
Updated 1/14/2013
Released 8/29/2012
5,684
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 |
(12)
Updated 1/8/2013
Released 1/8/2013
5,471
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
|
(2)
Updated 2/13/2013
Released 2/13/2013
5,321
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.
|
(13)
Updated 11/27/2011
Released 11/27/2011
7,338
Downloads
|
|
|
The xSqlPs module is a part of the Windows PowerShell Desired State Configuration (DSC) Resource Kit. This module contains the xSqlServerInsta
|
(1)
Updated 8/22/2014
Released 2/7/2014
3,137
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.
|
(18)
Updated 10/19/2011
Released 10/19/2011
6,920
Downloads
|
|
|
This T-SQL script will demo how to combine multiple rows into one row by a same column value in SQL Server.
|
(0)
Updated 4/21/2014
Released 4/21/2014
754
Downloads
|
|
|
This is a utility procedure which gives the details like parameters , Datasources , Datasets etc of the given report by querying ReportServer database tables.
|
(22)
Updated 5/31/2011
Released 5/30/2011
4,253
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
|
(3)
Updated 7/27/2013
Released 5/4/2013
1,153
Downloads
|
|
|
This deck provides a high-level description of SQL Server Master Data Services, which is the SQL Server solution for master data management. Master data management (MDM) describes the efforts made by an organization to discover and define non-transaction
|
(6)
Updated 4/11/2012
Released 4/11/2012
7,521
Downloads
|
|