Working with SQL for many years there have been a few useful tools to assist with coding. Some of them are free and others require licences, however if you just want to test them out, you can usually get a 14 day free-trial.

This is quite convenient for when I start at new clients and can show them how these tools can help them to work more efficiently.

Free Tools:

  • SQL Search is my absolute favourite! Definitely useful when you have many DB’s and you need to find something.

Licence Required Tools:

  • SQL Prompt allows you to format code, definitely useful when you have taken over someone else’s code.
  • SQL Assistant has a more advanced intellisense and allows you to format code amongst other things.