Understand the left semi join showplan operator with EXISTS, compare anti and inner joins, and inspect graphical-plan properties.
Corrupted Model Database: How to Get SQL Server Running Again
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.
Interview Question of the Week #037 – What are the Properties of Relational Tables?
Explain the properties of relational tables and connect each rule to SQL Server types, keys, duplicate rows, named columns, and ordering.