Blog

SQL Server log shipping is a proven disaster recovery solution that maintains one or more secondary copies of a production database by continuously backing up, copying and restoring transaction-log backups. It is available in SQL Server 2019 and other supported SQL Server versions. It is commonly used when organisations need a cost-effective warm standby database without the clustering requirements and licensing complexity associated with some high-availability technologies.

PostgreSQL logging is essential for troubleshooting, performance monitoring, auditing, and operational support. However, incorrectly configured logging can quickly consume large amounts of disk space and create unnecessary operational risk. In a recent production scenario, a PostgreSQL 15 environment was generating more than 20 GB of logs per day, with approximately 150 GB of disk space consumed in less than a week. This article explains how to identify the root cause of excessive PostgreSQL logging, safely reduce log volume, improve rotation and retention, and understand the impact of these changes in a streaming replication environment.

How to Update SQL Server After Cloning and Renaming a Windows Server Cloning a Windows virtual machine is a common way to create a test, development, disaster recovery or migration environment. However, when a SQL Server machine is cloned and the Windows hostname is changed, SQL Server may continue to retain the original server name

How to Find and List Oracle Archive Logs for Specific Dates and RMAN Backups As an Oracle Database Administrator, managing archive logs is a daily reality. Whether you are dealing with a disk space crisis in your Fast Recovery Area (FRA), preparing for a Point-in-Time Recovery (PITR), or auditing database changes, you frequently need to

Building a Debezium CDC Proof of Concept Replicating AWS RDS MySQL to SQL Server on Windows Introduction Many organisations need a reliable way to move operational data from one database platform to another without relying on heavy batch jobs, manual exports, or nightly ETL windows. One practical approach is Change Data Capture, usually called CDC.

Secure Your Reports: How to Enable SSL/TLS Certificate on SQL Server Reporting Services 2019 SQL Server Reporting Services, commonly known as SSRS, is widely used by organisations to publish business reports, dashboards, operational summaries, financial reports, and customer-facing analytics. Because these reports often contain sensitive business information, securing access to the SSRS web portal

Secure Your SQL Server 2019: A Practical Guide to Enabling SSL/TLS Encryption In today’s security-first IT environment, protecting database traffic is no longer optional. SQL Server often holds business-critical information such as customer records, financial data, application transactions, reports, and internal operational data. If connections between applications and SQL Server are not encrypted

Building an Azure SQL Managed Instance Link to an on-premises SQL Server for a true DR design Here's a high-level breakdown of the activities and steps involved in building an Azure SQL Managed Instance Link to an on-premises SQL Server for a true DR design. Phase 1: Planning & Prerequisites 1. Validate version and licensing

Building an On-Premises Disaster Recovery Option for Azure SQL Managed Instance Many organisations are moving their SQL Server workloads to Azure SQL Managed Instance to gain the benefits of a fully managed cloud database platform. However, some industries still have compliance, regulatory, sovereignty, or internal risk requirements that demand a disaster recovery copy outside Azure,

How to Configure Azure Front Door and Integrate It with HAProxy (Complete Step-by-Step Guide) If you're hosting websites or applications behind an Azure Virtual Machine and using HAProxy as your reverse proxy/load balancer, adding Azure Front Door is one of the best upgrades you can make for performance, security, and global availability. In this guide,

Mastering SQL Server Transactional Replication: Creating, Testing, and Monitoring a Reliable Data Sync Environment In modern IT environments, businesses often need data to be available in multiple locations for reporting, disaster recovery, analytics, or application performance. One of the most proven technologies for near real-time data distribution in Microsoft SQL Server is Transactional Replic

🚀How to Identify and Troubleshoot Slow Queries in Oracle Database 19c Performance issues are one of the most common challenges faced by database administrators. When users report that “the system is slow”, the root cause is often inefficient SQL queries. In this guide, we’ll walk through a practical, step-by-step approach to identifying slow queries in