DBASolved

Subscribe to  DBASolved feed  DBASolved
Data Migration, Data Replication, Cloud and DevOps
Updated: 3 weeks 4 days ago

Securing MCP Servers for Enterprise Use: Beyond HTTPS Protocol

Fri, 2025-08-15 07:54

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.

Categories: DBA Blogs

Why I’m Building AI Agents for Oracle GoldenGate (And You Should Too)

Tue, 2025-08-12 10:26

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.

Categories: DBA Blogs

Connecting to Oracle Database 23ai on Oracle@GCP with VS Code: A DBA’s Guide

Thu, 2025-07-31 10:02

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.

Categories: DBA Blogs

Oracle@GCP Setup: A Senior DBA’s Guide to Simple Enterprise Database Deployment

Thu, 2025-07-31 08:51

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.

Categories: DBA Blogs

Oracle GoldenGate LOB Replication to Snowflake: Getting It Right

Wed, 2025-07-30 10:39

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.

Categories: DBA Blogs

Real-Time Oracle Database to Google BigQuery: A GoldenGate 23ai How-To Guide

Mon, 2025-07-14 19:03

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.

Categories: DBA Blogs

Oracle GoldenGate 23ai Performance Tuning: Achieving 10M Rows/Hour on X-Small Snowflake Warehouses

Tue, 2025-07-08 17:42

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.

Categories: DBA Blogs

Five Enterprise Strategies for implementing AI

Fri, 2025-04-11 11:37

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.

Categories: DBA Blogs

GenAI: How to get started

Thu, 2025-03-27 13:14

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.

Categories: DBA Blogs

Oracle GoldenGate 23ai – Permissions, what to know!

Sun, 2024-08-18 14:53

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.

Categories: DBA Blogs

AIOUG Oracle Community Yatra 2024 … After Event Thoughts

Sun, 2024-08-04 20:20

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.

Categories: DBA Blogs

AIOUG Oracle Community Yatra 2024 … I’m excited, are you?

Tue, 2024-06-25 09:24

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.

Categories: DBA Blogs

The age of AI with Oracle GoldenGate23ai

Wed, 2024-06-19 11:11

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.

Categories: DBA Blogs

Oracle GoldenGate 23ai: Powering Real-Time Data Integration 

Mon, 2024-05-06 22:25

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.

Categories: DBA Blogs

Unlocking the Power of AI Vector Search in Oracle Database 23ai

Mon, 2024-05-06 21:46

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.

Categories: DBA Blogs

Embedding Machine Learning Models in the Oracle Database: Create an ONNX model

Mon, 2024-04-15 09:20

  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.

Categories: DBA Blogs

Similarity Search with Oracle’s Vector Datatype, Python, and Flask

Tue, 2024-03-05 11:46

  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.

Categories: DBA Blogs

Similarity Search with Oracle’s Vector Datatype

Tue, 2024-02-27 09:36

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.

Categories: DBA Blogs

Oracle Vector Datatype – Updating table data

Mon, 2024-02-26 14:36

  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.

Categories: DBA Blogs

Oracle’s Vector Datatype

Fri, 2024-02-02 12:33

At Oracle Cloud World 2023, Oracle announced they were moving toward enabling Artificial Intelligence (AI) within many of their products. […]

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

Categories: DBA Blogs

Pages