Activity overview
Latest activity by sgtmango333
SQL Clone TDE Strategies
I've read Steve Jones's article from 2017 regarding using SQL Clone with TDE enabled databases. The workaround was restoring the DEK to the target server prior to deploying the clone. This is all...
Thanks David. Yes it was the red underlines, so probably SSMS and not SQL Prompt. / comments
Thanks David. Yes it was the red underlines, so probably SSMS and not SQL Prompt.
Thanks Aaron! Both good to know! / comments
Thanks Aaron! Both good to know!
Larry, I happen to be working on a project to change the collation of a database and fix references to that database in an uncollated DB. I've found that SQL Prompt is sensitive to those collation differences and can show an object as invalid on the uncollated server due to casing. The query will run fine, but the objects show up as invalid.
It seems a little inconsistent, but I didn't dig real deep and my trial has expired. So I can't really duplicate. Just and FYI and something to look at. / comments
Larry, I happen to be working on a project to change the collation of a database and fix references to that database in an uncollated DB. I've found that SQL Prompt is sensitive to those collation...
Disabling Tab History
There are times when an adhoc script has sensitive information that I don't necessarily want saved out on an unencrypted location. I found that the Tab History feature, cool as it is, saves some o...