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
No comments:
Post a Comment