blog.atwork.at

news and know-how about microsoft, technology, cloud and more.

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

Saturday, January 27, 2018 5:00 PM Toni Pohl
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.
Azure | Cloud | Developer | English | Microsoft | SQL Server | Security
mehr

CU at SharePoint Saturday Bremen 2018

Sunday, January 14, 2018 1:00 PM Toni Pohl
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!
Azure | Cloud | Developer | English | Event | Microsoft | MVP | Office365 | SharePoint | atwork
mehr

How Azure Security Center protects your data against cyber attacks

Monday, January 1, 2018 1:00 PM Toni Pohl
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.
Azure | Cloud | English | Microsoft | Office365 | Security
mehr

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

Friday, December 29, 2017 1:00 PM Toni Pohl
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!
Cloud | Business Intelligence | Developer | English | Microsoft | Office | Office365 | PowerApps | SharePoint | Tools | Graph
mehr

Import and export data to an Azure SQL Database

Thursday, December 7, 2017 5:00 PM Toni Pohl
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.
Azure | Cloud | English | Microsoft | SQL Server
mehr