Categories: Varia

Happy 2022

Or is it April 2020? Not sure. Anyway, I’d like to extend my best wishes for the upcoming year. I hope there will be many possibilities for the data community to come together and share knowledge in a safe and responsible manner.

In case you’re wondering, here are my top 5 blog posts of 2021:

  1. Converting a Datetime to UTC – apparently a common problem, so it does well in Google search results I guess.
  2. Cool Stuff in Snowflake – Part 3: SPLIT and FLATTEN – the number one of 2020.
  3. Dynamic Datasets in Azure Data Factory – a very useful pattern for ADF. Glad a blog post of this year made the list.
  4. Reading a SharePoint List with Azure Logic App – no matter how hard you try, you can’t get rid of the SharePain
  5. Dynamically Changing Shapes in Power BI – an oldie. Keeps popping up, but the follow-up blog post has actually better solutions.

------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

View Comments

  • Hi Koen,

    Wish you a very happy new year!
    Im going through your video on azure introduction video, it is very informative.Thanks for the awesome video!

    Im native to cisco voice platform where azure is completely new to me. Im keen to know the procedure/ steps involved in migrating data from SQL to Azure pipeline or Data lake
    Im in the process of learning all the steps that you hint in your next reply & also if you can direct me on what all i need to learn specific to this data movement (from sql=>data lake) would really helpful.
    I will look forward to hear from you soon.

    Many Thanks!

    Cheers
    Manjunath

Recent Posts

Book Review – Agile Data Warehouse Design

I recently read the book Agile Data Warehouse Design - Collaborative Dimensional Modeling, from Whiteboard…

4 days ago

Cloudbrew 2024 – Slides

You can find the slides for the session Building the €100 data warehouse with the…

1 week ago

Book Review – Microsoft Power BI Performance Best Practices

I was asked to do a review of the book Microsoft Power BI Performance Best…

1 month ago

Create a Numbers Table in Power Query

This is a quick blog post, mainly so I have the code available if I…

1 month ago

Microsoft finally adds Tenant Switcher for Fabric / Power BI

Praise whatever deity you believe in, because it's finally here, a tenant switcher for Microsoft…

1 month ago

Book Review – Humanizing Data Strategy by Tiankai Feng

This book was making its rounds on social media, and the concept seems interesting enough…

1 month ago