Your backup job is green, but is every database in it? Here is a read-only way to find the ones missing from msdb history.
Comparing Two Schemas With sys.columns and a FULL OUTER JOIN
Use read-only queries for comparing two schemas, finding missing columns, checking type details, and reviewing indexes and modules.
SQL Server: Why Retrying an INSERT Can Create Duplicate Rows
Retrying an INSERT can create duplicate rows even with an identity primary key. These tested examples use a stable request ID to return the original order, reject changed inputs, and preserve unrelated errors.
GDR or CU: Choosing Your Update Branch
Choose GDR or CU for SQL Server by understanding security and cumulative branches, checking the exact build, and testing a branch change.
SQL SERVER – How to Get SQL Server Restart Notification?
Want a restart notification when SQL Server starts, without buying a tool? Here are the steps to run a stored procedure at startup.
SQL SERVER – SQL Server High Availability Options – Notes from the Field #032
Not sure which of the High Availability options fits your organization? Tim Radney explains the SQL Server choices in very simple words.
Attach a Database in SQL Server and Detach It Safely
To attach a database, use CREATE DATABASE with FOR ATTACH and point it at the data and log files. This post detaches a demo database, attaches it again, shows the error that stops a detach, and compares the old sp_attach_db procedure with the current statement.