I think there are different visualizations for different purposes.
- we need information quickly to make a decision. a GPS tends to be better here in the moment. Turn...

You need to read the ALTER TABLE syntax. The complexity is in repeating the existing column names, nullability, etc. I think Sue has a good basic script for...

This forum isn't a place to document a journey. It's a place to ask questions or discuss issues. a blog or series would be better

First, there isn't an error table from an insert. Second, we can't see your data, so we have no idea what a violation would be. Rather than a little test...

This is a perfect place to use testing to double check yourself. Pick a few tickets, then build  a test like this (I use tSQLt - tsqlt.org)

Use two views. One for CRUD, one for display that decrypts data.

What's the purpose of the view? In other words, what are you trying to accomplish?

If you use decryptbykey() in the view, you can't insert data into that...

Replication can work. export/import can work, whether you use SSIS or something else. Keep in mind, your web service essentially does this, by querying a database, getting results, putting in...

Interesting. Are you working only with calendar days? So a Friday 4:00pm ticket open until Tues 9:00am after a weekend and Monday holiday is 480 (Fri) + 540 (Tue) minutes?

You still need the key open, so anyone that can't open the key will get NULLs in the view.