Prepare for a SQL Server upgrade by checking deprecated features, compatibility, collation, plans, and application behavior before moving.
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.
Designing a Database for Multiple Customers
A database for multiple customers can share tables, split schemas, or split databases; the choice balances isolation and operating cost.
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.
The Blocked Process Report
The blocked process report shows the waiting session and blocker after a configured threshold, with Extended Events capturing the XML for review.
SQL SERVER – Interview Questions – Difficult SQL Puzzle
Today at my organization, we had nearly 30 interviews scheduled of DBA and .NET developers. Let us see a difficult SQL puzzle.
TIMEFROMPARTS: Fraction Values Follow the Precision
TIMEFROMPARTS builds a time from separate components. The same fractions argument means milliseconds at precision three and much smaller units at precision seven.