I’m delighted to announce that I’ve been selected to speak at the (revamped) PASS Data Community Summit. Alas, PASS is no more, but the summit lives on in this free online edition. That’s right, free! Dozens of sessions related to the Microsoft Data Platform are at your fingertips 🙂 I’m giving a professional development session […]
Category: Varia
Cool Stuff in Snowflake – Part 13: Row-Pattern Recognition
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share. It might be some SQL function that I’d really like to be in SQL Server, it might be something else. In the book T-SQL Window Functions […]
dataMinds Saturday Recording Available
I did a session on data visualization best practices on the past dataMinds Saturday virtual conference. The recording has now been made available at the AE website. They used the web infrastructure of their own webinars, so you have to register to view the recording (we’re GDPR compliant if you’re worrying about your privacy). So […]
Techorama 2021 – Session Materials
You can find the slides and the scripts used at Github. Hopefully we’ll see each other next year at an in-person event.
STAR SCHEMA ALL THE THINGS
The title says it all, but I’ll explain it anyway. When building a data model that will be used for analysis by human beings, always create a star schemas. Or multiple star schemas connected with conformed dimensions. Why? Because it’s the most intuitive and user-friendly interface. Because remember, your data model is the user interface […]
MSSQLTips Author of the Year 2020
At least there’s one consistency in the year 2020: every day amazing articles are published on the MSSQLTips.com. And the author of the year contest at the end of the year! I’ve been nominated again for the author of the year award, and you can vote here. There are many excellent authors nominated as well, […]
Top 5 Blog Posts of 2020
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 – […]
Good Riddance 2020
Normally I’d write a “Happy xxxx” blog post at the start of the new year, but this time I’m just glad the previous year is over. It has been a remarkable year to say the least. Focusing on the Data Community, I think I’ll remember 2020 for two reasons: The rise of the virtual event. […]
Vote for GroupBy Conference May 2020
GroupBy is a virtual conference, for the community and by the community. Content is focused on the Microsoft Data Platform. Speakers can submit sessions for two events: GroupBy Europe on May 12th 2020, which focuses on European time zones. GroupBy Americas on May 13th 2020, which focuses on timezones relevant to the USA. After speakers […]
Author of the Year 2019 Nomination at MSSQLTips
This year I’ve been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine people have been nominated as well, you can check out the entire list here. There’s also a Rookie of the Year award, for new authors at MSSQLTips. It would be nice if you could cast […]