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:

Converting a Datetime to UTC – apparently a common problem, so it does well in Google search results I guess.
Cool Stuff in Snowflake – Part 3: SPLIT and FLATTEN – the number one of 2020.
Dynamic Datasets in Azure Data Factory – a very useful pattern for ADF. Glad a blog post of this year made the list.
Reading a SharePoint List with Azure Logic App – no matter how hard you try, you can’t get rid of the SharePain
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.

Next Speaking at SQLBits 2022 »

Previous « New Argument for STRING_SPLIT Function

View Comments

Manjunath says:

January 4, 2022 at 7:20 am

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
- Koen Verbeeck says:
  
  January 8, 2022 at 10:07 pm
  
  Hi Manjunath,
  I suggest you look for tutorials on Azure Data Factory.
  
  Regards,
  Koen