October=Speaking Month

by Erwin | Aug 28, 2019 | Events

Data Factory

DataSaturday Holland and DataMinds in Belgium

Like last year I have been selected again this year for both events to speak.

Cool to be able to speak at 3 different events within 7 days, but also to see many known people and to met new people.

Data Saturday

Data Saturday Holland is the new name for SQL Saturday Holland, The Microsoft Data Platform themed community event which will be held at a new location Pathé Leidsche Rijn.

This year I will for the first time join forces with Ahmed Mansour, Cloud Solution Architect @Microsoft

Session Title:

Help, I need to migrate my On Premise Database to Azure, which Database Tier do I have to choose from.

Session Details:

During this session we will walk you through all the different Tiers in Azure, DTU, Vcore, Serverless and Managed Instance and will provide examples when to use which Tier.
We will also show you the Microsoft Data Migration Assesment (DMA). This tool will help you to decide which tier you should choose. So if you need help or just interested in the different Azure Database Tiers then visit our session

Saturday October 5, 2019 16:00pm - 16:45pm

Room 4

Tickets are still available, so reserve your spot quickly.

DataMinds Connect

This year DataMinds Connect will be held in Lamot, a unique convention center located along the water, in the historic center of Mechelen.

Session Title:

Azure Key Vault, Azure Dev Ops and Data Factory how do these Azure Services work perfectly together!

Session Details:

Can we store our Connectionstrings or BlobStorageKeys or other Secretvalues somewhere else then in Azure Data Factory(ADF)? Yes you can! You can store these valuable secrets in Azure Key Vault(AKV). But how can we achieve this in ADF? And finally how do we deploy our DataFactories in Azure Dev Ops to Test, Acceptance and Production environments with these Secrets ? Can this be setup dynamically? During this session I will give answers on all of these questions. You will learn how to setup your Azure Key Vault, connect these secrets in ADF and finally deploy these secrets dynamically in Azure Dev Ops. As you can see a lot to talk about during this session.

Tuesday October 8, 2019 16:45pm - 17:45pm

Room Alcazar

No tickets yet, you can order them here!

Techorama NL

I will speaking during Techorama NL, I've written a post about this event a couple days ago, which you can find here

See you all in October on one of these events.

My Session at TechoramaNL 2019

TechoramaNL 2019 Date: 2 th October Location: Pathé Ede From September 30 th to October 2 nd TechoramaNL was held in the Netherlands for the 2nd time. TechoramaNL is the largest deep knowledge IT conference in the Netherlands with 1500 participants and 120 sessions in...

My sessions at Pass Data Community Summit

A hybrid conference in Seattle and online This year's PASS Data Community Summit is more than a conference – it's a homecoming. Reconnect with old friends, build new relationships, gain new skills, and get the world-class training you need to take that next step in...

Watch the MS Ignite sessions on-demand

MS Ignite Sessions MS Ignite 2020 was this year a virtual event. Most of the sessions were live in the evenings and the other sessions were available at different times in different time zones. Compliments to the MS Ignite team for organizing such a great event Most...

DataGrillen 2022

DataGrillen 2022 Microsoft Purview When we say: Data, bratwurst and beer, we are of course talking about DataGrillen. After more than 2 years of absence, it was time again in recent days, with speakers from all over the world with almost 50 sessions, good weather and...

My Virtual Session at SQLBits 2020

SQL BITS 2020, the greatest data show Last week was SQL BITS week. After the event was moved from April to September, it eventually became a Virtual event. Setting up a Virtual event requires a lot of adjustments in the Organization. Recording All regular sessions...

Data:Scotland

Data: Scotland 2022 Microsoft Purview Scotland’s Data Community Conference happened this year again in Glasgow. This years event was happening in a sunny Glasgow, more then 400 attendees and more then 50 sessions. It was great to see so many people live again. I...

Speaking(Virtual) at SQL Saturday #963 Denmark

SQL Saturday 963 Denmark PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. My...

DataMinds 2018

An event in the Footbal Arena from Gent! Two days after SQLSatholland it was time for DataMinds Connects, which was held in beautiful Belgian Ghent. The location for this event was in the stadium of KAA Gent. Because the organization of SQLSatHolland and DataMinds...

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

