This is a note on how to silently install SQL Server Management Studio (SSMS) via command (PowerShell).SSMS is a tool most people use to administer SQL Server and to run SQL queries.
This post is a guide on how to connect to SQL Server with Windows Authentication, but using a different Domain User rather than your own.
When you log into SQL Server using SQL Server Management Studio (SSMS), opening a new query window will automatically scope you within the default database set when your user was created.
Logs are always important if you’re supporting systems. The SQL Server Agent has always been a heavily used tool in my experience, so writing execution trace messages to the logs might help investigate an issue one day.