Database Tools

Here are some tools and utilities I've found useful writing SQL.

Azure Data Studio

Azure Data Studio is becoming my favorite tool to write and view SQL queries and their results.  I use it to connect to Azure Synapse (SQL Data Warehouse), SQL Server (On Premise), and SQL Server (AWS Cloud).

You can run it on both Mac and Windows.

Quest Online Code Formatter

Quest's Online Code Formatter is an easy to use online tool you can use to format your SQL to make it easier to read and maintain.

NotePad ++

NotePad++ is a very handy text editor.  I use it to write SQL and view various data files in CSV, JSON, or XML formats.

Close

50% Complete

Two Step

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.