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.
Sort by:
|
List for several machines all drives with size, free size and the percentage of free space. Optional you can send the result as html or plain text report by smtp e-mail.
|
Featured
|
|
|
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,610
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,439
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,139
Downloads
|
|
|
Many companies manage their updates through WSUS, but sometimes WSUS updates aren't pushed out properly; there for you need to obtain the Windows Updates directly from Microsoft. Comments and enhancements are welcome!
|
(4)
Updated 7/19/2012
Released 7/19/2012
2,479
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,563
Downloads
|
|
|
List for several machines all drives with size, free size and the percentage of free space. Optional you can send the result as html or plain text report by smtp e-mail.
|
(51)
Updated 12/27/2011
Released 8/16/2011
10,434
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,396
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
565
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
973
Downloads
|
|
|
This Windows PowerShell sample script helps you to get the properties of the objects in multiple SQL Server instances or SQL Server groups. It applies to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012.
|
(3)
Updated 7/29/2013
Released 10/15/2012
303
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
295
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
730
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,919
Downloads
|
|
|
This script will demo how to check SQL Server missing update KB2277078 to prevent leak of security audit entries in TokenAndPermUse
|
(2)
Updated 7/29/2013
Released 10/15/2012
165
Downloads
|
|
|
This PowerShell script exports all (or filtered) reports, data sources and images directly from the ReportServerdat
|
(4)
Updated 9/7/2011
Released 9/6/2011
1,651
Downloads
|
|