Recent Blog ArticlesNewest TopicsMost LikesTagged:TagInitialize a Managed Instance replication Subscriber with a PITR backup This article provides you with steps for initializing a Managed Instance transactional replication subscription with a point-in-time-restored (PITR) backup of the published database. The Publisher an...Initialize a Managed Instance replication Subscriber with a backup This article provides you with a sample script for creating a transactional replication with the Publisher and Distributor hosted on-premise and the Subscriber being a Managed Instance databas...Considerations on Bidirectional Transactional Replication This article discusses the advantages, risks, and potential pitfalls of Bidirectional Transactional Replication. How to Capture the Actual Execution Plan in Azure SQL Database This article describes steps how you can retrieve the actual execution plan of a query directly from the runtime statistics, without having to extract the query first and run it separately outside of...Resolve tempdb-related errors in Azure SQL Database This article describes troubleshooting and mitigation steps for resolving tempdb-related errors and exceptions in Azure SQL Database. Bidirectional Transactional Replication in SQL Managed Instance This article provides a sample script for creating a Bidirectional Transactional Replication between two Managed Instances. Resolve Elastic Query issues in Azure SQL Database Elastic Queries are used to implement cross-database queries in Azure SQL Database. Elastic Query makes data located in an Azure SQL Database available to other Azure SQL Databases. It allows you to ...Add wait operation to ARM template deployment On the Azure Database for PostgreSQL support team, we recently received reports about failed server deployments. The deployments were initiated through Azure Resource Manager (ARM) JSON templates and...Azure SQL Database unavailable after switching from BYOK CMK to service-managed TDE key Recently we have received a support case where an Azure SQL Database became unavailable after switching from TDE Customer-Managed Keys (CMK) to service-managed keys. The switch itself went fine, but ...REST API call does not list SQL resources on Azure subscription The Symptoms Recently I came to a support issue where we tried to use REST API to list SQL resources on an Azure subscription. The output returned results, but it did not show any of the SQL resour...
