Azure Data Factory: Save a pipeline as a Template

by | Feb 8, 2019 | Azure Data Factory

Erwin

by Erwin | Feb 8, 2019

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

Yeah My website is Finally Live

Yeah My website is Finally Live

by | Feb 1, 2019 | Divers

Erwin

by Erwin | Feb 1, 2019

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

Calculate the Last Day of the Month using SQL

Calculate the Last Day of the Month using SQL

by | Jan 29, 2019 | Azure, Azure SQL Database

Erwin

by Erwin | Jan 29, 2019

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

Change your Action Group in Azure Monitoring

by | Jan 11, 2019 | Azure

Erwin

by Erwin | Jan 11, 2019

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.

Feel free to leave a comment

Data Factory Pricing

Data Factory Pricing

by | Jan 8, 2019 | Azure

Data Factory pricing

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