Find databases owned by personal logins, review an approved replacement owner, and test dbo mapping and execution-context effects.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Post-Restore Checklist: Owner, Trustworthy, Broker and Users
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 slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.