Events from March 19 – October 7, 2023 – Page 3

Azure Data Factory: Generate Pipeline from the new Template Gallery

Loading view.

Events Search and Views Navigation

Search

Enter Keyword. Search for Events by Keyword.

Find Events

Event Views Navigation

List

Month

Day

Today

2024-02-08

February 8

-

2024-06-13

June 13

Select date.

February 2024

Thu

8

February 8

Fabric February

Microsoft Norway,

Dronning Eufemias gate 71, Oslo, Norway

March 2024

Tue

19

March 19

SQLBits Training Day

Farnborough International Ltd,Show Centre

P S Rd, Farnborough, Farnborough, United Kingdom

Wed

20

March 20 - March 23

SQL Bits General Sessions

Farnborough International Ltd,Show Centre

P S Rd, Farnborough, Farnborough, United Kingdom

Sun

24

Featured

March 24 - March 30

Microsoft Fabric Community Conference

MGM Las Vegas

3799 S. Las Vegas Blvd., Las Vegas, Nevada, Nevada, United States

May 2024

Tue

14

Featured

May 14 @ 8:00 am - May 15 @ 5:00 pm CEST

SQL Day 2024

Centennial Hall

Wroclaw, Poland

Thu

16

Featured

May 16 @ 8:00 am - May 17 @ 5:00 pm CEST

DataGrillen

IT Zentrum Lingen

Kaiserstraße 10b, Lingen, Germany

Sat

25

Featured

May 25 @ 8:00 am - 5:00 pm CEST

DATA SATURDAY STOCKHOLM

Telia head office campus

Stjärntorget 1, Stockholm, Sweden

June 2024

Mon

3

June 3 - June 5

Power BI Cruise

Silja Serenade

Stockholm, Sweden

Sat

8

June 8

Data Saturday Croatia

Hotel International

Zagreb, Croatia (Local Name: Hrvatska)

Thu

13

Featured

June 13 @ 8:00 am - June 14 @ 5:00 pm CEST

Data Platform Next Step

HUONE Copenhagen

Amager Strandvej 390, 2770, Kastrup, Denmark

Previous Events

Today

Next Events

Subscribe to calendar

Google Calendar

iCalendar

Outlook 365

Outlook Live

Export .ics file

Export Outlook .ics file

Collection of all ADF Mapping Data Flow videos

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

Parameterize Linked Services in ADF

Parameterize Linked Services For my Azure Data Factory solution I wanted to Parameterize properties in my Linked Services. Not all properties are Parameterized by default through the UI. But there's another way to achieve this. Linked Service Open your existing...

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....

Microsoft Build 2022 Book of News

Microsoft Build 2022MSBuild 2022 has just started. A lot of new Announcement will be released or demonstrated the upcoming days. Like every year or event most of these announcement are added to the Book of News.The book of news can be downloaded from the link below...

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 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:...

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

How to check your SQL Server Quota in Azure?

Azure Subscription Usages for SQL Server Last week we reached our Logical server Quota in Azure. By default you're only allowed to add 20 Logical Servers, but we wanted to have some more for testing purposes.Microsoft Support You can submit a support ticket trough...

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...

My Sessions at DataSaturdayNL 2019

DataSaturday NL 2019Date: 5 th October Location: Pathé Leidsche Rijn Data Saturday Holland is the new name for SQL Saturday Holland. A new start a new location and wow what a top location, Pathé Leidsche Rijn. A cinema with 7 screens and ranging from 180 to 668 seats....

Azure DevOps and Azure Feature Pack for Integration Services

SQLBits 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

Are you using Azure DevOps?

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 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...

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...

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...

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....

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

How to use concurrency in Azure Synapse pipelines?

How to prevent concurrent pipeline execution?Concurrency This week I had a discussion with a colleague about how we can now make sure that a Pipeline does not start when it's already started. He then indicated, have you ever thought of the concurrency option? I've...

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...

Parameterize Linked Services in ADF

Parameterize Linked Services For my Azure Data Factory solution I wanted to Parameterize properties in my Linked Services. Not all properties are Parameterized by default through the UI. But there's another way to achieve this. Linked Service Open your existing...

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...

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...

Rerun Pipeline activities in Azure Data Factory

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

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...

Enable Pattern Rules in Azure Purview

How can I enable Pattern Rules?Pattern Rules Last night I was preparing for a demo with Azure Purview. As always, I walk through all the activity hubs to see if there are any new options. This time I noticed that the Pattern Rules option was greyed out. Resource Set...

Azure Purview MSIgnite Spring 2021 Announcements

Azure Purview Ignite 2021 AnnoucementPricing This week the Azure Purview announced that they will extend the Azure Purview offer to provision 4 Capacity Units of the Data Map for free till May 31, 2021! Charging will start on June 1, 2021. Great news for customer who...

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...

Goodbye 2020 Hello 2021

Goodbye 2020 Started to work for InSpark Last year was certainly an eventful year. Started with a new job at InSpark and after 10 weeks we all know what happened, the first intelligent lockdown. The Netherlands was partially locked, but our office was immediately...

ADF: Get Metadata Activity stopped working

Meta Data ActivityToday my pipelines in Azure Data Factory (ADF) suddenly stopped working. The output structure was not found. Quit strange while these pipelines have been running for weeks. Invalid Template After debugging my Pipeline I found out the...

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...

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...

How to use concurrency in Azure Synapse pipelines?

How to prevent concurrent pipeline execution?Concurrency This week I had a discussion with a colleague about how we can now make sure that a Pipeline does not start when it's already started. He then indicated, have you ever thought of the concurrency option? I've...

Control my Nest Thermostat on my Domoticz Server running on a Synology DiskStation

Control your Nest Thermostat in DomoticzNormally I always write Azure related, but today I'm writing about something different, on how I can control my Nest Thermostat on my Domoticz Server (Home automation). A while ago I have upgraded my Nest Thermostat to login...