Tag: datawarehouse

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

Aug 21 2022

Azure

SQL : Move tempdb to D:

by mattias

No Comments

When you install SQLServer on an Azure virtual machine, you can take advantage of the D: drive that comes with such a VM. Its characteristics are that it is local,...

azure, database, datawarehouse, db, dba, sql, SQLServer, tempdb, vm

Jun 14 2020

Business Intelligence

SQLServer : disable inactive logins

by mattias

2 Comments

SQLServer doesn’t have a functionality to expire accounts if they have not been used for a certain amount of time. Sometimes this can come in handy, e.g. in an environment...

administration, datawarehouse, db, dba, disable, history, login, logon, sql, sqlagent, SQLServer, table, trigger, tsql

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