Mattias De Smet

Jun 03 2020

Azure, Business Intelligence

Azure SQL DB: setup AD Authentication

by mattias

No Comments

Follow below steps to allow Azure AD users and groups to connect to your Azure SQL database: create a User in Azure AD optionally: create a Group in Azure AD...

active directory, ad, authentication, azure, db, external provider, group, sql, user

Jun 01 2020

Azure

Azure : Change VM RDP port number

by mattias

No Comments

Here are three easy ways to change your RDP port number of an Azure VM. 1. Azure Portal This is a good way when you don’t want to login to...

azure, compute, os, port, portal, portnumber, powershell, rdp, scripting, vm

May 24 2020

Navision

Navision: Track Maximum & Average Users by day using PowerBI

by mattias

No Comments

With its simple Active Sessions table, Navision doesn’t provide an option out-of-the-box to track usage information. I will describe a mechanism that will allow you to understand what the maximum...

dax, maximum, navision, optimize, PowerBI, session, trigger, tsal, usage

May 16 2020

Business Intelligence

Power BI for SQL Server Agent jobs

by mattias

2 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