433 questions with SQL Server on Azure Virtual Machines tags
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
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
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
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
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
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
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
Azure Backup
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
Developer technologies | Transact-SQL
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
Health Probe Failing After Azure Load Balancer SKU Upgrade – One SQL Server Unhealthy
We have an Azure setup with a SQL pool containing two SQL servers (SQLServer-0 and SQLServer-1) behind a Load Balancer. The Load Balancer is configured with a custom TCP health probe on port 59999. Everything was working as expected prior to upgrading…
SQL Server on Azure Virtual Machines
How can I increase the size of the data disk on a Windows Server VM running SQL Server?
Hi, I have a Windows Server VM on Azure that is running SQL Server. Its size is Standard E4bds v5 and it was created from the sql2022-ws2022 source image offer. It has a single P30 Premium SSD LRS data disk of swize 1024GiB. I want to increase the size…
SQL Server on Azure Virtual Machines
SQL virtual machine version upgrade
We are currently using SQL virtual machine 2016 version standard edition the end of support is going to reach at July14, 2026. So, we are plaining to upgrade the SQL virtual machine to 2022 version. our Virtual machine size is Standard E8-4ads v5. We…
SQL Server on Azure Virtual Machines
VM Started Automatically to Create/Update/Delete Virtual Machine Extension by SQLVMResourceProviderAuth
I noticed that 3 of my VMs were automatically started by a system process and left running. It seems to be related to creating or updating and then deleting virtual machine extensions by the SQLVMResourceProviderAuth entity. Events (both on the same…
SQL Server on Azure Virtual Machines
How to remove SQL Server 2017 after in-place upgrade to 2022 on Azure SQL VM?
Hi community members, I’ve completed an in-place upgrade of SQL Server from 2017 to 2022 on an Azure SQL VM using this Microsoft guide: Change SQL Server version on Azure VM. The upgrade went fine, and the VM is re-registered with the SQL IaaS Agent…
SQL Server on Azure Virtual Machines
Recovery Pending mode.
Hello, Last night we increased the CPU and RAM size of our production Windows machine running on Azure to optimize performance and manage credits more efficiently. However, after the resize operation, our SQL Server databases have gone into Recovery…
SQL Server on Azure Virtual Machines
With SQL Server 2019, how do you configure PMEM on an Azure VM?
As a DBA relatively new to the Azure VM environment, do you have the ability to configure SQL Server 2019 as described in https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-persistent-memory?view=sql-server-ver17. I have…
SQL Server on Azure Virtual Machines
Memory issue on Azure SQL Server VM
Hi Team, Need your help to troubleshoot. high memory issue on one of the SQL Server on Azure Virtual Machine. No other application installed on this VM. its dedicated to SQL only. Here is the existing setting at SQL : Total Memory in VM server: 64…
SQL Server on Azure Virtual Machines
How do I deploy an Azure SQL VM?
I am trying to start up a Windows 2022 VM with Developer's Edition SQL 2022. It's a menu option, so it seems this should be pretty straightforward. It fails with MSSQL Service failing to start -- every time. I am largely taking defaults -- main…
SQL Server on Azure Virtual Machines
Network security group to allow inbound 1433 connections not working as expected in SQL Virtual Machine
Hi all, I'm using the following to deploy a SQL Server virtual machine. This machine allows mixed type authentication and allows external connections. imageReference { publisher: 'microsoftsqlserver' offer: 'sql2022-ws2022' sku:…
SQL Server on Azure Virtual Machines
Data disk space is low
Action is needed immediately to prevent data/application issues. Our SQL data drive is getting full; we have increased the VM to resize the disk but still the vm shows the same size. And the SQL is almost full.
SQL Server on Azure Virtual Machines