Business Insights
Business Insights

Embracing the New Normal with Google Workspace – Part One

October 23, 2020

“The only thing that is constant is change.” – Heraclitus, Greek Philosopher, 535 BCE to 475 BCE While change might be a hot topic of discussion since the arrival of the novel coronavirus, the above quote is a reminder that…

Thriving Through Change with Google Workspace

October 21, 2020

Work has been transforming as long as we’ve been doing work. Companies have always needed to adapt to new societal, technological, and global developments. The current pace of transformation, however, is something entirely new. It’s not an exaggeration to say…

Leading Through Crisis – What Ernest Shackleton Can Teach Us About the COVID Pandemic

September 17, 2020

In January 1915, polar explorer Ernest Shackleton’s ship became trapped in ice near Antarctica. For the next two years, he kept his crew of 27 men alive on a drifting ice cap, before leading them to safety. In this article…

Datascape Podcast Episode 44: Snowflake with Kent Graziano

July 27, 2020

Episode 44: Show Notes Snowflake is the only data platform built for the cloud for all your data and all your users. Today we have Kent Graziano, Chief Technology Evangelist at Snowflake, here on the show to discuss how this…

The Top 10 Reasons to Add Pythian to Your Team

July 24, 2020

Let’s start with the obvious: Technology has changed a lot in the past ten years. And as technology has changed, so too have the reasons for augmenting your IT department with the expertise of a managed services provider (MSP). Ten…

How QAD workers get access to Pixelbooks in minutes, using Grab and Go

July 8, 2020

This article was originally posted on Google Cloud Blog, click here to read the original. Author’s note: Today’s post is by Scott Lawson, Director of IT Architecture at QAD, provider of cloud-based software and services for global manufacturing companies. QAD…

8 Questions To Ask When Choosing A Database Managed Service Provider

July 6, 2020

If you’re searching for a database managed service provider, congratulations are in order. You’re one step closer to being able to focus more fully on the strategic priorities of your business. But bear in mind that choosing the wrong provider…

DBAs and the Cloud: Evolving Roles and New Challenges

June 17, 2020

Do businesses have the right skills and expertise internally to take full advantage of both the tactical and strategic benefits of the cloud? To help you determine what skills are needed on your team, we’ve developed a list of 5 key skills of modern DBAs in the era of cloud. And for a complete picture of what cloud means for your DBA team, Warner Chaves, one of Pythian’s principal consultants, has written a white paper outlining how database management is different in the cloud, and the key skills the modern DBA must have.

Keep Your Teams On-Track During COVID-19 and Beyond

June 4, 2020

It could be that your organization was working remotely long before the arrival of COVID-19. Even if that’s the case, you’re now dealing with challenges you couldn’t have imagined back in March. But here’s some good news: Agosto, a Pythian…

Hands On Transfer Learning with Keras

June 4, 2020

Transfer learning is an approach where the model pre-trained for one task is used as a starting point for another task. It’s extremely useful in scenarios where there are limited data available for model training, or when training a large…

OATUG Forum Online (or, the 2020 Version of Collaborate Las Vegas)

May 29, 2020

Hi everyone! It’s been a very busy year for me, so I haven’t had much time to blog. But, here we go! This isn’t a technical post, but more of an opinion piece. I’ve split this post into two parts….

How Pythian and Google helped reduce pesticide use in high-value crops

April 29, 2020

Semios is a Vancouver-based data analytics company for growers of high-value crops such as almonds and apples. It uses a combination of machine learning, in-crop wireless networks and half a million IoT sensors across 80,000 acres to offer real-time monitoring…

Datascape Podcast Episode 41 – Choosing a Public Cloud for Oracle Database

April 23, 2020

You can run Oracle anywhere. It’s very flexible, which means anywhere you can get a VM, you can run it, including a virtual box on your laptop. There’s even have a free edition (XE) if you don’t have large data…

Tips that Help Alleviate Pressures on DataOps

April 15, 2020

Data is hard. Its always been hard, and it’s not getting easier. We always have more of it, there are more sources to integrate, it changes all the time, the quality is questionable, and the business wants it all right…

