Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Add function to extract Asymmetric Key similar to CERTENCODED for Certificates (SQLCLR / SSDT)

Currently we are able to extract the public and private keys of a Certificate via CERTENCODED ( https://docs.microsoft.com/en-us/sql/t-sql/functions/certencoded-transact-sql ) and CERTPRIVATEKEY ( https://docs.microsoft.com/en-us/sql/t-sql/functions/certprivatekey-transact-sql ). However, we cannot extract even the public key of an Asymmetric Key.

This presents problems for SSDT when importing a database, and it makes it much, MUCH harder to work with the new "CLR strict security" server configuration option ( https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/clr-strict-security ) of SQL Server 2017 if the goal is to NOT rely on any external files (DLL or SNK) when publishing an Assembly. And this is definitely the goal of SSDT and any reasonable project / deployment.

And no, the even newer work around of white-listing Assemblies by making them "Trusted" is NOT an option as that "feature" should not even exist and should be removed ASAP!

4 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base