Reproduce stale views after SELECT star and ALTER TABLE, find candidate definitions, refresh with sp_refreshview, and prevent the pattern.
CE Feedback for Expressions in SQL Server 2025
Inspect CE feedback for expressions in SQL Server 2025, check compatibility and Query Store, and observe repeated execution evidence.
Making Online Learning Stick
Making online learning stick takes practice beside each video, short notes, spaced review, and one finished project that uses the skill.
Finding Databases Owned by Personal Logins and Fixing Them
Find databases owned by personal logins, review an approved replacement owner, and test dbo mapping and execution-context effects.
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.