微软azure_有关MicrosoftAzure技术的简介和常见问题解答微软 azure
Most of the DBAs, Data Scientists, BI and Database developers are working on SQL Server on-premises. Is it time to migrate to the Cloud?
⼤多数DBA，数据科学家，BI和数据库开发⼈员都在内部SQL Server上⼯作。 现在该迁移到云了吗？
In this new article, we will talk about numbers, statistics, Azure technologies like Virtual Machines with SQL Server, Azure SQL, Azure Data Factory, Azure Machine learning and other technologies.
在这篇新⽂章中，我们将讨论数字，统计数据，Azure技术，例如带有SQL Server的虚拟机，Azure SQL，Azure数据⼯⼚，Azure机器学习和其他技术。
If you are not familiar with the Azure terms and technologies, this article is for you. We will give you an introduction to
Azure technologies.
如果您不熟悉Azure术语和技术，那么本⽂适合您。 我们将向您介绍Azure技术。
This article will answer the following questions:
本⽂将回答以下问题：
What is Azure?
什么是Azure？
Is Azure Popular compared with Amazon Web Services (AWS) or other cloud services?
与Amazon Web Services（AWS）或其他云服务相⽐，Azure Popular是否受欢迎？
How can I migrate SQL Server on-premises to Azure?
如何将SQL Server本地迁移到Azure？
What databases are available in Azure?
Azure中提供哪些数据库？
What is the difference between Azure SQL and Azure SQL Data Warehouse?
Azure SQL和Azure SQL数据仓库之间有什么区别？
What is an elastic database pool?
什么是弹性数据库池？
What is Redis Cache?
什么是Redis缓存？
I am using Linux. What are my options in Azure?
我正在使⽤Linux。 我在Azure中有哪些选择？
Can I setup an Oracle or DB2 database in Azure?
我可以在Azure中设置Oracle或DB2数据库吗？
Is it possible to handle Big Data in Azure?
是否可以在Azure中处理⼤数据？
What is Azure Storage, Azure Data Lake and what are the differences?
什么是Azure存储，Azure数据湖？有什么区别？
What is Azure Machine Learning?
什么是Azure机器学习？
What is the difference between SQL Server Data Mining and Azure Machine learning?
为什么oracle网站进不去SQL Server数据挖掘和Azure机器学习之间有什么区别？
What is Azure Data Factory?
什么是Azure数据⼯⼚？
What is the difference between Azure Data Factory (ADF) and SSIS?
Azure数据⼯⼚（ADF）和SSIS有什么区别？
什么是Azure？ (What is Azure?)
Azure is a Cloud Service Platform where you can create Virtual Machines, SQL Server Databases, My
SQL Databases, reports, Websites, Ethereum blockchain applications as well as store files and handle Big Data. It was announced in 2008 and released in 2010.
Azure是⼀个云服务平台，您可以在其中创建虚拟机，SQL Server数据库，MySQL数据库，报表，⽹站，以太坊区块链应⽤程序以及存储⽂件和处理⼤数据。 它于2008年宣布并于2010年发布。
与Amazon Web Services（AWS）或其他云服务相⽐，Azure Popular是否受欢迎？ (Is Azure Popular compared with Amazon Web Services (AWS) or other cloud services?)
According to the , AWS has approximately 33% of the share revenue, Azure is in second place with 11% and then is IBM with 8%, Google 5%. There are hundreds of cloud providers. Here you have a list of some of them:
根据 ，AWS拥有约33％的股份收⼊，Azure排名第⼆，为11％，其次是IBM的8％，Google的5％。 有数百个云提供商。 这⾥有⼀些清单：
AWS is winning the race (by far), but Microsoft is growing faster. According to the same reference, the Market Share Gain in the last 4 quarters was 1% by AWS and Azure 3%!
AWS赢得了⽐赛（到⽬前为⽌），但是Microsoft的增长速度更快。 根据同⼀参考，AWS和Azure过去四
个季度的市场份额增长为
1％，Azure为3％！
According to the , the cloud revenue per year was $12 billion and 70 million people use Office 365. Revenue from Azure grew triple digits and database usage doubled each year.
根据 ， 每年的云收⼊为120亿美元，并且有7000万⼈使⽤Office365。Azure的收⼊每年增长三位数，数据库的使⽤每年增加⼀倍。
如何将SQL Server本地迁移到Azure？ (How can I migrate SQL Server on-premises to Azure?)
You can migrate your data to Azure Virtual Machines where you can install SQL Server or use Azure Templates or use Azure SQL. Azure SQL is a service where you have a Database to connect and you do not need to worry about the operative system. You can have a Database in the Cloud in few minutes with automatic backups.
您可以将数据迁移到可以安装SQL Server或使⽤Azure模板或使⽤Azure SQL的Azure虚拟机。 Azure SQL是⼀项服务，您可以在其中连接数据库，⽽⽆需担⼼操作系统。 您可以在⼏分钟内通过⾃动备份在云中建⽴数据库。
What are some Virtual Machines in Azure (note that you can have Windows or Linux machines):
什么是Azure中的⼀些虚拟机（请注意，您可以拥有Windows或Linux计算机）：
There are several options to migrate the Data to Azure. You can use , , , , , , , , etc.
有多种选项可将数据迁移到Azure。 您可以使⽤ ， ， ， ， ， ， ， 等。
Azure中提供哪些数据库？ (What databases are available in Azure?) By the moment you can have the following Databases as services:
⽬前，您可以将以下数据库作为服务：
Database as a service for MongoDB
数据库作为MongoDB的服务
List of options in Azure:
Azure中的选项列表：
In a virtual machine in Azure, you can install any database supported by the OS.
在Azure的虚拟机中，可以安装操作系统⽀持的任何数据库。
Azure SQL和Azure SQL Datawarehouse有什么区别？ (What is the difference between Azure SQL and Azure SQL Datawarehouse?)
Azure SQL is a simple database (with some replications depending on the configuration specified). Azure SQL Data Warehouse is a that allows to process huge queries using multiple SQL DB Nones. That is why an Azure SQL Data Warehouse is more expensive.
Azure SQL是⼀个简单的数据库（某些复制取决于指定的配置）。 Azure SQL数据仓库是⼀种 ，允许使⽤多个SQL DB None处理⼤型查询。 这就是为什么Azure SQL数据仓库更昂贵的原因。
什么是弹性数据库池？ (What is an elastic database pool?)
is used to group several databases and pay an optimized amount for all the databases with variable usage.
⽤于对多个数据库进⾏分组，并为所有使⽤量可变的数据库⽀付优化的⾦额。
什么是Redis缓存？ (What is Redis Cache? )
(Remote Dictionary Server) is a NoSQL in-memory database. It is an open-source and supports string, lists, maps, sets and more types of data.
（远程字典服务器）是NoSQL内存数据库。 它是开源的，⽀持字符串，列表，映射，集合和更多类型的数据。
我正在使⽤Linux。我在Azure中有哪些选择？ (I am using Linux. What are my options in Azure?)
Azure SQL is in the Cloud, it can be administered using a browser in any operative system. You can access to the Azure Portal from your tablet, smartphone, your Linux machine or Windows machine. Approximately 33% of the virtual machines in Azure are using Linux.
Azure SQL位于云中，可以使⽤任何操作系统中的浏览器进⾏管理。 您可以从平板电脑，智能⼿机，Linux计算机或Windows计算机访问Azure门户。 Azure中⼤约33％的虚拟机正在使⽤Linux。
The following browsers are supported:
⽀持以下浏览器：
Internet Explorer 11.
Internet Explorer 11。
Microsoft Edge (latest version).
Microsoft Edge（最新版本）。
Chrome (latest version).
Chrome（最新版本）。
Firefox (latest version).
Firefox（最新版本）。
Safari (in Mac only).
Safari（仅在Mac中）。
You can always have a virtual machine with Ubuntu, RedHat, SUSE, CoreOS and more.
您始终可以拥有具有Ubuntu，RedHat，SUSE，CoreOS等功能的虚拟机。
Some VMs supported:
⽀持某些虚拟机：
You can also use MySQL or PostgreSQL as cloud services and create your WebSite or another language of your preference in Azure and connect to the Azure Databases.
您还可以将MySQL或PostgreSQL⽤作云服务，并在Azure中创建WebSite或您喜欢的其他语⾔，然后连接到Azure数据库。
Azure supports PowerShell for Linux, Visual Studio for Linux, PHP, Java and more languages.
Azure⽀持Linux的PowerShell，Linux的Visual Studio，PHP，Java和其他语⾔。
我可以在Azure中设置Oracle或DB2数据库吗？ (Can I setup an Oracle or DB2 database in Azure?)
There are some nice VM templates to setup Oracle or DB2.
有⼀些不错的VM模板可⽤于设置Oracle或DB2。
The DB2 template for VM:
VM的DB2模板：

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。