October=Speaking Month

October=Speaking Month

Monitoring

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

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

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 OSLO This 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…

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…

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…

October=Speaking Month

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

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

Monitoring 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 Datasaturday events please visit the Data Saturdays event page. Azure Purview I…

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…

My First Blog Post SQLSatHolland 790

Yeah, m y 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…

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…

Service Healths in Azure

Monitoring

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