Thanks Jeff & Steve. Will keep this thread posted with updates and/or outcome. First meeting with product/dev team did not achieve much.

EDIT : I like Jeff's DBA prayer 😀

• This reply was modified 2 years, 7 months ago by  TheMaskedDBA.

Thanks Jeff. Appreciate the detailed insights regarding performance implications. The product team has so far not engaged with regards to a design discussion, but trying nonetheless. I agree that performance...

To anyone interested: We found that SQL 2008 R2 cannot use a certificate with a serial number thumbprint of greater than  16 bytes. It has to be 16 bytes or...

2 choices:

1. Create a server group(One folder up from CMS) and add all servers to group, open a query in the context of the "server group" and run your SQL...

You encrypted the databases 🙂 ?

I checked the SQL 2008 R2 version here: https://technet.microsoft.com/en-us/library/ms187798(v=sql.105).aspxhttps://technet.microsoft.com/en-us/library/ms187798(v=sql.105).aspx

This has no info other than the below:

A certificate...

Gail - Thanks for your reply and appreciate your help. A quick check of this documentation : CREATE CERTIFICATE reveals the following text in the remarks section:

The Private...

Details about that is exactly what I'm looking for. Is there any documentation about the limitations anywhere ? We are using...

Thanks Gail. Yes, the certs / keys we generated are 2048 bits, from Comodo, which I can import into SQL 2016 successfully, but unable to do so into SQL 2008...

Thanks Gail / Arsh. Yes, I realize that profiler should not be run on PRD servers and most of the team is aware of this. This was a rookie DBA...

I know this is an old issue, but one I ran into as well some months back. The solution is to uninstall / reinstall ODBC drivers as there is a...

Something like that can be achieved, by using Rollover option, and using parameter @filecount while using the proc sp_trace_create. It will basically delete the oldest file if the maximum number...

You are correct. Not sure how I missed that ! Thanks.

It is not easy(or even possible, perhaps) to mathematically/statistically ensure the numbers you speak of. While that level of redundancy certainly does offer a high possibility of you being able...

For those interested - I got the answer from my posting on the MSDN forums, from a Microsoft employee(so I think it's legit :-)).

The short answer is yes, the buffer...