How to Delete a SQL Server Database Safely
A SQL Server database may be deleted when it’s no longer needed, such as after migration, project completion, or in…
Category: Database
Fixing SQL Server SSL Error: The Certificate Chain Was Issued by an Untrusted Authority
When connecting to SQL Server, you might encounter this login error: “A connection was successfully established with the server, but…
SQL Server Issue – SQL Server Database struck in Recovery Mode
Scenario: We can not restore the same with latest backup because the DB is critical and there is no latest…
SQL Server – How to run a query for all the database(s) in SQL Server Instance
We will use sp_MSforeachdb procedure which is an undocumented procedure that allows you to run the same command against all…