This comprehensive guide explore into some essential maintenance techniques and best practices to ensure your SQL Server deployment.
SQL SERVER – Fix – Error – The certificate chain was issued by an authority that is not trusted
ASP.NET Core applications can sometimes result in the error “The certificate chain was issued by an authority that is not trusted.”
Detecting Deadlocks in SQL Server Using Trace Flags 1204 and 1222
Well, let us discuss Detecting Deadlocks in SQL Server Using Trace Flags 1204 and 1222. T-SQL for enabling, disabling, and checking the status of these trace flags.
Data Quality Asserts in T-SQL: Failing a Load When Rules Break
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.
SQL SERVER – TempDB Error: CREATE FILE encountered operating system error 3
Let us fix error TempDB error: CREATE FILE encountered operating system error 3 (The system cannot find the path specified.)
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.