Insight into Azure Data Factory vs SSIS
Learn about similarities and differences of SSIS and Azure Data Factory and provide some insight as to when you would use one over the other.
Koen Verbeeck is a seasoned business intelligence consultant with over a decade of experience with the Microsoft Data Platform. He holds several certifications, including Azure Data Engineer. He's a prolific writer, with over 375 articles on technologies such as Microsoft Fabric, SSIS, ADF, SSAS, SSRS, MDS, Power BI, Snowflake and Azure services. He has spoken at various events such as PASS, SQLBits, dataMinds Connect and many others. He frequently delivers educational webinars on MSSQLTips.com. For his efforts, Koen has been awarded the Microsoft MVP data platform award for many years.
- MSSQLTips Awards:
- Leadership Award (200+ Tips) - 2021
- Author of the Year - 2014/2020/2022
- Author Contender - 2024/2025
SQL FOR Loop Alternatives
Learn different ways to create FOR Loops using T-SQL such as using WHILE loops, cursors, tally tables and more.
SQL Aggregate Functions Code Samples
Learn about the different T-SQL aggregate functions in SQL Server such as count, sum, min, max, avg and more along with examples.
Power Query Introduction
In this tip we'll introduce you to Power Query the self-service data preparation tool from the Power BI family.
BI Developer – Day in the Life
In this article we cover what a typical day looks like for a business intelligence developer using the Microsoft Data Platform stack.
BI Developer Technical and Soft Skills for Success
In this article we cover technical skills and soft skills that are typically found in successful BI developers.
SQL Concatenate Examples
In this article we look at how to concatenate SQL Server data using various methods using concatenation operator, functions CONCAT and CONCAT_WS.
Examples for SQL CAST and SQL CONVERT Functions
Learn how to convert SQL Server data to different data types such as string, date, integer and numeric using the CAST and CONVERT functions.
Snowflake Streams for Change Data Capture Scenario
In this article we look at using streams in Snowflake to set up a change data capture scenario where only new or modified rows are processed.
SQL Queries Explained
In this article we look at what a SQL query is, tools you can use to write and execute queries with SQL Sever and some example queries.
Exploring Snowflake Tasks
In this article we look at how to schedule SQL statements in Snowflake by using tasks with a step by step example of how this can be done.
Azure Data Factory Data Flows
This article covers what data flows are in Azure Data Factory and how to get started with using data flows in ADF.
Azure Data Factory Pipeline Scheduling, Error Handling and Monitoring
In this article we cover an overview of how to use Azure Data Factory for pipeline scheduling, error handling and monitoring.
Getting Started with Azure Data Factory – Part 1
In this article we walk thru steps of how to get started with Azure Data Factory and build a simple pipeline in ADF.
SQL INSERT INTO SELECT Examples
In this article we show how you can insert data into SQL Server tables using the INSERT INTO statement.
SQL UPDATE Statement
In this article we cover how to update data in a SQL Server table using the UPDATE statement along with several examples.
CASE Statement in SQL Examples
This tip will teach you when and how you can use CASE in T-SQL statements with several code examples to give you a better understanding.
SQL Server SELECT Examples
This tip will teach you how you can use SELECT to read, aggregate and sort data from one or more tables.
What is an SSIS Package
This tip will teach you what a SQL Server Integration Services package is and what you can do with a SSIS package.
SSIS – SQL Server Integration Services
In this tip we explain what the SQL Server Integration Services service is and things you should know to get started using SSIS.
SSIS Favorite Features
In this tip we cover some interesting and good-to-know features of SSIS that you should be aware of and using.
SSDT Top Features for Database Projects
In this tip we cover some interesting features of SQL Server Data Tools to use when working on database projects.
TSQL Tips and Tricks
Learn TSQL tricks working with CTEs, UPDATES, Window Functions, Duplicate Rows, Tally Tables and Concatenating string values in SQL Server.
Resolve Git Merge Conflict for SSIS Projects
In this tip we show how to resolve merge conflicts when using git for Integration Services project development.