DP203
2023-02-25 本文已影响0人
山猪打不过家猪
1.Introduction to Azure Cloud Computing
1.1 Resource management group and subscription
![](https://img.haomeiwen.com/i14814834/b1b5d2d40c8aa034.png)
1.2 CREATE A SQL SERVER ON AZURE
-
choose an azure service
image.png
-
create a new SQL server and database
image.png
-
waiting for the creation to finish and getting the connection address
image.png
-
use the address and admin name logging in from sqlserver2008
image.png
1.3 Data Cycle
![](https://img.haomeiwen.com/i14814834/3cabe85c03c0b25a.png)
- HDFS: distributed file system
1.4 SQL Server in azure virtual machine
![](https://img.haomeiwen.com/i14814834/19949148279a64dc.png)
![](https://img.haomeiwen.com/i14814834/399ea2cd61f960ba.png)
1.4 FIREWALL SETTINGS
![](https://img.haomeiwen.com/i14814834/510d7ff577afb32f.png)
1.4 ELASTIC DATABASE
-
create an elastic database
image.png
- db1001 and db1002 are the single databases on the same server dbsvr1001
- db1003 is not an elastic database, and it is on a different server
add an elastic pool
![](https://img.haomeiwen.com/i14814834/e1614374ab4fd177.png)
![](https://img.haomeiwen.com/i14814834/5ab27a8e9a9ecbff.png)
-
add these two databases to the pool
image.png
image.png
image.png
1.5 Managed Instance(04/033)
![](https://img.haomeiwen.com/i14814834/53eb2edcfd2c9295.png)
-
step 1. create a new a visual machine
image.png
-
create a new subnet
image.png