To fix logic errors, testing and verifying your SQL script to compare the expected and actual results is necessary.

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.

I'm trying to start/stop MS SQL Service on various DB servers (locally) but we don't always know the name of the instance (Always only 1 SQL Server running on a single server).

Find out how client statistics, execution plans, and Code Analysis in SQL Server Data Tools can help improve query, stored procedure, and script performance. You can use the tools provided by SQL ...

Copy SQL scripts into that directory. Notice that they don't show up in Visual Studio unless entries are manually added to the sqlproj file or the scripts are added using the Visual Studio UI.