azure云数据库_Microsoft Azure SQL数据库-分步创建教程

最新推荐文章于 2023-03-19 22:27:27 发布

culuo4781

最新推荐文章于 2023-03-19 22:27:27 发布

阅读量935

点赞数

文章标签：数据库 java 大数据 mysql python

原文链接：https://www.sqlshack.com/microsoft-azure-sql-database-step-by-step-creation-tutorial/

版权

azure云数据库

Microsoft Azure SQL Database is a managed cloud database for programmers/developers to develop their products easier due to less involvement in maintenance allowing the customer to concentrate on their products, because, most of the data maintenance or infrastructure is taken care by the cloud service providers.

Microsoft Azure SQL数据库是一个托管的云数据库，程序员/开发人员可以更轻松地开发产品，这是因为维护工作较少，使客户可以专注于他们的产品，因为大多数数据维护或基础架构都由云服务提供商来处理。

云数据库的优点： ( Advantages of a cloud database: )

Elastic in nature – increase or decrease your server capacity instantly.
本质上具有弹性–立即增加或减少服务器容量。
Availability – Geo replication becomes too easier. This makes the backup strategy very easy two or three clicks.
可用性–地理复制变得太容易了。这使备份策略非常容易，只需单击两次或单击三下即可。

Business scenario and justification:

业务场景和理由：

SQL Server 2016 Licensing costs:

SQL Server 2016许可费用：

SQL Server 2016 editions	Description or suitability of the product	Licensing Details	Channel availability	Cost of the product (US$)
Enterprise	Comprehensive, Projects with high critical database and business intelligence requirements. The software provides high reliability and handles huge performance levels for Tier-1 workloads.	Per core**	Volume licensing, hosting	$14,256***
Standard	Core database management functionalities and business intelligence capabilities for non-critical workloads with minimal IT resources.	Per core**	Volume licensing, hosting	$3,717***
Standard	Core database management functionalities and business intelligence capabilities for non-critical workloads with minimal IT resources.	Server + CAL**** (CAL – Client Access License)	Volume licensing, hosting, retail FPP	$931***
Developer	Full-featured version of SQL Server software that allows developers to cost-effectively build, test, and demonstrate applications based on SQL Server software.	Per user	Free download	Free
Web	Secure, cost effective and highly scalable data platform for public web sites. Available to third party software service providers only.	–	Hosting only	See your hosting partner for pricing
Express	Free entry-level database that’s ideal for learning, as well as building desktop and small server data-driven applications of up to 10 GB.	–	Free download	Free

SQL Azure Costs:

SQL服务器 2016年版	产品说明或适用性	许可详细信息	频道可用性	产品成本（美元）
企业	具有高关键数据库和商业智能要求的综合项目。该软件具有很高的可靠性，并可以处理1级工作负载的巨大性能水平。	每核心**	批量许可，托管	$ 14,256 ***
标准	核心数据库管理功能和商业智能功能，可利用最少的IT资源处理非关键工作负载。	每核心**	批量许可，托管	$ 3,717 ***
标准	核心数据库管理功能和商业智能功能，可利用最少的IT资源处理非关键工作负载。	服务器+ CAL **** （CAL –客户端访问许可证）	批量许可，托管，零售FPP	931美元***
开发者	SQL Server软件的功能齐全的版本，使开发人员可以经济高效地构建，测试和演示基于SQL Server软件的应用程序。	每位使用者	免费下载	自由
网页	适用于公共网站的安全，经济高效且高度可扩展的数据平台。仅适用于第三方软件服务提供商。	–	仅托管	咨询您的托管合作伙伴以获取价格
表达	免费入门级数据库，非常适合学习以及构建高达10 GB的桌面和小型服务器数据驱动的应用程序。	–	免费下载	自由

SQL Azure成本：

For basic level of SQL Azure is $4.99 per month.

SQL Azure的基本级别为每月4.99美元。

Business Calculations:

业务计算：

For a small critical project, which lasts for 3 months of time,

对于一个持续3个月的小型关键项目，

Dedicated database	A user needs to buy the Standard version which costs	$3,717 (USD)
Microsoft AzureSQL Database	A user can opt any other Azure model for storing the data	3 * 4.99$ = 14.97$
	Cost Savings	$ 3702.03 (USD)

