My Virtual Session Cloud Lunch and Learn Marathon

by Erwin | May 13, 2021 | Events, Microsoft

Microsoft

by Erwin | May 13, 2021

Cloud Lunch and Learn Marathon 2021

This Thursday May 13th 2021 I’ve been speaking during Cloud Lunch and Learn Marathon 2021. It was the first Cloud Lunch and Learn Marathon conference, more then 1200 registered attendees, 24hours Live and pre recorded sessions. Amazing. A big compliment to the organizers and thank you for having me.

You can still watch the sessions online:

Live on Youtube

(169) Cloud Lunch and Learn – YouTube

Live on twitch

CloudLunchLearn – Twitch

Azure Synapse Analytics

I presented a session on if there is a way that we can build our Azure Synapse Pipelines all with parameters based on MetaData?

Code from my demos can be found here.

You can find my slides below on Slideshare:

Is there a way that we can build our Azure Synapse Pipelines all with parameters based on MetaData? from Erwin de Kreuk

In case you have any questions left please feel free to ask them via the comment or Socials.

Feel free to leave a comment

Goodbye 2022, Hello 2023

by Erwin | December 31, 2022 | Blogs | 0 Comments

Microsoft 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…

Azure Synapse Analytics

by Erwin | June 15, 2020 | Blogs, Azure, Azure Synapse Analytics | 0 Comments

Microsoft 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…

Updated competency exams and certifications Data Platform and Data Analytics for 2020

by Erwin | March 20, 2020 | Blogs, Azure | 1 Comment

Microsoft 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…

Custom comments in Azure Synapse Analytics

by Erwin | May 16, 2023 | Blogs, Azure, Azure DevOps, Azure Synapse Analytics | 0 Comments

Microsoft Add custom comments to your Azure DevOps and Github commits Finally 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…

Calculate the Last Day of the Month using SQL

by Erwin | January 29, 2019 | Blogs | 2 Comments

Microsoft 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…

LEAP 2018

by Erwin | December 18, 2018 | Blogs | 0 Comments

Microsoft 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…

Azure Purview Public Preview Starts billing

by Erwin | January 18, 2021 | Blogs, Azure, Microsoft Purview | 5 Comments

Microsoft 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…

Service Health Alerts in Azure

by Erwin | November 19, 2018 | Blogs | 0 Comments

Microsoft 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…

Parameterize Linked Services in ADF

by Erwin | July 9, 2020 | Blogs, Azure, Azure Data Factory, Azure Synapse Analytics | 2 Comments

Microsoft 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…

Restore a accidentally deleted Azure SQL Database

by Erwin | July 1, 2021 | Blogs, Azure, Azure SQL Database | 2 Comments

Microsoft 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…

Watch the MS Ignite sessions on-demand

by Erwin | Oct 5, 2020 | Events, Microsoft

Microsoft

by Erwin | Oct 5, 2020

MS Ignite Sessions

MS 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 the sessions are ready to watch on demand. If you have not done this yet, here is the link to be able to do this.

Feel free to leave a comment

Microsoft Fabric pricing (Preview)

by Erwin | June 3, 2023 | Blogs, Microsoft Fabric | 0 Comments

Microsoft Microsoft Fabric Pricing Microsoft 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…

Goodbye 2021, Hello 2022

by Erwin | January 3, 2022 | Blogs | 0 Comments

Microsoft Goodbye 2021 Recap 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…

SQLBits session: Microsoft Purview Data Policy App

by Erwin | March 17, 2023 | Blogs, Events, SQLBits | 0 Comments

Microsoft 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…

Control my Nest Thermostat on my Domoticz Server running on a Synology DiskStation

by Erwin | April 14, 2020 | Blogs, Domoticz | 7 Comments

Microsoft Control your Nest Thermostat in Domoticz Normally 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…

New Microsoft Azure Certifications

by Erwin | May 3, 2019 | Blogs, Azure | 2 Comments

Microsoft 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

Parameterize Linked Services in ADF

by Erwin | July 9, 2020 | Blogs, Azure, Azure Data Factory, Azure Synapse Analytics | 2 Comments

Service Health Alerts in Azure

by Erwin | November 19, 2018 | Blogs | 0 Comments

Updated competency exams and certifications Data Platform and Data Analytics for 2020

by Erwin | March 20, 2020 | Blogs, Azure | 1 Comment

Rerun Pipeline activities in Azure Data Factory

by Erwin | March 7, 2019 | Blogs, Azure, Azure Data Factory, Azure Synapse Analytics | 1 Comment

Microsoft 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…

Azure Purview March Updates

by Erwin | March 15, 2022 | Blogs, Azure, Microsoft Purview | 0 Comments

Microsoft Azure Purview updates Announcements 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:…