Loading view.

Events Search and Views Navigation

Search

Enter Keyword. Search for Events by Keyword.

Find Events

Event Views Navigation

List

List

Month

Day

Today

2023-05-08

May 8, 2023

-

2023-10-09

October 9, 2023

Select date.

May 2023

Mon

8

May 8, 2023 @ 8:00 am - May 10, 2023 @ 5:00 pm CEST

SQLDAY 2023

Fri

12

May 12, 2023 @ 8:00 am - 5:00 pm CEST

News Stars of Data

Virtual

Sat

13

May 13, 2023

Data Saturday Stockholm

Gymnastik- och Idrottshögskolan

Lidingövägen 1, Stockholm, Sweden

Mon

15

May 15, 2023 @ 8:00 am - May 17, 2023 @ 5:00 pm CEST

Techorama Belgium 2023

Kinepolis Antwerp

Groenendaallaan 394, Antwerpen, Belgium

Thu

25

May 25, 2023

Experts Live Netherlands

Congrescentrum 1931

oude engelenseweg 1, Den Bosch, Netherlands

June 2023

Thu

8

Featured

Featured

June 8, 2023 @ 8:00 am - June 9, 2023 @ 5:00 pm CEST

Data Platform Next Step

Legoland Billund

AASTVEJ 10, Billund

September 2023

Fri

8

Featured

Featured

September 8, 2023 @ 8:00 am - 5:00 pm CEST

DataScotland

Murrayfield Stadium, Edinburgh

Roseburn St,, Edinburgh, United Kingdom

Tue

12

Featured

Featured

September 12, 2023 @ 8:00 am - September 13, 2023 @ 5:00 pm CEST

SQLKonferenz

Congress Park Hanau

Schlossplatz 1, Hanau, Germany

October 2023

Sat

7

Featured

Featured

October 7, 2023 @ 8:00 am - 5:00 pm CEST

DataSaturday Holland

Kinepolis Jaarbeurs Utrecht

Jaarbeursboulevard 300, Utrecht, Utrecht, Netherlands

$25

Mon

9

Featured

Featured

October 9, 2023 @ 8:00 am - October 10, 2023 @ 5:00 pm CEST

DataMinds Connect 2023

Congres- en Erfgoedcentrum Lamot

Van Beethovenstraat 8-10, Mechelen, Belgium

Previous Events

Today

Next Events

Subscribe to calendar

Google Calendar

iCalendar

Outlook 365

Outlook Live

Export .ics file

Export Outlook .ics file

Read More

Microsoft Fabric Community Conference

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

Azure Data Factory: Save a pipeline as a Template

Saving a PipelineAnother 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...

Microsoft Build 2022 Book of News

Microsoft Build 2022MSBuild 2022 has just started. A lot of new Announcement will be released or demonstrated the upcoming days. Like every year or event most of these announcement are added to the Book of News.The book of news can be downloaded from the link below...

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

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

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

Custom comments in Azure Synapse Analytics

Add custom comments to your Azure DevOps and Github commitsFinally ​Finally and secretly hidden, we can now add a Comment to our commits in Azure Synapse Analytics and Azure Data Factory to Azure Dev Ops. How do you activate this custom comment option in your existing...

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

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

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

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

Read More

Microsoft Fabric Community Conference

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

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

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

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

My First Blog Post SQLSatHolland 790

Yeah, my first blog is LIVEAfter 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...

Azure Data Factory: Save a pipeline as a Template

Saving a PipelineAnother 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...

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

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

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

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

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

Read More