专用数据库	用户需要购买收费标准版	$ 3,717（美元）
Microsoft AzureSQL数据库	用户可以选择任何其他Azure模型来存储数据	3 * 4.99 $ = 14.97 $
	节约成本	$ 3702.03（美元）

After 3 months, I finished my project and no need for SQL Server. If we think above the cost savings, it is really huge.

3个月后，我完成了项目，不需要SQL Server。如果我们认为节省成本以上，那确实是巨大的。

Final Result : The above calculations demonstrates the advantages of Azure Computing in the modern era.

最终结果：以上计算证明了Azure计算在现代时代的优势。

The above justification clears an option of Pay as you go. How much you’ve used, pay for that.
以上证明清除了“随用随付”选项。您用了多少钱，为此付费。
Easy firewall options to control, who can access the databases.
易于控制的防火墙选项，谁可以访问数据库。
SQL access with Virtual machines provides huge cost saving for the customers.
使用虚拟机进行SQL访问可为客户节省大量成本。
Security patches – No need to think about updating the software’s, the cloud providers will take care of these things.
安全补丁–无需考虑更新软件，云提供商将处理这些事情。
Disk space – Maintaining the machine is the core part of the cloud providers. In case of disk filling, an automatic switch over of servers and everything is taken care by Microsoft.
磁盘空间–维护计算机是云提供商的核心部分。在磁盘填充的情况下，Microsoft将自动切换服务器和所有内容。
Moving databases between different servers to handle increased load – Everything is on simple clicks and the provider will take care of rest.
在不同的服务器之间移动数据库以处理增加的负载–只需单击一下，一切便由提供程序来处理。

SQL Azure历史记录： ( SQL Azure History: )

SQL Azure was originally announced in 2009 and released in 2010.

SQL Azure最初于2009年宣布，于2010年发布。

SQL Azure分步创建： ( SQL Azure Step by Step creation: )

Step 1 : To access or create your Azure services or database. Go to -> Microsoft Azure

步骤1：访问或创建您的Azure服务或数据库。转到-> Microsoft Azure

Step 2 : You need a Microsoft account to login. Use your credit card for initial registration. You’ve got 3 months of free access to Azure portal and afterwards, they will charge for your usage.

步骤2：您需要一个Microsoft帐户才能登录。使用您的信用卡进行初始注册。您有3个月的免费访问Azure门户的权限，此后，它们将向您收取使用费。

Step 3: Once you’ve registered and your account will get activated and you can see the initial portal of your Azure platform as below.

步骤3：注册后，您的帐户将被激活，您可以看到如下所示的Azure平台的初始门户。

Step 4: You are able to see the dashboard of your Azure portal as below. Some of the important portions to note down.

步骤4：可以看到如下所示的Azure门户的仪表板。需要注意的一些重要部分。

Option to create your new services
选择创建新服务
List of already created available services
已创建的可用服务列表
List of datacenters in the globe for Microsoft Azure
全球Microsoft Azure数据中心列表
Support console to contact support team – You can raise your problems as tickets and the support team will respond with clear solutions – personally, I love their service
支持控制台与支持团队联系–您可以提出问题，因为故障单，支持团队将以清晰的解决方案做出回应–就我个人而言，我喜欢他们的服务
Your logged in account details with logout option.
使用注销选项登录的帐户详细信息。
Searching option for the objects and also help files.
搜索对象和帮助文件的选项。
Indications near to search option. In case of any over usage of billing details everything.
搜索选项附近的指示。万一帐单明细化了，一切都在。
Billing summary information’s.
帐单摘要信息。

Step 5: Click “New” and Select “Databases” and you can click “SQL Database” to create your SQL Azure database.

步骤5：单击“新建”并选择“数据库”，然后单击“ SQL数据库”以创建SQL Azure数据库。

Step 6: Once you click the SQL Database, a SQL Database blade will appear in metro style with the below list:

步骤6：单击SQL数据库后，SQL数据库刀片将以Metro样式出现，并具有以下列表：

Database Name : Name of your SQL Azure database.
数据库名称：SQL Azure数据库的名称。
Subscription Type : Under which subscription(payment model) you are trying to access or create database.
订阅类型：您尝试访问哪个订阅（付款模式）或创建数据库。
1. Creating new resource groups
  创建新的资源组
2. Amend to the existing resource groups
  修改现有资源组
The option is yours to decide.

该选项由您决定。

