Azure Data Factory Frequently Asked Questions
Find answers to your questions with our Azure Data Factory FAQ. Learn about features and limitations of ADF today.
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
Azure Data Factory FAQ
Get answers to your questions in our Azure Data Factory FAQs and learn about data pipelines and integration services.
Improve Query Performance in the Fabric Warehouse with Clustering
Learn how to improve performance issues in Microsoft Fabric Warehouse and leverage cloud-based data analytics effectively.
Microsoft Fabric Architecture FAQ
Explore the Microsoft Fabric architecture through frequently asked questions about its features and capabilities in data analytics.
Microsoft Fabric Frequently Asked Questions
Find answers to your questions in our Microsoft Fabric FAQs. Learn about features and capabilities of this powerful data platform.
Calculate Rolling Average with SQL DATE_BUCKET Function
Understand how to use DATE_BUCKET SQL command to group dates and calculate averages in T-SQL for your sales data analysis.
What’s New in SSIS 2025?
Discover new features of SSIS in SQL Server 2025 and learn if an upgrade makes sense for your on-premises solutions.
Develop SSIS Packages with SSIS 2025
In this tip, we show you how to develop SSIS 2025 packages for SQL Server 2025, and how you can migrate existing projects to the latest version.
SSIS 2025 Download, Install and Configure
Learn how to download, install, and configure SQL Server Integration Services (SSIS) for SQL Server 2025 in this step by step guide.
Regex String Split using SQL Server 2025 REGEXP_SPLIT_TO_TABLE
Explore how to use string split in SQL Server 2025 with regex for complex text parsing without cumbersome custom coding.
SQL Server 2025 REGEXP_MATCHES Function to Extract Multiple Substrings
Learn how to use SQL REGEXP_MATCHES to extract multiple substrings efficiently without loops or cursors in SQL Server 2025.
Powerful Text Extraction with REGEXP_SUBSTR in SQL Server 2025
See how to easily extract text from a SQL string using the regex function REGEXP_SUBSTR to simplify text extraction.
Replace Text using RegEx with SQL Server 2025 REGEXP_REPLACE
Learn how to use RegEx in SQL Server 2025 using REGEX_REPLACE to find and replace complex text strings in your data.
The New JSON Index in SQL Server 2025
Explore how to create and use a JSON index in SQL Server to improve query performance for tables that store JSON data.
JSON_CONTAINS Function in SQL Server 2025
Learn about the JSON_CONTAINS function in SQL Server 2025 and how it simplifies checking values in JSON data.
Extract Text using Regular Expressions with SQL Server 2025 Function REGEXP_INSTR
Discover the power of REGEXP_INSTR in SQL Server 2025 for finding complex patterns in your text data using regular expressions.
SQL Concat Operator and UNISTR Function in Azure
Explore the concat operator in T-SQL and UNISTR function for handling Unicode characters and managing strings in Azure SQL DB.
SQL Server 2025 REGEXP_COUNT Function to Count Occurrences in Text
Learn about the SQL Server 2025 REGEXP_COUNT function and how this could be used in SQL queries to count occurrences in text.
REGEXP_LIKE Function in SQL Server 2025
Learn how to use the regex_like function to write a regex command to find LIKE string values in SQL Server strings and tables.
Install AdventureWorks Database for SQL Server 2025
Follow these steps to install the AdventureWorks database for SQL Server 2025 so you can begin learning and testing its new features.
Install SQL Server 2025 Demo Environment in Azure
In this article, we look at how to get a test environment setup and install SQL Server 2025 in Azure for testing and trial purposes.
Build Power BI Time Dimension with Power Query
Learn how to build a Power BI time dimension using Power Query to easily create report breakdowns by various time elements in Power BI.
Script to Create a SQL Time Dimension Table
In this article, we look at using a SQL time dimension table and how to create a time dimension table in SQL Server.
Azure Data Factory Settings – Part 2
Learn about things in Azure Data Factory that you should know about such as changing default settings, Git Integration, Orchestrion and more.