Azure Event Grid Topic to Pass Events in ADF and Synapse Analytics
Learn how to use the Event Grid Topic resource in Azure to manage events between different instances of Azure Data Factory (ADF) or Synapse Analytics.
Semjon Terehhov is an MCSE in Data Management and Analytics, Data consultant & Partner at Cloudberries Norway. He has a master's degree from the University of Oxford. For the past 10 years, I have worked as a DBA, BI Developer, and DevOps starting with SQL Server 2005. I have worked from the hardware up all the way through to the stack to the front end programming to design data solutions for end-users needs.
Data Lake Medallion Architecture to Maintain Data Integrity
The article explains how to take general principles of Medallion architecture for the design of Data Lakes.
SQL Server Windows Authentication with Users and Groups
In this article we cover how to use Windows Authentication for SQL Server access and how to setup permissions using groups, users and roles.
Read API Data with Power BI using Power Query
In this tip we will walk through how to load API data into Power BI using Power Query.
Improve Power BI Performance with SQL Server Indexing
In this tip we look at different Power BI modes and what they do to the SQL Server database in terms of T-SQL and how indexes should be structured to efficiently support the workload.
Change Capture Alternatives with Azure Data Factory
This article will help you decide between three different change capture alternatives and guide you through the pipeline implementation using the latest available Azure Data Factory V2 with data flows.
Configuring Azure Data Factory Data Flow
In this tip we look at how to build and configure an Azure Data Factory data flow using pipelines, data sources and sinks.
SQL Server IOT Database Design Example
In this tip we look at how to build a data model and load data to support loading data for an IOT data collection project.