Write data quality asserts in T-SQL to reject invalid staging rows, preserve check results, and record each load attempt.
INSERT EXEC: Capturing a Procedure’s Result Set and Its Limits
Capture rows with INSERT EXEC, match result columns, understand nested and multiple-result limits, and choose supported alternatives.
TempDB Operating System Error 3: Fix a Wrong TempDB Path
TempDB operating system error 3 means a tempdb file path cannot be found, for example after a typo in a move. This post reproduces the error safely, shows how error 3 differs from error 2 and lists the repair steps when the service will not start.
SQL SERVER – Fix Error – Cannot execute as the database principal because the principal “dbo” does not exist
One of my clients recently sent me an email with the following error. The error was visible in the error log and was about the database principal.
SQL SERVER Agent Missing from SSMS
Agent XPs can explain why SQL Server Agent is Missing from SSMS. I check edition and service state before changing configuration.
SAVE TRANSACTION: Roll Back Half a Transaction
SAVE TRANSACTION sets a marker inside an open transaction. You can roll back to it and keep the earlier work. This post tests it on SQL Server 2025. It shows why a nested BEGIN TRAN can’t do the same and what XACT_STATE() returns after an error.
Searching the Error Log by Date and Text With xp_readerrorlog
Search the SQL Server error log by date and text, select archives, capture matching rows, and cycle logs without losing context.