Error 3154 says the backup set holds a backup of a different database. Here is how to fix it in SSMS, plus the T-SQL RESTORE WITH REPLACE option.
XQuery Comparisons: General Equality Is Not Singleton Equality
XQuery Comparisons use different rules for general sequence operators and singleton value operators. I make equality and inequality visible side by side. A general unequal-pair result is not always the inverse of an equal-pair result.
SQL SERVER – vCPUs – How Many Are Too Many CPU for SQL Server Virtualization ? – Notes from the Field #003
Do not blame virtualization for slow servers. David Klee explains how many vCPUs are too many for SQL Server virtualization and how to set them up right.
SELECT * Cost: Why Wide Result Sets Slow Exports
The query starts fast but the export crawls. A small demo shows how much a wide text column adds, and what to measure on your own server.
Edge Constraints: Controlling Which Nodes a Graph Edge Connects
An edge table with no rules accepts nonsense links. Add an edge constraint, watch the bad edge fail, and see what the constraint still does not check.
A Server Trigger That Blocks Accidental Database Drops
A server trigger can turn a wrong-tab DROP DATABASE into an error message. Here is a small demo that guards one name and removes itself at the end.
Personal Technology – From Floppy to CD, DVD to USB Drive – Quick Note on Evolution of Personal Storage Device
Finding a box of old floppy disks made me nostalgic. A quick look at the personal storage device, from 1.44 MB floppies to CD, DVD and USB drives.