Find the nearest store with SQL Server geography, validate coordinate order, apply a distance radius, and inspect spatial index use.
Synchronizing Data Between Two Databases
Synchronizing data between two SQL Server databases requires a latency target, change source, conflict rule, and recovery plan before tool selection.
geometry MakeValid: Repair Can Change the Geometry Type
geometry MakeValid returns a valid geometry from an invalid instance, but the result can change type. I keep the original beside the proposed repair. A validity flag alone does not describe everything that changed.
Random Tokens in SQL Server: Generation, Storage and Expiry Checks
Random tokens in SQL Server need more than a generated value. Their stored state must define expiry, revocation and whether consumption already occurred. A guarded disposable fixture makes the boundary conditions explicit.
Documenting a Server You Just Inherited
Documenting a server you just inherited starts with identity, databases, files, jobs, access, alerts, and tested recovery ownership.
GENERATE_SERIES: Make the Step Explicit
GENERATE_SERIES returns numbers within a declared range. These read-only examples specify the step, preserve input types and order every returned series deliberately.
Heap Tables: When a Table Without a Clustered Index Hurts
Find heap tables, inspect forwarded records and empty-page behavior, and choose between a clustered index and a planned rebuild.