The scripts

SQL Scripts Manager contains 28 scripts to simplify everyday SQL Server administration

  • Back up database
  • Buffer cache hit ratio
  • Database files: size and space used
  • Export 'Procedure call' templates
  • Export UPDATE templates
  • Install Ola Hallengren's Maintenance Solution
  • Object read and write statistics
  • Ping multiple machines
  • Top resource waits
  • Backups in last 'x' days
  • CPU-intensive queries
  • Execution plan cache
  • Export SELECT templates
  • Index fragmentation
  • Integrity check
  • Partitioned table count
  • Server CPU utilization
  • User login audit
  • Who is running what?
  • Blocking transactions
  • Database file I/O waits
  • Export INSERT templates
  • Export 'Table-valued function' templates
  • Index maintenance
  • Last good backup
  • Performance counter hit ratio
  • Tables without a clustered index
  • Version and uptime for an instance

Adding and sharing scripts

Why 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:

  1. Download the relevant template XML file for either:
  2. In your favorite XML editor (for example XMLPad or Notepad++ — set the language to XML in the menu, to get the best experience with this tool), simply change the script name, description, your name, and any relevant details like homepage and twitter handle
  3. Copy / paste your script into the identified place in the script
  4. Test that the script works OK...
  5. ...and then upload it to

Further tips on adding your scripts

Particularly for more complicated scripts

Back to top

The authors

9 SQL Server experts have contributed the scripts in SQL Scripts Manager

Glenn Berry

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

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

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

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

Ola Hallengren

Ola Hallengren is a DBA for an investment bank in Sweden.

He has been working with SQL Server since 2001, and maintains the website.

His "SQL Server Maintenance Solution" won the 2010 SQL Server Magazine Gold Community Choice Award.

Tracy Hamlin

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

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

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

Gail Shaw

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.

Back to top