• Adam Thurgar

DBA Toolkit


Every DBA should have a toolkit. A set of scripts that you are comfortable with and can reuse over and over again.

If you don't, then where do you start in building this toolkit.

Now there are a lot of scripts available for download, but you want to be sure that any scripts come from a reliable and reputable source.

I would recommend the following as starting point.

1. Ola Hallengren's SQL Server Maintenance Solution

The industry de-facto standard for backups and maintenance. It is by far the most complete and thorough set of scripts for ensuring that your databases are backed up, error free and optimised.

You can download the free solution from his web site. https://ola.hallengren.com/

2. Brent Ozar's First Responder Kit.

A suit of scripts for getting a handle on your SQL Server environment and then finding configuration issues and using all this for performance tuning.

https://www.brentozar.com/first-aid/

3. SQL Down Under

Tools for comparing databases, tables, finding unused indexes, manipulating strings, performance tuning and converting data.

https://sqldownunder.com/sdu-tools/

4. SQL Skills

Anything from SQL Skills is gold.

https://www.sqlskills.com/sql-server-resources/

Get familiar with these scripts and you will have the start of a good toolkit.

You can supplement this with anything from Adam Machanic, Glen Berry and Kalen Delaney just to name a few.

You can then add your own scripts over time.


2 views

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t