Learn about Microsoft Fabric for Data Analytics
This article discusses Microsoft Fabric is and is not and how this impacts things such as Azure Data Factory, Azure Synapse Analytics, and Power BI.
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
Power BI Artificial Intelligence Possibilities
In this tip, we'll give an overview of particular AI possibilities within Power BI.
Read Cosmos DB Data with Azure Data Explorer
Learn how to read Cosmos DB data with Azure Data Explorer in this step-by-step article.
AI Tools for IT Professionals
In this article, we look at various AI tools that might be able to make you more efficient as an IT person.
Azure Cosmos DB cosmicworks Sample Database Installation
In this article, we walk through a few different options to set up the sample Cosmos DB database cosmicworks for testing and other needs.
Star Schema vs Snowflake Schema for Dimensional Modeling
Sometimes people say to avoid the snowflake schema and stick to a clean star schema. Why is that? Is something wrong with creating a snowflake schema?
Snowflake Schema Overview and Usage in Power BI
In this article, we look at what a snowflake schema is and also how to use a snowflake schema in Power BI.
Star Schema Data Modeling for Power BI
I often hear the star schema is the best way to structure data for a Power BI model, I'm not familiar with this concept, what does this mean?
Learn SQL Query Language on SQL Server
Learn various ways to get started with the SQL language to help you build new skills or build upon existing skills.
Install AdventureWorks Database in Azure SQL Database
Learn how to configure Azure SQL Database and setup the AdventureWorks database for code testing and learn how to use features of SQL Server.
Azure Functions to read an Excel file from Azure Blob Storage
Learn how to use Azure Functions to read an Excel file from Azure Blob Storage into memory and apply transformations.
How to Retrieve a File from Azure Blob Storage with an Azure Function
In this tip, we'll cover a solution that retrieves a file from Azure Blob storage into the memory of an Azure Function.
Power BI Desktop to Combine SSAS 2022 Data with Additional Sources
This tip walks through the steps of how to combine data from SQL Server Analysis Services SSAS 2022 with other data using Power BI Desktop.
Setup Azure Synapse Link to Query Azure Cosmos DB Data with Synapse
In this tip, we guide you through the setup of Azure Synapse Link so you can query Azure Cosmos DB data with the Synapse Serverless.
Azure Synapse Link to Replicate SQL Server Data to a Synapse Workspace
Use Azure Synapse Link to replicate tables from Azure SQL Database or SQL Server 2022 to a dedicated SQL Pool in an Azure Synapse Analytics workspace.
Optimize Power BI Data Model for Performance and Accuracy
This tip will go through some guidelines for creating an optimized data model when working with Power BI for performance and accurate results.
SQL Server 2022 WINDOW Clause to Simplify SQL Queries
In this tip, we'll introduce the new WINDOW clause in SQL Server 2022 and it can simplify queries with multiple OVER clauses.
ETL Interview Questions for T-SQL, Database Design and Data Loading
More possible interview questions you might see if you are seeking a position as an ETL developer using the Microsoft Data Platform.
Data Quality Tools to Streamline Development and Data Accuracy
Learn how and why to use Melissa's data quality components that integrate into SSIS packages to fix data problems and save your company money.
SQL Server GREATEST and LEAST Functions for Range of a Data Set
In this article, we look at how to calculate the range of a data set by using the new GREATEST and LEAST functions available in SQL Server 2022.
T-SQL Code for Last non-NULL Value from a Set of Records in SQL Server
Learn different ways of using SQL to get the last non-NULL value from a set of records so the result set always includes a valid value.
GENERATE_SERIES SQL Server Function to Expand Date Range into Rows
In this tip, we cover how to use the GENERATE_SERIES function to expand a range of dates into rows.
ETL Interview Questions on Performance, Troubleshooting and more
This is an article related to in-depth interview questions you might see as an ETL developer related to performance, troubleshooting, and more.
Developer ETL Interview Questions for SSIS and ADF
This is the second article about interview questions you might have if seeking a position as an ETL developer using the Microsoft Data Platform.