AZURE : CHANGE VM RDP PORT NUMBER

Here are three easy ways to change your RDP port number of an Azure VM.1. AZURE PORTALThis is a good way when you don’t want to login to the machine. It does all the manual steps you’d have to think of otherwise.Go to to Operations section on your VM blade and click on Run CommandsClick on SetRDPPortIn the input form enter the new RDP port numberRead more on my blog:... more

Jun 02

Navision: Track Maximum & Average Users by day using PowerBI

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 users sessions were in the past x days, how many on average, and plot the historical data. You can also see what type of clients your user favor. All of this information allows you to optimize the amount of licenses and infrastructure required. And it's a good opportunity to dive into... more

May 30

MASTERING NEW DATA

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 master data.Using Business Rules, it becomes possible to act on data within master data, set automated validation and ensure a basic level of data quality and consistency.In this article, I want to show how to automate the detection of new meta data appearing in source systems that drive your master... more

May 13

UPGRADE THE AZURE VM WINDOWS OS

Come the day you want to install SQLServer 2019, when the first prerequisite is to have Windows 2019 installed. Not to worry, until you discover that your Azure VM doesn’t support upgrading its OS. The only option is really to create a new VM with the new OS and reinstall this machine. For a test setup, it’s probably manageable, but in #realworld this will quite quickly mean a new project, approvals, and months of pain.Read more :... more

May 13

SCALING POWERAUTOMATE USING AZURE QUEUES

Often enough, a single PowerAutomate flow can be a perfect solution for a simple task. But when you start copying that solution for different triggers, it can soon become a maintenance nightmare. This article tries to describe a more scalable... more

May 13

UPLOADING EMAIL ATTACHMENTS TO DEVOPS ISSUE

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. Instead of copy/pasting, it would be good to just forward the email to DevOps, or setup a dedicated mailbox, so user incident reports automatically create a DevOps issue.PowerAutomate has all the ingredients, but when implementing in the real-world, you quickly miss the ability to include... more

May 13

POPULAR
EXPRESSIONS ON CONNECTIONSTRING ISSUE IN SSIS 2019
UPLOADING EMAIL ATTACHMENTS TO DEVOPS ISSUE
SCALING POWERAUTOMATE USING AZURE QUEUES
UPGRADE THE AZURE VM WINDOWS OS
MASTERING NEW DATA