Loading view.
There were no results found.
There were no results found.
Events Search and Views Navigation
Search
Enter Keyword. Search for Events by Keyword.
Find Events
Event Views Navigation
List
List
Month
Day
Today
Upcoming
Upcoming
Select date.
Previous Events
Today
Next Events
Subscribe to calendar
Google Calendar
iCalendar
Outlook 365
Outlook Live
Export .ics file
Export Outlook .ics file
Read MorePass Data Community Summit
Pass Data Community Summit
Change a Action Group
Previous Article
In my previous artcile I wrote about how to create Service Helath Alerts.
In this article you will learn how to change the Action Group to add, change or Remove members(Action Group Type Email/SMS/Push/Voice)
Azure Portal
In the Azure Portal go to Monitor – Alerts – Manage Action Groups
Click on the Action Group you want to change and a new window will open.
Remove, Add or Change Members:
You have several options you can change:
Add a New Member
Remove a Member( click on the X below ACTIONS)
Change a Member(click on the edit details)
Change Member
In the new Window you can change, the name, email address or Notification Type
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
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
Azure Open AI and Microsoft Fabric
Microsoft Purview new Experience is coming
How to enable Microsoft Fabric
Create capacity for Microsoft Fabric
Microsoft Fabric pricing (Preview)
Feel free to leave a comment
Read More
Pass Data Community Summit
Calculate the Last Day
Today 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.
With this function you never have to worry anymore about how many days(28,29,30,31) your month has.
The function works as follows:
Defined date:
declare @datum datetime = ‘2018.11.01’
SELECT EOMONTH(DATEADD(mm, -1, @datum)) as LastDayPreviousMonth
Getdate()
SELECT EOMONTH(DATEADD(mm, -1, getdate())) as LastDayPreviousMonth
Current Month
SELECT EOMONTH(getdate()) as LastDayCurrentMonth
Feel free to leave a comment
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...
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...
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...
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...
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...
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...
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...
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...
Control my Nest Thermostat on my Domoticz Server running on a Synology DiskStation
Control your Nest Thermostat in DomoticzNormally I always write Azure related, but today I'm writing about something different, on how I can control my Nest Thermostat on my Domoticz Server (Home automation). A while ago I have upgraded my  Nest Thermostat to login...
Read More
Pass Data Community Summit
Yeah, my first built website is LIVE
The 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 design my own website and finally the moment is there! My website is live and I’m really proud that I can show it to you.
WordPress
I have never built a website with WordPress.The last time I built a website was 10 years ago, with Joomla. I needed to learn everything from scratch and as everybody know, learning from scratch takes a while.But with some help here and there, I made the building of the website my own. Thanks in part to all the advice from my colleague Joke, thanks for this.
Divi Builder
The website is build with Divi Builder, the Divi Builder Plugin is a stand-alone Drag & Drop page builder plugin which can be downloaded from https://www.elegantthemes.com/. This builder is really ease to use and I can certainly recommend it to everyone. You better invest time in writing content than in building pages for the website.
In case you have some comments or advice about the website, just let me know.
First articles and blogs
Also hope you are going to enjoy my blogs and articles. When you like to receive the latest news, please subscribe on the website or send me a message.
Erwin
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...
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...
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...
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:...
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...
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...
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...
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...
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...
10 Days of Azure Synapse Analytics
10 Days of Azure Synapse AnalyticsFor the next 10 days, every day a different topic is explained about Azure Synapse Analytics. The shortest and easiest way to see how Azure Synapse Analytics can help you, to make decisions within your data landscape.Day 1...
Read MorePass Data Community Summit
Saving a Pipeline
Another great improvement in Azure Data Factory. Saving you template!
How can you save your template?
First of all you need to connect your Azure Data Factory to  a GIT integration. Both Azure DevOps GIT and GitHub are supported. Please follow this link if you don’t have a Git Integration.
Select the template you want to save:
Name your template and save it to a Git Location of your choice:
The template you have saved can be found in Factory Resources.
With this new option it will  be easier to share Pipeline Activities with other Azure Data Factory instances.
And most important of saving your template it will save a lot of development time in your new instance.
Happy Saving
Feel free to leave a comment
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...
Updated competency exams and certifications Data Platform and Data Analytics for 2020
Retiring and new exams and certifications as of June 30 2020 A lot of Exams and certifications for Data Platform and Data Analytics are retiring on June 30 2020. All retired Exams and certifications will remain eligible for competency attainment and renewal until June...
Are you using Azure DevOps?
Azure DevOpsMore and more users are starting with Azure DevOps. Azure DevOps can be used for up to 5 users free of charge and is therefore a great start to start a project. Â Â Build and Release I will not describe what Azure DevOps can do, because that is too much to...
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...
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...
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
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 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...
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...
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...
Read More