What is SSRS? SSRS stands for SQL Server Reporting Services. It is a reporting tool developed by Microsoft that comes free with the SQL Server. It produces formatted reports with the tables of data, graph, and reports. Reports are hosted on a server and configured to run using parameters supplied by users. When we run the […]
Microsoft
Feature of Snowflake: Zero Copy Cloning
Feature of Snowflake: Zero-Copy Cloning Zero Copy Cloning in Snowflake: Snowflakes have some advanced feature like Time Travel, zero-copy cloning […]
How to create zip file which contains single text file with a fixed threshold in SSIS.
What is SSIS? SQL Server Integration Service (SSIS) is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks. The SSIS ETL tool Extracts data from different sources and transforms that data according to user requirements. And then loads data into various destinations. […]
Implementation of XML Extract in SSIS
SQL Server Integration Service (SSIS) : SSIS is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks. SSIS is a fast & flexible data warehousing tool used for data extraction, loading and transformation like cleaning, aggregating, merging data, etc. It makes it […]
Filtering, merging, and adding new column in Azure Data Factory
Azure Data Factory is a strong ETL tool, with the capacity of creating ETL pipelines using low code/no code approach. This can be achieved with using “Activities”. Activities are the tasks that are conducted on data within a pipeline. In this post I demonstrate an ETL process which copies data from one source to another, […]
Microsoft Inspire 2022 Recap: “The Viva Edition”
Jump to: Viva Engage Viva Goals Viva Sales Other Viva News Microsoft’s annual partner conference, Microsoft Inspire, wrapped up Wednesday, July 20, 2022. While still virtual, Microsoft CEO Satya Nadella kicked off his keynote by explicating the ‘digital imperative’ of infusing technology into all business processes. He implored partners to not just talk about digital […]
HOW TO IMPLEMENT BASIC ETL TEST SCENARIOS (PART 1)
In this blog, we will see what the basic test scenarios for ETL testing are. However, before we go to the ETL test scenarios, let me first tell you what ETL is and how it works, along with the process involved with it. WHAT IS ETL? ETL stands for Extract-Transform-Load, and it is a process […]
Column Mappings as a Dynamic Content in Azure Data Factory
In this post, I would like to walk you through the approach by which we can provide the column mappings as a dynamic content in copy data activities in Azure Data Factory using a table placed in a database. Why there is a need to provide the column mappings as a dynamic content? We can […]
In-Depth understanding of client side script on Model Driven App and Dynamics 365
In this Power Platform article, we’ll look at how to add client-side scripting to a Model Driven App. Read on to learn how to use a client-side script in Model-driven or Dynamics 365 Forms, as well as what methods and collections are available. I’ll attempt to answer as many questions as possible in order to […]
How to Convert Blank Values to Null in Flat File Source in SSIS Package
SQL Server Integration Services(SSIS): SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading. In […]
How To Create Reports Using SQL Server Reporting Service(SSRS)
SQL Server Reporting Services (SSRS) is a SQL Server subsystem that enables the creation of graphical, Mobile and printed reports using SQL Server and other data sources. It is part of Microsoft SQL Server Services suite. SQL Server is a relational database management system (RDBMS) that supports transaction processing, business intelligence and analytics applications. […]
Power BI: Merge and Append Queries
Introduction: Power BI’s merging and appending operations allow you to join data from multiple tables. The choice between the merge and append queries depends upon the type of concatenation you want to carry out based on your requirement. When you have one or more columns that you’d like to add to another query, then you […]