Resource Type: Azure > Provider > SQL Virtual Machine

The SQL Virtual Machine provider offers a fully managed service for running SQL Server on Azure Virtual Machines. This provider enables users to deploy, manage, and scale SQL Server instances with full control over the operating system and SQL Server configurations, allowing for customizations and optimizations tailored to specific workloads while benefiting from the scalability and reliability of the Azure infrastructure.

Resource Context

SQL Virtual Machine is a part of the Provider service.

Each SQL Virtual Machine lives under a Subscription.

Controls

The primary controls for Azure > Provider > SQL Virtual Machine are:

In Your Workspace

Developers

Resource Type URI

tmod:@turbot/azure-provider#/resource/types/sqlVirtualMachine

Category URI

tmod:@turbot/turbot#/resource/categories/other

GraphQL

query resource(id: "tmod:@turbot/azure-provider#/resource/types/sqlVirtualMachine") { … }

query resourceActivities(filter: "resourceId:'tmod:@turbot/azure-provider#/resource/types/sqlVirtualMachine'") { … }

mutation createResource(input: { … })

mutation updateResource(input: { … })

CLI

Get Resource

turbot graphql resource --id "tmod:@turbot/azure-provider#/resource/types/sqlVirtualMachine"

Steampipe Query

Get Resource

select * from guardrails_resource where resource_type_uri = 'tmod:@turbot/azure-provider#/resource/types/sqlVirtualMachine';

Get Policy Settings (By Resource ID)

select * from guardrails_policy_setting where filter = 'resourceTypeId:"tmod:@turbot/azure-provider#/resource/types/sqlVirtualMachine"';

Get Resource Notification

select * from guardrails_notification where resource_type_uri = 'tmod:@turbot/azure-provider#/resource/types/sqlVirtualMachine' and notification_type in ('resource_updated', 'resource_created');