My Sessions at DataSaturdayNL 2019

by Erwin | Oct 13, 2019 | Divers

Azure

by Erwin | Oct 13, 2019

DataSaturday NL 2019

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

Speaking Dinner

The speaker dinner on Friday evening started with a climb of the Dom tower in Utrecht. Unfortunately, due to the renovation, we were unable to reach the top entirely, but we have achieved the 318 steps upwards. At the same time we were briefed about the history of this tower. After the climb we had a nice dinner together.

Event

Saturday the day of the event started early, the event was sold out with 750 tickets. Due to illness of 1 of the speakers I was asked to give an extra session. It's always an honor when they ask you to do an extra session. There was not much time left to prepare, but it worked out eventually. After this session the other session followed immediately. I did this session together with Ahmed Mansour. I had never did co-present a session before, but I really enjoyed it and will certainly do this more often. It brings a lot of variety during a session, but the session also becomes more interactive. In addition, the fun Ahmed and I had during the preparations was definitely worth it.

Thank you

Thanks again to the organization and the crew, and of course all sponsors because without sponsors it is almost impossible to organize such a big event. As usual, it was another top event and I am already looking forward to next year.

The presentations of DataSaturdayNL and sample code can be found here.

DataSaturdayNL 2019 Azure Key Vault, Azure Dev Ops and Azure Data Factory how do these Azure Services work perfectly together! from Erwin De Kreuk

Help, I need to migrate my On Premise Database to Azure, which Database Tier do I have to choose from (DataSaturday NL 2019 Erwin de Kreuk / Ahmed Mansour) from Erwin De Kreuk

Recorded Sessions

This is the first time I have recorded a session. Nice to see again, but also to learn from it again.

Feel free to leave a comment

My Session at TechoramaNL 2019

by Erwin | Oct 12, 2019 | Events

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 2 days. With more than 1000 submitted sessions, the selection was very difficult. I was therefore very proud that my Session was selected.
Decoration, catering, speaker room, reception, parking, communication and speaker dinner were well organized. Hereby a compliment to the organization, volunteers, ministry and of course all sponsors because without sponsors it is almost impossible to organize such a big event.
Thank you for inviting me and hopefully until next year.
Pictures of the event can be find here.

The presentations of TechoramaNL and sample code can be found here.

TechnoramaNL Azure Key Vault, Azure Dev Ops and Azure Data Factor from Erwin De Kreuk

Below are some impressions of the session which as been filmed by Reitse Eskens @2meterDBA:

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

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 DataWeekender 4.2

DataWeekender 4.2 This Saturday I've joined the Van and Spoke at DataWeekender Azure Purview I presented a session on Azure Purview Microsoft's answer to Data Governance and Data Lineage You can find my slides below on Slideshare: Data weekender4.2 azure purview erwin...

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

My first Virtual session in 2022 for Dataminds

DataMinds This Tuesday I've joined the DataMinds user Group to talk about Azure Purview. Azure Purview It was the first session of the year for both me and DataMinds. Some great questions during the session, thank you for that. You can find my slides below on...

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

Data Toboggan January 2022 (Video)

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

October=Speaking Month

by Erwin | Aug 28, 2019 | Events

Azure

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.

Speaking at SQLBits in London (postponed to September 2020)

Video: Learn Live Use Data Factory pipelines in Microsoft Fabric

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 Virtual Session Scottish Summit 2021

Scottisch Summit 2021 This Saturday I've been speaking during Scottisch Summit 2021. It was my first Summit, but is was a great event, with more than 400 sessions covering the full Microsoft Stack in 7 different language English, Spanish, German, French, Italian,...

Speaking at SQL BITS 2022

SQL BITS 2022 We’re Hitting the Arcade SQL Bits is back this year in London from March 8-12 2022. SQLBits is the largest data conference in the world and this year's theme is to bring us back to our incandescent youth, so prepare to level up your data skills and reach...

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

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

My First Blog Post SQLSatHolland 790

Yeah, my first blog is LIVE After 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...

Speaking at Techorama NL

October=Speaking Month

$variable({"type":"content","value":{"name":"post_title","settings":{"before":"","after":""}}})$ 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...

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.

Data Saturday #1 Pordenone(Video)

Recording of my session during Data Saturday #1 Pordenone Azure Purview Microsoft's answer to Data Governance and Data Lineage

Data Saturday Stockholm

Data Saturday Stockholm Bra så alla tillbaka personligen This means great so everyone back in person. Last weekend I had the honor to speak at Data Saturday in Stockholm. About one of my favourite topics Azure Synapse Analytics. It was nice to see everyone in person...

October=Speaking Month

My Session at DataMindsConnect 2019

DataMindsConnect 2019 Date: 7 and 8 th October Location: Lamot Mechelen Conference number 3 within 7 days and this time in Mechelen.The location for this conference is in an old beer brewery in the center of Mechelen. Datamindsconnect is the largest Dataplatform event...

Speaking at SQL Server Konferenz 2020

SQL Server Konferenz SQL Server Konferenz 2020 is a international Conference which is held each year in Darmstadt, Germany. Trilled to be speaking This year I will speak and attend SQL Server Konferenz 2020 from March 3th until March 5th. I was very happy when I...

My Virtual session DataWeekender 4.2

Speaking at SQL BITS 2022

Speaking(Virtual) at SQL Saturday #963 Denmark

My First Blog Post SQLSatHolland 790

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

ADF: Get Metadata Activity stopped working

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

Azure

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.

Azure

DataSaturday NL 2019

Speaking Dinner

Event

Thank you

Recorded Sessions

Feel free to leave a comment

TechoramaNL 2019

Azure

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

Azure

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

Categories