Skip to content
  • Home
  • Contact
SQL Frank

Blog series by Frank Ruiter – RuiterBI Solutions

Recent Posts

  • Execute SSIS package with SQL Task (outer project reference)
  • Generate view definitions with HASH calculated columns based on extended properties
  • Get metadata from cubes with T-SQL
  • Object dependencies in SQL Server
  • Metadata driven run management

Archives

Categories

Category: T-SQL

SQL Server SQL Server Integration services (SSIS) T-SQL

Execute SSIS package with SQL Task (outer project reference)

6 September 20216 September 2021 by frankruiter@gmail.com

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

11 February 202111 February 2021 by frankruiter@gmail.com

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

30 November 202030 November 2020 by frankruiter@gmail.com

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

9 October 202030 November 2020 by frankruiter@gmail.com

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

29 September 202029 September 2020 by frankruiter@gmail.com

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

18 February 202018 February 2020 by frankruiter@gmail.com

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…

© 2022 SQL Frank | WordPress Theme Design by Superb
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT