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…
Category: SQL Server
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…
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…