logo
 
  1. IT-Security >
  2. Programmierung >
  3. SQL Server on Azure Virtual Machines resource provider


ArabicEnglishFrenchGermanGreekItalianJapaneseKoreanPersianPolishPortugueseRussianSpanishTurkishVietnamese

SQL Server on Azure Virtual Machines resource provider

RSS Kategorie Pfeil Programmierung vom | Quelle: azure.microsoft.com Direktlink öffnen

SQL Server on Azure Virtual Machines is a cost-effective lift and shift method to run SQL Server on Microsoft Azure with full control of the version, edition of SQL Server, operating system, and VM size. Today, we are revealing a new Resource Provider called Microsoft.SqlVirtualMachine, a management service running internally on Azure clusters to handle SQL Server-specific configurations and deployments on Azure VMs. SQL VM resource provider enables dynamic updates of SQL Server metadata and orchestrates multi-VM deployments required for SQL Server HADR architectures. SQL VM resource provider also enables SQL Server specific browse and monitoring experiences.

With SQL VM resource provider, we are introducing three new resource types:

  • Microsoft.SqlVirtualMachine/SqlVirtualMachine represents SQL Server configurations on an Azure VM. Once created, it links to the existing VM resource with the VirtualMachineResourceId property and gets SQL Server configurations from SQL IaaS Extension properties. SqlVirtualMachine resource type has a property to represent the SQL Server License type. By setting the SQL Server License type to AHUB or PAYG, the SQL Server license can be dynamically updated even after the VM instance is deployed without any downtime.
  • Microsoft.SqlVirtualMachine/SqlVirtualMachineGroup represents a group of SQL VMs that will participate in an HADR architecture. Today we support SQL Server 2016 and SQL Server 2017 Always ON Availability Groups on an Active Directory domain joined windows failover cluster with Windows Server 2016. Creating a resource of SqlVirtualMachineGroups type will configure the windows failover cluster to host Always ON AG.
  • Microsoft.SqlVirtualMachine/Sql Virtual Machine Groups/Availability Group Listener represents an Always ON Availability Group Listener which can be connected from any VM in the same VNet.

Swagger spec for SQL VM resource provider with examples for all REST APIs can be found on GitHub.

SQL VM Resource Provider sets up the infrastructure for two new features, AHB for SQL VM and Automated Always ON AG. AHB for SQL VM brings significant cost savings for existing PAYG SQL VMs via simple PowerShell or Azure CLI calls. The Automated Always ON AG feature hides the details of Azure infrastructure from the user and automates the manual steps required for configuring Always ON AG on Azure VM.

To use SQL VM resource provider, register your subscription with the Microsoft.SqlVirtualMachine provider. You can register with the Microsoft.SqlVirtualMachine provider on the Azure portal. Start by selecting “All Services” and navigating to “Subscriptions.” From there you can select the “Resource Providers.” You can also register your subscription with Microsoft.SqlVirtualMachine provider by running the following power shell command:

Register-AzureRmResourceProvider -ProviderNamespace Microsoft.SqlVirtualMachine

SQL VM RP is available for all VM instances deployed from Azure Marketplace SQL images, together with self-deployed SQL Server on Azure VMs. You can create a SqlVirtualMachine resource and link to an existing Azure VM running SQL Server created from a generalized VHD. Register with the Microsoft.SqlVirtualMachine provider today to leverage flexible licensing and enhanced manageability features for SQL Server running on Azure VM.

...

Webseite öffnen Komplette Webseite öffnen

Newsbewertung

Kommentiere zu SQL Server on Azure Virtual Machines resource provider






Ähnliche Beiträge

  • 1. Azure.Source – Volume 61 vom 1651.51 Punkte ic_school_black_18dp
    Microsoft Connect(); 2018 On Tuesday, December 4th, Microsoft Connect(); 2018 provided a full day of developer-focused content—including updates on Azure and Visual Studio, keynotes, demos, and real-time coding with experts. Scott Guthrie’s keyno
  • 2. Azure.Source – Volume 58 vom 1357.79 Punkte ic_school_black_18dp
    Now in preview Update 18.11 for Azure Sphere in public preview This is an update to the Azure Sphere Operating System, Azure Sphere Security Service, and Visual Studio development environment. This release includes substantial investments in our se
  • 3. Azure.Source – Volume 60 vom 1253.47 Punkte ic_school_black_18dp
    Now in preview Simplifying security for serverless and web apps with Azure Functions and App Service New security features for Azure App Service and Azure Functions reduce the amount of code you need to work with identities and secrets under management. Key Vault re
  • 4. Azure.Source – Volume 62 vom 1243.55 Punkte ic_school_black_18dp
    KubeCon North America 2018 KubeCon North America 2018: Serverless Kubernetes and community led innovation! Brendan Burns, Distinguished Engineer in Microsoft Azure and co-founder of the Kubernetes project, provides a welcome to KubeCon North America 2018, which took p
  • 5. Azure Marketplace new offers – Volume 28 vom 1178.97 Punkte ic_school_black_18dp
    We continue to expand the Azure Marketplace ecosystem. From November 17 to November 30, 2018, 80 new offers successfully met the onboarding criteria and went live. See details of the new offers below: Virtual machines CloudflareAz
  • 6. Microsoft Azure portal May 2019 update vom 904.43 Punkte ic_school_black_18dp
    This month is packed with updates on the Azure portal, including enhancements to the user experience, resource configuration, management tools and more. Sign in to the Azure portal now and see for yourself everything that’s new. Download the Azu
  • 7. Microsoft Azure portal May 2019 update vom 904.43 Punkte ic_school_black_18dp
    This month is packed with updates on the Azure portal, including enhancements to the user experience, resource configuration, management tools and more. Sign in to the Azure portal now and see for yourself everything that’s new. Download the Azu
  • 8. Azure.Source – Volume 63 vom 870.71 Punkte ic_school_black_18dp
    Now in preview Transparent Data Encryption (TDE) with customer managed keys for Managed Instance Announces the public preview of Transparent Data Encryption (TDE) with Bring Your Own Key (BYOK) support for Microsoft Azure SQL Database Managed Instance. Azure SQL Database M
  • 9. Azure.Source – Volume 63 vom 870.71 Punkte ic_school_black_18dp
    Now in preview Transparent Data Encryption (TDE) with customer managed keys for Managed Instance Announces the public preview of Transparent Data Encryption (TDE) with Bring Your Own Key (BYOK) support for Microsoft Azure SQL Database Managed Instance. Azure SQL Database M
  • 10. Azure Marketplace new offers – Volume 26 vom 727.94 Punkte ic_school_black_18dp
    We continue to expand the Azure Marketplace ecosystem. During September and October, 149 new consulting offers successfully met the onboarding criteria and went live. See details of the new offers below: Consulting Services   1-Day Big Da
  • 11. Azure Marketplace new offers – Volume 26 vom 727.94 Punkte ic_school_black_18dp
    We continue to expand the Azure Marketplace ecosystem. During September and October, 149 new consulting offers successfully met the onboarding criteria and went live. See details of the new offers below: Consulting Services   1-Day Big Da
  • 12. Azure.Source – Volume 59 vom 633.39 Punkte ic_school_black_18dp
    Now in preview Simplifying confidential computing: Azure IoT Edge security with enclaves – Public preview Azure IoT Edge is a fully managed service that delivers cloud intelligence locally by deploying Azure AI, Azure services, and custom logic d