Author: Peter Whyte
-
SQL Server Row-Level Security: The Filter Does Not Stop Cross-Tenant Writes
A Row-Level Security filter can hide another tenant’s rows while still allowing a cross-tenant insert. See the HPAI01 reproduction, add block predicates, and treat session context as a trust boundary.
Written by
-
View the Definition of a Stored Procedure in SQL Server
Three ways to read the source of a stored procedure, and the trap in all of them: without VIEW DEFINITION, OBJECT_DEFINITION returns NULL rather than an error, which looks exactly like the procedure does not exist.
Written by
-
TempDB Is Full or Still Growing: Find What Is Using It, Right Now
TempDB belongs to the whole instance, so the question is never whether it is full, it is which session filled it. One query names the session, and user objects, internal objects and the version store each end a different way.
Written by
-
SQL Server Service Will Not Start: Error 17113, 17058, 1067 and Where the Real Reason Is
The service will not come up and Windows only says 1067. Where the real reason lives, what errors 17113 and 17058 are actually telling you, and what to do when the log says nothing at all.
Written by
-
How to Move TempDB Files in SQL Server
TempDB on the C: drive is a problem waiting for a busy day. It can grow very large, very quickly, sometimes within minutes under the right workload, and when it fills the OS drive it takes the whole server down with it. Moving the tempdb files to their own drive is a standard best practice,…
Written by
-
RAND() vs NEWID() in SQL Server
Most people searching for “random numbers in SQL Server” want one of two things: SQL Server gives you two common tools for this: RAND() and NEWID(). They solve different problems, and confusion usually starts when they are treated as interchangeable. This post shows how to use both, starting with simple examples, and explains why they…
Written by
-
SQL Server Error 3906: Writes Fail Because the Database Is Read-Only
Msg 3906 means SQL Server considers the target database read-only. Check its state and recovery role before changing it. A log-shipping secondary may be read-only by design.
Written by
-
RESTORE VERIFYONLY Fails: Reached the End of the File (Error 3203)
RESTORE VERIFYONLY returned Msg 3203 on a truncated backup in this HPAI01 test. The header was readable, but the file was incomplete. Direct RESTORE returned Msg 3287 instead.
Written by
-
SQL Server Is Slow: What to Check First, in Order
A symptom router for the slow SQL Server call. One check per step, in the order that finds the fault fastest, each handing off to the post that owns it.
Written by
-
SQL Server Backup Failed or the Restore Is Stuck
Three incidents that look alike and share nothing: a BACKUP that failed, a RESTORE that failed, and a restore that is still running. This page routes each one to the post that owns it.
Written by
- 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
- RAND() vs NEWID() in SQL Server
- Backups & Recovery (17)
- DBA Scripts (151)
- High Availability (HA) (12)
- 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)