Learn some best practices for writing and testing SQL scripts that can automate your database tasks effectively and efficiently.

Learn how to handle errors and exceptions in SQL scripts for database automation using best practices and techniques such as TRY-CATCH, RAISERROR, transactions, logging, testing, and coding.

The following table includes links to Azure CLI script examples to manage single and pooled databases in Azure SQL Database.

When creating automation scripts to discover, add, update or remove records from a remote SQL database, you need to make sure your script can successfully connect to the database.