How To Implement a Composite Key In SSAS Tabular Model
As you might know SSAS tabular models do not support composite keys so you always must have just one column…
Archive
Category: T-SQL
Creating a Simple Date Dimension Using Recursive Common Table Expressions (CTE)
In this post I’ll explain how to create a simple date dimension to use it in your data warehouses and…
How to manage the user access rights to see database views but not source tables using T-SQL
Problem: There is a group of users that are not intended to have direct read access to the database tables.…
How to install database diagram support programmatically
In the previous article we discussed about how migrating a database diagram into another database. In this article I’ll quickly…