LEAP 2018

LEAP 2018

Erwin

by Erwin | Dec 18, 2018

Lead Enterprise Architect Program

From 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 diversity of speakers and Program Managers.

 

Amsterdam Seattle

After a long flight of 11 hours from Amsterdam to Seattle, we arrived around 13:00 on Sunday December 2nd. Since we have also gone back 9 hours, it is important to stay awake for as long as possible. So that we have less trouble with our Jetlag the following days(hopefully).

Jetlag

Fortunately we have one day of rest before Leap starts on Tuesday. The Monday we spend in Seattle. Starting the day with a nice breakfast at Pike Place.

After breakfast we went for a long walk trough downtown Seattle. In the afternoon we did a Locks tour by boat. A wonderful activity to get through your jetlag with a great view from Seattle. In the evening we end up in the Pike Brewery where we have met more Leap participants.

Finally it is Tuesday, Start of LEAP

After I have seen almost every hour on the clock during the night, I woke up early. The bus was leaving the hotel at 7:15 to the Microsoft Campus in Redmond where we were expected in the EBC (Executive Briefing Center) for breakfast.

Business - Technical

In the morning we have tracks with the whole group, in the afternoon we split up in Business and Technical tracks. The first day is dedicated to various sessions about Azure, DevOps and Digital Transformation for Partners. In the afternoon I have followed the technical sessions where we talked about DevOps, DataBricks and DataLake. Super cool to see how open all Program Managers are. All sessions are dedicated to questions that we have and which were all answered well. We ended the day with a group dinner.

Day 2

Day 2 is kicked off by Rohan Kunar, CVP Azure Data, followed by a session on AI and Serverless Architecture. In the afternoon we talked this time about IOT and Machine Learning. We closed the evening with dinner in a Brazilian Restaurant, the atmosphere was great and some participants will remember this evening for the time being.

What happened in Seattle stays in Seattle!

3 Wonderful days are coming to an end

The last day we started with a White Board session of the Distinguished Architect of Microsoft, a beautiful session in which many topics about the use and the future of data.
We closed the morning with a Technical session about the Power Platform.

Seattle by Night

After a few hours of rest, yes the jet lag still works, we finalized the day in Seattle with some other participants with a drink at the Taphouse Grill, if you are in Seattle, a must to visit, they have more than 150 beers on tap. For dinner we end up in the CheeseCake Factory.

I had 3 top days, thanks for the organization and the super nice program. Personally, I got a lot of energy out of these days and good to see that we are on the right track as Axians.

See you next time.

Feel free to leave a comment

Service Healths in Azure

Erwin

by Erwin | Dec 14, 2018

Creating Service Health Alerts in Azure

Azure Portal

In the Azure Portal go to Monitor – Service Health – Health alerts

Service_Alert_1

If you have created alerts before you will see them over here. Assuming you haven’t created an Alert before, we will start to create an Alert.

1 Define Alert Condition:

Service_Alert_2

Select the correction Subscription

Select the Azure Services where you want to get an Alert for

Select the Azure Region

And for this Alert Condition we will select only the Service issue as the Event Type.

2 Define Alert Details

Service_Alert_5

Define Alert Rule name CustomerName – Service Issue Alert

Define Description

Select the Resource Group where you want to save this Alert. I’ve created a seperate Resource Group where I store everything which is related to Monitoring of my Azure Environment.

3 Define Action Group

The last step of the alert Creation is to setup how we want to notify people. I the example below I will care take about the  Action Group Type Email/SMS/Push/Voice

 

 

 

 

 

 

 

 

Fill in your email address

 

 

 

 

 

Fill in your email address and make your sure you install the Micrsosoft Azure app on your phone to receive push messages.

 

 

 

 

 

 

 

 

You also have the possibility to define multiple Action Groups.

Next time I will write how to change your Action Group to add or remove Members.

Thanks so much for reading through this article today, and I hope you all take some time to try it out. It's will make your life easier.

Feel free to leave a comment

Service Health Alerts in Azure

Service Health Alerts in Azure

Maintenance and Service Healths in Azure

I get often questions, is there no maintenance in Azure. Like every data center, the Azure data center also needs maintenance. You can even be notified when a specific service, in a specific data center, has scheduled maintenance so that you will not be surprised.

 

Do you want know how to setup up these Service Health Alerts? Please click on the link below.

Service Healths in Azure

DataMinds 2018

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 worked well together, top speakers where
present again.

Great event for Speakers

Nice detail, the speaker room was in the Presidential SkyBox with a very nice view in the Stadium.20181015_08325720181015_082654

And every speaker had his own football shirt.
During this event I talked about Migrating your On Premise database to Azure SQL Data Warehouse

 

 

Migrate to Azure SQL DataWareHouse

Have you ever tried to migrate your DataWareHouse (DataVault) solution to a Azure SQL DataWareHouse? Azure SQL DW is a MPP system and requires a lot of changes to your current solution.
What are the best practices for Migrate your solution? Why should you migrate to a Azure SQL DW? I did, and would like to share my experience. During the session I spoke about Distribution keys, Replicated Tables, identity Colums, CTAS, scaling, pausing, monitoring and much more.

Great Feedback

The session was well attended and the feedback was very good afterwards. I'm enjoying every time again to share my knowledge with the Community. Speaking at events always gives me a lot of energy.

Organisation

Compliments to the organizers Benni, Stijn and Frederik

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

My Virtual Session DataSaturday #1 Pordenone

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

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

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

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

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 2020(Video)

All sessions of SQLBits 2020 have been made available to everyone and can now be viewed via their Youtube channel. To make it easier to find a recording of your choice, a number of playlists have been created: Developer SQLBits 2020 - Developer sessions High...

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

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

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

My First Blog Post SQLSatHolland 790

My First Blog Post SQLSatHolland 790

Erwin

by Erwin | Oct 15, 2018

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 activities. That is the main reason to start this blog.

Now back to SQLSatHolland, which was held on October 13th in Utrecht. This free event is very well attended and with 550 attendees it is one of the largest SQLSaturday’s in the world. Not everyone who registered did show up, but that was mainly due to the extremely hot weather in the Netherlands, 28 degrees in October.

International top speakers
This year there were again international Top speakers to Utrecht, compliments for the organizers André, Peter and Joost and many others. Organizing such a big event is already a challenge, but finding international speakers is not easy either.

Azure Data Factory V2
This year my session was about Migrating to Azure SQL DataWarehouse with Azure Data Factory V2, this was the first time I presented this session, so extra exciting for me. You can find the session details here 

Enthusiastic audience
The session went very well and the room was crowded. You can be very exited about your session, but it is always the question whether others like your session as well.

I got some nice compliments after the session and that is one of the reasons you end up doing it

It was a great day, spoke to a lot of people, see you next year.

 

Feel free to leave a comment