Extract data with PowerBI from your Azure Datalake Storage
So, it has been a while. But finally I got the time to start writing again. It has been to long, I know…. This time, a topic about PowerBI and specifically on how to connect…
So, it has been a while. But finally I got the time to start writing again. It has been to long, I know…. This time, a topic about PowerBI and specifically on how to connect…
So, have you ever needed to execute an SSIS package with an outer project reference? There are some ways to do so. This blog will tell you how you can accomplish this by using a…
So, a while ago I posted a blog about extended properties. In this blog I have used extended properties to dynamically UNPIVOT data. In this article I want to give another example on how to…
There is a great way to get metadata from your tabular cubes by using the dynamic management views. With simple T-SQL you can get lots of metadata out of your cubes. I use them to…
In the last post, I wrote about metadata driven run management. A system that caches the output from views in tables(if defined) and finally creates synonyms to either a view or cached table. I build…
So, it has been a while since my last blog. But I have been working a lot from my home office lately due to Covid. With the work, and the distractions from home, it has…
In the modern datawarehouse environment a data lake store is often used for storage, especially in big environments. Storage in Azure is not expensive, so think of it as a staging environment for example where…
I just recently started using extended properties on columns for different purposes. In my opinion, it can be used in many cases. Extended properties can be used on almost every object in SQL Server. In…
PowerBI has come a long way when it comes to reporting besides the standard dashboards. However there are still many practical uses for simple and plain Reporting Services Reports(SSRS). For instance, detail reports are very…
Welcome to SQLFrank.com, my own personal blog site. I am a Business Intelligence consultant/Architect. In may 2019 I started working als a Freelance consultant at RuiterBI Solutions. Beside starting for myself, one of the other things I wanted to do was this, to start a blog site.