The SQL Server transaction log works like a string of log records, each with an LSN. My simple notes on the basic architecture of transaction logs.
SQL SERVER – How to Restore Corrupted Model Database from Backup?
SQL Server would not start due to a corrupted model database with error 5125. Here is how to restore a corrupted model database from backup the right way.
SQL SERVER – Failed Rule “Valid DSN” and “Valid Database compatibility level and successful connection”
Upgrading SQL Server 2016 CTP2.2 to CTP2.3, setup failed the rules Valid DSN and Valid Database compatibility level for Reporting Services. Here is what to check.
SQL SERVER – Finding If Date is Last Day of the Month
Did an employee join on the last day of the month? I show the add one day trick and the EOMONTH function from SQL Server 2012 to check it.
SQL SERVER – Scope of ERROR_MESSAGE
ERROR_MESSAGE() gives the exact error text inside a TRY CATCH block, but it returns nothing outside CATCH. A quick demo of the scope of ERROR_MESSAGE.
SQL SERVER – Security Considerations for Contained Databases
Security considerations for contained databases: how contained authentication works, the initial catalog it needs, and the fallback to server logins.
SQL SERVER – Edition Upgrade from Evaluation to Enterprise Core – AlwaysOn Warning!
Upgrading SQL Server from Evaluation to Enterprise Core, setup warned that AlwaysOn Availability Groups is enabled. Here is what the edition upgrade check means.