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…
Archive
Category: SQL Server
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…
How to copy or migrate database diagrams into another database
We discussed in one of the previous articles called “How to store a SQL Server database diagram into a file…