Toni Pohl

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. ...

See the amazing musical made by interns spending the summer of 2019 at Microsoft: Microsoft the Musical. 150 interns and employees came to the Microsoft Redmond Campus outside of their day jobs to produce this 10 minutes video as a musical during the summer of 2019. The video was published to YouTube yesterday, on September 6th, and result is amazing. The full credits are at IMDb.com. Microsoft the Musical is a cool and professionally made video, with some self-mockery to Windows Vista, and Windows Phone and referrals to current technology. “All around the world our products are well known. Except for when we tried to make a phone…” ...

Das Wiener Büro der atwork gmbh befindet im Loft-Büro im Q19 Einkaufszentrum in Wien Döbling. Hier finden Sie eine kurze Wegbeschreibung und Hinweise für die Erreichbarkeit mit öffentlichen Verkehrsmitteln und das Parken mit dem Auto. Unser Adresse lautet: atwork gmbh Top 211 Kreilplatz 1 1190 Wien www.atwork-it.com Klicken Sie hier für eine Landkarte mit Bing Maps! Das atwork Office befindet sich im 2. Stock und ist am einfachsten über den Eingang Kreilplatz 1 (Club Köö) von der Strasse zu erreichen. Im Haus folgen Sie den Schildern mit unserem atwork Logo. ...

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. ...

Modern websites and website templates use Cascading Style Sheets (CSS) intensively. To load websites faster, it makes sense to reduce these files to the essential content. You can do that with many tools. PurgeCSS is one of them. See the How To here. I wanted to optimize a small, static one-pager website. I used a HTML5 template with Bootstrap 4. Nothing very fancy, but simple and modern. All my tests ran against my localhost. ...

When installing a new computer, it takes some time to download and install the essential software. This is what Chocolatey is for. Chocolatey is a cost free package manager for Windows using NuGet infrastructure and PowerShell to quickly installing applications and tools that you need. I am using choco since a long time, now I wanted to show my current packaged software for my new computer. See the script here. About and Prerequisites Partly taken from About Chocolatey: Chocolatey CLI aka choco (or choco.exe) is a client that provides the core of Chocolatey and the installation store for locally installed packages. You need to have Windows 7+ or/ Windows Server 2003+ as Operating System and PowerShell v2+ (not PowerShell Core yet though) and the .NET Framework 4+ installed. Just to mention, the installation will attempt to install .NET 4.0 if you do not have it installed, see choco installation and Getting Started. Besides the client, there also exists a Chocolatey GUI and Chocolatey Agent (aka chocolatey-agent) for central administration. ...

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. ...