Tag: etl

Aug 27 2022

Business Intelligence

SQL : CLR to do base36 decoding

by mattias

No Comments

Always wanted to escape the set based world of SQL and get back to that good old .Net procedural (even object oriented) experience for a quick calculation? Let me show...

assembly, database, datawarehouse, db, etl, sql, SQLServer, tsql

Jun 28 2020

Business Intelligence

BI : Securing SSIS project deployments

by mattias

No Comments

When you’re sharing an on-premises SSIS server with multiple teams you’d want to segregate responsibilities to their projects. It’s not a much advertised feature of SSISDB, but it allows you...

bi, database, edw, etl, integration services, security, SQLServer, ssis, ssisdb

May 16 2020

Business Intelligence

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,...

db, email, etl, power bi, PowerBI, SQLServer

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...

database, datawarehouse, etl, sql, SQLServer, ssis

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...

automation, business rules, datawarehouse, etl, mappings, Master Data Services, notification, parameters, SQLServer, ssis