Creating Azure SQL Server

The creation of Azure SQL Server starts in the Azure portal in the same way as was described in the previous section. When finding a correct option, we need to use search term SQL Server 2017, because SQL Server 2016 is already offered. Azure portal will show a list of many options, but basically, we need to decide between three editions of SQL Server:

  • Enterprise
  • Standard
  • Web

When the choice is done, we are asked for Deployment model. The deployment model decides if we will create a resource (virtual machine in our case) existing independently of other resources, or we can group more resources together logically. Deployment model can be:

  • Classic: Newly created resource is independent.
  • Resource Manager: Resources ...

Get SQL Server 2017 Administrator's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.