Speaking at SQLBits in London (postponed to September 2020)

SQLBits 2020 SQLBits is the largest Microsoft Data Platform conference in Europe taking place between 29nd September and 3rd October2020 at the Excel London. Proud to be speaking I am very proud and happy that one of my sessions was selected for SQLBits. It's not the...

Speaking at Techorama NL

by Erwin | Aug 19, 2019 | Events

Techorama = Deep Knowledge IT Conference

Techorama is a yearly international technology conference which takes place at Pathé Ede, Netherlands from September 30th until October 2nd. This will be the second year the event will be in held in the Netherlands. Last year more then 1100 people attend the Conference. This year the organisation expect around 1500 attendees.

Proud to be speaking

This year I will also speak at Techorama. I was very happy when I received a message at the end of April that my session was selected. Something to be very proud of.

Session Title:

Azure Key Vault, Azure Dev Ops and Data Factory how do these Azure Services work perfectly together!

Session Details

Wednesday October 2, 2019 10:00am - 11:00am

Room 5

Complete agenda

September 30th:

Workshops

October 1st and 2nd:

Sessions

No tickets yet, click here to reserve your spot. Hope to see you all at Techorama.

My Virtual Session DataSaturday #1 Pordenone

My Virtual Session DataSaturday #1 Pordenone DATA SATURDAY #1 PORDENONE This Saturday I've been speaking during DataSaturday #1 Pordenono. The first ever DataSaturday after Pass has retired. If you want to visit more Datasaturday events please visit the Data Saturdays...

Data Toboggan January 2022 (Video)

Recording of my session during the Data Toboggan January 2022 conference. Dealing with different roles in Azure Synapse Analytics

My sessions at Pass Data Community Summit

SQL SERVER KONFERENZ 2020

SQL SERVER KONFERENZ 2020 Date: 4-5 March Location: KongressCenter Darmstadt Speaking Dinner The speaker dinner on Tuesday evening was held in Restaurant Sitte. And yes what do you eat when you are in Germany a delicious Schnitzel with baked potatoes. It was a...

Data Community Austria

Unleashing the Potential of Metadata-Driven ELT Framework in Synapse Analytics and Microsoft Fabric Today, I had the opportunity to speak at the Data Community Austria Day 2024, a full day of sessions dedicated to data enthusiasts and professionals. The event was held...

My virtual session at Data Toboggan

Data Toboggan This Saturday I've joined the Data Toboggan to talk about Azure Synapse Analytics. Azure Synapse Analytics Today I've been talking on how to deal with all the different roles in Azure Synapse Analytics during Data Toboggan. An event 100% focussed...

Techoroma NL 2019

Techoroma NL 2019 Azure Key Vault, Azure Dev Ops and Azure Data Factory how do these Azure Services work perfectly together! Some impressions during Techorama NL 2019.

SQL BITS 2022 Session recordings

Recordings SQL Bits 2022 All sessions of SQLBits 2022 have been made available to everyone and can now be viewed via their Youtube channel. Microsoft asked me to present me this session during SQL Bits in the Cloud Scale Analytics solution area. Session Title: Lake...

Video: Learn Live Use Data Factory pipelines in Microsoft Fabric

Below you find the recording form the session for Learn Live which I did together with Javier. Use Data Factory pipelines in Microsoft Fabric Use Data Factory pipelines in Microsoft Fabric - Training | Microsoft Learn After you have followed above learning path you...

Speaking at Techorama NL

Techorama = Deep Knowledge IT Conference Techorama is a yearly international technology conference which takes place at Pathé Ede, Netherlands from September 30th until October 2nd. This will be the second year the event will be in held in the Netherlands. Last year...

ADF: Get Metadata Activity stopped working

by Erwin | Jul 1, 2019 | Azure, Azure Data Factory

Data Factory

by Erwin | Jul 1, 2019

Meta Data Activity

Today 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 output.structure couldn't be evaluated.

Field List

I don't know when this option was added, but if you open the Get Metadata Activity you will find under Dataset the option Field List

The only thing I needed to do get my previous output back was adding structure as an argument. The structure will take care of the Metadata of my table and will be used in the Copy Data Activity.

