SSMS Maximum Characters Displayed
By default, the SQL Server Management Studio (SSMS) maximum number of characters displayed in a single column of a query, when outputting as text is 256 characters.
SSMS Show Line Numbers
This is a tip on how to show line numbers in the SQL Server Management Studio (SSMS) query window. Showing line numbers in SSMS is something that you may prefer to have enabled as default.
How to Connect to SQL Server with Windows Authentication using a Different Domain
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
The Use command in SQL Server is a way to change context to a specified database, which I often refer to this as scoping to a database for a query.
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 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
I’ve seen this Index was out of range error within SQL Server Management Studio (SSMS) when trying to change the order of Agent Jobs.
The (SSMS) Import Flat File Feature
The Import Flat File wizard within SSMS was introduced in December 2017 (14.0.17213.0). This is a streamlined version of the Import Data feature and it minimises the user intervention during a file import.
Using Custom Connection Colours in SSMS
SQL Server Management Studio (SSMS) is the tool that most SQL Server user queries are run from. It has an option that allows you to change the colour of your query banner, which is useful if you want visually mark a server that you work with every day.
