Blog
Azure Articles
Learn about Azure
Azure Automation: Database Copy and Error Handling with SendGrid Notifications
In fast-paced development environments, ensuring that non-production databases reflect the latest production data is critical for developers. Instead of manually restoring production data into non-prod environments upon request, automating this…
Navigating Azure SQL Data Migration: Addressing Foreign Key Complexities
Client Requirement for Azure SQL Data Migration The client’s requirement was to migrate data from their Azure SQL Server production databases to Azure SQL databases in the UAT environment. However,…
Resolving Azure SQL Stored Procedure Performance Issues: A Case Study
In the fast-paced world of cloud computing, where efficiency and speed are paramount, encountering performance issues can be a daunting challenge. Recently, a client faced a perplexing situation with their…
A Migration Roadmap for SQL Server to Azure SQL Database
Migrating your SQL Server instance to the Azure SQL Database opens up new opportunities for scalability, reliability, and cost-efficiency. Whether you’re running SQL Server on-premises or on cloud platforms like…
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…
Migrating an On-premises Database to Azure
Pre-requisite for Migrating an on-premises database to Azure. How can you validate whether your database is compatible with Azure SQL Database? This can be validated in multiple ways: What are…
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…
How to make On-Premises databases offline
The primary reason why a database is made in an offline state is that they are not in use, or they are redundant. There are multiple ways through which the…
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…
What is Azure migration and what are the different migration patterns?
Migration, in simple words, is a set of processes of transferring data and applications from one location to another. Migration usually comes in the picture when there is a need to transfer data from on-premises server to the Cloud.
