Mattias De Smet

Jun 01 2020

Azure

Azure : Change VM RDP port number

by Mattias De Smet

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 De Smet

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 De Smet

8 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 De Smet

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

May 10 2020

Azure

Power Automate : Uploading email attachments to DevOps issue

by Mattias De Smet

1 Comment

Creating issues in DevOps is easy enough, but frequently issues arise from an email received from the business users, with much the same details as you’d need to put in...

devops, email, flow, function, json, powerautomate