Prepare for a SQL Server upgrade by checking deprecated features, compatibility, collation, plans, and application behavior before moving.
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.
Percent Change Between Rows: Handling Zero and NULL Safely
One zero month can kill a revenue report. Here is how to get percent change without errors or lies.
Breaking Ties Deterministically: Why ORDER BY Needs a Tie-Breaker
Tied scores can come back in any order, which breaks paging. Here is the one column that fixes it.
An Upgrade Checklist That Fits on One Page
An upgrade checklist that fits on one page keeps before, during, and after checks visible, including backups, logins, jobs, clients, and rollback.
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.