DBASolved

Discover how documenting technical solutions transformed my Oracle consulting career and why sharing knowledge multiplies your value. Learn practical approaches to start writing about your technical experiences and build both expertise and community connections.

The post Why Do I Write? A Journey from Knowledge Hoarding to Community Building appeared first on DBASolved.

Model Context Protocol (MCP) servers are transforming how enterprises integrate AI with their business applications, but this powerful connectivity creates new security challenges that go far beyond basic HTTPS encryption. As MCP servers grant AI systems access to sensitive business data across multiple applications—from CRM systems to databases—they essentially become gateways to your entire digital infrastructure. This comprehensive guide explores the multi-layered security approach needed for enterprise MCP deployments, covering authentication strategies, network architecture, data protection, and monitoring capabilities that ensure your AI integration remains both powerful and secure.

The post Securing MCP Servers for Enterprise Use: Beyond HTTPS Protocol appeared first on DBASolved.

After implementing Oracle GoldenGate in more environments than I can count, I’ve noticed something: every implementation follows the same pattern. […]

The post Why I’m Building AI Agents for Oracle GoldenGate (And You Should Too) appeared first on DBASolved.

Get connected to Oracle Database 23ai on Oracle@GCP in under 10 minutes using VS Code and SQL Developer extension. This step-by-step guide walks through wallet retrieval, connection configuration, and security best practices for DBAs managing cloud databases. No complexity, just straightforward instructions to establish secure connections and start working with your Autonomous Database instance.

The post Connecting to Oracle Database 23ai on Oracle@GCP with VS Code: A DBA’s Guide appeared first on DBASolved.

After decades of managing Oracle databases – from 8i in the Army to the latest 23ai deployments – I’ve seen […]

The post Oracle@GCP Setup: A Senior DBA’s Guide to Simple Enterprise Database Deployment appeared first on DBASolved.

Recently I’ve been helping clients navigate one of the more challenging aspects of Oracle GoldenGate implementations – replicating Large Objects […]

The post Oracle GoldenGate LOB Replication to Snowflake: Getting It Right appeared first on DBASolved.

For data engineers and architects, enabling real-time data flow from transactional Oracle databases into analytical platforms like Google BigQuery is […]

The post Real-Time Oracle Database to Google BigQuery: A GoldenGate 23ai How-To Guide appeared first on DBASolved.

Your Snowflake bills are probably 3x higher than they need to be. We  wrapped up an implementation where we slashed […]

The post Oracle GoldenGate 23ai Performance Tuning: Achieving 10M Rows/Hour on X-Small Snowflake Warehouses appeared first on DBASolved.

Artificial Intelligence (AI) is rapidly transforming the business landscape, offering unprecedented opportunities for innovation and growth. However, successful AI implementation […]

The post Five Enterprise Strategies for implementing AI appeared first on DBASolved.

This post we are going to look at some items related to getting started with Generative AI. This is mostly […]

The post GenAI: How to get started appeared first on DBASolved.

One of the biggest issues with Oracle GoldenGate over the years has been the database permissions needed for the GoldenGate […]

The post Oracle GoldenGate 23ai – Permissions, what to know! appeared first on DBASolved.

This is going to be a bit of a personal blog post, but I think is important to be shared […]

The post AIOUG Oracle Community Yatra 2024 … After Event Thoughts appeared first on DBASolved.

I started my career in IT back in 1995 when I joined the United States Military (Army). As an eighteen-year-old […]

The post AIOUG Oracle Community Yatra 2024 … I’m excited, are you? appeared first on DBASolved.

Artificial Intelligence (AI) is buzzing in today’s enterprise circles. Let’s briefly examine using AI in data integration, specifically with Oracle […]

The post The age of AI with Oracle GoldenGate23ai appeared first on DBASolved.

Oracle GoldenGate has long been the go-to solution for real-time data integration, and with the release of Oracle GoldenGate 23ai, […]

The post Oracle GoldenGate 23ai: Powering Real-Time Data Integration  appeared first on DBASolved.

Oracle has recently, May 2, 2024, unveiled Oracle Database 23ai, packed with innovative AI capabilities that are transforming the way […]

The post Unlocking the Power of AI Vector Search in Oracle Database 23ai appeared first on DBASolved.

  This post is the first of a three-part series where I’m going to show you how to use pre-configured […]

The post Embedding Machine Learning Models in the Oracle Database: Create an ONNX model appeared first on DBASolved.

  If you have been following the last few blog posts, this is the final one with regards to setting […]

The post Similarity Search with Oracle’s Vector Datatype, Python, and Flask appeared first on DBASolved.

In my last two posts I showed you what the Oracle Vector Datatype is and how to update existing data […]

The post Similarity Search with Oracle’s Vector Datatype appeared first on DBASolved.

  In my last blog post on Oracle’s Vector data type, I simply showed you how the datatype is used […]

The post Oracle Vector Datatype – Updating table data appeared first on DBASolved.