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

2021-04-17

April 17, 2021

-

2021-11-02

November 2, 2021

Select date.

April 2021

Sat

17

April 17, 2021 @ 5:00 pm - April 18, 2021 @ 2:00 am CEST

Data Saturday #5 Redmond (Virtual)

Virtual

Sat

24

April 24, 2021 @ 8:00 am - 5:00 pm CEST

Data Saturday #6 Malta (Virtual)

Virtual

Free

May 2021

Mon

17

May 17, 2021 - May 19, 2021

Techorama BE Spring Edition(Virtual)

Virtual

June 2021

Sat

12

June 12, 2021 @ 9:00 am - 6:00 pm CEST

Data Saturday #9 Data Toboggan – Cool Runnings (Virtual)

Virtual

Sat

12

June 12, 2021 @ 5:00 pm - June 13, 2021 @ 2:00 am CEST

Data Saturday #7 Los Angeles

Virtual

Free

September 2021

Sat

4

Featured

Featured

September 4, 2021 @ 9:00 am - 5:00 pm CEST

Data Saturday Oslo (Virtual)

Virtual

Free

Tue

21

Featured

Featured

September 21, 2021 @ 12:00 pm - 9:00 pm CEST

Data Platform Discovery Day 2021

Virtual

Free

October 2021

Mon

11

Featured

Featured

October 11, 2021 @ 8:00 am - October 12, 2021 @ 5:00 pm CEST

DataMinds Connect 2021

Congres- en Erfgoedcentrum Lamot

Van Beethovenstraat 8-10, Mechelen, Belgium

$375

Sat

16

Featured

Featured

October 16, 2021 @ 8:00 am - 5:00 pm CEST

Data Saturday Minnesota (Virtual)

Virtual

Free

November 2021

Tue

2

Featured

Featured

November 2, 2021 @ 4:00 pm - November 4, 2021 @ 4:00 pm CET

Microsoft Ignite

Virtual

Free

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

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

High Concurrency Notebook Activity in Microsoft Fabric

Microsoft Fabric is a cloud-based platform that provides integrated data engineering and data science solutions. One of the key features of Microsoft Fabric is the support for Apache Spark, a distributed computing framework that enables large-scale data processing and...

Azure Synapse Analytics Code Repository has arrived

Azure Synapse Analytics Code repository‎I just opened my Azure Synapse Analytics Workspace and got a great surprise, the option Git Configuration is available as of today‎.    After a long wait, today the Git Configuration option became available in Azure Synapse...

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

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

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

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

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

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

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

High Concurrency Notebook Activity in Microsoft Fabric

Microsoft Fabric is a cloud-based platform that provides integrated data engineering and data science solutions. One of the key features of Microsoft Fabric is the support for Apache Spark, a distributed computing framework that enables large-scale data processing and...

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

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

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

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

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

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

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

Azure Synapse Analytics Code Repository has arrived

Azure Synapse Analytics Code repository‎I just opened my Azure Synapse Analytics Workspace and got a great surprise, the option Git Configuration is available as of today‎.    After a long wait, today the Git Configuration option became available in Azure Synapse...

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