Start Vera as in Get started, with your license key activated and the emulator started by the Vera launcher (Activate Pro). Then open Bash in a terminal of its own (on macOS, whose terminal starts zsh, type bash first), go to an empty scratch directory and run this; it needs curl and Python 3, and jq. It fetches the emulator's own certificate, so every request checks TLS, and defines data_request and data_arm, which this page's commands use. The bearer token vera-local is a dummy local credential, not your license key.
The health check answers {"cloud": "azure", "generation_status": "generated", "status": "ok"}. Requests go only to the emulator at https://localhost:8543: the helper refuses any other address, including the Azure-looking URLs some responses hold. When you've finished, close the terminal and delete the scratch directory; that removes only these local files, not what you created in the emulator.
The examples use the SQL management API at 2025-01-01 and resource groups at 2025-04-01, the versions tested with this build: keep them as shown. Every request goes to the management endpoint, https://localhost:8543. The server’s host name, azdatasql.database.localhost, is a value on its record: nothing answered SQL there in testing.
Create a logical server and a database on it, read both back, then delete them. The administrator password is a dummy for this example: don’t use a real one.
Create the resource group the examples share, then the server, and read the server. Creating the server answers HTTP 202, and data_arm prints each response, then polls the operation until it has succeeded (long-running operations):
Each delete answers HTTP 202, and the helper waits for its operation to finish. A GET of the server then answers HTTP 404. The resource group azdata-rg stays, since deleting a group fails in Vera 1.2.2: see deleting resource groups. Other pages’ examples reuse it. To remove it and anything else left over, start a fresh emulator: see Stop and start again.
Logical servers: created with an administrator login and version 12.0, read back with a fullyQualifiedDomainName under database.localhost, listed in their resource group and deleted. A missing server answers HTTP 404.
Databases: a Basic database created on a server, read back with its name, collation and configuration, and deleted.
Long-running operations: creating the server and both deletes returned an operation that the helper polled until it finished.
Not run as examples: firewall and virtual network rules, elastic pools, failover groups, auditing, threat protection and vulnerability assessments, backups and restores, managed instances, and the rest of the management API. The API coverage marks these from a review of Vera 1.2.0’s source, with their limits in the notes.
No database engine was reachable. The server and database are management records. On Vera 1.2.0-rc.3, a check inside the emulator’s container found nothing listening on port 1433. In Vera 1.2.0 preview, port 1433 on the loopback address refused connections even after the server’s operation had finished. Connecting with sqlcmd, signing in, running queries or stored procedures, backups and restores, and isolation between databases weren’t established.
The host name is a record.azdatasql.database.localhost names the server; it isn’t an address a SQL client was shown to reach. Likewise, nothing showed the administrator login, the version or the Basic SKU applied to a running server.
Import and export move no BACPAC file.Databases_Import, Databases_Export, Servers_ImportDatabase and database extension imports record a local snapshot and its origin; no BACPAC is downloaded or uploaded. An import from an unrecognized URI can finish with empty local database metadata.
Jobs and Data Sync run nothing. An elastic job execution schedules local step and target attempts but never sends its T-SQL to a database. Data Sync refreshes and syncs update local metadata and logs; no data is synchronized.
Vulnerability scans check a small local rule set. A scan checks a few local TLS and encryption settings, not Azure’s complete security assessment, and a scan without the evidence it needs can end as FailedToRun.
Key, replication and recommendation actions are local. Encryption protector revalidation and Key Vault key validation record the key reference without contacting Key Vault. Distributed availability groups record partner, role and replication state; SQL replication and on-premises connectivity aren’t established. Applying a recommended action moves it through its states without running a SQL script.
Every operation of the API on this page, from its pinned public definition, and whether Vera 1.2.0 implements it. Only the API surfaces in this release are listed, and each operation once. Implementation availability was reviewed against the Vera 1.2.0 source on 6 November 2026. Source inspection identifies a local implementation and its known limits; it doesn't mean every operation or API version was tested with a request. Each note names its evidence: a Local observation without a build or date is from Vera 1.2.0 preview, on 5 November 2026, and one from a later build, such as Vera 1.2.0-rc.3 or Vera 1.2.2, names that build and its date. No response was compared with Azure's. What the statuses mean
No resource or operation matches .
Try part of a name, such as BackupShortTermRetentionPolicies_CreateOrUpdate, or .
BackupShortTermRetentionPolicies
4 of 4 implemented
Operation
Status
Notes
BackupShortTermRetentionPolicies_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
BackupShortTermRetentionPolicies_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
BackupShortTermRetentionPolicies_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
BackupShortTermRetentionPolicies_Update
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Capabilities
1 of 1 implemented
Operation
Status
Notes
Capabilities_ListByLocation
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DataMaskingPolicies
2 of 2 implemented
Operation
Status
Notes
DataMaskingPolicies_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DataMaskingPolicies_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DataMaskingRules
2 of 2 implemented
Operation
Status
Notes
DataMaskingRules_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DataMaskingRules_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DataWarehouseUserActivities
2 of 2 implemented
Operation
Status
Notes
DataWarehouseUserActivities_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DataWarehouseUserActivities_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseAdvisors
3 of 3 implemented
Operation
Status
Notes
DatabaseAdvisors_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseAdvisors_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseAdvisors_Update
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseAutomaticTuning
2 of 2 implemented
Operation
Status
Notes
DatabaseAutomaticTuning_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseAutomaticTuning_Update
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseBlobAuditingPolicies
3 of 3 implemented
Operation
Status
Notes
DatabaseBlobAuditingPolicies_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseBlobAuditingPolicies_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseBlobAuditingPolicies_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseColumns
3 of 3 implemented
Operation
Status
Notes
DatabaseColumns_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseColumns_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseColumns_ListByTable
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseEncryptionProtectors
2 of 2 implemented · 1 known difference
Operation
Status
Notes
DatabaseEncryptionProtectors_Revalidate
Known difference
Source inspection: Validates and records the key reference locally; it doesn't contact Key Vault or confirm remote authorization. Local SQL management records; no T-SQL execution is established.
DatabaseEncryptionProtectors_Revert
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseExtensions
3 of 3 implemented · 1 known difference
Operation
Status
Notes
DatabaseExtensions_CreateOrUpdate
Known difference
Source inspection: Import and export record a local BACPAC snapshot and its origin; no BACPAC file is downloaded or uploaded. An import from an unrecognized URI can finish with empty local database metadata. Local SQL management records; no T-SQL execution is established.
DatabaseExtensions_Get
Implemented
Source inspection: Import and export record a local BACPAC snapshot and its origin; no BACPAC file is downloaded or uploaded. An import from an unrecognized URI can finish with empty local database metadata. Local SQL management records; no T-SQL execution is established.
DatabaseExtensions_ListByDatabase
Implemented
Source inspection: Import and export record a local BACPAC snapshot and its origin; no BACPAC file is downloaded or uploaded. An import from an unrecognized URI can finish with empty local database metadata. Local SQL management records; no T-SQL execution is established.
DatabaseOperations
2 of 2 implemented
Operation
Status
Notes
DatabaseOperations_Cancel
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseOperations_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseRecommendedActions
3 of 3 implemented · 1 known difference
Operation
Status
Notes
DatabaseRecommendedActions_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseRecommendedActions_ListByDatabaseAdvisor
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseRecommendedActions_Update
Known difference
Source inspection: Moves a stored recommendation through its execution and verification states locally; no SQL script runs and no workload is measured. Local SQL management records; no T-SQL execution is established.
DatabaseSchemas
2 of 2 implemented
Operation
Status
Notes
DatabaseSchemas_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseSchemas_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseSecurityAlertPolicies
3 of 3 implemented
Operation
Status
Notes
DatabaseSecurityAlertPolicies_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseSecurityAlertPolicies_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseSecurityAlertPolicies_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Source inspection: Runs a small local check of TLS and encryption settings, not Azure's full SQL vulnerability rule set. A scan without the evidence it needs can end as FailedToRun. Local SQL management records; no T-SQL execution is established.
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseVulnerabilityAssessmentRuleBaselines_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseVulnerabilityAssessmentScans
4 of 4 implemented · 1 known difference
Operation
Status
Notes
DatabaseVulnerabilityAssessmentScans_Export
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseVulnerabilityAssessmentScans_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseVulnerabilityAssessmentScans_InitiateScan
Known difference
Source inspection: Runs a small local check of TLS and encryption settings, not Azure's full SQL vulnerability rule set. A scan without the evidence it needs can end as FailedToRun. Local SQL management records; no T-SQL execution is established.
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseVulnerabilityAssessments
4 of 4 implemented
Operation
Status
Notes
DatabaseVulnerabilityAssessments_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseVulnerabilityAssessments_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseVulnerabilityAssessments_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DatabaseVulnerabilityAssessments_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Databases
14 of 14 implemented · 2 known differences
Operation
Status
Notes
Databases_CreateOrUpdate
Implemented
Local observation: Created a Basic database on the server (HTTP 201).
Databases_Delete
Implemented
Local observation: Deleted the database (HTTP 202), and its operation finished.
Databases_Export
Known difference
Source inspection: Import and export record a local BACPAC snapshot and its origin; no BACPAC file is downloaded or uploaded. An import from an unrecognized URI can finish with empty local database metadata. Local SQL management records; no T-SQL execution is established.
Databases_Failover
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Databases_Get
Implemented
Local observation: Returned the database with its name, collation and configuration (HTTP 200).
Databases_Import
Known difference
Source inspection: Import and export record a local BACPAC snapshot and its origin; no BACPAC file is downloaded or uploaded. An import from an unrecognized URI can finish with empty local database metadata. Local SQL management records; no T-SQL execution is established.
Databases_ListByElasticPool
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Databases_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Databases_ListInaccessibleByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Databases_Pause
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Databases_Rename
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Databases_Resume
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Databases_Update
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Databases_UpgradeDataWarehouse
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DeletedServers
4 of 4 implemented
Operation
Status
Notes
DeletedServers_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DeletedServers_List
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DeletedServers_ListByLocation
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DeletedServers_Recover
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DistributedAvailabilityGroups
7 of 7 implemented · 4 known differences
Operation
Status
Notes
DistributedAvailabilityGroups_CreateOrUpdate
Known difference
Source inspection: Records partner and role state and replication metadata locally. SQL replication and on-premises network connectivity aren't established. Local SQL management records; no T-SQL execution is established.
DistributedAvailabilityGroups_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DistributedAvailabilityGroups_Failover
Known difference
Source inspection: Records partner and role state and replication metadata locally. SQL replication and on-premises network connectivity aren't established. Local SQL management records; no T-SQL execution is established.
DistributedAvailabilityGroups_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DistributedAvailabilityGroups_ListByInstance
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
DistributedAvailabilityGroups_SetRole
Known difference
Source inspection: Records partner and role state and replication metadata locally. SQL replication and on-premises network connectivity aren't established. Local SQL management records; no T-SQL execution is established.
DistributedAvailabilityGroups_Update
Known difference
Source inspection: Records partner and role state and replication metadata locally. SQL replication and on-premises network connectivity aren't established. Local SQL management records; no T-SQL execution is established.
ElasticPoolOperations
2 of 2 implemented
Operation
Status
Notes
ElasticPoolOperations_Cancel
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ElasticPoolOperations_ListByElasticPool
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ElasticPools
6 of 6 implemented
Operation
Status
Notes
ElasticPools_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ElasticPools_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ElasticPools_Failover
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ElasticPools_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ElasticPools_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ElasticPools_Update
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
EncryptionProtectors
4 of 4 implemented · 1 known difference
Operation
Status
Notes
EncryptionProtectors_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
EncryptionProtectors_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
EncryptionProtectors_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
EncryptionProtectors_Revalidate
Known difference
Source inspection: Validates and records the key reference locally; it doesn't contact Key Vault or confirm remote authorization. Local SQL management records; no T-SQL execution is established.
EndpointCertificates
2 of 2 implemented
Operation
Status
Notes
EndpointCertificates_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
EndpointCertificates_ListByInstance
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Source inspection: Local SQL management records; no T-SQL execution is established.
ExtendedServerBlobAuditingPolicies
3 of 3 implemented
Operation
Status
Notes
ExtendedServerBlobAuditingPolicies_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ExtendedServerBlobAuditingPolicies_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ExtendedServerBlobAuditingPolicies_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
FailoverGroups
8 of 8 implemented
Operation
Status
Notes
FailoverGroups_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
FailoverGroups_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
FailoverGroups_Failover
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
FailoverGroups_ForceFailoverAllowDataLoss
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
FailoverGroups_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
FailoverGroups_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
FailoverGroups_TryPlannedBeforeForcedFailover
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
FailoverGroups_Update
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
FirewallRules
5 of 5 implemented
Operation
Status
Notes
FirewallRules_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
FirewallRules_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
FirewallRules_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
FirewallRules_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
FirewallRules_Replace
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
GeoBackupPolicies
3 of 3 implemented
Operation
Status
Notes
GeoBackupPolicies_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
GeoBackupPolicies_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
GeoBackupPolicies_List
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
IPv6FirewallRules
4 of 4 implemented
Operation
Status
Notes
IPv6FirewallRules_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
IPv6FirewallRules_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
IPv6FirewallRules_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
IPv6FirewallRules_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
InstanceFailoverGroups
6 of 6 implemented
Operation
Status
Notes
InstanceFailoverGroups_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
InstanceFailoverGroups_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
InstanceFailoverGroups_Failover
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
InstanceFailoverGroups_ForceFailoverAllowDataLoss
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
InstanceFailoverGroups_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
InstanceFailoverGroups_ListByLocation
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
InstancePoolOperations
2 of 2 implemented
Operation
Status
Notes
InstancePoolOperations_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
InstancePoolOperations_ListByInstancePool
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
InstancePools
6 of 6 implemented
Operation
Status
Notes
InstancePools_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
InstancePools_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
InstancePools_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
InstancePools_List
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
InstancePools_ListByResourceGroup
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
InstancePools_Update
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobAgents
5 of 5 implemented
Operation
Status
Notes
JobAgents_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobAgents_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobAgents_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobAgents_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobAgents_Update
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobCredentials
4 of 4 implemented
Operation
Status
Notes
JobCredentials_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobCredentials_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobCredentials_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobCredentials_ListByAgent
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobExecutions
6 of 6 implemented · 2 known differences
Operation
Status
Notes
JobExecutions_Cancel
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobExecutions_Create
Known difference
Source inspection: Schedules local step and target attempts but never sends the job's T-SQL to a database; a successful execution is local orchestration only. Local SQL management records; no T-SQL execution is established.
JobExecutions_CreateOrUpdate
Known difference
Source inspection: Schedules local step and target attempts but never sends the job's T-SQL to a database; a successful execution is local orchestration only. Local SQL management records; no T-SQL execution is established.
JobExecutions_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobExecutions_ListByAgent
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobExecutions_ListByJob
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobPrivateEndpoints
4 of 4 implemented
Operation
Status
Notes
JobPrivateEndpoints_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobPrivateEndpoints_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobPrivateEndpoints_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobPrivateEndpoints_ListByAgent
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobStepExecutions
2 of 2 implemented
Operation
Status
Notes
JobStepExecutions_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobStepExecutions_ListByJobExecution
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobSteps
6 of 6 implemented
Operation
Status
Notes
JobSteps_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobSteps_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobSteps_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobSteps_GetByVersion
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobSteps_ListByJob
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobSteps_ListByVersion
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobTargetExecutions
3 of 3 implemented
Operation
Status
Notes
JobTargetExecutions_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobTargetExecutions_ListByJobExecution
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobTargetExecutions_ListByStep
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobTargetGroups
4 of 4 implemented
Operation
Status
Notes
JobTargetGroups_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobTargetGroups_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobTargetGroups_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobTargetGroups_ListByAgent
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobVersions
2 of 2 implemented
Operation
Status
Notes
JobVersions_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
JobVersions_ListByJob
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Jobs
4 of 4 implemented
Operation
Status
Notes
Jobs_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Jobs_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Jobs_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Jobs_ListByAgent
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
LedgerDigestUploads
4 of 4 implemented
Operation
Status
Notes
LedgerDigestUploads_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
LedgerDigestUploads_Disable
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
LedgerDigestUploads_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
LedgerDigestUploads_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
LongTermRetentionBackups
24 of 24 implemented
Operation
Status
Notes
LongTermRetentionBackups_ChangeAccessTier
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Source inspection: Runs a small local check of TLS and encryption settings, not Azure's full SQL vulnerability rule set. A scan without the evidence it needs can end as FailedToRun. Local SQL management records; no T-SQL execution is established.
Source inspection: Local SQL management records; no T-SQL execution is established.
ManagedInstanceEncryptionProtectors_Revalidate
Known difference
Source inspection: Validates and records the key reference locally; it doesn't contact Key Vault or confirm remote authorization. Local SQL management records; no T-SQL execution is established.
ManagedInstanceKeys
4 of 4 implemented
Operation
Status
Notes
ManagedInstanceKeys_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ManagedInstanceKeys_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ManagedInstanceKeys_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ManagedInstanceKeys_ListByInstance
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Source inspection: Validates and records the key reference locally; it doesn't contact Key Vault or confirm remote authorization. Local SQL management records; no T-SQL execution is established.
ManagedLedgerDigestUploads
4 of 4 implemented
Operation
Status
Notes
ManagedLedgerDigestUploads_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ManagedLedgerDigestUploads_Disable
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ManagedLedgerDigestUploads_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ManagedLedgerDigestUploads_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerAdvisors
3 of 3 implemented
Operation
Status
Notes
ServerAdvisors_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerAdvisors_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerAdvisors_Update
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerAutomaticTuning
2 of 2 implemented
Operation
Status
Notes
ServerAutomaticTuning_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerAutomaticTuning_Update
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerAzureADAdministrators
4 of 4 implemented
Operation
Status
Notes
ServerAzureADAdministrators_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerAzureADAdministrators_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerAzureADAdministrators_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerAzureADAdministrators_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerAzureADOnlyAuthentications
4 of 4 implemented
Operation
Status
Notes
ServerAzureADOnlyAuthentications_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerAzureADOnlyAuthentications_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerAzureADOnlyAuthentications_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerAzureADOnlyAuthentications_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerBlobAuditingPolicies
3 of 3 implemented
Operation
Status
Notes
ServerBlobAuditingPolicies_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerBlobAuditingPolicies_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerBlobAuditingPolicies_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerConfigurationOptions
3 of 3 implemented
Operation
Status
Notes
ServerConfigurationOptions_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerConfigurationOptions_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerConfigurationOptions_ListByManagedInstance
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerConnectionPolicies
3 of 3 implemented
Operation
Status
Notes
ServerConnectionPolicies_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerConnectionPolicies_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerConnectionPolicies_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerDevOpsAuditSettings
3 of 3 implemented
Operation
Status
Notes
ServerDevOpsAuditSettings_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerDevOpsAuditSettings_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerDevOpsAuditSettings_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerDnsAliases
5 of 5 implemented
Operation
Status
Notes
ServerDnsAliases_Acquire
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerDnsAliases_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerDnsAliases_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerDnsAliases_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerDnsAliases_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerKeys
4 of 4 implemented
Operation
Status
Notes
ServerKeys_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerKeys_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerKeys_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerKeys_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerOperations
1 of 1 implemented
Operation
Status
Notes
ServerOperations_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerSecurityAlertPolicies
3 of 3 implemented
Operation
Status
Notes
ServerSecurityAlertPolicies_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerSecurityAlertPolicies_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerSecurityAlertPolicies_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerTrustCertificates
4 of 4 implemented
Operation
Status
Notes
ServerTrustCertificates_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerTrustCertificates_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerTrustCertificates_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerTrustCertificates_ListByInstance
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerTrustGroups
5 of 5 implemented
Operation
Status
Notes
ServerTrustGroups_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerTrustGroups_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerTrustGroups_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerTrustGroups_ListByInstance
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerTrustGroups_ListByLocation
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerUsages
1 of 1 implemented
Operation
Status
Notes
ServerUsages_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerVulnerabilityAssessments
4 of 4 implemented
Operation
Status
Notes
ServerVulnerabilityAssessments_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerVulnerabilityAssessments_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerVulnerabilityAssessments_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
ServerVulnerabilityAssessments_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Servers
9 of 9 implemented · 1 known difference
Operation
Status
Notes
Servers_CheckNameAvailability
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Servers_CreateOrUpdate
Implemented
Local observation: Created a logical server with version 12.0 (HTTP 202), and its operation reached Succeeded. No SQL Server engine was reachable afterwards: port 1433 refused connections.
Servers_Delete
Implemented
Local observation: Deleted the server (HTTP 202); once its operation had finished, a GET answered HTTP 404.
Servers_Get
Implemented
Local observation: Returned the server with fullyQualifiedDomainNameazdatasql.database.localhost (HTTP 200), before and after its create operation had finished. A missing server, and the server after deletion, answered HTTP 404.
Servers_ImportDatabase
Known difference
Source inspection: Import and export record a local BACPAC snapshot and its origin; no BACPAC file is downloaded or uploaded. An import from an unrecognized URI can finish with empty local database metadata. Local SQL management records; no T-SQL execution is established.
Servers_List
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Servers_ListByResourceGroup
Implemented
Local observation: Listed the resource group's servers (HTTP 200).
Servers_RefreshStatus
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Servers_Update
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SqlAgent
2 of 2 implemented
Operation
Status
Notes
SqlAgent_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SqlAgent_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SqlVulnerabilityAssessmentBaseline
2 of 2 implemented
Operation
Status
Notes
SqlVulnerabilityAssessmentBaseline_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Source inspection: Local SQL management records; no T-SQL execution is established.
SqlVulnerabilityAssessmentExecuteScan
1 of 1 implemented · 1 known difference
Operation
Status
Notes
SqlVulnerabilityAssessmentExecuteScan_Execute
Known difference
Source inspection: Runs a small local check of TLS and encryption settings, not Azure's full SQL vulnerability rule set. A scan without the evidence it needs can end as FailedToRun. Local SQL management records; no T-SQL execution is established.
Source inspection: Local SQL management records; no T-SQL execution is established.
SqlVulnerabilityAssessmentsSettings_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SqlVulnerabilityAssessmentsSettings_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
StartStopManagedInstanceSchedules
4 of 4 implemented
Operation
Status
Notes
StartStopManagedInstanceSchedules_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
StartStopManagedInstanceSchedules_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
StartStopManagedInstanceSchedules_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
StartStopManagedInstanceSchedules_ListByInstance
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SubscriptionUsages
2 of 2 implemented
Operation
Status
Notes
SubscriptionUsages_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SubscriptionUsages_ListByLocation
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SynapseLinkWorkspaces
1 of 1 implemented
Operation
Status
Notes
SynapseLinkWorkspaces_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncAgents
6 of 6 implemented
Operation
Status
Notes
SyncAgents_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncAgents_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncAgents_GenerateKey
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncAgents_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncAgents_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncAgents_ListLinkedDatabases
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncGroups
11 of 11 implemented · 2 known differences
Operation
Status
Notes
SyncGroups_CancelSync
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncGroups_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncGroups_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncGroups_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncGroups_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncGroups_ListHubSchemas
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncGroups_ListLogs
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncGroups_ListSyncDatabaseIds
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncGroups_RefreshHubSchema
Known difference
Source inspection: Refreshes and syncs from local metadata and completion logs; no data is synchronized with an external database. Local SQL management records; no T-SQL execution is established.
SyncGroups_TriggerSync
Known difference
Source inspection: Refreshes and syncs from local metadata and completion logs; no data is synchronized with an external database. Local SQL management records; no T-SQL execution is established.
SyncGroups_Update
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncMembers
7 of 7 implemented · 1 known difference
Operation
Status
Notes
SyncMembers_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncMembers_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncMembers_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncMembers_ListBySyncGroup
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncMembers_ListMemberSchemas
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
SyncMembers_RefreshMemberSchema
Known difference
Source inspection: Refreshes and syncs from local metadata and completion logs; no data is synchronized with an external database. Local SQL management records; no T-SQL execution is established.
SyncMembers_Update
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
TdeCertificates
1 of 1 implemented
Operation
Status
Notes
TdeCertificates_Create
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
TimeZones
2 of 2 implemented
Operation
Status
Notes
TimeZones_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
TimeZones_ListByLocation
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
TransparentDataEncryptions
5 of 5 implemented
Operation
Status
Notes
TransparentDataEncryptions_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
TransparentDataEncryptions_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
TransparentDataEncryptions_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
TransparentDataEncryptions_Resume
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
TransparentDataEncryptions_Suspend
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
Usages
1 of 1 implemented
Operation
Status
Notes
Usages_ListByInstancePool
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
VirtualClusters
7 of 7 implemented
Operation
Status
Notes
VirtualClusters_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
VirtualClusters_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
VirtualClusters_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
VirtualClusters_List
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
VirtualClusters_ListByResourceGroup
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
VirtualClusters_Update
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
VirtualClusters_UpdateDnsServers
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
VirtualNetworkRules
4 of 4 implemented
Operation
Status
Notes
VirtualNetworkRules_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
VirtualNetworkRules_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
VirtualNetworkRules_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
VirtualNetworkRules_ListByServer
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
WorkloadClassifiers
4 of 4 implemented
Operation
Status
Notes
WorkloadClassifiers_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
WorkloadClassifiers_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
WorkloadClassifiers_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
WorkloadClassifiers_ListByWorkloadGroup
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
WorkloadGroups
4 of 4 implemented
Operation
Status
Notes
WorkloadGroups_CreateOrUpdate
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
WorkloadGroups_Delete
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
WorkloadGroups_Get
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.
WorkloadGroups_ListByDatabase
Implemented
Source inspection: Local SQL management records; no T-SQL execution is established.