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

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: )

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

   Business scenario and justification:

   SQL Server 2016 Licensing costs:

   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:

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

   Business Calculations:

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

   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)

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

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

   业务场景和理由：

   SQL Server 2016许可费用：

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

   SQL Azure成本：

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

   业务计算：

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

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

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

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

4. The above justification clears an option of Pay as you go. How much you’ve used, pay for that.
   以上证明清除了“随用随付”选项。 您用了多少钱，为此付费。
5. Easy firewall options to control, who can access the databases.
   易于控制的防火墙选项，谁可以访问数据库。
6. SQL access with Virtual machines provides huge cost saving for the customers.
   使用虚拟机进行SQL访问可为客户节省大量成本。
7. Security patches – No need to think about updating the software’s, the cloud providers will take care of these things.
   安全补丁–无需考虑更新软件，云提供商将处理这些事情。
8. 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将自动切换服务器和所有内容。
9. 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门户的仪表板。 需要注意的一些重要部分。

1. Option to create your new services
   选择创建新服务
2. List of already created available services
   已创建的可用服务列表
3. List of datacenters in the globe for Microsoft Azure
   全球Microsoft Azure数据中心列表
4. 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
   支持控制台与支持团队联系–您可以提出问题，因为故障单，支持团队将以清晰的解决方案做出回应–个人而言，我喜欢他们的服务
5. Your logged in account details with logout option.
   使用注销选项登录的帐户详细信息。
6. Searching option for the objects and also help files.
   搜索对象和帮助文件的选项。
7. Indications near to search option. In case of any over usage of billing details everything.
   搜索选项附近的指示。 万一帐单明细化了，一切都在。
8. 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样式出现，并具有以下列表：

1. Database Name : Name of your SQL Azure database.
   数据库名称：SQL Azure数据库的名称。
2. Subscription Type : Under which subscription(payment model) you are trying to access or create database.
   订阅类型：您尝试访问哪个订阅（付款模式）或创建数据库。
3. Resource Group : It’s a kind of container which will have all the resources logically group together for maintenance purpose. See, I want to give access to a specific set of resources. In that case, I can group together and provide access to that group. This makes easier for me to allocate resources to resource groups based on what makes the most sense for your organization. Azure provides an option of
   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:
      • 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.
   5. Deployment dependencies – Clearly define the dependencies between the resources. So that, they will be deployed in correct order.
      

   资源组：这是一种容器，它将所有资源按逻辑分组以进行维护。 看，我想授予对一组特定资源的访问权限。 在这种情况下，我可以分组在一起并提供对该组的访问权限。 这使我更容易根据对您的组织最有意义的方式将资源分配给资源组。 Azure提供了以下选项
   1. 创建新的资源组
   2. 修改现有资源组

   该选项由您决定。

   资源组下要注意的关键点列表。

   1. 资源 –可通过Azure获得的易于管理的项目。 一些常见的资源是：
      • 虚拟机
      • 储存帐户
      • 网络应用
      • 数据库
      • 虚拟网络
   2. 使我们的生活更轻松，我们可以将解决方案的所有资源作为一个组进行部署，管理和监视，而不是单独处理。
   3. 一致性维护–我们可以在整个项目生命周期中重复部署解决方案，从而对处于一致状态的部署充满信心。
   4. 我们可以通过声明性模板而不是脚本来管理基础架构。
   5. 部署依存关系–明确定义资源之间的依存关系。 这样，它们将以正确的顺序部署。

Elastic pool – This is one of the awesome new feature introduced in latest version of SQL Azure. Let’s talk about this one in my later articles.

Now comes the very important factor, pricing tier option to select your preference. You got lot of pricing options based on the features like premium, standard and basic level. Let’s talk about the pricing in detail in my future articles.

I’ve selected an option of Basic level for my SQL Azure database.

我为我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云数据库