Blog | Pythian | Database (2)

Oracle

Optimizing Reports and Automating Failure Monitoring Using PL/SQL and the RMAN Catalog

The blog post is an addition to my earlier blog post Automating Oracle RMAN Backup Reports with PL/SQL Using the RMAN ...

Oracle

Automating Oracle RMAN Backup Reports with PL/SQL Using the RMAN Catalog

The reason for this blog post is to provide an alternative way on how to review RMAN backups for Oracle Database fleet.

Oracle

Resuming OMSPatcher Session When it Failed to Apply a Patch

Oracle Enterprise Manager Server ( OMS ) could be tricky when you have a bug, known issues or even an abnormal ...

Database

One of the hidden mechanics of PostgreSQL may not seem important at first

Introduction When you INSERT a row into some databases like Oracle, the row is only written to the datafile, once the ...

Oracle

The Power of Three: How Pythian, Oracle, and Google Cloud’s Partnership Means Simpler Cloud Migrations

The Oracle Database@Google Cloud partnership is transforming (and simplifying) how companies manage and move their key ...

Google Cloud

Unlock the Power of Google Cloud: Why It’s Time to Get Off Traditional Databases

Is it time to finally move off your traditional database and into the cloud? Many traditional environments are ...

Database

What is the Best Way to Shrink Your Tables in PostgreSQL?

