Introduction to Azure SQL Deployment and Configuration

https://microsoft.github.io/sqlworkshops/

• IaaS
• VM with SQL
• SSAS and SSIS require their own VM
• PaaS
• Backups are automatic full
• Just SQL Instance
• Includes SQL Agent
• Just SQL DB
• 8tb max size
• Hyperscale required for No maximum size
• Versionless, auto-patches
• Cannot restore a bak file, but can import or use bacpak
• Azure Data studio used to connect to db's instead of SSMS using web interface through azure
• Lift and Shift, can move VHD or import instance to cloud
• Tempdb can be put on local ssd
• General Purpose - General solution
• Business Critical - Local Redundancy
• Database Only - mainly useful for
• Business Apps, Ecommerce, Dev/Test
• Migration
• azure.com/AMP
• aka.ms/datamigration

Business Central - "We paused while you were away" happens too quickly

Nothing to do with timeout.

An Image is missing, images do not transfer via DD, you must import them locally to each POS database from the Retail Image List screen.

A menu button is invalid and setup pointing to an invalid function or image

 Set-NAVWebServerInstanceConfiguration -WebServerInstance BC150 -KeyName SessionTimeout -KeyValue "01:00:00"

Restart-NAVServerInstance [Instance Name]

Restart instance