The main point of the article is that we should expect data to change and allow for this. Not just with database design, but with the ETL, NULL/defaults, and more....

It's a neat town. We...

The one thing I'll say in defense of...

This is one reason I dislike many natural keys as PKs.

I don't understand how this follows from the discussion..  First, there's not a whole lot of cases where there...

If you are doing updates, then SSIS works great. If this is a full migration each time, there is the SQL Server Migration Assistant that works well. A number of...

A lesson from The Phoenix Project. No one should be above others. You might know more, but you don't get to break rules.

I'd disable the user rather than delete.

Glad you enjoyed it. I missed it when retrying it today as well.

You alter the key to use the new server certificate.

The data could be structured differently, different amounts on pages, so reclaiming space might end up looking different later. Check fillfactor and any other config differences as well. Might be...

It should still work. Was the data the same? The cleantable should rebuild the table and recover space.

Which Microsoft page? There are differences in editions, so you need to know that. If you use developer, free, you can't disable telemetry. That's the price of the edition. For...

I'll ping Mike for updated images.

Hire one that doesn't open the ransomware ones.

NO idea of the details, but I do worry about a manager covering their own self-interest by firing a staffer. Could be justified,...

Have you tried doing the snapshot restore WITH STATS?

Never had anyone worry about this, and I can't seem to find out if this is tracked. I'd have thought dm_exec_requests had...