Color code the SQL Server Management Studio status bar so you always know which server you are on before you run a script. A quick video.
Non-Updating Updates: Skipping Rows That Would Not Change
An UPDATE that writes the same value still marks the row as modified. I show how IS DISTINCT FROM skips those rows and keeps NULL changes.
SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – Part 1 of 2
Rows kept vanishing from a product table with no DELETE anywhere in the code. Part 1 of a puzzle that leads to ON UPDATE CASCADE and ON DELETE CASCADE.
What Is a Primary Key, and What Happens Without One?
A primary key is the promise that every row can be told apart. Why NULL is refused, what a table without one actually costs you, how it differs from a unique constraint, and when to choose a natural key over a made up one.
Offloading Reports to a Readable Secondary
Readable secondary replicas can serve reports away from a SQL Server primary; learn routing, lag, licensing, and query differences to test.
SQL SERVER – Beginning of SQL Server Security
The beginning of SQL Server security: how authentication, logins, users and permissions work together to keep your data safe from misuse.
What Distributed SQL Means and What It Costs
Understand distributed SQL through data placement, compute and storage roles, write coordination, and the latency and operating costs behind scale.