Double clicking a SQL Server patch just flashed a window and vanished. SqlSetup.log in the %temp% folder showed why the Setup Screen was not launching.
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.
SQL SERVER – FIX Error 18456, Severity: 14, State: 5. Login failed for user
A customer moving from Oracle kept getting Error 18456, Severity: 14, State: 5 from Java and from SSMS. Here is how we found the real cause.
Consultant’s Life – 30 Minutes Pre Call With Customer for SQL Server Performance Tuning
A Pre Call gives a performance-tuning engagement a clear starting point. I want to understand the symptom and what the customer needs.
SQL SERVER – Understanding How to Play With Row Constructor
A code review surprised me with an unusual use of the Row Constructor. Here is what the code did and how you can play with row constructors yourself.
How to Find Recent Executed Queries in SQL Server? – Interview Question of the Week #087
An interview question that stumped candidates: how do you find recent executed queries in SQL Server? A DMV script using sys.dm_exec_query_stats answers it.
SQL SERVER – SSMS Enhancement – Databases Node Filter Capability
A client with 86 databases struggled to find one in Object Explorer. A newer SSMS Enhancement lets you filter the Databases node. Here is how it works.