In The Economics of Multi-Cloud Databases, we looked at the financial case for spreading database workloads across AWS, Azure, and Google Cloud Platform (GCP) - where the cost savings come from, why avoiding vendor lock-in has real economic weight, and how egress fees and operational overhead can quietly cancel out those savings if left unmanaged. That article made the case that multi-cloud is a legitimate strategic option, not a universal best practice, and that it only pays off when it's actively managed rather than left to accumulate by accident.
This article picks up where that one left off. If the economics are sound, the next question is operational: how do you actually run a multi-cloud database estate day to day without the complexity eating the savings? More organizations now run databases across more than one cloud provider - often AWS, Azure, and Google Cloud Platform (GCP) at the same time. Sometimes this happens by design, as a deliberate resilience strategy. More often it happens by accumulation: a team standardizes on AWS RDS for one project, another spins up Azure SQL Database for a new app, and a data science group builds on BigQuery or Cloud SQL because that's what integrates with their tooling. Either way, the result is the same a database estate spread across three different consoles, three different billing models, and three different sets of operational quirks.
Navicat 17 raised the bar with its redesigned Model Workspace, Data Profiling, and Data Dictionary. Meanwhile, Navicat 18, which is slated for release in mid-August, is shaping up to be an even bigger leap forward. From AI-assisted data editing to a completely unified modeling experience, this release touches nearly every corner of the app. There's far too much to unpack in a single post, but this article will provide a preview of what's coming.
Zero trust security operates on a simple premise: never assume trust based on network location, and verify every request as if it originated from an open network. For decades, database security relied heavily on perimeter defenses, i.e., firewalls, VPNs, and the assumption that anything inside the corporate network was safe. Zero trust discards that assumption entirely. Every connection, every query, and every user session must be authenticated, authorized, and encrypted, regardless of whether the request comes from a laptop in the office or a contractor working remotely. This article breaks down what that shift looks like in practice for DBAs, and how everyday tools like SSH tunneling, SSL/TLS connections, and role-based access management fit into a zero trust approach.
Every application needs to be tested, and every test needs data. Yet generating good test data is one of those tasks that gets underestimated until it becomes a problem. Teams either use production data and run into privacy and compliance issues, or they hand-craft a handful of rows that barely scratch the surface of what the application will actually encounter in the wild. Neither approach scales, and both leave gaps in test coverage that tend to surface at the worst possible moment. This article makes the case for investing in proper test data generation and shows how Navicat's built-in tooling can make the process significantly faster and more reliable.
Database teams have more options than ever for managing MySQL environments, but the choice often comes down to a fundamental question: should you install a desktop client on every machine, or give your team browser-based access to a centralized platform? The answer depends less on personal preference and more on how your team works, where your data lives, and how much control you need over access and security.
- 2026 (1)
- August (1)
- July (1)
- Zero Trust Database Security for DBAs: Best Practices with SSL, SSH & Role-Based Access
- Database Test Data Generation Made Easy with Navicat
- Web-Based MySQL GUI Tool vs Desktop: Which is Right for Your Team?
- Designing Better Databases with Data Vault 2.0 and Navicat Data Modeler 4
- Version-Controlling Your Database Schema with Git and Navicat
- June (1)
- May (1)
- Reading Execution Plans Without the Headache
- The Case for Data Lineage in Your Database
- Stored Procedures vs. Application Logic: Where Should Business Rules Live?
- From SQL Beautifiers to Intelligent Autocomplete: A History of Developer Productivity Tools
- How to Manage Shared Query Libraries Across a DBA Team
- April (1)
- March (1)
- The Hidden Costs of Cloud Database Services (and When On-Prem Makes More Financial Sense)
- How AI Code Completion Is Changing the Way DBAs Write SQL
- Role-Based Access Control in Database Environments: Getting It Right
- On-Prem vs. Cloud Database Hosting: How to Choose the Right Approach for Your Organization
- Getting Started with AI Assistants in Navicat On-Prem Server 3.1
- SQL vs. NoSQL: Choosing the Best Fit for Your Project
- February (1)
- What Metrics Actually Matter in Database Monitoring
- A Practical Guide to Database Transaction Isolation Levels
- Database Connection Pooling Explained
- Managing Database Credentials Securely
- Building Resilient Database Architectures
- The Future of Database Licensing Models: Navigating the Shift in How We Pay for Data Infrastructure
- January (1)
- Harnessing PostgreSQL Power: An Introduction to Supabase
- The ROI of Database Automation: Quantifying the Business Value of Automated Tuning, Patching, and Optimization
- Database Observability: The New Frontier in Performance Management
- The Database Skills Gap Crisis: Navigating the Shortage of Database Professionals
- The Economics of Multi-Cloud Databases
- 2025 (1)
- December (1)
- November (1)
- October (1)
- September (1)
- August (1)
- Going Beyond Basic Monitoring with Modern Database Observability Platforms
- Privacy-Preserving Databases: Protecting Data While Enabling Access
- Privacy-Preserving Databases: Protecting Data While Enabling Access
- Privacy-Preserving Databases: Protecting Data While Enabling Access
- A Guide to Database Sharding as a Service
- July (1)
- June (1)
- The Rise of Embedded AI/ML Capabilities in Modern Databases
- Immutable Databases: the Evolution of Data Integrity?
- Seamless Information Access Through Data Virtualization and Federation
- Database DevOps Integration: Bridging the Gap Between Development and Operations
- Navicat Sponsors SQLBits 2025 – Supporting the Future of Data Platforms
- May (1)
- Edge Databases: Empowering Distributed Computing Environments
- The Rise of Low-Code/No-Code Database Interfaces: Democratizing Data Management
- Data Vault 2.0: A Modern Approach to Enterprise Data Modeling
- Streaming-First Architectures: Revolutionizing Real-Time Data Processing
- Navicat Proudly Sponsors PGConf.de 2025 as Silver Sponsor (Two Free Tickets Up for Grabs!)
- April (1)
- March (1)
- February (1)
- January (1)
- 2024 (1)
- 2023 (1)
- 2022 (1)
- 2021 (1)
- 2020 (1)
- 2019 (1)
- 2018 (1)
- 2017 (1)
