SQL Scripts Manager contains 28 scripts to simplify everyday SQL Server administration
UPDATE templatesSELECT templatesINSERT templatesWhy not join the experts?
Add your own scripts to SQL Scripts Manager to share with your colleagues and the wider SQL Server community.
For scripts which run against a server or a database, without any other parameters, it's simple and straightforward to add and upload your scripts.
Simply follow the steps below:
Further tips on adding your scripts
Particularly for more complicated scripts
9 SQL Server experts have contributed the scripts in SQL Scripts Manager
Glenn Berry is a Database Architect at NewsGator Technologies in Denver, Colorado.
In addition to being a Microsoft SQL Server MVP, Glenn is an Adjunct Faculty member at University College, University of Denver, where he has been teaching since 2000.
Louis Davidson has been in the IT industry for 16 years, and has written four books on database design.
His most recent publication "Performance Tuning with SQL Server Dynamic Management Views", co-authored with Tim Ford, is available from Redgate.
He is currently the Data Architect and sometimes DBA for the Christian Broadcasting Network, and has been a Microsoft SQL Server MVP for six years.
Phil Factor (real name withheld to protect the guilty) has 25 years of experience with database-intensive applications.
Despite having once been shouted at by a furious Bill Gates at an exhibition in the early 1980s, he has remained resolutely anonymous throughout his career.
Tim Ford is the Primary DBA and Subject Matter Expert for the SQL Server platform for Spectrum Health.
A Microsoft SQL Server MVP, Timothy recently launched SQL Cruise, a training company for SQL Server.
His most recent publication "Performance Tuning with SQL Server Dynamic Management Views", co-authored with Louis Davidson, is available from Redgate.
Tim maintains his own blog at http://thesqlagentman.com
Ola Hallengren is a DBA for an investment bank in Sweden.
He has been working with SQL Server since 2001, and maintains the Ola.Hallengren.com website.
His "SQL Server Maintenance Solution" won the 2010 SQL Server Magazine Gold Community Choice Award.
Tracy Hamlin is the 2010 winner of the Exceptional DBA Awards.
She has been a Database Administrator for over 25 years, moving from working with Oracle and Sybase, to working exclusively with SQL Server.
Tracy is currently SQL Server DBA at Hymel Brossette Inc.
Rodney Landrum has been working with SQL Server technologies for longer than he can remember.
He writes regularly about many SQL Server technologies, including Integration Services, Analysis Services, and Reporting Services.
Rodney is a Microsoft SQL Server MVP.
Dan McClain is currently the senior database administrator at GatewayEDI in St. Louis.
He has over 30 years of I.T. experience – 23 of them with Fortune 500 companies; 23 years as the technical lead for the SQL Server team at Anheuser-Busch in St.Louis, where he spent his days overseeing the health and performance of more than 4,000 databases on 300+ SQL Servers.
He then had another year as technical architect at Monsanto, also in St. Louis. Dan is the 2008 winner of the Exceptional DBA Awards.
Read an interview with Dan at www.sqlservercentral.com
Gail Shaw is a database consultant from Johannesburg, South Africa, specializing in performance tuning and database optimization.
Gail was awarded MVP for SQL Server in July 2008. Gail runs the website SQL in the Wild.