How Pythian Is Flattening the IT Disruption Curve

April 14, 2020

COVID-19 is creating a perfect storm of disruption, chaos, and challenges for organizations in both the private and public sectors. The current pandemic is almost certainly adversely affecting every institution, while a few might be able to draw a few…

Infographic: What is Data Governance?

March 25, 2020

An explainer on achieving consistency, trustworthiness, and accessibility across your data estate. The Wild West might be entertaining in movies or TV, but it’s the equivalent of a horror show when it comes to your organization’s data. That’s why strong…

Our Commitment to You During COVID-19

March 17, 2020

In light of the continued spread of Coronavirus (COVID-19) globally, we want to let our clients know how Pythian is prepared to continue providing the high standard of service you’ve come to expect. Our leadership team has developed an action…

The top 5 reasons you need a data governance strategy

March 17, 2020

The concept of good governance is key to any high functioning society and economy. It helps establish and maintain trust between constituents and their representatives, along with setting the stage for people and organizations to operate within a well-defined framework…

Advice for Remote Work Planning

March 12, 2020

With many companies investigating or enacting remote work options in response to the COVID-19 outbreak, the Pythian team would like to share their best advice to those companies considering a move to remote work. Here are some of our remote…

Defining “real-time’ or ‘streaming’ analytics and its use cases

March 5, 2020

This is the first in a series on real-time or streaming data analytics best practices, including terminology, system design and examples of real-world success. In this initial post, we’ll focus on terminology and possible use cases. When launching a multi-part…

More Articles >

Technical Track
Technical Track

Silent Out-of-Place Patching For Oracle 19c GI

October 22, 2020
I am going through a process of patching an Oracle Grid Infrastructure (GI) from 19.6 to 19.8 (Patch 31305339) and I wanted to try out-of-place patching (OOP). Since I didn't have access to the GUI (graphical user interface) environment, I...

Reducing Contention on Hot Cursor Objects (Cursor: Pin S)

October 20, 2020

First, let me offer a little explanation about the wait event “cursor: pin S.” Oracle states: “A session waits on this event when it wants to update a shared mutex pin and another session is currently in the process of…

OPatchAuto Bug on 19.3 GI/RDBMS When Patching to 19.6

October 15, 2020
The other day I was doing a fresh install of Oracle 19.3. I was using the binaries from edelivery, doing some testing in that version, then patching to 19.6. The installation and the tests went fine. Next, I proceeded to...

How to Overcome the Top 10 SQL Server Performance Challenges

October 14, 2020

Working with consulting clients is rewarding, interesting, and challenging. In discussion with some of my colleagues, I’ve noticed the same performance challenges come up over and over again across clients with completely different hardware, industry verticals, levels of staff seniority,…

