Validate payloads with JSON_PATH_EXISTS and typed ISJSON in SQL Server 2022, distinguish null from missing, and enforce a clear contract.
Naming Conventions for Tables, Columns and Constraints
Use naming conventions for readable SQL Server tables, columns, keys and indexes, then find exceptions and plan safe renames with sp_rename.
Data Quality Rules in T-SQL
Data quality rules in T-SQL turn nulls, duplicates, invalid dates, and broken references into visible failures before rows reach reports.
Surrogate Keys and Natural Keys
Surrogate keys keep warehouse history stable while natural keys preserve source identity; learn lookup, uniqueness, and change handling.
Interview Questions and Answers – Frequently Asked Questions Day 6 of 31
Frequently Asked Questions Day 6: which TCP/IP port SQL Server runs on and how to change it, and the difference between a clustered and a non-clustered index.
SEQUENCE Cache Size, Gaps and Insert Throughput
Compare SEQUENCE cache size, restart gaps, rollback gaps, and insert throughput with CACHE 50, CACHE 1000, and NO CACHE.
SQL SERVER – How to ALTER CONSTRAINT
Can you ALTER CONSTRAINT in SQL Server? No. The only way to change a constraint is to drop it and create it again, and here is the script for that.