Disclaimer: Apress gave me a free copy of the book to review. People that know me, also know I always give honest feedback 🙂 I had the pleasure of reading the book Mastering Snowflake Solutions: Supporting Analytics and Data Sharing. The book is aimed at data professionals who have already taken their first steps developing […]
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: […]
If you’re wondering what you’ve all been reading while working at home, here’s the list: Cool Stuff in Snowflake – Part 3: SPLIT and FLATTEN – People really seem to want to split some strings in Snowflake, and are possibly surprised with the resulting array. Like I was. Dynamically Changing Shapes in Power BI – […]
This is a quick blog post, mainly so I have the code available if I need it somewhere in the future 🙂 Sometimes you need a numbers table (also called tally table) when you’re working with data. It’s a table with one single integer column that contains incremental numbers (0,1,2,3,4,…). In a database, it’s fairly […]
Because my Windows machine apparently decides to install updates over night (and thus reboot my machine), it has happened that I lost the query that I was writing for Redshift in the tool DBeaver. When you work with SQL Server Management Studio (SSMS), you typically don’t have this issue as a temporary copy is always […]
A couple of years back Itzik Ben-Gan (the T-SQL guru) wrote the book Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions. It’s has been one of my most favorite technical books (I included it in this list): it was really an eye-opener to how useful and powerful window functions can be. It teaches the […]