Database migration from Managed Instance to SQL Server with transactional replication

Author- Ashfaq Pathan (Associate Data Engineer) Transactional Replication Setup We will set up a transactional replication for migrating the database from Managed Instance to SQL Server 2017 hosted on Azure SQL-VM. Managed Instance will be both Publisher and Distributor. SQL Server will be Subscriber. Prerequisites: 1. Azure Subscription. 2. Storage account with one file-share in it…

ELK Stack

Installation of ELK Stack on CentOS

Author: Prashant Pawar, Cloud Engineer   The ELK Stack — is a collection of open-source software Elasticsearch, Logstash, and Kibana on the server side, along with Filebeat on the client side which allows you to search, analyse, and visualize logs generated from any source in any format, a practice known as centralized logging. The Elastic Stack has four main components: Elasticsearch: a distributed RESTful search…

Elastic querying on Azure SQL Database

Author – Moulshree S. D., Sr. Data Engineer On-premises SQL Server does support three- or four-part names, but the Azure SQL Database does not. The Elastic Database query feature enables you to run a Transact-SQL query that spans multiple Databases in Azure SQL Database. The Database migration Assessment throwing error as “Cross-Database queries using three-…