When you share the file from your OneDrive with external users, often is to collaborate during the lifecycle of the document. There are some scenarios where you may want to know when that file is edited. So we have PowerAutomate where you can create a Flow to detect these changes. However, there are some tricks… READ MORE
In some cases there might be necessary to prevent an Azure (Build) Pipeline from running if some other pipeline in your project fails. Well, I encountered a scenario like this the other day. After spending an hour trying to find an out of the box solution, I concluded that it probably none available yet. However,… READ MORE
Many of us will work in organisations that have a global presence and therefore may have a need to know the value of something in a local currency / Exchange Rate Conversion. There isn’t any out of the box way to convert a base currency to another currency in Power Automate, so I wanted to… READ MORE
In today’s blog post I will walk you through the process of creating an admin audit log dashboard for Defender ATP (Advanced Threat Protection). During my past customer engagements, I was often asked if there is a way to show device actions taken by Defender ATP admins. The answer is yes, this is possible. First,… READ MORE
I faced some troubles in executing cmdkey.exe on a PowerShell remote session, while I was trying to automate the creation of a SQL Failover Cluster Instance on Azure VMs, using Azure Premium File Share (PFS) as shared storage. You need cmdkey.exe since you must persist Azure PFS access credentials on the Credential Manager of both cluster nodes, into the… READ MORE
You can use Azure Database Migration Service to migrate the databases from an on-premises SQL Server instance to Azure SQL Database. In this example, we will move the SQL Server 2008 database on on-premises Windows Server 2008 R2 to Azure SQL. As seen in the image below, there is a database called “DCOInsurance” on SQL… READ MORE
Microsoft Flow does not have an action to create folders in either OneDrive or SharePoint. To my mind this is an odd design choice by the Flow team. There are two ways to overcoming this shortcoming. The first is to use the Microsoft Graph or the SharePoint API in a HTTP action to create the… READ MORE
In my previous posts, I have written quite a few times about SharePoint Framework service scopes (I will add links at the end of the article). In short, Service Scopes are the SPFx implementation of the Service Locator pattern i.e. a single shared “dictionary” where services (either oob SPFx or custom) are registered and can be consumed… READ MORE
When we decide to use JWT in our API’s and Frontend SPA, we need to use an algorithm when issuing a token. There are several options for subscribing to the JWT. It must be symmetrical or asymmetric. Probabilistic or deterministic. See in this article how to sign your JWT and tips on using them. When generating a JWT, it… READ MORE
Many software developers and programmers have this doubt regarding whether Python is faster than Visual Basic. Some of the experienced Python Programmers have the opinion that Visual Basic is faster than Python. This blog discusses this aspect of Visual Basic and before getting into the reason why Visual Basic is faster than Python, let’s get… READ MORE
