356 questions with SQL Server on Azure Virtual Machines tags
Azure SQL Server on Managed Instance not the best fit for Data Warehouse + ETL workloads! Do you agree?
Hi, I currently have a Data Warehouse on an Azure Managed Instance and SSIS Packages hosted on the SSISDB Catalog of the same instance being executed via Azure-SSIS Integration Runtime. By looking at the features offered by a Microsoft Managed Instance,…
Azure SQL VM Automatic Patching not working
Hello Team, My SQL Azure VM has Automatic Patching Enabled to Install Windows updates on every Saturday after 11 PM. Also, VM has Active hours between 6 AM to 12 AM. But still found Unepxted Restart by "svschost.exe" process complete…
Securing access to the Azure SQL Server Database via SSMS using Privatelink ?
My company already using the Azure Express route circuit to allow secure and quicker data access across the WAN. I am trying to secure access to my SQL database in Azure from my user laptop across the globe. Turn off the Public Endpoint for all SQL…
Azure SQL server 2022 images on WS2019
We planning to upgrade our SQL servers on azure VMs from SQL 2016 -WS2012R2 to SQL2022- WS2019. We are not seeing SQL 2022 images with WS2019 available in the marketplace and instead have SQL2022 with WS022. Firstly, is this correct ? if so what's the…
What to do if Cryptographic provider version in dll is different from the guid recorded in system catalog?
I am attempting to establish EKM with AKV, thus far I have followed the instructions provided here but I am now faced with an error at part 5 which states Cryptographic provider version '01.00.0004.00' in dll is different from the guid recorded in…
is it possible to configure WSUS server in azure with SQL paas database
is it possible to configure WSUS server in azure with SQL PAAS database , instead of IAAS sql db https://learn.microsoft.com/en-us/azure/architecture/example-scenario/wsus/
How does automated patching work?
How does automated patching work for a 3-node Always On AG cluster with SQL on Azure VMs? Does it use a rolling update process that leaves the original primary node still as primary after the patching is completed?
How to archive an on-premise sql server database of about eight terabytes to azure
We have an on-premise sql server database of about eight terabytes that we are trying to archive to Azure. How can I go about it? This archive needs to be accessible because we might need to pull data from it in the future.
Azure VM locall SSD use for TempDB
[Edited] Kinda late to the game of SQL on Azure VM with Always On AG. Per this article, it's recommended practice to put TempDB on the ephemeral temp drive D: which is low-latency…
Migration to Azure SQL VM Named Instances using Azure Data Studio Migration Extension
Hi, We are trying to migrate databases using Azure Data Studio Migration Extension. We have an Azure SQL VM with one Default SQL Instance (running on port 1433) and 4 SQL Named Instances (running on dynamic ports). But, ADS Migration Extension…
Error 10060: Configure Azure NSG for Azure DB and Azure DW Connectivity
I have created an Azure SQL server and database and am trying to connect through SQL Server Management Studio. I am not able to connect and get the following error message: TITLE: Connect to Server ADDITIONAL INFORMATION: A network-related or…
SQL Logs reporting multiple "Login failed for domain\Computer...." Error: 18456 every minute. How do I resolve this?
New SQL Server build. Comprises of 2x Azure VMs "LiveDB1" and a "LiveDB2". Configured with WSFC and Always On HA. There is an Availability Group listener that is load-balanced using Azure Load Balancer. The system is being tested…
SQL on Azure VM AlwaysOn with DNN listener
Hi: I have created a 2 nodes SQLServer AlwaysOn on Azure VM, with DNN listener. SQLServer version is 2019 CU15, Window version is 2019. e.g. node1 (10.0.2.15) node2 (10.0.2.16) WindowCluster (DNN) DNNListener (DNN, port 6789) WindowCluster…
can I use an Azure Integration runtime to UPSERT data from ADF to SQL Server on azure VM?
Hi, I'm trying to UPSERT data from ADF to a SQL server hosted on Azure Virtual Machine since SHIR is not supported in Mapping dataflows. I've created an Azure Integration Runtime with Virtual Network Enable, however when I tried to create an endpoint I…
Getting Timeout Error[258] Unable to complete login process due to delay in prelogin response.
Restored a TFS Database in CUS region in Azure SQL VM. Not able to connect to database from Client machine which is an on-prem machine. Getting the following error when using SQLCMD utility: Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP…
SQL auth password with special characters (quotes) is corrupted during SQL Server on Azure VM deployment
Hello! I've met an issue while trying to deploy an SQL Server on Azure VM: https://azure.microsoft.com/en-us/services/virtual-machines/sql-server/ I cannot login to the SQL Server with the SQL auth credential I've set during deployment - I get the…
Working with Dotnet and Sql edge on M1 mac nuget packages
Hello, Im new to mac, I have an M1 mac mini, Im using Visual Studio for M1 mac as well Recently I have Installed docker with sql edge container in it. In order to make my Web API projects more efficient, I couldn't figure it out if I need some…
Azure SQL Managed Instance - Long term Retention
Hello all, I can setup LTR policies -PITR, weekly, yearly backups for all existing databases that are created on Azure SQL MI. However, the policies DO NOT apply for any new databases created after the policy is created. Is there a way to create…
Compliance
Hi, Is Azure App service compliant with ISO 27001 and is SQL Server on Azure Virtual Machines compliant with GDPR?
Read-only database in azure cloud from on-prem database
Hello, Can you provide me a way to sync full database and have read only version of on-prem database on azure cloud? Seems like High Availability is not working, there are Data Sync / replication options but they are only table level. I want full…