blog.atwork.at

news and know-how about microsoft, technology, cloud and more.

Optimize SQL queries using subqueries for lookups in Azure SQL Databases

Tuesday, April 27, 2021 11:00 PM Toni Pohl
I like to work with Azure SQL Databases and use data from the cloud without any administrative effort. When working with apps, App Insights helps to detect anomalies, and to analyze bottle necks. Although SQL Azure can scale very well, we discovered performance issues in some legacy apps. Read here how we solved that by optimizing TSQL data queries.
Azure | Developer | English | Microsoft | SQL Server
mehr

Join us at globalazure.at 2021

Thursday, April 15, 2021 10:10 PM Toni Pohl
We look forward to participating in the Global Azure Austria event again! The event is part of the event series Global Azure 2021. As in the past years, the Austrian edition of Global Azure 2021 is provided by the Coding Club Linz. Like last year, Global Azure 2021 will be a virtual event again and deliver over 30 sessions to your home on April 16th. Join us!
Azure | English | Event | Microsoft | MVP | atwork
mehr

Tips for PowerApps-Add required user permissions for PowerApps using Dataverse

Thursday, April 1, 2021 9:45 PM Toni Pohl
When users shall have access to a PowerApp that is using Dataverse (formerly Common Data Service - CDS), they also need to have the permissions to access the data entity (nowadays called table). So, if your users get an ugly "unknown error occurred" when accessing the PowerApp, here´s the solution to assign the required security role and permissions.
App | Developer | English | Microsoft | Microsoft365 | Office365 | PowerApps
mehr

Azure Logic Apps Toolbox 7-Resolve issues with the SharePoint Connector

Thursday, March 11, 2021 10:45 PM Toni Pohl
Using SharePoint Online (SPO) and Azure Logic Apps helps to automate processes. For a project, we have created some workflows with Azure Logic Apps that monitor changes to an SPO list or document library for approvals and other document workflows. We have found that the SPO connector does not always send all data in a reproducible manner: sometimes some fields were sent and sometimes not. We struggled with this behavior and found an unexpected workaround.
Azure | Developer | English | Logic apps | Microsoft | Microsoft365 | Office365 | Serverless | SharePoint
mehr

Azure Logic Apps Toolbox 6-Work with items in Apply to each

Saturday, March 6, 2021 8:00 AM Toni Pohl
Automation of small tasks is helpful for many recurring processes. Unless you regularly use Power Automate (Flow) or Azure Logic Apps, it is often not that easy to remember the correct syntax for accessing items in a loop. Here is the quick help.
Azure | Business Intelligence | Cloud | Developer | English | Logic apps | Microsoft | Microsoft365 | Office365 | Serverless
mehr

Working with Azure AD schema extensions in Graph PowerShell

Thursday, March 4, 2021 5:00 PM Toni Pohl
Schema extensions enable to store extended custom data directly to objects in Azure AD. This article describes how to access data we defined and added in Introducing user schema extensions in Delegate365 with the Microsoft Graph PowerShell module.
Delegate365 | English | Developer | Cloud | Microsoft | Microsoft365 | Office365 | PowerShell | Tools | atwork
mehr

Introducing user schema extensions in Delegate365

Thursday, February 25, 2021 9:00 PM Toni Pohl
The current version of Delegate365 adds a new feature: Schema extensions for users. Schema extensions allow to add custom data to Azure AD objects. In Delegate365, administrators can use the Delegate365 schema extension feature to add custom properties to a user. Find out, how you can use the user schema extension in Delegate365 here.
Delegate365 | English | Microsoft | Office365 | Microsoft365 | atwork | Cloud
mehr

Use multiple Node.js versions on your computer (and develop a SPFx webpart)

Saturday, January 23, 2021 9:00 PM Toni Pohl
As developer, it often makes sense to have multiple versions of a framework installed on a single computer. For example, when developing SPFx applications with Node,js v10.x and developing web applications using Angular and Node.js v14.x you need both versions. Thankfully, with Node Version Manager, we can.
Developer | English | Microsoft | Open Source | SharePoint | Tools
mehr

Working with Azure AD schema extensions and Microsoft Graph

Tuesday, December 29, 2020 10:30 PM Toni Pohl
Azure Active Directory is Microsoft´s Cloud Identity system that stores user, license, group, apps, device data and more data in a secure way. As developers, we can extend many of these resources with custom extension. This can be useful to store additional metadata, such as a cost center or personal data for a user, for a group or other resource types. Unfortunately, there isn't much documentation on that. Here's how to do this step-by-step for the user resource with Azure AD schema extensions in real life.
Azure | Cloud | Developer | English | Graph | Microsoft | Microsoft365 | Office365 | PowerShell
mehr