atwork.blog

news and infos about microsoft, technology, cloud and more

How to restrict access and to connect to a single SQL Azure database only

As of today, many organizations use various Microsoft Azure services. SQL Azure databases are popular among them. Often, IT Administrators want to allow departments or vendors full access to just one specific SQL Azure database and to restrict their access to other resources. See here how this works.

CU at SharePoint Saturday Bremen 2018

We are looking forward to see you at the SharePoint, Office 365 and Azure community event next week on January 20, at the first SharePoint Saturday North Germany 2018, in the city of Bremen. There will be a lot of interesting sessions and a great speaker’s lineup. CU there!

How Azure Security Center protects your data against cyber attacks

In many scenarios, public cloud services allow a high grade of elasticity, flexibility and cost effectiveness combined with standardization. On the other hand, every customer needs to build trust to the desired platform and that all his services and data are protected against any attacks. So, it’s very interesting to see, what kind of mechanisms the large cloud providers as Microsoft are using to keep data safe and how they detect attacks and what countermeasures they execute.

How to access files stored in OneDrive or in a SharePoint site with Microsoft Graph and the Excel API

The Microsoft Graph API is the new unified endpoint for developers accessing data from an Office 365 tenant. Amongst many other features, you can work with OneDrive and SharePoint files with the Graph REST API. Additionally, you can directly work with Excel files through the Graph Excel API. Since all samples I found just use the personal OneDrive for Business (OFB) file storage, I wanted to document how to access files that are stored in a SharePoint Online site (SPO) as well. So, here we go!

Import and export data to an Azure SQL Database

BCP, the bulk copy program utility is still around - and it’s helpful! It’s a long time, since I used this tool, but nowadays it got promoted for one of my daily jobs. See a short description how to use the Microsoft Command Line Utilities with Azure SQL Database for connecting and importing and exporting data quickly.

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.