Author: Peter Whyte
-
The Evolution of SQL Server: Every Version from 1989 to 2025
🕐 Version history, with the support dates that actually matter Every release from the 1989 OS/2 original to SQL Server 2025, what each one changed for the people running it, and which ones are still receiving security updates today. Lifecycle dates checked against the builds and lifecycle reference, which is regenerated after each patch release.…
Written by
-
Cannot Execute As the Database Principal (Error 15517)
SQL Server error 15517, cannot execute as the database principal. Why dbo maps to an orphaned owner after a restore and the one-line fix.
Written by
-
Silent Failures: The SQL Server Problems That Never Raise an Error
Twelve SQL Server failures that produce no error, no failed job and no alert, why each stays silent, and one script that finds them all.
Written by
-
SQL Server Login Migration: What Gets Silently Left Behind
sp_help_revlogin carries more than you think, including disabled state. What nothing carries, and why the script you actually ran matters more.
Written by
-
CREATE USER WITHOUT LOGIN vs Contained Database Users
Both look like a user with no login and they are opposites. How to tell them apart, what each is for, and the migration break that fails silently.
Written by
-
The sqldba MCP Server: Give Your AI Assistant a Verified SQL Server Reference
The reference behind this site, as six tools an AI assistant can call: error numbers, wait types, patch levels and scripts, hand-verified rather than scraped. It never connects to your SQL Server, and it refuses rather than guessing.
Written by
-
Cannot Resolve the Collation Conflict (Error 468)
Nothing is broken when you see 468. Two sides of a comparison store text under different rules, and SQL Server will not guess which should win. The fix is one line, and it does not belong on the column.
Written by
-
Logical Consistency-Based I/O Error in SQL Server (Errors 823 and 824)
823 means the storage failed the read and said so. 824 means it succeeded and the data was wrong. Which one you have changes who you escalate to, and what you protect first.
Written by
-
Cannot Recover the Master Database (Error 3417) and What the Log Actually Says
3417 is the summary, not the diagnosis. Four kinds of master damage reproduced in a throwaway container, and 3417 appeared in none of them. Here is what each one actually logs.
Written by
-
The Database Principal Owns a Schema in the Database and Cannot Be Dropped (Error 15138)
🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. Msg 15138 · Level 16 · State 1 The database principal owns a schema in the database, and cannot be dropped. ⚡Reassign, then drop. ALTER AUTHORIZATION ON SCHEMA::[name] TO [dbo] clears it, but check for owned roles and objects too…
Written by
- DBA Scripts: Get Log Shipping Status
- SQL Server Row-Level Security: The Filter Does Not Stop Cross-Tenant Writes
- View the Definition of a Stored Procedure in SQL Server
- TempDB Is Full or Still Growing: Find What Is Using It, Right Now
- SQL Server Service Will Not Start: Error 17113, 17058, 1067 and Where the Real Reason Is
- How to Move TempDB Files in SQL Server
- Backups & Recovery (17)
- DBA Scripts (152)
- High Availability (HA) (13)
- Installation & Configuration (49)
- Maintenance (25)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (20)
- Storage & Capacity (16)
- T-SQL Fundamentals (15)
- Troubleshooting (94)
- Wait Types (235)