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

Tag: azure-vm

Do I need a separate server for Quorum?

By adminPosted on December 20, 2022

Question : We are working on setting up AlwaysOn Availability Group for SQL Server 2014. There will be 2 nodes: […]

Change default collation when provisioning a SQL Server VM in the Azure portal

By adminPosted on December 11, 2022

Question : Is there a way to change the default SQL collation directly from the “Create virtual machine” wizard in […]

Availability Group – Deleting old backup files

By adminPosted on December 8, 2022

Question : I’m using Azure VMs with a SQL Server Availability Group, and Ola Hallengren’ scripts. Backups are working without […]

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 […]

Primary server ‘XYZ’ can not write to shared drive during availability group configuration

By adminPosted on October 30, 2022

Question : I am in a process of adding databases to availability group. In one of the steps it was […]

PREEMPTIVE_OS_WRITEFILEGATHER wait on database RESTORE with IFI on

By adminPosted on September 14, 2022

Question : I have an Azure VM with Windows Server 2012 R2 and SQL Server 2014 Enterprise Edition. I have […]

Transaction Log file size is increasing in my Azure (IAAS) SQL Server 2014 database [duplicate]

By adminPosted on August 9, 2022

Question : This question already has answers here: Why Does the Transaction Log Keep Growing or Run Out of Space? […]

Moving database from one server to another

By adminPosted on July 25, 2022

Question : I have a virtual machine running SQL Server 2012 in Azure and have also generated a script of […]

Set column to only accept negative values

By adminPosted on July 21, 2022

Question : Is there anyway to change a column data type so that it will accept only negative values? It’s […]

Sql Server 2016 errror Incorrect syntax near ‘EXTERNAL’

By adminPosted on June 15, 2022

Question : I have two SQL Server 2016 VMs in Azure. I am trying to connect these two sql server […]

  • 1
  • 2
  • 3
  • …
  • 5

Recent Posts

  • Explanation for second Compute Scalar
  • Why is this datetime index not being used?
  • how to find out the log backups that I need to restore in order to bring log shipping from standby to online?
  • Embedding JSON in a string
  • SQL Server – Identical query on near identical database takes 20 seconds on sql2012 but does not complete after 50+ hours on sql2014
  • RMAN list archivelogs that are needed for to recover specified backup
  • Minimizing SELECT latency in PostgreSQL
  • Replication from EC2 Master to RDS Slave – Connecting to master
  • How to index range condition and ordering by a different colum?
  • Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync
  • What queries are supported by MySQL but not PostgreSQL?
  • MYSQL: What is the benefit of compound indexes, over separate ones?
  • Help with relational database design
  • Will SQL 2008 SSIS package files work with SQL 2016 databases after database upgrades?
  • How to prevent memory optimized tables from blowing out OPT_MEMORY_OPTIMIZED$HKv2
  • MySQL Workbench connect to MS Access
  • Remove duplicate values from query result
  • Primary key guarantees: duplicates and nullity
  • Postgresql Vacuum and replication
  • Is the overhead of frequent query cache invalidation ever worth it?

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