Thanks SC, but it was more like the type of transformations below...and excitedly enough after working through a few issues, I was able to create the SQL CLR UDF and...

Hi Chris. If you haven't even gotten to the deployment part yet, that is even more fun (yes, that is sarcasm). You will want to look at the following...

The data is stored on a MySQL database as encrypted. The encryption is not done by MySQL, but instead an application using the C# libraries encrypts the data before it...

Well, I just found this article which seems to  make it really easy based on what I got so far. Looks like I can just modify my console app a...

As a follow up, I installed the same version of the .NET framework on the Server that hold the DB to be masked, and it worked!  To recap, I'm connected...

Thanks for the advice.  I grabbed the SET output from both and put them into Notepad++ using the Compare plugin to help highlight differences and the very first thing I...

I appreciate the feedback and will check driver settings...we just noticed that in the Trace, the Prepared version was being put into an explicit transaction, so I'm thinking SQL Server...

Its a true Prepared Statement with only one parameter (@P0) as BigInt type...when I've asked in the past, the Developer states that
I could try putting in an STP,...

BTW, I got it to work by adding the Public Role within the problematic database, to the SYS schema with SELECT and View Definition all under the same database...and that...

Thanks, but I've checked the DENY roles about 10 times now and there is no deny on anything set.  I did make it a little further in troubleshooting though.  After...

Thanks Ed, you are correct. The license structure is now per core. We moved this instance from a physical 24 core box to a VM with 12 cores allocated. I...

Hi Ed,
Thanks so much for your reply and confirmation.  I started reading around Microsoft Tech Articles and found a good one regarding the new Cardinality Estimator in 2014, and...

Update.  After removing the FAST 5000 option AND implementing the date comparison recommended, the Index Scan turned into an Index Seek.  I really need to take an official Performance Tuning...