Past Events from October 7, 2019 – July 19, 2020 – Page 5

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

Loading view.

Events Search and Views Navigation

Search

Enter Keyword. Search for Events by Keyword.

Find Events

Event Views Navigation

List

Month

Day

Today

2019-10-07

October 7, 2019

-

2020-07-19

July 19, 2020

Select date.

October 2019

Mon

7

October 7, 2019 - October 8, 2019

DataMinds Connect 2019

Congres- en Erfgoedcentrum Lamot

Van Beethovenstraat 8-10, Mechelen, Belgium

€325 – €375

November 2019

Mon

4

November 4, 2019 - November 8, 2019

Pass Summit 2019

Washington State Convention Center

705 Pike Street, Seattle, WA, United States

Mon

4

November 4, 2019 - November 8, 2019

Microsoft Ignite

Orange County Convention Center

Orlando, FL, United States

January 2020

Fri

24

January 24, 2020

Azure Lowlands

Erasmus University

Burgemeester Oudlaan 50, Rotterdam

March 2020

Tue

3

March 3, 2020 - March 5, 2020

SQLKonferenz

KONGRESSCENTER DARMSTADT, GERMANY

Schlossgraben 1, Darmstadt, Germany

Wed

11

March 11, 2020 - March 12, 2020

Microsoft lgnite The Tour Amsterdam

RAI Amsterdam

Europaplein 24, Amsterdam, Netherlands

May 2020

Tue

5

May 5, 2020

Microsoft Business Applications Summit(Workshop Day)

Dallas

TX, United States

Euro500

Wed

6

May 6, 2020 - May 7, 2020

Microsoft Business Applications Summit(Virtual)

Dallas

TX, United States

euro 995

Tue

19

May 19, 2020 - May 21, 2020

Microsoft Build

Washington State Convention Center

705 Pike Street, Seattle, WA, United States

July 2020

Sun

19

July 19, 2020 - July 23, 2020

Microsoft Inspire

Mandalay Bay Convention Center

3950 S Las Vegas Blvd, Las Vegas, Nevada

Previous Events

Today

Next Events

Subscribe to calendar

Google Calendar

iCalendar

Outlook 365

Outlook Live

Export .ics file

Export Outlook .ics file

Datagrillen: Data, Bratwurst und Beer

Power BI Cruise

Data, Bratwurst and Beer

An event that started 5 years ago as a small event, that has grown into an event with 200 participants, 50+ sessions, 5 tracks, 2 days and a BBQ in a small place in Germany, called Lingen. William Durkin and Ben Weissman are the main organizers, but are supported by a bunch of volunteers and supported by a great group of sponsors.

Speaker/Volunteer diner
Wednesday the event started for me with a drink in Hotel Lobby and with a great dinner in the Alte Posthalterei. We had a great evening, met some old friends and made some new friends.

Sessions

The first day started early, we helped preparing the badges and did the check in. Around 9:00 am almost every attendee was in and ready for the Keynote. During the keynote there was a special welcome to all the newcomer Speakers and their mentors. This newcomer track is designed to accommodate people new to presenting. In my opinion this newcomer tracks should be introduced to all events.
During these 2 days there were 5 sessions divided over 5 tracks on both days. I have attended many nice sessions, but I have certainly gained a lot of new inspiration out of these sessions.

Day 1 ended with the traditional bbq. Personally, I love bbq a lot and know that it is hard work to get a bbq for 200 people, but the catering did very well. Compliments to the catering.
During the days I have spoken to many people, both well-known and also many new ones. From Axians we joined this event with 3 people.
We are 1 large #sqlfamily.

Rafle time
After 2 tiring days, the event was traditionally closed on Friday by William and Ben with the raffle. And that was for me also the end of 2 great days and I could start with my home trip.

Sponsors
Thank you Solisyon, Datamasterminds, SentryOne, PowerBi Sentinel, dbWatch, Rosen, Shop Apotheke Europe, Redgate, Hedda and IT Emsland without you the event wasn’t free, there where no drinks and there was no food.
Next Year
Next year the event will take place on may 28 and may 29.
Call for Speakers is open https://sessionize.com/datagrillen-2020/
See you next year. And once again thank you William and Ben for organizing

Feel free to leave a comment

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. Feel free to leave a comment

My Session at TechoramaNL 2019

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

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

My Virtual Session Cloud Lunch and Learn Marathon

Cloud Lunch and Learn Marathon 2021This Thursday May 13th 2021 I've been speaking during Cloud Lunch and Learn Marathon 2021. It was the first Cloud Lunch and Learn Marathon conference, more then 1200 registered attendees, 24hours Live and pre recorded sessions....

