I had the extreme pleasure recently to extract some data out of an Oracle database. I wrote the source query in Toad, where it executed successfully. I created my SSIS package, added the dataflow and an OLE DB Source component. I copy pasted the query into the editor and tested it using the preview. Which […]
Tag: syndicated
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 […]
Small Multiples in Power BI
In the December 2020 release of Power BI Desktop, a long-awaited feature was added as a preview: small multiples (also known as trellis chart). A feature request for this chart type has been made since 2015! Small multiple charts are a set of charts of the same type on a grid, allowing you to easily […]
Unable to validate source query in Tabular Editor
When you have a very large fact table in Analysis Services Tabular, you most likely have it partitioned. Suppose you are making some changes to the underlying source of the table and you hit “refresh table metadata” to add some new columns for example. What happens behind the scenes is that Tabular Editor will run […]
Upcoming Webinar- Introduction to SSIS
At February 25th March the 4th 2021 I’ll be giving a webinar on the MSSQLTips.com website. The topic is Integration Services. This webinar is meant as an introduction for beginners. The abstract: For years, Microsoft SQL Server Integration Services (SSIS) has been the tool in the data platform stack to integrate, move and transform your […]
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. […]
Speaking at SQLSaturday Vienna 2021
I’m thrilled to announce I’ve been selected to speak at SQLSaturday Vienna. Actually, it’s on Friday 15th of January, so don’t get fooled by the name. I’m bringing the session Self-service BI – Why Data Modelling Is Still Important, which is a beginner level talk about why you should pay attention to the data model […]
Migrating SSIS to Azure – an Overview
For quite some time now, there’s been the possibility to lift-and-shift your on-premises SSIS project to Azure Data Factory. There, they run in an Integration Runtime, a cluster of virtual machines that will execute your SSIS packages. In the beginning, you only had the option to use the project deployment model and host your SSIS […]