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.
Automated Restore Tests: Proving Backups Work Every Week
Schedule restore tests that select current backups, move files to an isolated server, run CHECKDB, record failures, and rotate databases.
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.
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.
SQL SERVER – Find Week of the Year Using DatePart Function
The DATEPART function returns a week number according to its week definition. I choose that convention before using calendar logic.
Finding Orphaned Child Rows Before Adding a Foreign Key
Find orphaned child rows before adding a foreign key, review their business meaning, validate relationships, and confirm constraint trust.