Find the nearest store with SQL Server geography, validate coordinate order, apply a distance radius, and inspect spatial index use.
SQL SERVER – Finding the Occurrence of Character in String
A quick T-SQL method using LEN and REPLACE to count the occurrence of character or word in a string, written as a hint for TSQL Beginners Challenge 14.
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.
Monitoring Availability Group Health
Monitor availability group health through replica connection state, database synchronization, send and redo queues, and failover readiness checks.