Author – Kriti Bhardwaj, Associate Data Engineer This article describes how to set up Data-in Replication in Azure Database for MySQL by configuring the source and replica servers. Data-in Replication allows you to synchronize data from an external MySQL server into the Azure Database for MySQL service. The external server can be on-premises, in virtual…
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-…
Author: Shruti Srivastava, Associate Data Engineer In this blog, We will check how to migrate data from Azure SQL database to Azure SQL Managed Instance. Pre-requisites: Azure Account SSMS Steps: A. Create Azure SQL Database with sample database Click on Create Sql database . Enter subscription name, resource group, Database name, Server name. Select…
Author: Ayush Chauhan, Data Engineer In this article, we will see how to automatically save the attachments associated with an Outlook Mail to Azure File Share using Microsoft Flow. This helps to archive the Outlook attachments. To optimize the attachment extraction from email to further optimize the performance of your entire solution you…
Author: Shruti Srivastava, Associate Data Engineer In this article , it is explained how to manually configure database migration from Sql Server to Azure SQL Managed Instance by using Log Replay Service(LRS). How the Procedure Works: In this procedure, thee migration consists of making full database backups on SQL Server with CHECKSUM enabled, and copying backup…
Author – Gauri Pawse, Sr. Data Engineer I have come across a frequent question that many users/architects asks i.e. what to use for Modeling? Should we go for Power BI Premium as that seems to be the future or should we go ahead with Azure Analysis Services? We will start with brief introduction of both…
Author: Shubhi Jain, Associate Data Engineer A Server based reporting service from Microsoft works on SQL server on which it is hosted. This SQL Server can be either local or remote. Supported SQL Server Data Engine on which SSRS can be hosted are: Azure SQL Managed Instance SQL Server 2019 SQL Server 2017 SQL…
Author: Sneha Valia Tally.ERP 9 Tally is at the forefront of simplifying business management for business through automation. Tally.ERP 9 is a windows–based Enterprise Resource Planning software. The software handles Accounting, Inventory Management, Order Management, Tax Management, Payroll, Banking and many such requirements of the business. It supports all day-to-day processes from recording invoices to generating various MIS reports. Tally’s product caters…
Author: Ayush Chauhan, Cloud Engineer The use case for this scenario is to capture real-time streaming data from sensors and IoT devices and then process it for data analysis and visualization purposes. Problem Statement : Consider a wind farm, where hundreds of wind turbines are harnessing energy from wind and storing them as energy…
Author – Gauri Pawse ( Sr. Cloud Engineer) Change Tracking is a lightweight solution in SQL Server database that provides an efficient change tracking mechanism for applications. It is a mechanism for tracking which rows have been inserted, updated, and deleted in tables monitored by change tracking. Using change tracking allows easy identification of new,…
