The core of the problem is "ownership". This is the knife plunging in the back of privacy.

My data is mine--or is it? Take Google for example. Would you agree they...

As with all things, it's a double-edged sword.

While I would never disdain backups for protecting data the backup itself introduces more attack surface, and potentially an unguarded one, or at...

Um, it isn't a VS extension, it's standalone but have you considered ModelRight? Not sure exactly why you're developing the DB in VS but ModelRight has a large number of...

A few comments:

<li style="list-style-type: none;">

1. I often need to use incrementing integers as a primary key.  However, that is never my first choice.  I have seen incrementing integers...

A key is a key whether it is implemented using a PRIMARY KEY constraint, UNIQUE constraint or other means. Referential integrity is something else because not all keys are...

Hi Steve

Natural keys serve a very different purpose to surrogates so it's pretty meaningless to say one is "superior" to the other. You will need both. If my patients...

Suppose I have to merge data from two systems which happen to have conflicting surrogate primary key values even though they...

Roger, I agree with nearly all you have said but when I said before that natural keys could be unique but mutable you said you "vehemently" disagreed with me!...

You already said, and I agree, that login names can change. Similarly customer account numbers, so those are two relatively common cases of keys that may need to be...

As a developer I vehemently disagree. You need a primary key to be mechanically useful. That means it must be immutable and have other desired characteristics, like uniqueness...

My point was about keys in general, not...

Under your interpretation doesn't that mean that all FKs fall under the GDPR? Meaning, ultimately, that relational databases are forbidden?

Or, if not forbidden, unusable by the vast majority of a...

Sounds more like a bug than a feature. Is this actually useful for anything beyond bar bets? Why would a single insert that breaks the rules be advantageous? Especially given...

Who in their right mind makes an employee account privileged? User accounts should NEVER have privileges sufficient to do DBA or system administrator work, that is what admin accounts are...

Evergreen sounds great--until it breaks an existing behavior.

I will freely admit MS goes through a Sisyphean effort to maintain backward compatibility and largely succeed. Well, they did until they started...