« All Events
Fabric February
February 8, 2024
« Pass Data Community Summit
SQLBits Training Day »
Add to calendar
Google Calendar
iCalendar
Outlook 365
Outlook Live
Details
Date:
February 8, 2024
Website:
fabricfebruary.com/
Venue
Microsoft Norway,
Dronning Eufemias gate 71
Oslo,
Norway
+ Google Map
« Pass Data Community Summit
SQLBits Training Day »
Fabric February
by ErwinOct 17, 2023
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:6 − six = Notify me of new posts by email.Submit Comment
Δ
This site uses Akismet to reduce spam. Learn how your comment data is processed.
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...
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...
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 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...
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...
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...
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...
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...
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...
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...
Read More
Fabric February
by ErwinOct 17, 2023
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:twenty − 9 = Notify me of new posts by email.Submit Comment
Δ
This site uses Akismet to reduce spam. Learn how your comment data is processed.
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...
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...
Microsoft Fabric pricing (Preview)
Microsoft Fabric PricingMicrosoft Fabric pricing in Public Preview is announced as of the 1 st of June.These are currently the Pay as You go pricing, later this year the Azure Reservation will follow. OneLake storage pricing is comparable to Azure ADLS (Azure Data...
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...
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...
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...
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 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...
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...
Azure Purview Public Preview Starts billing
Billing for Azure Purview(Public Preview)As of January 20th 2021 0:00 UTC Azure Purview will starts billing.Preview From January 20 ,2021 Azure Purview will start billing. During the Public Preview, you will only be billed if you exceed the 4 capacity units for Azure...
Read MoreFabric February
Fabric February
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
Microsoft Fabric Content Hub Update November
How to Discover and Govern Your Data with Microsoft Purview and Microsoft Fabric
Microsoft Fabric Content Hub Update October
Microsoft Fabric Content Hub Update September
Azure Open AI and Microsoft Fabric
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:one × one = Notify me of new posts by email.Submit Comment
Δ
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Fabric February
by ErwinOct 17, 2023
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:5 × three = Notify me of new posts by email.Submit Comment
Δ
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Calculate the Last Day of the Month using SQL
Calculate the Last DayToday I needed to calculate the last day of the previous month for a Customer.Ever heard from the function EOMONTH? Searching on the web I came across a function I never heard from before EOMONTH, this function can be used as of SQL Server 2012....
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...
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...
Service Health Alerts in Azure
Maintenance and Service Healths in AzureI 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...
New Microsoft Azure Certifications
Microsoft Certification by Solution Area Handy overview of the new Microsoft Azure Certifications. More details can be found here Feel free to leave a comment
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 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:...
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...
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....
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...
Read More