Azure

A very quick tip today: When using an Azure Logic App in combination with an Azure SQL Database, filtering rows can be done like here. As example: A T-SQL query as this one… SELECT - FROM [dbo].[Customers] WHERE [StorageDataSentDate] IS NULL ORDER BY [Id] …will be formulated as filter expression with an OData query as here. The definition for the Get_rows_(V2) action looks similar as here: … "Get_rows_(V2)": { "inputs": { "host": {"connection": {"name": "@parameters('$connections')['sql']['connectionId']"} }, "method": "get", "path": "/v2/datasets/@{encodeURIComponent(encodeURIComponent('[someserver].database.windows.net'))}, @{encodeURIComponent(encodeURIComponent('governancetoolkit365'))}/tables/ @{encodeURIComponent(encodeURIComponent('[dbo].[Customers]'))}/items", "queries": {"$filter": "(StorageDataSentDate eq null)", $orderby": "Id"} }, "runAfter": {"Initialize_variable": ["Succeeded"]}, "runtimeConfiguration": { "paginationPolicy": {"minimumItemCount": 5} }, "type": "ApiConnection" }, … Depending on the data size, remember to configure pagination. ...

Working with Azure SQL Databases is handy. Just, how can I copy data from one Azure SQL database to another database? See the best practice here. I had such a use case. I needed to copy a table (all rows) from a source database to a destination database with SQL Management Studio. The table did not have much data, but extensive data with varchar(MAX) fields containing HTML and Base64 encoded images. So, a copy in the edit mode via clipboard did not work. ...

Delegate365 version 8.4 came up with a lot of improvements and updates. This version recently got another update to speed up the license assignment synchronization operation. See the details here. Delegate365 allows to add sync rules to the sync operation to automate specific operations. In large tenants, the sync can run for a long time since all objects must be queried for changes. To accelerate the sync operation when using license assignment sync rules, we optimized this process as follows: ...

atwork ist Anbieter von modernen Business-to-Business IT-Lösungen auf der Basis von Webtechnologien. Wir sind ein agiles Team und entwickeln Lösungen in unserem Büro in Wien Döbling. Wir suchen Dich zur Unterstützung unserer Lösungs- und Produktentwicklung und bieten flexible Arbeitszeiten und ein spannendes Umfeld! Dein Job ist die Entwicklung von Apps und Services mit Microsoft .NET und aktuellen Webtechnologien. Abhängig von Deiner Projekterfahrung und nach Einarbeitung in unsere Lösungen trägst du Verantwortung für Projekte und übernimmst Aufgaben in der Spezifikation, Design und Implementierung. Du arbeitest gemeinsam mit unseren Kollegen und Kunden aktiv an der Weiterentwicklung der Lösungen. ...

In addition to all the great features in Office 365, governance plays an important role, especially for large organizations. Richard Campbell, runasradio.com, interviewed Martina Grom recently about governance and tools in Office 365. The interview is available as podcast here. In this podcast, Richard chats with Martina about the various aspects of Office 365 that affect the way users collaborate with each other and get work done. There are bunch of great tools inside and outside of Office 365 to enable Governance. Check out the latest Office 365 Governance podcast with Martina Grom at runasradio.com. ...

Delegate365 v8.4 brings a bunch of new features and improvements. Office 365 Groups management allows to teamify existing groups and to control all Teams settings including policy settings. The Sync Job can send warnings if many objects are deleted, Shared Mailboxes and Resource Mailboxes licenses can be removed, Reports can be directly downloaded, Room Lists are available, License Orders can be exported and much more. See a description of the new features here. ...

Microsoft Forms is very popular because it is a very easy way to create web forms quickly. You can create surveys, quizzes and simple forms, and easily see results as they come in. This quick tutorial shows how you can use Microsoft Forms, convert a from into a group form, how to access the result file and how to add additional tasks with Microsoft Flow or Azure Logic Apps. So, here we go. ...

Azure Active Directory (Azure AD) acts as a central identity service and manages all apps in a tenant. When it comes to app management, Administrators often are confused why there are two (or currently three) application management modules existing in the Azure portal. Well, see the explanation here. An app can have many properties. The important part is, that Azure AD assigns an unique Application ID to an app and allows developers to add certain capabilities such as permissions, conditional access and more that is used by applications to access specific services. ...

The Microsoft MVP Award Program honors IT Professionals and Developers who support the Microsoft community and share their knowledge. The program´s renewal cycle is every year on July 1st. So, today it was a busy day on Twitter and the #MVPBuzz hashtag. We at atwork are proud and pleased that our MVP’s have been renewed for their community contributions for 2019-2020! The MVP Award is Microsoft’s way of thanking outstanding community leaders based on their actions to share knowledge and technology in all possible ways, from speaking engagements to supporting others in communities. An MVP is awarded for contributions over the previous year for community work. See more abut the MVP program at mvp.microsoft.com and learn about the award categories here and view all current MVPs here. ...

Yesterday, I wrote how to Update your Azure CLI with Choco. Today, I needed to renew an existing Service Principal Name in an AAD. A SPN stands for Service Principal Name which is used for automation authentication. The PowerShell az module got some updates (v1.0.0). So, here´s the full step-by-step instruction for renewing a SPN with az ad sp credential. This updates the steps described at How to create or renew Service Principal Names in Azure Active Directory… ...