Intro
A few days ago Microsoft announced that you will be able to use an Azure Storage Account as SFTP (Secure File Transfer Protocol). This is a feature that a lot of people have been waiting for a long time. Please bear in mind that SFTP on a Storage Account is still in preview and lot might change in the regards to functionalities.
Azure SFTP is the right now the closest thing that you can get to FTP-as-a-Service, it’s something that I have been looking forward to myself for a long time (I can now finally shutdown my FTP server maybe). The need for (S)FTP has been in decline for a long time because there are a lot of great tools out there that can be used to share files and collaborate on said files. (Microsoft SharePoint, OneDrive etc.)
The need for SFTP is from my point of view still valid, when you need to share a large file with another company. One case for it is that you need to share a big database (.bak) with another person. Another case is you need to receive a lot of files from a vendor that you need in a program. Then SFTP might be more suited for your needs.
As I said, there are still many valid needs for SFTP.
Azure
Using Azure Service principal to run PowerShell script on Azure SQL server (Managed instance)
Azure service principals (or App regs.) is nice secure way to connect to fx. a Azure SQL manage instance and then perform querys using PowerShell. This is an ideal alternativ to using a local Service Account. The upside to this is that you can authenticate with a secret or with a certificate that you create for yourself or the machine you are running your script(s) from.
Assign Azure SQL database permissions to AAD group
Intro
When you create an Azure SQL database (DB) right of the bat, you will be faced with the need to assign permission in the database to users or security groups. Normally on an on-premises SQL DB it’s no problem and can be done using the GUI in SSMS. But for an Azure SQL DB, there is no GUI to assign permissions, you will need to use SQL queries to assign permissions to users or groups. Let me show you how to assign SQL DB permissions to a AAD security group.
How to create a Azure SQL server and a Database
So I was asked today to provide my good friend and colleague Martin Bengtsson with an Azure SQL Database (DB) for project regarding reporting from Config manager using Power BI.
First thing first, you cannot just create a SQL DB azure, you need to have a SQL server – As-a-Service. Then you can create all the databases you need.
Add custom domain to Azure App Service
I got a call last night from our in-house developer, he had created a website, to be used the following morning, and he needed to get a Custom domain name setup.
Here is how to setup a Custom Domain name for your Azure App Service