Datatoboggan 2021(Video)

Recording of my session during Data Toboggan 2021 Azure Purview Microsoft's answer to Data Governance and Data LineageFeel free to leave a comment

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

Watch the MS Ignite sessions on-demand

MS Ignite SessionsMS 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 of...

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

SQLBITS 2022

SQL BITS 2022 What a great time I had Wednesday 9th of March the time had finally come, at 1830 my plane would leave for London City. After all the preparations over the past few weeks, the time was there. After arriving in London City and checking in at the hotel, I...

Datagrillen: Data, Bratwurst und Beer

Data, Bratwurst and BeerAn event that started 5 years ago as a small event, that has grown into an event with 200 participants, 50+ sessions, 5 tracks, 2 days and a BBQ in a small place in Germany, called Lingen. William Durkin and Ben Weissman are the main...

ADF: Get Metadata Activity stopped working

Power BI Cruise

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

LEAP 2018

Lead Enterprise Architect ProgramFrom the 4th of December until the 6th of December I've joined the LEAP (Lead Enterprise Architect Program) 2018 Data/AI from Microsoft NL. Three days on the Microsoft Campus in Redmond joining business and technical sessions from a...

Calculate Workingdays including Holidays with T-SQL

Calculate Workingdays between 2 Date columnsRecently I have been getting some questions from my customers, can I calculate the number of workdays between 2 dates? Of course my answer was, yes you can. But I do want certain closing dates and holidays of our company not...

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

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

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

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

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

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

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

Speaking at Techorama NL

Power BI Cruise

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

Feel free to leave a comment

Datagrillen: Data, Bratwurst und Beer

Data, Bratwurst and BeerAn event that started 5 years ago as a small event, that has grown into an event with 200 participants, 50+ sessions, 5 tracks, 2 days and a BBQ in a small place in Germany, called Lingen. William Durkin and Ben Weissman are the main...

Datatoboggan 2021(Video)

Recording of my session during Data Toboggan 2021 Azure Purview Microsoft's answer to Data Governance and Data LineageFeel free to leave a comment

Data Toboggan January 2022 (Video)

Recording of my session during the Data Toboggan January 2022 conference. Dealing with different roles in Azure Synapse AnalyticsFeel free to leave a comment

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 Feel free to leave a comment

DataSaturday NL 2019

Recording of my session on DataSaturdayNL 2019 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...

My Session at DataMindsConnect 2019

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

Scottisch Summit 2021(Video)

Recording of my session during Scottisch Summit 2021 Is there a way that we can build our Azure DataFactory all with parameters based on MetaData?Feel free to leave a comment

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 DataSaturday #14 Oslo

DATA SATURDAY #14 OSLOThis Saturday I've been speaking during DataSaturday #4 Oslo. If you want to visit more Datasaturday events please visit the Data Saturdays event page.Azure Purview I presented a session on Azure Purview Microsoft's answer to Data Governance and...

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

October=Speaking Month

Power BI Cruise

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.

Feel free to leave a comment

My Virtual session at Data Toboggan

An inaugural event specializing on Azure Synapse AnalyticsData Toboggan This Saturday I've been speaking during Data Toboggan an inaugural event specializing on Azure Synapse Analytics. 12 Hours of sessions with amazing speakers.Azure Purview I presented a session...

My Virtual Session Cloud Lunch and Learn Marathon

Cloud Lunch and Learn Marathon 2021This Thursday May 13th 2021 I've been speaking during Cloud Lunch and Learn Marathon 2021. It was the first Cloud Lunch and Learn Marathon conference, more then 1200 registered attendees, 24hours Live and pre recorded sessions....

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 DataSaturday #1 Pordenone

DATA SATURDAY #1 PORDENONEThis 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 event page.Azure Purview I presented a...

The new and refreshing Azure Data Factory home page

The Data Factory home page has been redesigned for a modern and more accessible (WCAG 2.1) experience. The new design is more fluid with better contrast and reflow capabilities. Thank you to the complete product team for this great experience The new and refreshing...

Datagrillen: Data, Bratwurst und Beer

Data, Bratwurst and BeerAn event that started 5 years ago as a small event, that has grown into an event with 200 participants, 50+ sessions, 5 tracks, 2 days and a BBQ in a small place in Germany, called Lingen. William Durkin and Ben Weissman are the main...

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

Speaking at Techorama NL

Techorama = Deep Knowledge IT ConferenceTechorama 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...

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

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