Andreas Nyhrén ErikAndreas

Install chocolatey per instructions on site

cinst packages.config -y

"Your account control strategy should rely on identity systems for controlling access rather than relying on network controls or direct use of cryptographic keys" - Microsoft Well Architected framework Security pillar

Context and steps

Create Azure SQLServer and database, only allow AAD auth
Set AAD admin, preferably a group account and add whoever needs admin access
Set firewall rules
Test connection with e.g. SSMS using AAD - universal with mfa login
Create a table ('test' is used here)
Create function app, http triggered VS 2022, copy code from here

	pool:
	vmImage: Hosted Ubuntu 1604
	demands: npm

	steps:
	- task: Npm@1
	displayName: 'npm install'
	inputs:
	verbose: false

	pool:
	vmImage: Hosted Ubuntu 1604

	steps:
	- task: DotNetCoreCLI@2
	displayName: Restore
	inputs:
	command: restore
	projects: '$(Parameters.RestoreBuildProjects)'

	const connection = new signalR.HubConnectionBuilder()
	.withUrl('http://localhost:7071/api/v1.0/messages/binding',
	{ accessTokenFactory: () => "aJwtToken" })
	.build();

	using System;
	using System.Globalization;

	public class Program
	{
	public static void Main()
	{
	//string inputStr = "Tue 18:00-Wed 06:00";
	string inputStr = "Sat 18:00-Mon 06:00";
	var now = DateTime.Parse("2021-08-30 06:01:00");