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 Mediumlink | Permalink | Comments (0) | Post RSS 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 Mediumlink | Permalink | Comments (0) | Post RSS 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 Mediumlink | Permalink | Comments (0) | Post RSS mehr
When to use what Azure monitoring service Sunday, March 7, 2021 7:00 AM Martina Grom The well-known Scott Hanselman has been producing the recurring Azure Friday series for a long time. Last Friday, Scott interviewed Azure Barry (Barry Luijbregts) about "What to use for monitoring your applications in Azure". Barry did a great overview about the main monitoring services. See the recording and a kind of summary transcript here. Azure | App | Cloud | Developer | English | Governance | Microsoft | Serverless | Tools | Visual Studio Mediumlink | Permalink | Comments (0) | Post RSS 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 Mediumlink | Permalink | Comments (0) | Post RSS mehr
Azure Logic Apps Toolbox 5-Custom JSON payloads Thursday, January 14, 2021 8:51 PM Christoph Wilfing Did you ever have the problem of pushing different JSON payloads to a logic app and hitting errors due to JSON schema mismatches? The usual HTTP Request forces you to define the JSON Schema at the beginning. For every tiny difference in the later used properties you need to create your own Logic App even if the process is the same. I will show you an example of a single Logic App deciding at runtime which JSON schema to use for decoding the post body payload. Stay tuned! Azure | Cloud | Developer | English | Flow | Logic apps | Microsoft | PowerShell Mediumlink | Permalink | Comments (0) | Post RSS mehr
Join the M365 virtual community events Tuesday, January 5, 2021 9:00 PM Martina Grom Ready to learn more about Microsoft 365 technology such as Microsoft Graph, SharePoint, Office-AddIns and more? Check out the Microsoft 365 virtual community events! Azure | Cloud | Developer | English | Graph | Microsoft | Microsoft365 | Office | Office365 | SharePoint Mediumlink | Permalink | Comments (0) | Post RSS 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 Mediumlink | Permalink | Comments (2) | Post RSS mehr
Azure Logic Apps Toolbox 4-Working with SharePoint dropdown fields Friday, December 18, 2020 3:00 PM Toni Pohl Yesterday I documented in "Get data from SharePoint as HTML table with Azure Logic Apps" how data is retrieved from SharePoint Online with an Azure Logic app. To dig a little deeper into working with SharePoint list data, here are a few more helpful tips. Azure | Developer | English | Logic apps | Microsoft | Microsoft365 | Office365 | SharePoint Mediumlink | Permalink | Comments (1) | Post RSS mehr
Azure Logic Apps Toolbox 3-Get data from SharePoint as HTML table Thursday, December 17, 2020 6:00 PM Toni Pohl Sometimes it´s good to get data from a data source as a table and as quickly as possible in an automated way. While this can be done with multiple ways, here´s a quick solution if you want to get the items from a custom list in SharePoint Online sent as a HTML table in an email with Azure Logic Apps (or Power Automate). Azure | Cloud | Developer | English | Logic apps | Microsoft | Microsoft365 | Office365 | SharePoint Mediumlink | Permalink | Comments (1) | Post RSS mehr
Get the new Azure architecture icons v3 Monday, November 30, 2020 6:00 PM Toni Pohl Cloud architecture diagrams need to look good. Get the new Azure architecture icons v3 here! Azure | Cloud | English | Microsoft | Design Mediumlink | Permalink | Comments (0) | Post RSS mehr
Free Microsoft eBook Roadmap to Digital Infinity Tuesday, November 17, 2020 10:30 PM Martina Grom Today´s a quick tip: Check out the free Microsoft eBook "Roadmap to Digital Infinity" - How to become an Intelligence Driven Organization! Azure | Cloud | Business Intelligence | English | Microsoft Mediumlink | Permalink | Comments (1) | Post RSS mehr