Module Signing Info (Microsoft Connect)

Module Signing, signature, certificate, asymmetric key, SQL Server, T-SQL, TSQL, SQLCLR, SQL# 2024-11-21 1-9

Module Signing Info

Home Concepts Answers Reference Microsoft Connect Contact

Module Signing, signature, certificate, asymmetric key, SQL Server, T-SQL, TSQL, SQLCLR, SQL#

— Microsoft Connect —

Suggestions

Expose public_key of Certificate in sys.certificates, just like sys.asymmetric_keys is doing
Allow Asymmetric Key to be created from binary hex bytes string just like CREATE CERTIFICATE
Add function to extract Asymmetric Key similar to CERTENCODED for Certificates
Add MSBuild predefined Targets for "BeforeSqlBuild" and "BeforePublish" to SSDT SQL Server Database Projects
Allow signing Database DDL Triggers and Server DDL and Logon Triggers - ADD SIGNATURE

Bugs
Trusted Assemblies are more problematic yet less functional than Certificates - Please Remove

Module Signing, SQL Server, certificate, signature, certificate, asymmetric key, T-SQL, TSQL, SQLCLR, SQL# 2024-11-21 1-9