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

Loading view.

There were no results found for this view. Jump to the next upcoming events.

Events Search and Views Navigation

Search

Enter Keyword. Search for Events by Keyword.

Find Events

Event Views Navigation

Month

List

Month

Day

This Month

2024-05-12

May 2024

Select date.

Calendar of Events

M

Mon

T

Tue

W

Wed

T

Thu

F

Fri

S

Sat

S

Sun

0 events,

29

0 events,

29

0 events,

30

0 events,

30

0 events,

1

0 events,

1

0 events,

2

0 events,

2

0 events,

3

0 events,

3

0 events,

4

0 events,

4

0 events,

5

0 events,

5

0 events,

6

0 events,

6

0 events,

7

0 events,

7

0 events,

8

0 events,

8

0 events,

9

0 events,

9

0 events,

10

0 events,

10

0 events,

11

0 events,

11

0 events,

12

0 events,

12

0 events,

13

0 events,

13

0 events,

14

0 events,

14

0 events,

15

0 events,

15

0 events,

16

0 events,

16

0 events,

17

0 events,

17

0 events,

18

0 events,

18

0 events,

19

0 events,

19

0 events,

20

0 events,

20

0 events,

21

0 events,

21

0 events,

22

0 events,

22

0 events,

23

0 events,

23

0 events,

24

0 events,

24

0 events,

25

0 events,

25

0 events,

26

0 events,

26

0 events,

27

0 events,

27

0 events,

28

0 events,

28

0 events,

29

0 events,

29

0 events,

30

0 events,

30

0 events,

31

0 events,

31

0 events,

1

0 events,

1

0 events,

2

0 events,

2

There were no results found for this view. Jump to the next upcoming events.

There are no events on this day.

Apr

This Month

Jun

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

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

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

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

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

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(Virtual) at SQL Saturday #963 Denmark

SQL Saturday 963 DenmarkPASS 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 first...

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

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

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

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

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

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

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 Synapse Analytics Code Repository has arrived

Azure Synapse Analytics Code repository‎I 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...

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

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

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

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

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

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

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

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

Speaking at SQLBits in London (postponed to September 2020)

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

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

October=Speaking Month

DataSaturday Holland and DataMinds in BelgiumLike 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...

My virtual session at Data Toboggan

Data TobogganThis 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 on...

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

SQL SERVER KONFERENZ 2020

SQL SERVER KONFERENZ 2020Date: 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...

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

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

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

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

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

Speaking(Virtual) at SQL Saturday #963 Denmark

SQL Saturday 963 DenmarkPASS 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 first...

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

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

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