Sergio GovoniinCodeXCode-Signing certificates with Azure Key Vault: What you need to know post June 1st, 2023Elevating code-signing security by simplifying CI/CD with Azure Key Vault and HSM solutions!3 min read·Mar 19, 2024----
Sergio GovoniinCodeXAutomation of maintenance activities in Azure SQL Database (3° Part)Database maintenance is an important factor also for Azure SQL and Elastic Jobs is the most complete solution for automation of scheduled…4 min read·Mar 3, 2024----
Sergio GovoniinCodeXHow to maintain SQL Server statistics on PolyBase external tableUpdating statistics is not supported on SQL Server external tables, try the workaround I found!3 min read·Nov 30, 2023----
Sergio GovoniinCodeXHow to manage Always Encrypted columns from a Delphi application!FireDac and ADO are your friends!5 min read·Aug 27, 2023----
Sergio GovoniinCodeXAdvanced database encryption with SQL Server Always Encrypted!The strongest encryption methods currently available in SQL Server and Azure SQL!7 min read·Aug 14, 2023----
Sergio GovoniinCodeXHow to reset IDENTITY column values in SQL ServerA story of a massive reseed!4 min read·Aug 7, 2023----
Sergio GovoniinCodeXDatabase encryption becomes transparent with SQL Server TDE!Encrypting your data at rest with SQL Server Transparent Data Encryption!5 min read·Jul 30, 2023----
Sergio GovoniinCodeXEncryption in your SQL Server backup strategy!Security best practices must be implemented also in your SQL Server backup strategy!4 min read·Jul 16, 2023----
Sergio GovoniinCodeXT-SQL three-valued logic and ANSI_NULLS setting!Possible values of the logical evaluation of an expression3 min read·Jul 10, 2023----