EM 13c: Patching Oracle Enterprise Manager With Release 4 Update 6 (

October 13, 2020

Once I had done this, I created a property file to be used during the patching activities so I wouldn’t have to input the Weblogic information over and over. The next step was to analyze whether this patch was applicable…

How to Enable RAM Cache in Oracle Exadata

October 8, 2020

A brief background on RAM cache or in-memory OLTP acceleration In this post I will present a feature — to simplify let’s call it RAM cache — introduced in Oracle Exadata Storage Server image 18.1. You’ve probably heard a lot…

Resolving Error ORA-28353: Failed to Open Wallet

October 6, 2020
Full disclosure: this is a post I've had in draft mode for almost one and a half years. I noticed the original error after applying the October 2018 bundle patch (BP) for While I realize most clients are no...

Management and Troubleshooting Features: Data Guard Command-Line Interface (DGMGRL) 19c

October 1, 2020

With Oracle Data Guard promising high availability, data protection and disaster recovery for enterprise data, it’s useful to understand the Data Guard command-line interface (DGMGRL) which enables you to control and monitor a Data Guard configuration from the DGMGRL prompt…

Overcoming ORA-01722 Error While Doing an Upgrade With Different DST Versions

September 29, 2020

This will be a short entry, but hopefully, it will help if you face the error “ORA-01722: invalid number” while doing an upgrade. Today I was doing an Oracle RDBMS upgrade from 12.2 with DST 34, to 19.7 with DST…

Setting up MySQL Monitoring With New Relic Infrastructure Pro

September 25, 2020

If you have a New Relic Infrastructure Pro license, and unmonitored MySQL servers, there’s now an easy solution at your fingertips. With the New Relic MySQL integration you can monitor and graph almost any detailed metric you could possibly want….

Dipping Your Toes Into Building an Analytics Platform on Google Cloud Platform

September 17, 2020

“We have many disparate data sources and we’re having a hard time getting a global view of all our data across our organization.” “Our data is currently all in <enter data warehouse name here> and we want to migrate it…

Leading Through Crisis – What Ernest Shackleton Can Teach Us About the COVID Pandemic

September 17, 2020

In January 1915, polar explorer Ernest Shackleton’s ship became trapped in ice near Antarctica. For the next two years, he kept his crew of 27 men alive on a drifting ice cap, before leading them to safety. In this article…

Benefits of Workshop Learning: a Cassandra Workshop Example

September 16, 2020

At Pythian, we pride ourselves in assisting and empowering our clients. We strive to understand the needs of each customer and to teach customers to make the most of their resources. Experience has shown that the best way to learn…

Exadata’s InfiniBand Switch: Incorrect NTP settings Leading to Evictions, and Patching Recommendations

September 8, 2020

Overview This post describes a recent outage during a routine Exadata (X7-2) patching to the release using “patchmgr.” An incorrect configuration of NTP (Network Time Protocol) on the InfiniBand (IB) switches placed all switches in the “discover” state after…

Using SQLCODE Function

September 8, 2020

The idea of this post is to show how to handle errors using SQLCODE function. That function shows the code error for the latest exception when running a PL/SQL code. Here is a small example of code that raises an…

ProxySQL Query Rules: Notes From Production

September 2, 2020

After spending four years working with ProxySQL in production, I’ve learned a few interesting lessons about interpreting and processing query rules. I hope to save you some time (and avoid wrong turns) with this summary of ProxySQL query rules. ProxySQL…

Cassandra Vulnerability – CVE-2020-13946 – Apache Cassandra RMI Rebind Vulnerability

September 2, 2020

On September 1, 2020, Apache disclosed a security vulnerability for Apache Cassandra. Summary: It’s possible for a local attacker without access to the Apache Cassandra process or configuration files, to manipulate the RMI registry to perform a man-in-the-middle attack and…

Top Five Recommendations to Accelerate Your Snowflake Adoption

August 27, 2020

After eight years in business, Snowflake filed its prospectus with the USA’s Securities and Exchange Commission to become a publicly traded company this week (August 24, 2020). Details are here. This is the next step in the history of the…

Adding Your RDS Fleet to PMM2 Using the API

August 27, 2020

PMM (Percona Monitoring and Management) is a great community tool for monitoring your OSDB (MySQL, PostgreSQL, MongoDB) fleet. It’s feature rich, and it’s built and distributed as open-source based on several de-facto industry standard tools such as Grafana and Prometheus….

CreateGoldImage Followup – Is CreateGoldImage Required for Cloning Oracle Home?

August 25, 2020

On October 31, 2019, I blogged about How To Use CreateGoldImage For Cloning In 19c. CreateGoldImage seems like a nice new feature; however, it’s also very buggy. Here are a few bugs: 2641469.1 27432355.8 27432338.8 I received a suggestion to use tar…

More Articles >

Pythian Life
Pythian Life

Pythian Postcards: Toulouse, France … by way of Mexico

October 16, 2020

Welcome to post number one in our new “Pythian Postcards” series! These posts will spotlight Pythian employees living all over the world, to let Pythian employees learn more about each other and showcase the diversity of the Pythian workforce. We…

How To Get The Most Out Of Your Next Virtual Learning Event

September 2, 2020

COVID-19 pandemic has disrupted every aspect of our lives this year. But in July, in spite of all the upheaval, the All India Oracle Users Group (AIOUG) still managed to hold its annual Oracle Groundbreakers Yatra conference. By moving the…

We Need More Women in Tech!

May 14, 2020

Two years ago, I joined Pythian. This was my introduction to working in “tech.” The only hint of what working in tech might be like came from binge watching TV series such as “Silicon Valley” and movies like “The Social…

What to Expect When Interviewing with Pythian

May 12, 2020

Welcome to Pythian’s recruitment process! We haven’t met yet, but if you’re considering a role here at Pythian, you’ll likely be speaking with me or one of my colleagues on the Talent Acquisition team.  What We Do Our purpose at…

Ten Tips When Working from Home During These COVID-19 Times

March 30, 2020

During this COVID-19 time, business is no longer as usual. Recently I have had a few contacts asking me for tips on how to work remotely. Why? Well, I have been working from home for ten years now. Working remotely, …

22 Ways to Make Remote Work, Work!

October 29, 2019

If I offered you a job that would allow you to live anywhere you wanted, where you could wake up and start work at any time, and never be stuck in traffic… would that check some of the boxes on…

Achieving rock-solid maintenance with template-based action plans

February 7, 2019

Pythian has always been serious about reducing human mistakes. Our consultants have always been required to log all terminal outputs for the work we execute so that the information is available to our clients, and to make sure the same…

A day in the life of a Red Cross volunteer

October 22, 2018

In addition to my day job working as a team manager at Pythian, I am fortunate to be part of a specialist Red Cross volunteer team called an Emergency Response Unit (ERU). There are many of these ERUs around the…

First time presenter, what a feeling!

October 9, 2018

It’s been a couple weeks now, and the dust has settled but not the sentiment. I am talking about my very first public presentation performed at Spain Oracle Users Group (SPOUG) during the Technical SPOUG Day 2018 on September 25th….

Mentorship can be a valuable tool for professional growth

July 5, 2018

Mentoring has been defined as a professional relationship between a mentor (more experienced) and a mentee (less experienced) to develop certain skills and knowledge that will enhance personal and professional growth. Mentors are usually assigned to junior members of a…

The life of a happy remote DBA

June 20, 2018

Life is a balancing act between the personal and professional. It is a journey and this journey should be filled with joy and happiness. It should also give you a chance to learn, to grow and to cherish moments, spending…

Technical training – good for business and career

June 15, 2018

Whether you are just starting out or have been working with technology and want to expand your skill set, training never hurts anyone. In some situations, your own company encourages it and wants to help you excel. You may be…

Pythian BORG: bringing on recruited gurus

May 2, 2018

When university graduation was rushing up on me and I hadn’t the first idea how I would start my career, my parents gave me the best advice I’ve ever received: Find meaningful work that you’re passionate about and collaborate with…

The life of a Pythian road warrior

April 9, 2018

I’m sitting here on March 16th, the day before Saint Patties day and I am thinking about what I will need for my trip to Salt Lake City next week. I work for Pythian in the Principal Consulting Group. We are…

The value of lifelong learning

March 9, 2018

When I was asked to write a blog post about two conferences I attended this year, I had to sit down and think. Think about how learning is such an essential aspect of my life, both personally and a professionally….

A Team Manager’s perspective on success at Pythian

February 15, 2018

To all managers out there, especially in the IT sector, to be truly successful you don’t need to be the most technical savvy person on your team.

Diversity: pursuing your dreams

February 1, 2018

Seven months ago, I was fortunate to start a new career journey with Pythian. At first I found working in IT intimidating as I was working with such a wide variety of technical subject matter experts on a daily basis,…

Kickstart your career

January 22, 2018

Working at Pythian has probably been one of the best decisions I could have made towards developing my technical skills as well as growing my skills as a person. When I first got the interview, I knew nothing of the…

From co-op to full time!

January 10, 2018

My experience with Pythian was like a co-op fairy tale. As a 4th-year student entering my last co-op term, I was looking for something more than just a regular administrative job. I was seeking a role in which I could…

The Pythian community gives back: movember and the holiday food drive

January 2, 2018

They say you can’t create an org culture, you can only guide it. As a growing IT services company with 400+ employees spread across 35+ countries, one of our biggest opportunities is not technological but cultural. An inherent challenge we…

More Articles >