SSMS is pretty great, especially for digging into query plans and deadlock graphs. Same for SQL Server Profiler.

We use Database projects in Visual Studio, so all our schema, stored procedures, and other scripts are in version control. We can compile them (additional validation) into dacpac packages, and script updates and deployment to local instances and Azure with sqlpackage and sqlcmd.