Practical, hands-on guides from our database, cloud and software teams — the same kind of write-ups we lean on internally, shared for anyone running these platforms themselves.
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
Read article ›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
Read article ›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.
Read article ›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
Read article ›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
Read article ›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
Read article ›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,
Read article ›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,
Read article ›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
Read article ›🚀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
Read article ›Git Essentials for Developers: Commands, Best Practices, and Real-World Workflow with GitLab Version control is at the heart of modern software development. Whether you’re working solo or in a distributed team, mastering Git is essential for maintaining code quality, collaboration, and traceability. In this guide, we’ll cover: 🧱 What is Git? Git is a distributed
Read article ›Setting Up GitLab on Ubuntu with HAProxy and Using HTTPS for Development – Complete Guide In modern software engineering, having a centralized, secure, and scalable code repository is critical. This guide walks through a real-world implementation of a self-hosted GitLab platform deployed on an Ubuntu VM, integrated with HAProxy for SSL termination, and configured for
Read article ›Tell us what you're wrestling with and we may turn it into the next guide.
Get in Touch