SSMS showed a white icon instead of green or red for SQL Server and Agent status, and Start and Stop were disabled. It comes down to your Windows account and WMI.
SQL SERVER – SSMS Trick – Switching Columns in Grid Output
Can you reorder columns in SSMS grid output without rewriting the query? A trick from Vinod Kumar’s user group session that surprised me.
SQL SERVER – Hidden SSMS Gem: Find Dialog’s Unknown Functionality
At a Bangalore user group meet, Vinod Kumar showed a Hidden SSMS Gem: something the Find dialog can do that I never knew in years of using it.
SQL SERVER – Set AUTO_CLOSE Database Option to OFF for Better Performance
How I helped a customer get better performance by setting the AUTO_CLOSE Database Option to OFF, and why this setting hurts busy databases.
SET NOCOUNT ON in SQL Server: How to Hide Rows Affected Messages
SET NOCOUNT ON stops SQL Server from sending a rows affected message after every statement. This post tests what it changes and what it doesn’t: @@ROWCOUNT, scope inside a procedure, timing and the text that sp_updatestats prints. It also covers client programs that depend on the count.
How to Find Missing SQL Server Configuration Manager? – Interview Question of the Week #089
Question: I just installed the latest version of SQL Server and now I am not able to find SQL Server Configuration Manager. What should I do?
SQL SERVER – How to Increase the SSMS Grid Font Size?
Presenting SSMS results to a big room? Zoom does not work on the results grid, but Tools, Options, Fonts and Colors lets you raise the grid Font Size.