Create the Login
CREATE LOGIN [Login] WITH PASSWORD = 'password' GO
Create the User
CREATE USER [User]
Access to the GraphAPI requires an auth token best collected via ADAL.NET MSAL.NET is an alternative but it does not handle caching elegantly
AzureDevOpsAR is simply the name of the app registration AzureDevOps will be associated with, don't like the name? Simply change the references below.
RESTORE FILELISTONLY FROM DISK = 'C:\Temp\database.bak'
Note: SRIDS must be the same when performing opertations on multiple geography instances*
SqlGeometry is 2D while SqlGeography is 3D+. It is worth considering deafaulting to SqlGeometry simply unless 3D measuements or localised geography systems are used. Many 3rd parties provide data in 2D and it is easier to transform geometries to difference co-ordinate systems.
Try SharpKml (https://github.com/samcragg/sharpkml) great library for manipulating KML