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-…

Visualize Tally Data in PowerBI

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…

Incrementally copy data through Azure Data Factory using Change Tracking Approach from on-premise SQL Server to an Azure SQL database

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,…