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…
SQL Server SQL Server Integration services (SSIS) T-SQL
Execute SSIS package with SQL Task (outer project reference)
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…
Extended properties SQL Server T-SQL
Generate view definitions with HASH calculated columns based on extended properties
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…
Dynamic management views SQL Server T-SQL Tabular
Get metadata from cubes with T-SQL
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…
Dynamic management views SQL Server T-SQL
Object dependencies in SQL Server
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…
PowerBI SQL Server SQL Server Integration services (SSIS) T-SQL
Metadata driven run management
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…
Azure data lake store Powershell
Provision Data Lake Store with files by using Powershell
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…
Extended properties PIVOT / UNPIVOT SQL Server T-SQL
Extended properties on columns in SQL Server
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…
DAX PowerBI Reporting Reporting Services(SSRS) Tabular
PowerBI drilldown to SSRS detail report
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…
Other
Hello there!
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.