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,849
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
|
|
|
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 |
(4)
Updated 1/8/2013
Released 1/8/2013
1,514
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
|
|
|
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
|
|
|
Using an encryption algorithm powerful 256-bit SQL Server, AES encryption can guarantee the security of your most sensitive data. Once one of the data is encrypted, you do not have to worry about a person who reads your confidential information. See more...
|
(2)
Updated 10/16/2013
Released 10/16/2013
383
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
|
|
|
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
|
(2)
Updated 11/28/2012
Released 11/23/2012
541
Downloads
|
|
|
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
|
(1)
Updated 10/10/2013
Released 10/8/2013
247
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
|
|