One of the most enduring debates in software architecture is deceptively simple to state but genuinely difficult to resolve: when you have a business rule to enforce, should it live in the database as a stored procedure, or in your application code? The answer shapes how your system is tested, maintained, scaled, and evolved. As we'll see in today's blog entry, it's a question that's worth thinking through carefully.
Developer productivity tools have quietly shaped how software gets built. What began as simple utilities for tidying up messy code has evolved into AI-powered assistants capable of understanding intent, fixing bugs, and explaining complex logic — all in real time. Tracing this evolution reveals not just how tools have changed, but how our expectations of them have grown.
A well-maintained shared query library is one of the most underrated assets a DBA team can have. When everyone on the team is pulling from the same vetted, documented pool of SQL, you eliminate duplicated effort, reduce the risk of logic errors creeping into production, and make onboarding new team members dramatically faster. But building and sustaining a shared library takes more than just dropping .sql files into a shared folder. Here's how to do it properly.
Every time a database client sends a query or receives a result set, that data travels across a network. On a private, isolated network with no external access, this may be an acceptable risk. In most real-world environments, however, where traffic crosses shared infrastructure, cloud networks, or the open internet, an unencrypted database connection is a significant exposure. SSL/TLS encryption closes that gap, and configuring it correctly is one of the more important and frequently overlooked steps in securing a database environment.
Database work has traditionally been a highly centralized discipline. DBAs and developers sat near each other, shared the same internal network, and could hand off work with minimal effort. That model has changed considerably. Teams are now routinely spread across cities, time zones, and continents, and the practices that worked in a shared office environment don't automatically translate to distributed ones. Getting collaboration right in this context requires deliberate process design, clear conventions, and tooling that bridges the physical distance without sacrificing security or consistency.
- 2026 (1)
- May (1)
- 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)
