This month’s T-SQL Tuesday is hosted by yours truly! The topic this month: how do you keep up with the fast changing world of data management? Does this impact your job? Or do you feel there’s no impact at all for your position? Do you fear the cloud? And so on 🙂 Everything changes fast […]
T-SQL Tuesday #89 Invitation – The times they are a-changing
T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called T-SQL Tuesday, it’s not limited to SQL Server database engine only). It is the brainchild of Adam Machanic (blog | twitter) and I’m honored to host this month’s edition. Each month a blog hosts the party and […]
T-SQL Tuesday #88 – The daily (database-related) WTF
It’s the time of the month again: the T-SQL Tuesday! This month’s edition is hosted by Kennie Nybo Pontoppidan (blog|twitter) and the topic is “daily database related WTF”. In other words, we get to tell one of our horror stories we encountered in our career as data professionals. Let me tell you the story of a small […]
Hands-On Data Analysis With Power BI Desktop at PASS BA Marathon
I’m delighted to announce I’ll give a session at the next PASS BA webinar marathon. The topic of this marathon is Data Driven Storytelling and Data Discovery. My session will focus on working with Power BI Desktop: getting data in, cleaning it, creating a model and visualizing the data. It will be mostly demos and just […]
Webinar – Executing, Configuring and Scheduling SSIS 2016 Packages
I’ll be giving a webinar for MSSQLTips.com at March 30th. It’s a sponsored webinar, meaning there will also be a vendor to talk about JAMS, a scheduler that “runs, monitors and audits critical processes across a diverse array of servers and business applications”. Anyway, the title is Executing, Configuring and Scheduling SQL Server 2016 Integration Services […]
Not An Administrator For Analysis Services Tabular
A couple of weeks back I installed SQL Server 2016 on my personal machine, including SSAS Tabular. Yesterday I created a new Tabular model project in SQL Server Data Tools. When I had to choose where to locate the model – integrated or a server workspace – I got the nice error message saying I […]
Updates to the Power BI course
Recently I published an open-source course/workshop to learn Power BI Desktop. Fellow MVP Dan English (blog | twitter) gave me the excellent feedback that IMDB actually doesn’t like people scraping their website for data. Furthermore, the OMDB API appears to have fallen almost out of funds and is thus not as reliable as I thought. Refreshing […]
Open Source Power BI Desktop Workshop
I’ve created a free, open-source workshop to teach people the capabilities and features of Power BI Desktop. I was inspired to do this by Brent Ozar, who also created a free open-source course How to Think Like the Engine. If you haven’t checked out that course, make sure you do because it’s great fun and […]
Missing Checkbox for Security Filter in Power BI Desktop
Just a quick blog post so that other people don’t waste 15 minutes of their life looking for a missing checkbox. I was implementing security using roles in a Power BI Desktop model. I had defined the role along with its filter on top of a many 2 many relationship. The relationship between the fact […]
Dynamically Changing Shapes in Power BI – Alternatives
NOTE: the DAX presented in this blog post is written in my locale (nl-BE). This means that semicolons are used in the functions and lists instead of commas. Also, we use the comma as the decimal seperator. 0.95 (in the US) is 0,95 in my locale. A couple of well placed search and replaces should […]