Single pane of glass to look at all of my SQL Servers
I just got back from SQL Pass Summit 2024 and I was told that I could ARC enable all of my SQL Servers so I would have a single pane of glass to view and scan logs, configurations, view best practices etc. Unfortunately, when I got home, I realized that since we have SQL Servers on Azure VMs we can't use Azure ARC to manage them. Unsupported configurations Azure Arc-enabled SQL Server doesn't currently support the following configurations: ... Multiple instances of SQL Server installed on the same host operating system with the same instance name. SQL Server in Azure Virtual Machines. An Always On availability group where one or more replicas is on a failover cluster instance. Since all our Azure VMs have the SQL Agent installed how can we unify our management experience in Azure?
SQL Server 2019 SKU Upgrade for Entra
I am looking to upgrade our 2019 instance to 2022 with in place upgrade. The database and server was created using a Template in Azure for "SQL Server Standard 2019 on Windows Server 2022". We would like to enable Entra Authentication. Currently the SQL Server Virtual Machine, Security Blade in Azure says: "Microsoft Entra authentication is not available for SQL virtual machine offer SQL2019 and sku Standard. Microsoft Entra authentication is available starting SQL Server 2022." Does anyone know if I upgrade in place will the option be available or will I have to build a new machine?
Tips & Tricks on ‘cloning’ Azure SQL virtual machines from captured images
First published on MSDN on Jul 06, 2016 While we have documentation on how to create a VM from captured image under “How to capture a Windows virtual machine in the Resource Manager deployment model”, it doesn’t address some specifics on SQL Server.
HELP with CTE or a Cursor to update multiple rows in 1 table ..selecting from Multiple databases
Server A Syetemtable of Dbname= ABC Dbname productid ABC 123 Syetemtable of Dbname= XYZ Dbname productid ABC 987 Syetemtable of Dbname= AQW Dbname productid AQW 123456 Like we have 1000 DB's in Server A and each db has a system table 1 Main LOGIN info table in Server A Dabatase DB1 SELECT * from DB1. DBO.LOGIN table DBName product ID ABC NULL XYZ A9065 AQW mailto:33c@1442 these rows in 1 main Login table are not matching the system table rows of each individual Databases Now I want to update 1 Main LOGIN info table in Server A Dabatase DB1, so that I get results matching each login table of all db's SELECT * from DB1. DBO.LOGIN table DBName product ID ABC 123 XYZ 987 AQW 123456
Backing up database from SQL server 2017 to Azure Blob container
Hi All, just wondering if I can get some assistance with an issue that I am having. I am trying to setup backup to URL in SSMS to Azure. I have created the credentials and the subplan and it would backup ok on the first day with no errors, however on the second day I would get the following error: Failed:(-1073548784) Executing the query "BACKUP DATABASE [SQLDB] TO URL = N'https:..." failed with the following error: "A nonrecoverable I/O error occurred on file "URL: https://azstorage.blob.core.windows.net/Storage/SQLDB_backup_2023_11_23_003000_3611749.bak:"Backup to URL received an exception from the remote endpoint. Exception Message: Unable to connect to the remote server. BACKUP DATABASE is terminating abnormally. I have tried dropping and recreating credentials, windows host server and SSMS are up to date (SQL 2017), installed latest cumulative updates, created a different storage account.About Azure SQL Database
Hi, how are you? I wonder if you can help me to understand something about Azure SQL Database in the Azure Calculator. This is: I have read extensively https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/single/#pricing and https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose. I understand that Min and Max vCores is the range in wich the compute will be scaled and billed, but I can get: CPU Used Memory Used Duration. ¿Is this the auto pause delay (https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose#create-serverless-db)? I hope you can help me to understand Best regards JonaDigital event: Extend to the Cloud with Azure VMware Solution
Transform your VMware investments in the cloud Learn how to easily run your VMware workloads natively on Azure at this free digital event. Join industry experts for an inside look at the latest capabilities of Azure VMware Solution and: Hear from customers who’ve used Azure VMware Solution to optimize their workloads. Learn how to cost-effectively migrate your VMware workloads, skills, and tools to the cloud. Get modernization tips and best practices direct from Microsoft and VMware insiders. See demos and be among the first to learn about new and upcoming product features. Join technical sessions on simple deployment, migration, disaster recovery, and connecting to other Azure services. Plus, ask the experts your questions in the live chat Q&A. Delivered in partnership with VMware. Register now > Extend to the Cloud with Azure VMware Solution Wednesday, March 23, 2022 9:00 AM–11:30 AM Pacific Time https://info.microsoft.com/www-extend-to-the-cloud-with-azure-vmware-solution.html?ocid=AID3045911_QSG_579520
