Automate Azure SQL Database Indexes and Statistics Maintenance

Automate Azure SQL Database Indexes and Statistics Maintenance

Azure SQL Database is a PaaS solution for migrating your on-premises databases to the Azure cloud infrastructure. It is a managed service and Azure manages the infrastructure, database availability, backup restore, and compute resources. Regularly maintaining your database is a crucial responsibility for database administrators to ensure optimal performance for your application queries. In the case…

Azure Data Sync between Azure SQL databases

Azure Data Sync between Azure SQL databases

Azure Data Sync is a powerful tool that allows the synchronization of data across multiple Azure SQL databases. This tool can be used for a variety of purposes, including data backups, disaster recovery, and data distribution.  This blog is focused specifically on using Azure Data Sync for data synchronization between Azure SQL databases.  What is…

Log Reader Agent Error Solution on Azure SQL Database while performing transactional replication 

Log Reader Agent Error Solution on Azure SQL Database while performing transactional replication 

In one of our projects for a leading banking and financial organisation, we encountered an issue while performing transactional replication.   Log reader agent error could not execute ‘sp_replcmds’ on sqlserverdb (Azure SQL Server). Our analysis revealed that the database that was being replicated had a different owner than sa, and this in turn was…