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

Migrate SSRS Report To Power BI

Author –  Kalim Khan, Sr. Cloud Engineer Overview: There are several reporting tools and platforms available today, and enterprises usually choose the one that is best suited for their business needs. Two popular options for reporting platforms are SQL Server Reporting Services (SSRS) and Microsoft Power BI. Due rich visualization and better performance people are…

Data flows with Power BI

Author – Gauri Pawse, Cloud Engineer    Most self-service BI tools don’t include a data warehouse or data lake. Although they will integrate with data warehouses or data lakes that are built by data professionals, they don’t let analysts and business users perform data warehousing tasks in tools that are designed for them. This is…

Automate the Process for Reading and Writing Data in Azure Storage Account Gen2 with Azure Data bricks

Author – Ayush Chauhan, Associate Data Engineer INTRODUCTION In this article, we will learn how we can load multiple files from a storage account and how to transform data back to it and azure database, along with how to automate this whole process, so one didn’t have to change any variables or write any extra…

Power BI Features

Author – Nimai Ahluwalia, Cloud Engineer Power BI is a suite of business analytics tools to analyze data and share insights. Monitor your business and get answers quickly with rich dashboards available on every device. Power BI comes up with great and some amazing features every month which is making it more effective and powerful…

Migrate Oracle Database to SQL Server using Microsoft SQL Server Migration Assistant for Oracle.

Migrate Oracle Database to SQL Server using Microsoft SQL Server Migration Assistant for Oracle.

Author – Sarvesh Pandey, Cloud Engineer There are many ways to migrate Oracle Database to Microsoft SQL Server like Azure Data Factory, Azure Data Migration Service, SQL Server Migration Assistant (SSMA). SSMA is a free Microsoft tool which is use to migrate Data from Oracle to Oracle databases to Microsoft SQL Server 2012, Microsoft SQL Server…