Normal SQL Server rights apply. SMO really will end up running some sort of query or RPC to get data, but it should fall under the SQL model. If the...

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)