Published inCodeXSQL Server Maintenance Plans: Strategies to protect and optimize your databases!Essential tasks, backups, restore, performance, workflows, and database availability.Dec 14Dec 14
Published inCodeXRegenerate 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
Published inCodeXCode-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
Published inCodeXAutomation 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
Published inCodeXHow 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
Published inCodeXHow to manage Always Encrypted columns from a Delphi application!FireDac and ADO are your friends!Aug 27, 2023Aug 27, 2023
Published inCodeXAdvanced database encryption with SQL Server Always Encrypted!The strongest encryption methods currently available in SQL Server and Azure SQL!Aug 14, 2023Aug 14, 2023
Published inCodeXHow to reset IDENTITY column values in SQL ServerA story of a massive reseed!Aug 7, 2023Aug 7, 2023
Published inCodeXDatabase encryption becomes transparent with SQL Server TDE!Encrypting your data at rest with SQL Server Transparent Data Encryption!Jul 30, 2023Jul 30, 2023