In PostgreSQL (PG), there are two issues when it comes to table bloat. One is a consequence of the MVCC (Multi-Version ...

Database

Solving PostgreSQL's pg_basebackup 'ERROR: temporary file size exceeds temp_file_limit'

When performing a pg_basebackup in PostgreSQL, you might run into this frustrating error: pg_basebackup: error: could ...

Oracle

Getting started with the Oracle Database @ Google Cloud Service - Service Setup

Now that the new “Oracle Database @ Google Cloud” service is in general availability (GA), customers are eager to give ...

Oracle

Installing Oracle Database 23ai Free for ARM - Solution to DBCA ORA-00600

On September 16th, 2024 Oracle released “Oracle Database 23ai Free” (Developer’s Edition) for the ARM (aarch64) ...

Google Cloud

How Gemini for Databases Can Optimize Performance with Generative AI

Generative AI isn’t just for composing emails and creating presentations; the power of AI is also coming to databases. ...

Oracle

I Lost My ORAPKI Wallet Password—Now What?

Usually, you will face this issue when one of your certificates expires and you need to add a new one. When you try to, ...

MySQL

How to Promote a Google Cloud Replica from an External MySQL Primary

This is the second blog in a series about how to migrate a MySQL instance from a VM to Google Cloud SQL. See the first ...

Database

How to Set Up a Neo4j Database

With the rise of generative AI, graph databases have become a trendy method to store data. Neo4j offers adjacent-free ...

MongoDB

MongoDB metrics and thresholds

In my earlier blog post about Replica Set Maintenance Activities (available here), I emphasized the significance of ...

MongoDB

MongoDB Replica Set Maintenance Activities

As database administrators (DBAs) responsible for managing MongoDB replica sets, we are pivotal in ensuring the ...

Cloud

The DBA’s Future Role in Driving Digital Transformation

The CTO's decision to drive digital transformation forward will impact the role of the DBA. The role of the DBA is ...

Oracle

Expand Elastic Configuration on Oracle Exadata - Part 2

In Part 1 of this blog series, we looked at how to reimage a vanilla Exadata compute or storage node to install the ...

Oracle

Expand Elastic Configuration on Oracle Exadata - Part 1

Introduction Oracle's Exadata platform is a great way to run production Oracle database workloads.

Microsoft SQL Server

Unveiling the power of multi-IP addresses in SQL server always on listener

‍Introduction to SQL Server Always on Feature The SQL Server Always On feature is a revolutionary high-availability and ...

Oracle

Expand your Oracle Tuning Tools with dbms_utility.expand_sql_text

Background When working on a view composed of SELECT statements on other views, it can be difficult to know what the ...

Google Cloud

Secure the Connection to Your VPC Network from Serverless Environments in Google Cloud

There might have been various situations where you have needed to connect to services created in your Virtual Private ...

Cloud

Kafka Monitoring on Kubernetes with Datadog

Sometimes, during software modernization or development with microservices architecture, a requirement for a message ...

Oracle

Mitigating Long Distance Network Latencies with Oracle Client Result Cache

Recently, Pythian was engaged to investigate the performance of an application that was reported as performing poorly ...

Oracle

Viewing PostgreSQL Logs from the OCI PostgreSQL Service

Background After setting up a DB System in the new “OCI Database with PostgreSQL” service, one of the things DBAs will ...

Database

Creating an OCI PostgreSQL DB System using the CLI

In the previous blog Getting Started with the OCI PostgreSQL DB System, we covered how to create an OCI PostgreSQL DB ...

Microsoft SQL Server

Removing SQL Reporting Services instances from scale out deployment

Problem In a client’s environment, over the years, new servers were added to SSRS scale out deployment and old servers ...

Google Cloud

Analyzing a Movie Dataset Housed on MongoDB Through GraphQL - Part 1: Introduction & Mongo Database Setup

I’ll provide a quick start tutorial for GraphQL in this article. We'll start with an overview and then go into a small ...

Cassandra

An Introductory Guide on Deploying Cassandra Database using Ansible

Creating Cassandra_installation playbookDeploying a Cassandra database manually on hundreds of machines might be a ...

Database

Getting started with the OCI PostgreSQL service

Background In November 2023, Oracle surprised many by finally releasing their Oracle Cloud Infrastructure (OCI) ...

AI Related Latest Blogs

AI Enablement

GigaOm x Pythian: Realities and Risks of Enterprise AI

In a recent interview on the Business Disruptions in Tech podcast, Howard Holton and ...

Oracle

Oracle AI Data Platform (AIDP): No-Nonsense Platform Overview

Oracle’s AI Data Platform (AIDP) is essentially an attempt to fix the biggest annoyance ...

Google Workspace

AI in the Workplace: Employee Productivity & Sentiment Survey

2025 employee survey on the use of AI In November 2025, Pythian, a professional services ...

View All →

Analytics related blog posts

Analytics

Using Multi-Agent Reasoning for NLP-to-SQL

As data-driven decision-making becomes essential, access to that data shouldn’t require deep technical ...

Analytics

Becky's BI Apps Corner: OBIA 11.1.1.10.2

Upgrade jitters? If you’re running older versions of OBIA, the new 11.1.1.10.2 release brings game-changing features like automatic error handling and ...

Analytics

Oracle Data Integrator (aka Sunopsis) Now On OTN

Oracle Data Integrator (formerly Sunopsis) has officially landed on the Oracle Technology Network, bringing

View All →

Build a scalable data foundation to accelerate with AI.

Get started today →

Optimizing Reports and Automating Failure Monitoring Using PL/SQL and the RMAN Catalog

Automating Oracle RMAN Backup Reports with PL/SQL Using the RMAN Catalog

Resuming OMSPatcher Session When it Failed to Apply a Patch

One of the hidden mechanics of PostgreSQL may not seem important at first

The Power of Three: How Pythian, Oracle, and Google Cloud’s Partnership Means Simpler Cloud Migrations

Unlock the Power of Google Cloud: Why It’s Time to Get Off Traditional Databases

What is the Best Way to Shrink Your Tables in PostgreSQL?

Solving PostgreSQL's pg_basebackup 'ERROR: temporary file size exceeds temp_file_limit'

Getting started with the Oracle Database @ Google Cloud Service - Service Setup

Installing Oracle Database 23ai Free for ARM - Solution to DBCA ORA-00600

How Gemini for Databases Can Optimize Performance with Generative AI

I Lost My ORAPKI Wallet Password—Now What?

How to Promote a Google Cloud Replica from an External MySQL Primary

How to Set Up a Neo4j Database

MongoDB metrics and thresholds

MongoDB Replica Set Maintenance Activities

The DBA’s Future Role in Driving Digital Transformation

Expand Elastic Configuration on Oracle Exadata - Part 2

Expand Elastic Configuration on Oracle Exadata - Part 1

Unveiling the power of multi-IP addresses in SQL server always on listener

Expand your Oracle Tuning Tools with dbms_utility.expand_sql_text

Secure the Connection to Your VPC Network from Serverless Environments in Google Cloud

Kafka Monitoring on Kubernetes with Datadog

Mitigating Long Distance Network Latencies with Oracle Client Result Cache

Viewing PostgreSQL Logs from the OCI PostgreSQL Service

Creating an OCI PostgreSQL DB System using the CLI

Removing SQL Reporting Services instances from scale out deployment

Analyzing a Movie Dataset Housed on MongoDB Through GraphQL - Part 1: Introduction & Mongo Database Setup

An Introductory Guide on Deploying Cassandra Database using Ansible

Getting started with the OCI PostgreSQL service

Recent news

Pythian Ranked on CRN's 2026 Solution Provider 500 List for Seventh Consecutive Year

Pythian Recognized as a Top AI & Data Consulting Firm for 2026

Pythian Recognized as Silver Winner in UKOUG Data Integration Partner of the Year Awards 2026

Pythian Leaders Recognized on CRN’s 2026 Women of the Channel List

Pythian and Three of Its Leaders Named Finalists for the 2025 CRN Women of the Year Awards

Pythian India Earns “Great Place to Work” Certification for Fourth Consecutive Year

Pythian’s Vanessa Simmons and Donna Williston Again Named to CRN’s 2025 Women of the Channel List

Pythian Positioned as Oracle Database @ Google Cloud Leader with Acquisition of Rittman Mead

Pythian Doubles Down on AI-Readiness, Expanding AI Practice with Valuable Services and Expertise

Pythian Launches Agentspace QuickStart

Pythian Wins 2025 Google Cloud Databases Partner of the Year for North America

Pythian and GigaOm Announce AI Partnership

Pythian Named Top Employer in Canada's National Capital Region for 2025

Pythian Welcomes Shawn Gandhi as Senior Vice President, Customer Engineering, and Country Managing Director for Canada

Pythian Announces New Oracle Database@Google Cloud Migration Services

Pythian India Earns “Great Place to Work” Certification for Third Consecutive Year

Pythian Recognized on CRN’s 2024 Solution Provider 500 List and DBTA’s 100 Companies That Matter Most in Data for 2024

Pythian Welcomes Brooks Borcherding as Chief Executive Officer

Pythian’s Vanessa Simmons and Donna Williston Honored by CRN on 2024 Women of the Channel Lists

Pythian Recognized as a Top Employer in Canada’s National Capital Region in 2024

Pythian Announces Generative AI Strategy and Offerings to Accelerate Enterprise Innovation

CRN Names Pythian’s Vanessa Simmons a 2023 Women of the Channel Power 80 Solution Provider

Award-Winning Marketing Veteran Christina O’Reilly Joins Pythian Services as Senior Vice President, Marketing

Pythian Makes Database Trends and Applications’ List of Trendsetting Solution Providers for 2023

Pythian Celebrates 25 Years of Enterprise Data, Analytics, and Cloud Success

Pythian India Achieves “Great Place to Work” Certification After Building High-Trust, High-Performance Culture

Pythian Named One of ‘The Companies That Matter Most in Data’ by Database Trends and Applications Magazine

Vanessa Simmons from Pythian Named on CRN’s 2022 Women of the Channel Power 70 Solution Providers List

Pythian Named Partner in Launch of Google Cloud Cortex Framework

Pythian’s SAP Services Practice Grows by 300 Percent in 2021

Pythian Renews Google Cloud Infrastructure Specialization in the Google Cloud Partner Advantage Program

Pythian Services Recognized on CRN’s 2022 MSP 500 List

Pythian Renews Machine Learning Partner Specialization in the Google Cloud Partner Advantage Program

Pythian Sets Company Record with Over 100 New Customers in 2021

Pythian’s CTO Paul Lewis Featured Commentary Published by InformationWeek

How to Modernize Backup Without Breaking the Bank

Pythian Launches FinOps Managed Services

Pythian Acquires SAP MSP Partner ManageServe

Pythian Taps Seasoned Cloud and Data Expert Paul Lewis as CTO

Pythian Achieves Managed Services Provider Status In the Google Cloud Partner Advantage Program

Keith Angell: Accelerating Enterprise Growth With Data And Analytics Through Remarkable Leadership

Pythian Achieves the Data Management Partner Specialization in the Google Cloud Partner Advantage Program

Pythian Adds Snowflake Data Cloud Services Suite

New CEO Keith Angell: Pythian Services A ‘Golden Nugget’

Pythian Appoints Keith Angell As CEO

Pythian Services Acquires Google Cloud Premier Partner Agosto

Pythian Announces Support For AWS Outposts As A Launch Partner

Pythian Wins 2018 Google Cloud Data Analytics Partner of the Year Award

Pythian achieves Machine Learning Partner Specialization in the Google Cloud Partner Specialization Program