The restore finished with no errors, yet the app cannot connect. Here are the four settings a restore quietly changes, and how to fix them.
REGEXP_LIKE Performance: Why Pattern Filters Cannot Seek
A short pattern can run a long CPU bill. Here is why REGEXP_LIKE scans, and how a plain prefix filter gives the index something to seek.
Every Deployment Script Needs a Tested Undo Script
Write and test an undo script before deployment, preserve old module text and changed rows, and identify changes that require recovery.
First and Repeat Purchases: Tagging Customer Orders With ROW_NUMBER
Tag repeat purchases with deterministic order numbering, calculate days to the second order, and compare customer cohorts fairly.
Migrating From PostgreSQL to SQL Server: Types and Syntax Differences
Plan migrating from PostgreSQL by checking identity values, Unicode, timestamps, paging, returned rows, collations, and upsert behavior.
In-Memory OLTP in SQL Server: Memory-Optimized Tables Explained
In-Memory OLTP stores selected tables in memory and uses row versions instead of locks. This post builds a small demo database, compares a disk table with two memory-optimized tables, and tests a natively compiled procedure. It also covers durability, bucket counts and memory use.
SQL SERVER – SSIS Parameters in Parent-Child ETL Architectures – Notes from the Field #040
Tim Mitchell reviews how to use SSIS parameters in Parent-Child ETL architectures, a very common design pattern in SQL Server ETL work.