Keeping SSMS up to date means reading release notes, choosing a supported channel, planning side by side installs, and checking settings.
SQL SERVER – Find Collation of Database and Table Column Using T-SQL
A quick tip to find the collation of database and table column in SQL Server with DATABASEPROPERTYEX and sys.columns, using AdventureWorks.
Which SSMS Version Can Connect to Which SQL Server Version
Choose an SSMS version for your SQL Server targets, check client and engine builds, and handle newer encryption defaults.
SQL SERVER – Find Table Row Count Without Using T-SQL and Without Opening Table
An interview question: how do you find a table row count without using T-SQL or opening the table? SSMS table properties show it on the Storage page.
SQL SERVER – Default Collation of SQL Server 2008
How to check or change the default collation while installing SQL Server 2008. The setup default for server installs is SQL_Latin1_General_CP1_CI_AS.
SQL Server – Switch Between Result Pan and Query Pan – SQL Shortcut
The F6 Shortcut moves focus between SSMS panes. I use it when switching between the query editor and results.
SSMS or VS Code for SQL Server Work
Choose SSMS or VS Code for SQL Server work by task: administration, plans, scripts, MSSQL extension features, and team workflow.