Red Gate logo

The scripts

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

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

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.

http://sqlserverperformance.
wordpress.com

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 Red Gate.

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.

http://sqlblog.com/blogs/louis_davidson/

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.

http://www.simple-talk.com/author/phil-factor

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 Red Gate.

Tim maintains his own blog at http://thesqlagentman.com

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 Ola.Hallengren.com website.

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

http://ola.hallengren.com/

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.

http://www.simple-talk.com/author/rodney-landrum/

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 www.sqlservercentral.com

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.

http://sqlinthewild.co.za/

Back to top

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 www.sqlservercentral.com

Further tips on adding your scripts

Particularly for more complicated scripts

Back to top