Question : We have 2 SQL Servers on-premise, combined into Availability Group We want to install windows updates, which will […]
Tag: azure
To do a refresh of a “on premise” postgres database to a azure postgres database or to do a backup and restore?
Question : We have a postgres database hosted on Azure, that we would like to refresh from a “on premise” […]
SQL Server 2019 Always On using Distributed Network Name
Question : We’re running a couple SQL servers in Azure that are set up with an Always On availability group […]
What are the features that Azure VM based SQL server supports and the managed instance doesn’t support?
Question : I’m deciding on whether to install SQL server on azure VM versus configuring a managed instance. I understand […]
Backup from Azure SQL Managed Instance and restore on an On-Prem version
Question : As per my understanding Azure SQL MI runs SQL Server under the hood. So a backup from MI […]
Trigger for last inserted value [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
SQL Server and Agent Services not starting automatic in AZURE IaaS
Question : We migrated an on-premise database to azure IaaS and the machines is on between 7am and 7pm that […]
Deploying dacpac through sqlpackage.exe with NETWORK SERVICE user
Question : I have a database release pipeline in Azure DevOps Server which deploys our dacpac files through Powershell commands […]
Is it bad practice to automate the updating of statistics and re-making of query plans on a relatively small SQL Azure database?
Question : I have a SQL Azure database that’s about 500MB in size. Every 2-3 weeks the database will suddenly […]
Why Azure site recovery may not meet RPO?
Question : While Azure Site Recovery may meet RTO, it may not meet RPO since it is not accounting for […]