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.
Monitoring SQL Server Restore Progress with sys.dm_exec_requests When restoring a large database in SQL Server, one of the most common questions from administrators, project teams, and business users is: “How much longer will it take?” SQL Server does not always give clear progress feedback in the standard restore window, especially when you are managing restores
Read article ›Overview If your Azure Portal shows a larger disk size (e.g., 128GB) but Linux reports smaller sizes in df -h or lsblk, the issue is almost always one of these: This guide covers: Symptoms You’ll See Example: Why df -h Doesn’t Show Your Disk df -h reports filesystems that are mounted (like /, /opt, /home).It
Read article ›Changing a Linux server hostname sounds simple—and it is—but doing it properly matters. A hostname touches everything from SSH prompts, monitoring, logging, certificates, internal DNS, and even some application configs. In this guide, I’ll show you the safest and most common methods to change a Linux hostname without breaking anything. What is a hostname (and
Read article ›When a production system “freezes” and users complain about timeouts, the usual culprit is blocking locks. This post is a practical playbook for Oracle DBAs to identify who’s blocking whom, what’s locked, and exactly which SQL is responsible—plus some prevention tips. All examples work on Oracle 19c+ (notes for RAC included). 1) Read the room:
Read article ›You may see this error message in the Windows Event Viewer What the message means Why it happens What you can do (pick one) Sanity checks SQL Server angle (for a log volume) If you want, I can draft the one-liner Scheduled Task to run weekly -ReTrim on M: and keep the event log clean.
Read article ›You hit: Your RMAN job can’t obtain the CF (control file) enqueue. Another RMAN session holds it, or a crashed one left it behind. Typical triggers Quick path to green 1) Find and kill the blocker Check active RMAN processes: Identify CF enqueue holders and waiters: End an orphaned blocker: or kill the OS process
Read article ›Generative AI is no longer experimental—it’s powering real-world enterprise, research, and consumer use cases. Five models stand out in 2025: Cohere Command R, Google Gemini 2.5 Pro, Meta Llama 4 Maverick, OpenAI gpt-oss-120B, and xAI Grok 4. Below we compare their strengths, limitations, and practical applications. Cohere Command R OverviewA 32-billion-parameter text-only model with retrieval-aug
Read article ›For decades, businesses have relied on applications that once solved critical problems and became the backbone of operations. These legacy applications were designed for their time—built to automate manual tasks, improve efficiency, and enable business growth. Many organisations still depend on them daily, even though the technology landscape has shifted dramatically. Why Organisations Still Use
Read article ›Installing docker and Portainer on windows server on Azure VM This guide walks through the tested and verified process for installing Docker and Portainer on a Windows Server virtual machine hosted on Microsoft Azure. These instructions are intended for production-grade setups using Windows-native Docker. To install Docker on an Azure Windows VM (for production workloads),
Read article ›1. Download IntelliJ IDEA Community Edition 2. Install IntelliJ IDEA Community Edition For Windows For macOS For Linux (Ubuntu/Debian) 3. Activate IntelliJ IDEA Community Edition The Community Edition is free and does not require activation.When you first open IntelliJ IDEA: 4. Set Up IntelliJ IDEA for First Use Configure the UI Install Plugins (Optional) 5.
Read article ›The error in your PowerShell terminal indicates that script execution is disabled on your system due to security policies. This is a common issue related to PowerShell's Execution Policy settings. Fix: Enable Script Execution To resolve this, follow these steps: Step 1: Check the Current Execution Policy Step 2: Change the Execution Policy To allow
Read article ›Save up to 50% of DBA cost with Onsys Remote Remote Database Support. In today’s fast-paced digital landscape, businesses rely on robust and well-maintained databases to drive operations, ensure data integrity, and support mission-critical applications. However, managing databases effectively requires expert DBA (Database Administrator) support, which can be costly for many organizations. This is
Read article ›Tell us what you're wrestling with and we may turn it into the next guide.
Get in Touch