I have big questions and absolutely no knowledge about Kubernetes. Haven't had a reason up until now.

What I'd like is 10 SQL Server development instances or whatever I should call them. When an object is first created it will point to some vanilla database which is shared between all 10. As this object makes changes to the database, those changes are saved separately and are Ephemeral on some kind of change file. For each development instance it sees only 1 database but behind the scenes it is the vanilla database + the change file. In my mind Kubernetes will reconcile these two to create a cohesive object.

Also, I'd like to implement Database Encryption. My SAN has dedupe and compression which gets killed with Encryption.

Can I do: development instance <-> Kubernetes Encryption only, and Kubernetes will decrypt the data prior to writing to SAN?

Is any of this possible?