List of key points to note under resource group.

资源组下要注意的关键点列表。
1. resource – An easily manageable item that is available through Azure. Some of the common resources are: 资源 –可通过Azure获得的易于管理的项目。一些常见的资源是：
  - virtual machine,
    虚拟机
  - storage account
    储存帐户
  - web app
    网络应用
  - database
    数据库
  - virtual network
    虚拟网络
2. Makes our life easier, we can deploy, manage, and monitor all the resources for your solution as a group instead of handling them individually.
  使我们的生活更轻松，我们可以将解决方案的所有资源作为一个组进行部署，管理和监视，而不是单独处理。
3. Consistency maintenance – We can repeatedly deploy solutions throughout the project lifecycle with much more confidence on our deployment which is in consistent state.
  一致性维护–我们可以在整个项目生命周期中重复部署解决方案，从而对处于一致状态的部署充满信心。
4. We can manage our infrastructure through declarative templates rather than scripts.
  我们可以通过声明性模板而不是脚本来管理基础架构。

1. Whether you want to create a blank database – No tables in it.
  是否要创建空白数据库–其中没有表。
2. Want to create a sample database – you can see AdventureworkLT. All the tables will be placed in your database. This will be used to work out some samples or quick check on your SQL databases.
  想要创建一个示例数据库–您可以看到AdventureworkLT。所有表都将放置在您的数据库中。这将用于计算一些样本或快速检查您SQL数据库。
3. Backup – Whether this database is a backup database for already created databases (if any)
  备份–此数据库是否为已创建数据库的备份数据库（如果有）
1. On selecting this option, a new blade comes right to the existing windows asking for creating a new server or you need to put it in the existing server (if any).
  选择此选项后，新刀片将直接出现在现有窗口上，要求创建新服务器，或者您需要将其放入现有服务器（如果有）中。
2. - Server name
    服务器名称
  - Server admin login
    服务器管理员登录
  - Password to access the server
    访问服务器的密码
  - Confirm password
    确认密码
  - - Location of the server you want. (List of available data centers will be provided in the drop down. You can select the server location based on your preference)
      您想要的服务器的位置。（可用数据中心列表将在下拉列表中提供。您可以根据自己的喜好选择服务器位置）
    - An additional option is available like, allow Azure services to access server. If you want your Azure service to access, click and enable it.
      可以使用其他选项，例如允许Azure服务访问服务器。如果要访问您的Azure服务，请单击并启用它。
    - Click select button in the below window and finalize your option.
      单击下面窗口中的选择按钮，然后完成选择。
I’ve selected an option of Basic level for my SQL Azure database.

我为我SQL Azure数据库选择了基本级别的选项。
Collation indicates the way, how you are going to store the data and it is bounded by a set of rules. This is really important to store a varchar or char data type or nchar or nvarchar data type. The reason is we are able to specify 归类指示方式，存储数据的方式以及受一组规则限制的数据。这对于存储varchar或char数据类型或nchar或nvarchar数据类型非常重要。原因是我们能够指定
1. case-sensitivity,
  区分大小写，
2. accent marks
  重音符号
3. kana character types and
  假名字符类型和
After selecting the collation type, If you want you can pin the database in to the dashboard for quicker access.
选择排序规则类型后，如果需要，可以将数据库固定在仪表板上，以加快访问速度。
Click “Create” button. Now you SQL Azure database is ready to go.
点击“创建”按钮。现在，您可以使用SQL Azure数据库了。
Step 7: Below is the database creation blade for your reference.

步骤7：以下是数据库创建刀片供您参考。

Step 8: You are able to see the database SQLShack database is created in the server sqlshackvenkat server. It is displayed in your dashboard as below,

步骤8：您可以看到数据库SQLShack数据库是在服务器sqlshackvenkat服务器中创建的。它显示在您的仪表板中，如下所示，

Step 9: On clicking the newly created SQL Server “sqlshackvenkat” you are able to see all the internal details as below.

步骤9：在单击新创建SQL Server“ sqlshackvenkat”时，您可以看到如下所有内部详细信息。

Final Step 10: Below is the overall features and details of our SQL Azure database created.

最终步骤10：以下是我们创建SQL Azure数据库的总体功能和详细信息。

翻译自: https://www.sqlshack.com/microsoft-azure-sql-database-step-by-step-creation-tutorial/

azure云数据库