Skip to content

Mattias De Smet

Microsoft BI and Azure solved cases
  • Azure
  • Business Intelligence
  • Navision
  • Contact
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

Posts navigation

1 2 3 4

Curious technological cases present themselves to me in my day to day life. While solving them, I write down my findings and hope I can help others with this summary.

Read more

Buy me a coffee

Categories

  • Azure (6)
  • Business Intelligence (10)
  • Navision (3)

Tags

azure automation windows ssas json flow compute os session navision SQLServer portnumber usage .net port notification powerautomate devops database maximum db email trigger dax powershell business rules optimize scripting upgrade rdp portal queue server analysis services mappings ssis PowerBI Master Data Services sql administration vm etl tsal datawarehouse function
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Subscribe

Buy me a coffee

Mattias De Smet

Microsoft BI and Azure solved cases
2020 Mattias De Smet