Optimize your Azure SQL Database performance with Automatic Tuning

Optimize your Azure SQL Database performance with Automatic Tuning

When moving SQL databases to Azure, let Azure do some work for you. As the name suggests, the Azure SQL Database Automatic Tuning feature provides automatic performance optimization for databases. Activate it, it’s simple. Once the data is available in Azure SQL Database, there is no more server maintenance necessary. Azure SQL Database is a relational database-as-a service that runs in the Microsoft Cloud. With the service there comes a bunch of benefits. One of them is the Automatic Tuning Mode. This enables stable workloads through continuous performance tuning utilizing Artificial Intelligence and applying corrective actions for databases in use. See more at Automatic tuning in Azure SQL Database ...

December 6, 2017 · 2 min · Toni Pohl
Delegate365 changelog version 7.1-Fixes, User Interface improvements, Sync Lock, MFA and more

Delegate365 changelog version 7.1-Fixes, User Interface improvements, Sync Lock, MFA and more

Right after Delegate365 version 7, we are releasing version 7.1 with some relevant updates. This version brings some fixes, an improved SyncOp, Sync Locking, First Start-support, a new Multi Factor Authentication automation feature, a streamlines sync rules experience, more videos and some updates. See the benefits and the details here. Dashboard-First Steps: To inform Admins if the basic Delegate365 configuration is missing, the dashboard now shows a First Steps box if necessary. This essentially helps new Delegate365 admins to show the required steps to configure Delegate365. Tasks that are already accomplished are marked with a green OK icon, open tasks are shown with an orange warning icon. So, this feature basically checks if they SyncOp has been executed to update the Delegate365 cache at least once, if at least one OU is existing, if at least one administrator has been assigned to one OU and one domain and if there are users assigned to any OU (so that there are users visible in Delegate365). The admin can click on the task to open the corresponding page to configure the desired properties. The following screenshot shows an example with three accomplished tasks and one open task. Once all requirements are satisfied, the First Steps box will no longer be visible (or show up again, if any requirement is missing). There is no manual method for switching the First Steps box on or off, it appears automatically to support the admin. Independently, Delegate365 checks if the connections to Azure Active Directory and Office 365 are valid as well. We think, this new feature makes sense in existing Delegate365 tenants and particularly in new ones. ...

December 4, 2017 · 7 min · Toni Pohl

atwork participates at The Art of Data Management event

The new GDPR (General Data Protection Regulation) comes in force in 6 months. From then on, every business processing personal data has to fulfil the statutory European data privacy laws. A violation can result in high fines and penalties. Within the cost free seminar series “The Art of Data Management”, taking place in Germany and Austria, atwork prepares you for the statutory changes. Our experts pass on a first general insight into the security concept of Office 365 and Azure and tell you how to fulfil the conditions of the new regulation with the help of Microsoft Cloud Services. ...

November 20, 2017 · 1 min · Toni Pohl
Get sample data quickly with Bing Search

Get sample data quickly with Bing Search

For testing purposes, having sample data is very helpful. Recently, I stumbled about a useful tool to get sample images for a custom topic quickly. See how to get test images here. So, imagine you need sample images for testing the Microsoft Custom Vision API. How to get sample pictures? Well, there’s a great source for that by Dmitri Soshnikov. at Custom Vision API demo on GitHub. Download the imdownload.exe tools and run this command line executable with a syntax as here: ...

November 20, 2017 · 1 min · Toni Pohl

Impressions of SharePoint Saturday Barcelona 2017

Fall time usually is a very busy time in the IT business. So, we were happy to have a break and be part of SharePoint Saturday 2017 in Barcelona! #SPSBCN took place on the 28th October in beautiful Barcelona (see the details on the SPSEvents.org website here). This event already was the 3rd SharePoint Saturday Barcelona. The venue location at IQS was the same as in the years before. Edin and his team of sug.cat (Grup d’Usuaris de SharePoint de Catalunya) organized the event perfectly and we all had a great time there. ...

November 9, 2017 · 2 min · Toni Pohl

Visual Studio Extension for SharePoint Framework

Developers who are not familiar with the new tooling for creating SPFx apps now get support by the new Visual Studio Extension for SharePoint Framework, available in the Visual Studio marketplace. Check it out at https://marketplace.visualstudio.com/items?itemName=SharePointPnP.SPFxProjectTemplate The description describes the functionality as “The Visual Studio Extension for SharePoint Framework wraps the command-line UI of the Microsoft Yeoman Generator (yo @microsoft/sharepoint) into a familiar Windows Forms experience, executes the generator project scaffolding behind the scenes and creates a Visual Studio project that includes all the necessary files for a complete web part project. Also included is a web part item template for adding new web parts to an existing Framework project. Developers can launch the Workbench local sandbox environment to test their web parts by pressing F5 or by binding to the Gulp Serve event in the Task Runner Explorer.” ...

November 4, 2017 · 1 min · Toni Pohl
Delegate365Cleanup unused apps

Delegate365Cleanup unused apps

Delegate365 is registered as an app in the customer’s Azure Active Directory. When a Delegate365 setup is executed, it may be necessary that a new app is registered and is used from then on. So, what happens with old apps? See how to cleanup unused Delegate365 apps here. Technically, the app needs permissions to sign-in the user and to read data from the tenant. If new app permissions are necessary through an update (as this was the case with version 6.5 and the new service health feature), the Delegate365 setup must be re-run. When a new app is created, the Administrator then has to confirm the app consent for his users as described here. ...

November 1, 2017 · 2 min · Toni Pohl

Azure Functions for Visual Studio Code

Working with Visual Studio Code? Then check out the Azure Functions extension for Visual Studio Code at the Visual Studio Marketplace! Find the extension and description at Azure Functions for Visual Studio Code. The Azure Functions for Visual Studio Code extension allows to create new projects and functions from a template, to debug function apps locally, to view and to deploy Azure functions, to start, stop and restart functions and has Intellisense support for the json-project files. ...

October 22, 2017 · 1 min · Toni Pohl
Change a connection for existing Azure LogicApps

Change a connection for existing Azure LogicApps

If one of your coworkers created a LogicApp some months ago and you want to “de-personalize” the connections used in a flow, you can modify the settings easily – if you know how to. So, in my case, in a LogicApp that’s sending emails and adding users to the newsletter system, the creator used a personal Office 365 account. I wanted to change that to an email “service” account. So I created a new mailbox account as first step. ...

October 20, 2017 · 2 min · Toni Pohl

See you at Thrive conference in Slovenia!

SharePoint Days conference has evolved to Thrive conference! We are looking forward to Thrive conference in beautiful Rimske Terme/Slovenia from 8th to 9th November! Join us and a bunch of experts and MVP fellows at this great event that’s close to Austria and Central Europe! Have a look a the great speakers lineup and the agenda with a lot of tracks and sessions around SharePoint, Office365 and Azure! As in the last year, Martina and I are honored to be part of Thrive conference. ...

October 18, 2017 · 1 min · Toni Pohl