Sergio GovoniinCodeXRegenerate IDENTITY column values on SQL Server and Azure SQL with sp_identity_rebirthThe sp_identity_rebirth stored procedure addresses the SQL Server and Azure SQL error 8115!Aug 72Aug 72
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!Mar 193Mar 193
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…Mar 3Mar 3
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!Nov 30, 2023Nov 30, 2023
Sergio GovoniinCodeXHow to manage Always Encrypted columns from a Delphi application!FireDac and ADO are your friends!Aug 27, 2023Aug 27, 2023
Sergio GovoniinCodeXAdvanced database encryption with SQL Server Always Encrypted!The strongest encryption methods currently available in SQL Server and Azure SQL!Aug 14, 2023Aug 14, 2023
Sergio GovoniinCodeXHow to reset IDENTITY column values in SQL ServerA story of a massive reseed!Aug 7, 2023Aug 7, 2023
Sergio GovoniinCodeXDatabase encryption becomes transparent with SQL Server TDE!Encrypting your data at rest with SQL Server Transparent Data Encryption!Jul 30, 2023Jul 30, 2023
Sergio GovoniinCodeXEncryption in your SQL Server backup strategy!Security best practices must be implemented also in your SQL Server backup strategy!Jul 16, 2023Jul 16, 2023