Skip to Main Content
SQL Server on Azure Virtual Machines
book

SQL Server on Azure Virtual Machines

by Joey D'Antoni, Louis Davidson, Allan Hirt, John Martin, Anthony Nocentino, Tim Radney, Randolph West
June 2020
Intermediate to advanced content levelIntermediate to advanced
200 pages
4h 4m
English
Packt Publishing
Content preview from SQL Server on Azure Virtual Machines

3. Hero capabilities of SQL Server on Azure Virtual Machines

While platform as a service (PaaS) databases such as Azure SQL Database have many upsides, the most common SQL Server deployment method on Azure is in an IaaS virtual machine (VM). The typical reasons for this are that partner software may not support PaaS options, or that you may need to work on older versions of the SQL Server engine. Another common scenario is when an organization chooses to run another SQL Server component, such as SQL Server Integration Services (SSIS), alongside the database engine. Some of the other included features that may be used include PolyBase, which allows data virtualization to other data sources such as MongoDB, Oracle, or Teradata. Also, Machine ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Pro SQL Server on Microsoft Azure

Pro SQL Server on Microsoft Azure

Pranab Mazumdar, Sourabh Agarwal, Amit Banerjee

Publisher Resources

ISBN: 9781800204591