The six properties of relational tables explained: atomic values, values of the same kind, unique rows and more, with the benefit of each one.
SQL SERVER – 2005 Collation Explanation and Translation
How to read a SQL Server 2005 Collation name like Latin1_General_CI_AS, check which collation you have, and avoid collation conflict errors.
IIF and CASE: Control Return Types and Use Typed NULL Values
IIF and CASE choose result values, but their branches also define a shared return type. I make that type explicit when mixed inputs could surprise the reader. Typed NULL values help describe the same output contract.
SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column value of the table
A query to list every identity column with its seed, increment and current value, plus what those numbers mean and how to reseed a table safely.
SQL SERVER – @@DATEFIRST and SET DATEFIRST Relations and Usage
How SET DATEFIRST changes the first day of the week, and how @@DATEFIRST returns the current value, which also changes with SET LANGUAGE. Simple examples.
SQL SERVER – Fix : Error 1418 – Microsoft SQL Server – The server network address can not be reached
Error 1418 says the server network address cannot be reached or does not exist. Check the firewall, then enable TCP/IP for the server and client on port 1433.
geometry STContains: Check Boundary Membership
geometry STContains differs from STIntersects at a polygon boundary. Four literal points expose the intended inclusion rule without treating ordinary language as a spatial predicate.