Blog | Pythian (9)

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) ...

Analytics

Oracle Enterprise Command Centers: Unlocking the Power of Data for Better Business Decisions

As organizations face an ever-increasing need for agility, they are constantly seeking ways to enhance their ...

Oracle

Testing DBSAT 3.0 - What's New ?

Overview DBSAT is a great database security assessment tool available since 2016. Within that time, it has evolved to ...

Oracle

Google ‘Backup and DR’ for Oracle

Whenever I’m thinking of Oracle backup, I basically think of putting Oracle RMAN backup to a disk (simplified version) ...

Oracle

Oracle Cloud Infrastructure: Schemas in Oracle Autonomous Database

If you have started familiarizing yourself with Oracle Cloud Infrastructure (OCI) Autonomous Database (ADB) service, ...

MySQL

How to Setup a Google Cloud SQL Replica from an External MySQL Primary

This is the first in a series of blog posts on how to migrate a MySQL instance from a VM to Google Cloud SQL.

AI Enablement

Architecting and Building Production-Grade GenAI Systems - Part 1: Architectural Matters

In recent months, it seems that everyone in the IT industry has been talking about Generative AI and Large Language ...

Analytics

Best Practices for Getting the Most Out of SAP HANA Cloud

If you've made the decision to invest in HANA Cloud, congratulations! You're on your way to leveraging the power of ...

Database

New Features for DBA's in PostgreSQL 16

Introduction 16 has just been launched, and this year, we have a raft of new features to look through and evaluate. ...

Microsoft SQL Server

Fix: Invalid Object Name 'SSISDB.catalog.customized_logging_levels'

Background You migrated an SSIS Catalog from another server by doing a backup and restore of the SSIDB. Restore ...

Oracle

Old Dog with New Tricks: Indexing Null Columns in Oracle

Background

MySQL

How to Migrate Your On-Prem MySQL 8 Database to RDS Using MySQL Shell Logical Backup

Context

Analytics

Apache Beam vs. Apache Spark

Introduction Both Apache Spark and Beam are distributed programming languages. Apache Spark was initially open-sourced ...

Microsoft SQL Server

Fix: The Instance ID 'MSSQLServer' is Already in Use by SQL Server Instance 'MSSQLServer.Inactive'

Problem: You attempted an in-place upgrade of an existing default instance of SQL Server. The upgrade failed for one ...

Oracle

Oracle SQL Trace: Is it Safe for Production Use?

Perhaps you have been approached by a client or manager and tasked with troubleshooting one or more slow-running SQL ...

Oracle

Oracle Database Migrated to Cloud Starts Experiencing "log file sync" Waits

A client was moving an Oracle 11.2.0.4 database from their data center to one of the major cloud providers' ...

Oracle

Checking Free Space of UNDO Tablespaces

This blog is a high-level overview of the fundamental Oracle feature UNDO tablespace and its space management. ...

Google Cloud

Dataflow and Airflow Integration Challenges for Beginners

First, let me briefly introduce dataflow and what it offers as a Google Cloud Platform (GCP) service.

Microsoft Azure

Extract Insights from Documents with Azure Document Intelligence

Most organizations that I speak to have tons of documents that contain valuable information but don't have the time or ...

MySQL

Exploring Backup/Restore Comparison Using MySQL Shell Utility vs. Percona XtraBackup Utility vs. MySQLDump

In this blog post, we will be comparing the time it takes for backup and restore using MySQL Shell Utility vs. Percona ...

Google Cloud

Understanding your Data Lifecycle for Better Data Management

Managing data is a lot harder than it sounds. It’s often stored in multiple locations. It can be structured, ...

AI Related Latest Blogs

Analytics

Oracle AI World: The Pragmatic Leader’s Guide to the Autonomous Enterprise

Leading up to Las Vegas, I laid out what the C-suite needed to watch for at Oracle AI ...

8 Best AI Automation Consulting Companies (2026 Guide)

It is undeniable that AI is embedded in every conversation we have and is restructuring ...

Analytics

First Look: Deep Insights Agents in Oracle Analytics AI Assistant

If you have followed our research or attended our conference sessions over the past two ...

View All →

Analytics related blog posts

Analytics

Oracle AI World: The Pragmatic Leader’s Guide to the Autonomous Enterprise

Leading up to Las Vegas, I laid out what the ...

Analytics

First Look: Deep Insights Agents in Oracle Analytics AI Assistant

If you have followed our research or attended our conference sessions over the past two years, you have seen how rapidly Oracle Analytics AI Assistant ...

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 ...

View All →

Build a scalable data foundation to accelerate with AI.

Get started today →

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

Oracle Enterprise Command Centers: Unlocking the Power of Data for Better Business Decisions

Testing DBSAT 3.0 - What's New ?

Google ‘Backup and DR’ for Oracle

Oracle Cloud Infrastructure: Schemas in Oracle Autonomous Database

How to Setup a Google Cloud SQL Replica from an External MySQL Primary

Architecting and Building Production-Grade GenAI Systems - Part 1: Architectural Matters

Best Practices for Getting the Most Out of SAP HANA Cloud

New Features for DBA's in PostgreSQL 16

Fix: Invalid Object Name 'SSISDB.catalog.customized_logging_levels'

Old Dog with New Tricks: Indexing Null Columns in Oracle

How to Migrate Your On-Prem MySQL 8 Database to RDS Using MySQL Shell Logical Backup

Apache Beam vs. Apache Spark

Fix: The Instance ID 'MSSQLServer' is Already in Use by SQL Server Instance 'MSSQLServer.Inactive'

Oracle SQL Trace: Is it Safe for Production Use?

Oracle Database Migrated to Cloud Starts Experiencing "log file sync" Waits

Checking Free Space of UNDO Tablespaces

Dataflow and Airflow Integration Challenges for Beginners

Extract Insights from Documents with Azure Document Intelligence

Exploring Backup/Restore Comparison Using MySQL Shell Utility vs. Percona XtraBackup Utility vs. MySQLDump

Understanding your Data Lifecycle for Better Data Management

Recent news

Pythian Announces Integration with Gemini to Help Accelerate Cloud Migration for Oracle Applications

Pythian Leaders Earn Three Finalist Honors in 2026 CRN Women of the Year Awards

Paul Lewis, Chief Technology Officer at Pythian Featured in CIOReview on Why AI Adoption Is the Metric That Matters

Pythian Named to DBTA 100: The Companies That Matter Most in Data

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