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.…
Deploying SSIS Projects to Different Environments
In this post I’m explaining how you can deploy a developed SSIS project to several different environments. It might have…
Operating on different source SQL Server instances in a single SSIS package
In some cases we need to do a single task for lots of SQL Server instances. Assume that we have…
Publishing A Google Analytics Data Source Or A Workbook Linked To A Google Analytics Data Source into Tableau Server
Introduction We can create informative reports on our website analytics using Tableau. Tableau has the ability to connect to a…