Loading view.
There were no results found.
There were no results found.
Events Search and Views Navigation
Search
Enter Keyword. Search for Events by Keyword.
Find Events
Event Views Navigation
List
List
Month
Day
Today
Upcoming
Upcoming
Select date.
Previous Events
Today
Next Events
Subscribe to calendar
Google Calendar
iCalendar
Outlook 365
Outlook Live
Export .ics file
Export Outlook .ics file
Read More
SQLBits Training Day
ADF Mapping Flow
Did you use the Dataflow preview functionality in Azure Data Factory? This has recently be renamed to Mapping Data Flows.
All video’s which the ADF team has created, are collected.
Start Here:
ADF Data Flow: Overview
ADF Data Flow: Data Flow Scenarios
ADF Data Flows: Getting started
Getting started with ADF Data Flows from Altius
Getting started with Mapping Data Flows by Adam from Azure 4 Everyone
Debug and Prep:
ADF Data Flow: Debug Session, Pt 1
ADF Data Flow: Debug Session, Pt 2 Data Prep
ADF Data Flow: Debug and Test Lifecycle
Mapping and Wrangling: Data Exploration
Debug and testing End-to-End in Mapping Data Flows
Data Masking for Sensitive Data
Benchmark Timings
Dynamically optimize data flow cluster size at runtime
Transformations:
ADF Data Flows: Joins
ADF Data Flows: Pivot Transformation
ADF Data Flows: Window Transformation
ADF Data Flows: Alter Row Transformation
ADF Data Flows: Surrogate Key Transformation
ADF Data Flows: Lookup Transformation
ADF Data Flows: Aggregate Transformation
ADF Data Flows: Derived Column Transformation
ADF Data Flows: Union Transformation
ADF Data Flows: Unpivot Transformation
ADF Data Flows: Exists Transformation
ADF Data Flows: Filter Transformation
ADF Data Flows: Conditional Split Transformation
ADF Data Flows: Select and New Branch
ADF Data Flows: Flatten Transformation
ADF Data Flow Sources: CosmosDB
Fuzzy Lookups
Quick Transformations
Drifted Columns using Pivot
Source & Sink Transformations: Partitioned Files
ADF Data Flows: New Datasets Parquet and Delimited Text
JSON Transformations
Infer Data Types
Dynamic Joins and Lookups
Optimize:
ADF Data Flow: Monitoring UX
ADF Data Flow: Data Lineage
ADF Data Flow: Optimize Data Flows
ADF Data Flow: Iterate files with parameters
ADF Data Flow: Decrease start-up times
ADF Data Flow Perf: SQL DB
Optimize compute environment
Patterns:
ADF Data Flow: Staging Data Pattern
ADF Data Flow: Clean Addresses Pattern
ADF Data Flow: ETL DW Load Pattern
ADF Data Flow: Deduplication of your Data
ADF Data Flow: Merge Files
ADF Data Flow: SCD Type 1 Overwrite
ADF Data Flow: SCD Type 2 History
ADF Data Flow: Fact Table Loading
ADF Data Flow: Logical Models
ADF Data Flow: Detect source data changes
ADF Data Flow: Schema Drift Handling
Flexible Schema Handling with Schema Drift
ADF Data Flow: Parameters
Transform SQL Server on-prem with delta data loading pattern
SCD Type 1 and Type 2 demo by Bob Rubocki
Rule-based Mapping
Distinct Row & Row Counts
Handling truncation errors
Partition your files in the data lake
Intelligent data routing
Transform and Create Multiple Tables
Data Quality Patterns
Self-join patterns
Data lake file output options
Evolving database schema handling
Expressions:
Date/Time expressions
Split Arrays and Case Statement
Fun with string interpolation and parameters
Data Flow Script Intro: Copy, Paste, Snippets
Data Quality Expressions
Collect aggregate function
Do you want to know more or you want to try out some examples, you can find them here
Feel free to leave a comment
Rerun Pipeline activities in Azure Data Factory
Rerun Pipeline activities in ADF! As of today you can rerun or partially, yes you’re reading it correct partially, rerun you Azure Data Factory pipeline.Where you previously had to run the entire Pipeline again, you can now run a part of the Pipeline. This can save a...
SQLBits session: Microsoft Purview Data Policy App
SQLBits 2023 Thanks everyone for visiting my session during SQLBits. It's great to see such a full room and that so many people have started using Microsoft Purview. SLIDES The slides can be downloaded via the link below, so that you can view them again at...
Data Factory Pricing
Data Factory pricingAre you also having problems to understand the Pricing Model for Azure Data Factory? After some research on the internet I came across an article which I wanted to share with you. ADFV2 Pricing ExamplesFeel free to leave a comment
Azure Synapse Analytics Code Repository has arrived
Azure Synapse Analytics Code repositoryI just opened my Azure Synapse Analytics Workspace and got a great surprise, the option Git Configuration is available as of today. After a long wait, today the Git Configuration option became available in Azure Synapse...
Goodbye 2022, Hello 2023
Goodbye 2022Recap It's that time of year again to reflect on the past year. Also think it's really good, to see what you've done in the past year. It is also the time again to traditionally bake Oliebollen on this day, a Dutch Tradition that we do on New Year's Eve....
Restore a accidentally deleted Azure SQL Database
Help I deleted my Logical ServerOOPS Have you ever experienced that you accidentally deleted your Logical Server in Azure? Because, for example, you made your Pipeline wrong. Surely. And of course you didn't have a backup in your storage either.Well I must confess...
How to enable Microsoft Fabric
Microsoft FabricI got some questions from customers that didn’t know how to enable Microsoft Fabric and that they only see Power BI Items and not the new announced Experiences. In this short blog I will explain how you can easily enable Microsoft Fabric.How to enable...
Azure Synapse Analytics
Azure Synapse Analytics Insights for all Azure Synapse provides a breathtaking view of your data across data warehouses and big data analytics systems. Bringing these two worlds together into a single service is challenging as it requires unifying similar...
A new year with a new job
Changing jobsAfter almost 11 years and 4 months I have decided to leave Axians and to start a new adventure in the new year. On January 2, 2020 I will start my day as Lead Data and AI at InsparkThe past years have flown by. I started at Eniac BI, which was...
Microsoft Fabric pricing (Preview)
Microsoft Fabric PricingMicrosoft Fabric pricing in Public Preview is announced as of the 1 st of June.These are currently the Pay as You go pricing, later this year the Azure Reservation will follow. OneLake storage pricing is comparable to Azure ADLS (Azure Data...
Read MoreSQLBits Training Day
Azure Feature Pack for Integration Services
Azure Blob Storage
A great addition for SSIS is using extra connectors like Azure Blob Storage or Azure Data Lake Store which are added by the Azure Feature Pack. This Pack needs to be installed on your local machine. Are you running your SSIS packages in Azure? You don’t have to install anything, this pack is installed by default.
Building your SSIS Packages in Azure DevOps
After I started to use Azure Dev Ops to build my SSIS packages on a hosted VS2017, I got some strange error messages running these packages.
Microsoft Support
After contacting support we found out that the Azure Feature Pack is not installed on a Hosted VS2017 instance and that you need to add this installation to your build processes.
Install Azure Feature Pack on your Hosted VS2017 machine
Follow the steps to download and install the Azure Feature Pack:
Open your dev.azure.com/instance.
Create a new Build Pipeline or use an existing one.
Select the correct Sources and after that you can add a new build task.
Add a Powershell Task.
This task needs to be added before the build process of your SSIS project.
Define the Display name “Install Azure Feature Pack”.
Type => Inline.
Add the script which you can find below.
Save and Queue the Pipeline.
Check the Results.
Powershell script
The script will take care of downloading and installing the Azure Feature Pack for SSIS2017 on your hosted 2017 machine.
The File SsisAzureFeaturePack_2017_x64.msi will be downloaded to the system variable Build.StagingDirectory.
Inline script:
[code lang="ps"]
# Erwin de Kreuk
# February 2019
# PURPOSE: Install Azure Feature pack on Hosted VS2017 machine in Azure DevOps
Write-Information 'Starting ADF ARM Transform'
#Define Filename
$Filename = 'SsisAzureFeaturePack_2017_x64.msi'
$Arguments=' /qn'
Write-Host 'Downloading...$Filename'
#Define download link including filename and output directory with filename
Invoke-WebRequest -Uri 'https://download.microsoft.com/download/E/E/0/EE0CB6A0-4105-466D-A7CA-5E39FA9AB128/SsisAzureFeaturePack_2017_x64.msi' -OutFile '$(Build.StagingDirectory)\$Filename'
Write-Host 'Installing...$Filename'
Invoke-Expression -Command '$(Build.StagingDirectory)\$Filename $Arguments'
Write-Host 'Finished Installing...$Filename'
[/code]
The next time you build your SSIS Packages with the Azure Components, these packages are build correctly. Create a Release Pipeline to Deploy the SSIS Packages to the SSIS server and to test your Package.
Thanks for reading today and if there’re some questions left do not hesitate to ask them.
Latest Posts
Microsoft Purview Data Governance Public Preview Rolllout
How to use mssparkutils.notebook.runMultiple in Notebooks in Microsoft Fabric?
Video: Learn Live Use Data Factory pipelines in Microsoft Fabric
How to use the PySpark executor in Notebooks in Microsoft Fabric?
High Concurrency Notebook Activity in Microsoft Fabric
Feel free to leave a comment
Read More
SQLBits Training Day
Azure DevOps
More and more users are starting with Azure DevOps. Azure DevOps can be used for up to 5 users free of charge and is therefore a great start to start a project.
Build and Release
I will not describe what Azure DevOps can do, because that is too much to mention. In my future articles I want to take you into the challenges that I had in my projects during building and releasing of f.e. DataFactory, SSIS Packages, KeyVault, a number of recognizable Azure Services that are regularly used within Business Analytics projects.
If you want to use Azure Feature Pack components like Azure Blob Storage or Azure Data Lake Store in your SSIS Packages, I would definitely read the following article:
Azure DevOps and Azure Feature Pack for Integration Services
Feel free to leave a comment
Azure Purview Public Preview Starts billing
Billing for Azure Purview(Public Preview)As of January 20th 2021 0:00 UTC Azure Purview will starts billing.Preview From January 20 ,2021 Azure Purview will start billing. During the Public Preview, you will only be billed if you exceed the 4 capacity units for Azure...
Proud to be an ADF Hackathon winner!
Azure Data Factory HackathonAround the clock During the event 'Around the clock Azure SQL and Azure Data Factory' event on Feb 3, 2021, they kicked-off the Azure Data Factory (ADF) Hackathon. Recording of this event can be found here.Winner I submitted a ADF Pipeline...
High Concurrency Notebook Activity in Microsoft Fabric
Microsoft Fabric is a cloud-based platform that provides integrated data engineering and data science solutions. One of the key features of Microsoft Fabric is the support for Apache Spark, a distributed computing framework that enables large-scale data processing and...
Azure Purview March Updates
Azure Purview updatesAnnouncements Last week during SQLBITS, quite a few new updates were announced. I would like to include you in these announcements.March updates Support for SAP Business Warehouse (Preview) Blogpost:...
How to enable Microsoft Fabric
Microsoft FabricI got some questions from customers that didn’t know how to enable Microsoft Fabric and that they only see Power BI Items and not the new announced Experiences. In this short blog I will explain how you can easily enable Microsoft Fabric.How to enable...
My First Blog Post SQLSatHolland 790
Yeah, my first blog is LIVEAfter a good talk with Reza Rad from RADACAD during SQLSatHolland, I decided to start my first blog!Knowledge sharing is very important, it gives me a lot of energy. But it also gives others people in the community energies to pick up new...
Calculate the Last Day of the Month using SQL
Calculate the Last DayToday I needed to calculate the last day of the previous month for a Customer.Ever heard from the function EOMONTH? Searching on the web I came across a function I never heard from before EOMONTH, this function can be used as of SQL Server 2012....
Collection of all ADF Mapping Data Flow videos
ADF Mapping FlowDid you use the Dataflow preview functionality in Azure Data Factory? This has recently be renamed to Mapping Data Flows. All video's which the ADF team has created, are collected. Start Here: ADF Data Flow: Overview ADF Data Flow: Data Flow...
Book of News Microsoft Ignite 2019
Microsoft Ignite 2019MSIgnite 2019 has almost come to an end. A lot of new Annoucement have been released and presented. Would you also like to know which announcements have been made?Microsoft has released during MSIgnite a "Book of News". This book contains all new...
Yeah My website is Finally Live
Yeah, my first built website is LIVEThe last couple of weeks I've been working hard to design my website and finally the moment is there. My website live and I'm really proud. Building my own website The last couple of weeks/months I've been working hard... to...
Read More
SQLBits Training Day
Rerun Pipeline activities in ADF!
As of today you can rerun or partially, yes you’re reading it correct partially, rerun you Azure Data Factory pipeline.Where you previously had to run the entire Pipeline again, you can now run a part of the Pipeline. This can save a lot of time if many different activities are created within one pipeline. Another nice step forward, I’m curious what else is coming in the next months.
Visualized
Besides that you can rerun your Pipeline in Azure Data Factory in a easy way, you also have the possibilities to see your run, visualized in the Azure Data Factory Monitoring. This is a big improvement in my opinion.
Rerun a Pipeline
If you want to partially rerun a Pipeline, follow the steps below:Select the Pipeline which has failed, go to the view activity runs and select the activity which failed.
Click on the Rerun Icon
You need to confirm that you want to rerun this activity.
The Pipeline will start and will first skip all the activities(the grey new icons in the upper right corner of each activity) in the Pipeline before your selected Activity.Your Pipeline will now finalize all the activities from your newly defined starting point.
What else is new?
Monitor Rerun History
You can now view all the history reruns by clicking on the toggle to ‘View All Rerun History’.
By clicking on the red marked action, you can see all the History from an particular Pipeline run.
Thanks for reading.
Updated 10th of March:
Found a video on Channel9 which explains how to “Rerun activities inside your Azure Data Factory pipelines”
https://channel9.msdn.com/Shows/Azure-Friday/Rerun-activities-inside-your-Azure-Data-Factory-pipelines?ocid=player
Feel free to leave a comment
Are you using Azure DevOps?
Azure DevOpsMore and more users are starting with Azure DevOps. Azure DevOps can be used for up to 5 users free of charge and is therefore a great start to start a project. Build and Release I will not describe what Azure DevOps can do, because that is too much to...
10 Days of Azure Synapse Analytics
10 Days of Azure Synapse AnalyticsFor the next 10 days, every day a different topic is explained about Azure Synapse Analytics. The shortest and easiest way to see how Azure Synapse Analytics can help you, to make decisions within your data landscape.Day 1...
Azure Purview March Updates
Azure Purview updatesAnnouncements Last week during SQLBITS, quite a few new updates were announced. I would like to include you in these announcements.March updates Support for SAP Business Warehouse (Preview) Blogpost:...
Yeah My website is Finally Live
Yeah, my first built website is LIVEThe last couple of weeks I've been working hard to design my website and finally the moment is there. My website live and I'm really proud. Building my own website The last couple of weeks/months I've been working hard... to...
Azure Data Factory: Save a pipeline as a Template
Saving a PipelineAnother great improvement in Azure Data Factory. Saving you template!How can you save your template? First of all you need to connect your Azure Data Factory to a GIT integration. Both Azure DevOps GIT and GitHub are supported. Please follow this...
Custom comments in Azure Synapse Analytics
Add custom comments to your Azure DevOps and Github commitsFinally Finally and secretly hidden, we can now add a Comment to our commits in Azure Synapse Analytics and Azure Data Factory to Azure Dev Ops. How do you activate this custom comment option in your existing...
Azure Purview Public Preview Starts billing
Billing for Azure Purview(Public Preview)As of January 20th 2021 0:00 UTC Azure Purview will starts billing.Preview From January 20 ,2021 Azure Purview will start billing. During the Public Preview, you will only be billed if you exceed the 4 capacity units for Azure...
Updated competency exams and certifications Data Platform and Data Analytics for 2020
Retiring and new exams and certifications as of June 30 2020 A lot of Exams and certifications for Data Platform and Data Analytics are retiring on June 30 2020. All retired Exams and certifications will remain eligible for competency attainment and renewal until June...
My First Blog Post SQLSatHolland 790
Yeah, my first blog is LIVEAfter a good talk with Reza Rad from RADACAD during SQLSatHolland, I decided to start my first blog!Knowledge sharing is very important, it gives me a lot of energy. But it also gives others people in the community energies to pick up new...
Azure Synapse Analytics
Azure Synapse Analytics Insights for all Azure Synapse provides a breathtaking view of your data across data warehouses and big data analytics systems. Bringing these two worlds together into a single service is challenging as it requires unifying similar...
Read More