Practical articles about ClickHouse, SQL Server, analytics architecture, performance, migration, and database operations.
Storage, memory, firmware, and software failures can damage pages without immediately stopping the application. Backups can preserve corruption that was never detected.
Read articleExtract a searchable JSON property into a typed computed column, enforce its meaning, and understand the read and write costs of indexing document data.
Read articleDistinguish allocated size, internal free space, and volume capacity, then choose predictable growth increments and actionable alerts.
Read articleGrant narrow procedure permissions through roles, understand ownership chaining and dynamic SQL, and test effective access using an unprivileged identity.
Read articleDesign bounded result consumption, diagnose ASYNC_NETWORK_IO, and separate database extraction from slow downloads without losing completeness.
Read articleReaders and writers can block each other under lock-based read committed isolation. RCSI uses row versions to reduce that blocking, but changes resource use and concurrency behavior.
Read articleUse an expand-and-contract deployment to coordinate schema, backfills, mixed application versions, validation, and rollback boundaries.
Read articleUse filtered indexes to keep active SQL Server workloads small, while handling parameterization, state transitions, statistics, and queue correctness.
Read articleUse row counts, reads, predicates, and runtime evidence to understand an execution plan before choosing an index or rewriting a SQL Server query.
Read articleAn index cannot help when a predicate hides its column inside a function or calculation. SQL Server may scan every candidate row instead of navigating to a range.
Read articleEvaluate GUID width, random inserts, and sequential-key contention, and compare a public GUID with a narrow internal clustered key.
Read articleCombine TRY CATCH, XACT_ABORT, and XACT_STATE with clear transaction ownership to prevent partial writes and misleading success responses.
Read article