The gist of it: > But there’s a far more compelling reason not to use any kind of PK in a public context: if you ever need to change keys, all your external re

The gist of it: > But there’s a far more compelling reason not to use any kind of PK in a public context: if you ever need to change keys, all your external references are broken. Think “404 Page Not Found”. > When would you need to change keys? As it happens, we’re doing a data migration this week, because who knew in 2003 when the company started that we would now have 13 massive SQL Server databases and growing fast?