An Azure service that is used to provision Windows and Linux virtual machines.
443 questions with SQL Server on Azure Virtual Machines tags
Resize of SQL Virtual Machine loses all settings
I create a SQL VM using the sql2022-ws2022 image and started to setup. Machine is D8ds_v4 This image setup C Drive with the operating system D Drive (temp drive including the SQL Temp Database) E Drive (1 GB Drive for SQL Data Files) F Drive (1 GB…
SQL Server on Azure Virtual Machines
Connection Challenges with Azure Databricks and SQL Server On VM in Serverless compute.
We successfully configured VNet peering between the SQL VM's VNet and the Databricks VNet, allowing access to the SQL Server on VMs. Testing the connection from Databricks using a job cluster yielded successful results, confirming that everything…
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
Microsoft.SqlVirtualMachine Resource Provider returning GatewayTimeout for specific VM in East US 2 — CLI and Terraform both affected
The Azure Resource Provider Microsoft.SqlVirtualMachine is returning a GatewayTimeout for a specific SQL VM resource in East US 2. All API calls to read this resource fail — both via Azure CLI and Terraform — while the same configuration works fine for…
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Process for Upgrading SQL Server Version on Azure Pay as You Go VM
Hi, Trying to find documentation on upgrading the SQL Version (i.e., 2019 to 2022) on a pay as you go Azure VM that included the Windows Server and SQL Server license in the pay as you go. Everything thing I can find seems to be related to hybrid…
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Connecting to database in Azure virtual machine SQL server
I am planning to connect to azure database resided in azure SQL virtual machine server ( IAAS) from Azure devops pipelines. azure SQL virtual machine version is 2022, is it supported? if it is not supported which one version is supported ?
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
For upgrade SQL server I have installed all the required SQL
Now I am not able to connect to vm and not able to start the vm
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Azure VM resize SQL server standard license will apply the license or additional purchase required
Hello Support, Azure VM running with Standard E4ads v5(4vCPU and 32 GB RAM and this will resize the VM to E8ads_v5 -8core CPU with 64 GB memory this will apply the sql Standard Edition (64-bit) on Windows Server 2019 or need to purchase addition…
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
After disk resize not able to see the extended volume showing same space
After disk resize not able to see the extended unalocated space in diskmgmt, increased from 64 to 104 in diskmgmt still it is showing 64 gb. vm sku is Standard D8ads v5 (8 vcpus, 32 GiB memory) vm is sql vm.
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
How do I integrate Microsoft Entra ID users with SQL server on SQLVM
Hello all, I am having an issue with remotely using my business software installed on my SQLVM. I have set up the remote access to the software on my SQLVM using AVD web client. The remote access using an Entra ID test user is successfully however, once…
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Can the same SQL Server 2022 license be used to upgrade multiple Azure VMs from SQL Server 2016 using the same media file?
We have successfully upgraded SQL Server 2016 to SQL Server 2022 on an Azure Virtual Machine using the SQL Server 2022 setup media file. We would like clarification on the following points from Microsoft: Can the same SQL Server 2022 installation media…
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
SQL Server Stuck in Disabled state
Our Azure subscription was deactivated on 10/23. We reactivated it on 12/5 but our database hrt-db-mysql-01 is still in a disabled state as of 12/9, with no option to start it. There are no avenues for support via phone / email / ticket through the…
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
How to enable SQL best practices assessments for SQL VMs via Powershell (not CLI)
I am using Powershell and the Update-AzSqlVM cmdlet to enable the features included with the SQL Server IaaS extension. I have been able to successfully Configure Storage via -SqlManagementType 'Full' parameter, but having trouble with the Enable SQL…
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Free SQL Server
What is free location for using. When i am trying to create server name then no free location available so.
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Data was not updating rows that contained existing primary key
Problem: Data was not updating rows that contained existing primary key. Solution: Go through and run where row exists update if not insert. Conflict: This increases row count which thus increases total files: 100+ added to each month. Possible…
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Azure 'East US 2' - No windows 2012 marketplace images
Azure 'East US 2' has no windows 2012 marketplace images. Could you please clarify why Windows Server 2012 images are unavailable in the East US 2 Azure region? The Central US still has these images, but East US 2 does not. Is this expected…
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Exporting Azure SQL database to BACPAC fails when Storage Account is restricted to "Selected networks"
Hi, I’m trying to export an Azure SQL database to a BACPAC file using both the Azure Portal and the az sql db export command. The target Storage Account has the following configuration: Storage Account → Networking → Public network access: Enable from…
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Extending Disk Space
I need to increase the storage space on my Azure SQL Server VM. I currently have a data array with 4 drives-each of which were 8GB. I modified each of them to be 10TB in total but after rebooting the server, it now shows my original F: which the same…
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Changing backup policy for Azure SQL databases in Azure recovery service valut
How to change backup policy for Azure SQL Database backup configured in RSV. I know one way but with that, policy has been changed on each database level.. Is there any way we can change for all the databases at one go.
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Azure Backup
An Azure backup service that provides built-in management at scale.
Preventing Database Deletion in SSMS
prevent accidental database deletions within SQL Server Management Studio (SSMS). Currently, I am exploring options to enforce this restriction effectively implemented a DDL trigger Is the above DDL trigger approach appropriate for preventing…
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
SQL Server | Other
Where can I read the transcript for the Azure SQL
I would like to read instead of listening all the time
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.