My First Blog Post SQLSatHolland 790

« All Events

This event has passed.
Microsoft Build

May 19, 2020 - May 21, 2020

« Microsoft Business Applications Summit(Virtual)
Microsoft Inspire »

Add to calendar

Google Calendar

iCalendar

Outlook 365

Outlook Live

Details

Start:

May 19, 2020

End:

May 21, 2020

Venue

Washington State Convention Center

705 Pike Street

Seattle,

WA

98101

United States

+ Google Map

« Microsoft Business Applications Summit(Virtual)
Microsoft Inspire »

Read More

DataMinds 2018

Microsoft Build

by ErwinDec 10, 2019

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

Feel free to leave a comment

0 Comments

Submit a Comment Cancel replyYour email address will not be published. Required fields are marked *Comment * Name *
Email *
Website
Please enter an answer in digits:2 × 5 = Submit Comment

Δ
This site uses Akismet to reduce spam. Learn how your comment data is processed.

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

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

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

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

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

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

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

Read More

Service Health Alerts in Azure

Microsoft Build

by ErwinDec 10, 2019

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

Feel free to leave a comment

0 Comments

Submit a Comment Cancel replyYour email address will not be published. Required fields are marked *Comment * Name *
Email *
Website
Please enter an answer in digits:7 − two = Submit Comment

Δ
This site uses Akismet to reduce spam. Learn how your comment data is processed.

A new year with a new job

Changing jobsAfter almost 11 years and 4 months I have decided to leave Axians and to start a new adventure in the new year. On January 2, 2020 I will start my day as Lead Data and AI at InsparkThe past years have flown by. I started at Eniac BI, which was...

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

Collection of all ADF Mapping Data Flow videos

ADF Mapping FlowDid you use the Dataflow preview functionality in Azure Data Factory? This has recently be renamed to Mapping Data Flows.  All video's which the ADF team has created, are collected. Start Here: ADF Data Flow: Overview ADF Data Flow: Data Flow...

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 Data Factory: New functionalities and features

New functionalities and featuresLast week, a number of great new functionalities and features were added within Azure Data Factory. I would like to take you in some details in the blog below:Customer key With this new functionality you can add extra security to your...

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

Proud to be an ADF Hackathon winner!

Azure Data Factory HackathonAround the clock During the event 'Around the clock Azure SQL and Azure Data Factory' event on Feb 3, 2021, they kicked-off the Azure Data Factory (ADF) Hackathon. Recording of this event can be found here.Winner I submitted a ADF Pipeline...

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

Goodbye 2020 Hello 2021

Goodbye 2020 Started to work for InSpark Last year was certainly an eventful year. Started with a new job at InSpark and after 10 weeks we all know what happened, the first intelligent lockdown. The Netherlands was partially locked, but our office was immediately...

ADF: Get Metadata Activity stopped working

Meta Data ActivityToday 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...

Read More

Service Healths in Azure

Microsoft Build

Microsoft Build

Creating Service Health Alerts in Azure

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

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:

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

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.

Latest Posts
How to use mssparkutils.notebook.runMultiple in Notebooks in Microsoft Fabric?
Video: Learn Live Use Data Factory pipelines in Microsoft Fabric
How to use the PySpark executor in Notebooks in Microsoft Fabric?
High Concurrency Notebook Activity in Microsoft Fabric
Data Community Austria

Feel free to leave a comment

0 Comments

Submit a Comment Cancel replyYour email address will not be published. Required fields are marked *Comment * Name *
Email *
Website
Please enter an answer in digits:eleven − 1 = Submit Comment

Δ
This site uses Akismet to reduce spam. Learn how your comment data is processed.

Read More

LEAP 2018

Microsoft Build

by ErwinDec 10, 2019

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

0 Comments

Submit a Comment Cancel replyYour email address will not be published. Required fields are marked *Comment * Name *
Email *
Website
Please enter an answer in digits:20 + three = Submit Comment

Δ
This site uses Akismet to reduce spam. Learn how your comment data is processed.

Working from Home: How do I get my energy and focus back on track?

Working from home It has now been exactly 7 weeks since I started working from home. In the beginning this went with full energy, but now gradually the energy and the focus on the work is starting to drain.I'm the only one in here? I'm sure, I'm not. I regularly hear...

Data Factory Pricing

Data Factory pricingAre you also having problems to understand the Pricing Model for Azure Data Factory? After some research on the internet I came across an article which I wanted to share with you. ADFV2 Pricing ExamplesFeel free to leave a comment

Goodbye 2022, Hello 2023

Goodbye 2022​Recap 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....

My Sessions at DataSaturdayNL 2019

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

Restore a accidentally deleted Azure SQL Database

Help I deleted my Logical Server​OOPS 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...

Goodbye 2020 Hello 2021

Goodbye 2020 Started to work for InSpark Last year was certainly an eventful year. Started with a new job at InSpark and after 10 weeks we all know what happened, the first intelligent lockdown. The Netherlands was partially locked, but our office was immediately...

Goodbye 2021, Hello 2022

Goodbye 2021Recap First of all, I would like to wish everyone a very beautiful and healthy 2022. We are now 3 days on the road into the new year and it is always good to look back at what happened last year. It's certainly been an eventful year, topped off with my MVP...

Azure Synapse Analytics

Azure Synapse Analytics  Insights for all Azure Synapse provides a breathtaking view of your data across data warehouses and big data analytics systems. Bringing these two worlds together into a single service is challenging as it requires unifying similar...

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

A new year with a new job

Changing jobsAfter almost 11 years and 4 months I have decided to leave Axians and to start a new adventure in the new year. On January 2, 2020 I will start my day as Lead Data and AI at InsparkThe past years have flown by. I started at Eniac BI, which was...

Read More

Upcoming Events