Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: azure

How to point Azure Hybrid Connection to Availability Group Listener ? Or redirect to secondary replica?

By adminPosted on January 30, 2023

Question : We have 2 SQL Servers on-premise, combined into Availability Group We want to install windows updates, which will […]

To do a refresh of a “on premise” postgres database to a azure postgres database or to do a backup and restore?

By adminPosted on January 19, 2023

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

By adminPosted on January 10, 2023

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?

By adminPosted on January 8, 2023

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

By adminPosted on December 30, 2022

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]

By adminPosted on December 30, 2022

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

By adminPosted on December 11, 2022

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

By adminPosted on December 10, 2022

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?

By adminPosted on November 23, 2022

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?

By adminPosted on November 22, 2022

Question : While Azure Site Recovery may meet RTO, it may not meet RPO since it is not accounting for […]

  • 1
  • 2
  • 3
  • …
  • 13

Recent Posts

  • Will query continue to run even after network times-out
  • Need some support on MySQL Query
  • The sort column must be the last column used in the index – MongoDB Indexing Advice
  • Understanding Backup Types
  • SQL Server sp_configure options?
  • DBA Permissions on LOCAL SERVER containing SQL SERVER [closed]
  • Update table using values from another table in SQL Server
  • Getting 0KB of size file while backup mysql database using mysql dump [closed]
  • Local Backup from Amazon RDS PostgreSQL database
  • Who is using my worker threads? SQL Server 2014 – HADR
  • Data Domain Boost viewing backups
  • One table for all persons
  • Database for building a realtime analytics system
  • Threads_cached 0 while thread_cache_size > 0
  • Why is performance non-linear if I do many UPDATEs in a single transaction
  • Mysql innoDB write operations are extremely slow
  • mysql_query expected [closed]
  • Oracle not using index when > used in where clause
  • Determine databases specified Login has access to on SQL Azure
  • What is the performance overhead of IFNULL in the select statement of mysql 5.7+ query

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding