SSMS Silent Install
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.
SSMS Maximum Characters Displayed
By default, the max number of characters displayed in a single column of a query in SSMS when outputting as text is 256 characters.
SSMS Show Line Numbers
This post contains a guide on how to show line numbers in the SSMS query window. Useful if you want to see line numbers while you code.
How to Connect to SQL Server with a Different Domain User Account
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.
USE Command in SQL Server
USE [database] in SQL Server is a way to change the context to a specific database when you are running a query in Microsoft SQL Server.
Change Default Database in SQL Server
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.
Disk Usage by Top Tables Report in SQL Server
The Disk Usage by Top Tables Report in SQL Server is a quick way to get the sizes of all tables within a database.
Include Execution Trace Messages in SQL Server Error Logs
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.
“Index was out of range” SQL Server Management Studio
If you try to change the order of steps in an Agent Job within SQL Server Management Studio (SSMS), you may encounter the error “Index was out of range.
