Match word patterns with LIKE and SUBSTRING, build sorted-letter anagram signatures, and use a leading-letter index for crossword searches.
Adding System Versioning to a Table That Already Has Rows
Turning on temporal history for a table that already has data does not rebuild the past. Here is the clean way to do it, and the traps to avoid.
Rewriting OR Conditions So the Index Gets Used
Rewrite OR conditions with separate seeks, preserve duplicate and NULL behavior, and compare plans before choosing UNION or recompilation.
SSRS Parameters That Do Not Slow Reports
SSRS parameters work best with selective defaults, compact value lists, and SQL queries that preserve useful indexes under real filters.
Why DBCC SHRINKFILE Crawls and How to Watch Its Progress
Explain why DBCC SHRINKFILE can take hours, monitor percent_complete and waits, and use TRUNCATEONLY before small steps.
SQL SERVER – Data Sources and Data Sets in Reporting Services SSRS
Before a report can show anything, it has to reach the data. Kathi Kellenberger explains data sources and data sets in SSRS in simple words.
Compatibility Level 170: What SQL Server 2025 Turns On
Move to compatibility level 170 on SQL Server 2025 with feature checks, Query Store baselines, plan comparisons, and a rollback plan.