Tag: SQLServer

May 16 2020

Power BI for SQL Server Agent jobs

by mattias

4 Comments

In a SQLServer datawarehouse you might have a lot of jobs scheduled through SQL Server Agent. There is little out of the box visibility on the status of those jobs,...

May 12 2020

Business Intelligence

Expressions on ConnectionString issue in SSIS 2019

by mattias

11 Comments

In SQLServer Integration Services, the use of Expressions to replace properties at runtime is very powerful. You can use it in combination with variables to pass parameters to queries, determine...

Apr 13 2020

Business Intelligence

Mastering New Data

by mattias

No Comments

Microsoft Master Data Services is a great tool for managing master data, and giving business user the control over master data as well as the ability to centrally manage their...