A Simple Query with a Devious Problem It's a scenario every database professional has encountered: a seemingly simple query brings a powerful server to its knees. In this case, 64 Core / 1TB RAM / all SSD. … AND the query was as basic as it gets: SELECT @LastMaxID =...
Welcome to our blog, which is more than just a record of our experiences. It’s a resource.
Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
Why SQL Server 2025 Is AI-Ready with Microsoft Fabric—and How XTIVIA Can Help
In today's rapidly evolving tech landscape, artificial intelligence (AI) is no longer a futuristic concept—it's now a crucial part of how businesses manage data, streamline operations, and drive insights. SQL Server 2025, the latest version of Microsoft's flagship...
AI-Powered Databases: How Built-In Intelligence is Revolutionizing Data Management
Database management? It's constantly changing! We've watched AI help DBAs with external tools, and now, we're seeing something really cool: AI is becoming part of the database itself. Artificial Intelligence is being directly embedded, providing intelligent...
Peace of Mind Included: Understanding SLAs for Your Remote DBA Managed Services
Database downtime can cripple your business operations and lead to significant financial losses. Every minute your database is offline, you're losing potential revenue, damaging customer trust, and straining your resources. Is your Service Level Agreement (SLA) for...
Is Your Cloud SQL Server Eating Your Lunch Money? (And How to Stop It!)
Let's face it: Cloud SQL Server instances are fantastic. They offer scalability, flexibility, and all those other buzzwords we love. But they can also be sneaky little budget-busters if you're not careful. It's easy to get carried away with provisioning more...
How Oracle DBSAT Helps You Meet CIS Benchmarks with Confidence
As a database professional with over 20 years of managing Oracle environments, I've seen firsthand how database security has evolved from a checkbox task to a mission-critical discipline. With threats becoming increasingly sophisticated and auditors relying more...
Resolving Oracle Patch Issues: Troubleshooting ORA-20001 and Applying Datapatch
Keeping your Oracle database up to date with patches is crucial for both security and performance. However, patching issues can arise, leading to errors such as ORA-20001. In this blog, we'll walk through a real-world troubleshooting scenario where an Oracle 19c...
Stop Throwing Money at the Problem: How XTIVIA Optimizes Your Managed Cloud Database
Cloud databases offer scalability and flexibility but can become a money pit if not correctly managed. Often, when performance issues arise – slow queries, application latency, or unexpected downtime – the knee-jerk reaction is to throw more resources at the problem....
Using Oracle Cloud Storage with RMAN for Backups
Oracle Cloud Infrastructure (OCI) provides a secure and scalable Object Storage solution for storing database backups. By integrating Oracle Recovery Manager (RMAN) with Oracle Cloud Infrastructure (OCI), organizations can achieve efficient, cost-effective, and...
Percona XtraBackup vs MySQL Enterprise Backup: Which One Should You Choose?
When it comes to backing up large MySQL databases, especially without downtime, two tools dominate the conversation: Percona XtraBackup and MySQL Enterprise Backup (MEB). Both are designed for hot backups (backups that do not require stopping the database) and support...