After rerunning my Pipeline the error was gone.

I changed all my pipelines and the processes where running fine again. I took me bit to find out what the exact error was.

Hopefully it will save you some time after reading this blog.

More about the Get Metadata Activity can be found here .

Feel free to leave a comment

SSMS 18.xx: Creating your Azure Data Factory SSIS IR directly in SSMS

by Erwin | Jun 18, 2019 | Sql Server Management Studio, Azure Data Factory

Creating your Azure Data Factory(ADF) SSIS IR in SSMS

Since version 18.0 we could see our Integration Catalog on Azure Instances directly.

Yesterday I wrote an article how to Schedule your SSIS Packages in ADF, during writing that article I found out that you can also created your SSIS IR(Integration Runtime) directly in SSMS.

I never saw the option before, it was always grayed out(because the SSISDB was already in Azure). But if you connect to an On Premise system it will not be grayed out.

An easy scenario to lift and shift your SSIS Packages to Azure, with a couple of steps you can create your SSIS IR.

Go to your Integration Services Catalog on your On Premise Server. Right Click and select the option "Try SSIS in Azure Data Factory" and click on Next.

Prerequisites

As Prerequisites you will need:

An Azure account.

An Azure SQL Database server or Managed Instance.

Configuration of your SSIS IR

Create SSIS IR in Azure wizard.

On the right upper corner you can log in to your Azure Subscription.

Select the correction Subscription, in case your have more subscription assigned to this account.

Select the Catalog Server where you want to install your SSIS IR on. This server cannot have an existing SSISDB.

Provide the necessary log in details and click on connect.

The last step is to Create your SSIS IR.

After you have clicked on Create, SSMS will do some validations and after these validations you will be asked to open the ADF Portal.

Azure Data Factory Portal

After you logged into the portal you will see a summary of the detail how your SSIS IR will be setup.

If you click on next your SSIS IR will be started.

Change Settings

To change any of the Parameters above you need to use the previous button. You can change:

Number of Parallel Executions Per Node

Custom Setup Container SAS URI

VNET

Node Size

License

The name of your SSIS IR and Resource Group are create by the setup and cannot be changed.

The Resource Group for example is created in the Region US-East.

Conclusion

It is a simple way to setup your SSIS IR in Azure, but I do prefer do this my self trough the Azure Portal or automated with a PowerShell script.

SSMS 18.1: Schedule your SSIS Packages in Azure Data Factory

by Erwin | Jun 17, 2019 | Azure, Azure Data Factory, Sql Server Management Studio

Schedule your SSIS Packages with SSMS in Azure Data Factory(ADF)

This week SQL Server Management Studio version 18.1 was released, which can be downloaded from here.

In version 18.1 the Database diagrams are back and from now on we can also schedule SSIS Packages in ADF via SSMS.

Select the package you want to schedule in your Integration Services Catalog,

Create the schedule you want to create and click on OK.

Your schedule will be created in Azure Data Factory.

Azure Data Factory

In Azure Data Factory a pipeline and trigger are created automatically

Azure Dev Ops

Scheduling your SISS packages is not working fine when you have Azure Dev Ops Enabled. Pipeline and Trigger are published to the Data Factory instead of Azure DevOps GIT as you can see below.

My advice will be to build your schedule/trigger directly in Azure Data Factory when you 're using Azure Dev Ops.

In case you have any questions left, do not hesitate to ask them. I'm more then happy to answer them.

« Older Entries

Next Entries »

Data Factory

DataSaturday Holland and DataMinds in Belgium

Like last year I have been selected again this year for both events to speak.

Cool to be able to speak at 3 different events within 7 days, but also to see many known people and to met new people.

Techorama NL

Techorama = Deep Knowledge IT Conference

Proud to be speaking

Complete agenda

Data Factory

Meta Data Activity

Today 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

Field List

Feel free to leave a comment

Creating your Azure Data Factory(ADF) SSIS IR in SSMS

Prerequisites

Azure Data Factory Portal

Change Settings

Schedule your SSIS Packages with SSMS in Azure Data Factory(ADF)

Azure Data Factory

Azure Dev Ops

Categories