Business Insights
Business Insights

Google Recognizes Pythian’s Outstanding Data Management Work in 2020 with Inaugural Award

July 28, 2021

Love your data.  It’s far more than our tagline here at Pythian—it’s truly in our DNA.  That’s why we’re thrilled, honored and even a bit humbled to be named the first-ever Google Cloud Specialization Partner of the Year for Data…

What Is FinOps? Part One: A Crash Course in Cloud Cost Optimization

July 27, 2021

FinOps is also known as cloud cost optimization. Today we discuss the importance and characteristics of managing cloud spend along with its business justifications and implications for your organization. This is the first of three posts in a series. Along…

The Importance of a Modern Cloud Platform Foundation: Part Four

July 19, 2021

As with any journey, having a good roadmap and a well-tuned vehicle make for a smoother trip. For an analytics program, the engine for success comes from a modern data platform. Today, this almost always means a cloud-based solution and…

Seven Reasons to Outsource Your Move to the Cloud

July 13, 2021

I was talking to someone the other day who asked me why they should consider outsourcing their planned VM migration to the cloud. They felt they were perfectly capable of doing it themselves. The question I asked in return was,…

The Four Stages of Analytics Maturity: Part Three

June 29, 2021

Once you’ve established your destination, it’s time to hit the road. An organization’s analytic journey typically progresses through four stages of maturity, as follows: See: Deliver insights on where the business is today and was historically. Predict: Project future scenarios…

Top Business Drivers for Analytics Programs: Part Two

June 22, 2021

Anyone who’s been on a road trip has heard this question. It usually comes from the backseat of the car, where it can be difficult to see the route ahead, and near-impossible to judge progress. For those tasked with managing…

Accelerating Your Analytics Journey: Part One

June 16, 2021

Data. According to Merriam Webster, data is “information in digital form that can be transmitted or processed.” Sounds simple. Sounds like something that’s everywhere. However, smart, influential business leaders will tell you data is important. It’s powerful. It’s a key…

Five Ways Your Machine Learning Model Is like Cookie Monster

May 18, 2021

At the highest, simplest level, a machine learning (ML) model is an algorithm that ingests data and spits out insights, predictions or recommendations. It has two important phases—first you have to train your model (training) then you let the model…

Myths of Google Workspace

May 3, 2021

At Pythian we know Google Workspace is a comprehensive suite of business productivity tools that drives enterprises to become more agile, more data driven, more collaborative, more productive and more engaged. Those already using Workspace understand the competitive edge it…

COVID-19’s Impact on Enterprise Cloud Adoption

April 26, 2021

While public cloud adoption has been growing rapidly, it’s not surprising that 2020 brought it to a new level as the global pandemic made “remote” the default for schooling, working and meetings. What’s interesting is how cloud adoption is happening….

Move Forward by Working Faster

March 18, 2021

“If you’re not moving forward, you’re falling back.” — Sam Waterston Despite – and, in some cases, because of – all the uncertainty we’ve faced recently, organizations are working hard to keep up with delivering the experiences, products and services…

Supporting Your Remote Workforce by Improving Access to Information and Ideas

March 12, 2021

“The value of an idea lies in the using of it.” — Thomas Edison Previously, many ideas were used and shared in classic “water cooler” situations – bumping into colleagues in the hall, sharing a coffee or even washing hands…

Embracing Flexibility to Improve Your Remote Team’s Performance

March 8, 2021

“Flexibility is the key to stability.” — John Wooden Hands up if you could use a little stability these days. With businesses facing so many factors beyond their control, stability can seem like an unattainable dream. We’d argue you can…

Cloud Cost Management and Optimization at Pythian: An Introduction

March 1, 2021

The shift to the cloud as “the new normal” has materially changed not just the technical, but also the financial landscape of computing. Centralized purchasing and price/volume negotiations have given way to ad hoc purchases of cloud resources throughout the…

Datascape Podcast Episode 46: Recapping Re:Invent 2020 With Apoorva

February 22, 2021

Episode 46: Show Notes The recent AWS re:Invent conference came with a barrage of updates and releases that have innovated what we can do on the cloud. Today we welcome Pythian Cloud Architect, Apoorva Wathodkar to recap our top highlights…

Datascape Podcast Episode 45: Recapping Microsoft Ignite 2020

February 18, 2021

Episode 45: Show Notes Our good friend Warner Chaves joins us again today on the show, this time to discuss some favorite updates from the Microsoft Ignite 2020 virtual conference. We start out hearing some pros and cons of the…

Pythian Achieves Managed Services Provider (MSP) Status

February 16, 2021

More than ever, Pythian is positioned to deliver value to clients using Google Cloud by leveraging our extensive managed service experience. After passing a rigorous third-party audit requiring the company to demonstrate our end-to-end customer lifecycle service delivery capabilities, Pythian…

Pythian Earns Data Management Partner Specialization

February 12, 2021

Here at Pythian, our mission is simple – we want you to love your data. To ensure our 650+ clients located around the world – spanning industries from SaaS, media and gaming, to financial services, e-commerce and more – keep…

Top Five Chrome Myths Debunked

December 17, 2020

Sometimes the best way to dispel a myth is to start with a concrete example. Here’s a great example from a client we worked with: QAD Inc. provides enterprise resource planning software and related enterprise software to manufacturing companies. By…

Migrating Oracle Workloads to Google Cloud – PostgreSQL on Cloud SQL or GCE

December 14, 2020

When working with clients on database migration, there are a range of options we help them assess and evaluate. These include: Bare Metal Solution (BMS) PostgreSQL On Cloud SQL On GCE (Google Compute Engine) Cloud Spanner Some organizations choose BMS…

More Articles >

Technical Track
Technical Track

Putting ML Prototypes Into Production Using TensorFlow Extended (TFX)

July 29, 2021

Introduction Machine learning projects start by building a proof-of-concept or a prototype. This entails choosing the right dataset (features), the appropriate ML algorithm/model and the hyper-parameters for that algorithm. As a result of a POC, we would have a trained…

What Is FinOps? Part One: A Crash Course in Cloud Cost Optimization

July 27, 2021

FinOps is also known as cloud cost optimization. Today we discuss the importance and characteristics of managing cloud spend along with its business justifications and implications for your organization. This is the first of three posts in a series. Along…

How to Use EM CLI to Verify Data Guard Configurations

July 22, 2021

EM CLI (Enterprise Manager Command Line Interface) allows users to access Enterprise Manager functionality from the operating system instead of from a browser. Why would you use EM CLI instead of a browser? It’s more efficient to execute commands from…

Data preparation with dbt and BigQuery

July 21, 2021

Raw incoming data needs to go through a series of data preparation steps before it can be used for analysis. These steps include tasks such as type casting, renaming columns, cleaning values and identifying duplicates. Writing code to perform these…

SYSQL: SysAdmin Query Language

July 20, 2021

Learn how to use Linux command line tools to perform data analysis on trace and log files.

The Importance of a Modern Cloud Platform Foundation: Part Four

July 19, 2021

As with any journey, having a good roadmap and a well-tuned vehicle make for a smoother trip. For an analytics program, the engine for success comes from a modern data platform. Today, this almost always means a cloud-based solution and…

Two Cases of Troubleshooting with psn

July 16, 2021

No, it’s not the PlayStation Network! Linux Process Snapper — pSnapper, or psn — is an open source tool written by Tanel Poder. Tanel provides a number of great examples on how to use psn and even a few videos…

Understanding the Implications of Creating a New PDB Using CREATE_FILE_DEST

July 15, 2021

Overview When creating a new pluggable database, or PDB, you can optionally include the CREATE_FILE_DEST clause. Here’s an example: create pluggable database PDB1 admin user admin identified by “************” create_file_dest = ‘+DATA_DG’;   The value provided can be an ASM…

Seven Reasons to Outsource Your Move to the Cloud

July 13, 2021

I was talking to someone the other day who asked me why they should consider outsourcing their planned VM migration to the cloud. They felt they were perfectly capable of doing it themselves. The question I asked in return was,…

Snowflake System Function Error: Argument 0 to Function SYSTEM$PIPE_STATUS Needs to Be Constant

July 8, 2021

I recently encountered the above issue which prompted me to write this blog post so I can easily reference the solution whenever I need it. However, I also hope it might help anyone out there who hits a similar issue….

Mitigating the Problems Created by Tombstones

July 2, 2021

Got too many tombstones? This blog post will talk about how to deal with tombstones once you already have them. For more information about tombstones, check out this post: Examining the Lifecycle of Tombstones in Apache Cassandra. Verifying the presence…

The Four Stages of Analytics Maturity: Part Three

June 29, 2021

Once you’ve established your destination, it’s time to hit the road. An organization’s analytic journey typically progresses through four stages of maturity, as follows: See: Deliver insights on where the business is today and was historically. Predict: Project future scenarios…

Bugs with iscsi-initiator-utils*-6.2.0.878-5

June 24, 2021

This is a quick post for anyone experiencing iSCSI (Internet Small Computer Systems Interface) target login issues on Linux 8. Symptoms include: 1. Upon machine start, iSCSI node target logon does not succeed automatically during the boot process. (This was…

Top Business Drivers for Analytics Programs: Part Two

June 22, 2021

Anyone who’s been on a road trip has heard this question. It usually comes from the backseat of the car, where it can be difficult to see the route ahead, and near-impossible to judge progress. For those tasked with managing…

How to Perform (UDC) User-Defined Compactions in Cassandra

June 18, 2021

User-defined compactions allow us to manually select which files should be compacted. This enables us to reclaim space and limit the size of compaction so it can fit into the remaining space. These compactions are relevant only for SizeTieredCompactionStrategy (STCS)…

Accelerating Your Analytics Journey: Part One

June 16, 2021

Data. According to Merriam Webster, data is “information in digital form that can be transmitted or processed.” Sounds simple. Sounds like something that’s everywhere. However, smart, influential business leaders will tell you data is important. It’s powerful. It’s a key…

Let’s Deal with High Read Latencies in Cassandra

June 10, 2021

High latency values may indicate a cluster at the edge of its processing capacity, issues with the data model—such as poor choice of partition key or high levels of tombstones—or issues with the underlying infrastructure. Below are some major reasons…

Consuming Tweets Using Apache Beam on Dataflow

June 9, 2021

Apache Beam is an SDK (software development kit) available for Java, Python, and Go that allows for a streamlined ETL programming experience for both batch and streaming jobs. It’s the SDK that GCP Dataflow jobs use and it comes with…

Pythian’s New Single Sign-on (SSO) Solution for Oracle E-Business Suite (EBS)—Part One

May 26, 2021

Our mission at Pythian is to help you Love Your Data. Because security is a crucial part of managing your data, we’re pleased to tell you about the identity management (IdM) solution we’ve developed to make it easier for Oracle…

Archive Read-Only Data from RDS SQL Server to Partitioned S3 Buckets

May 25, 2021

Overview Here’s a scenario we’ve seen in many businesses; your SQL Server database has grown to the point that performance has degraded significantly, and your business no longer meets the intended RTO (recovery time objective). In this case, your database…

More Articles >

Pythian Life
Pythian Life

The Pythian Talent Community

April 23, 2021

Welcome to our round up of everything new and exciting going on at Pythian! This blog post series highlights what #PythianLife is all about, from how we’re keeping our culture alive remotely to exciting new projects we’ve been working on,…

Pythian Named a 2021 Top Employer in the National Capital Region

April 16, 2021

At Pythian we recognize that to help you Love Your Data, it’s important for our employees to love what they do. That’s why we’re so gratified to be one of the 2021 winners of the National Capital Region’s Top Employers…

Top TV and Movie Picks from the Women of Pythian

March 19, 2021

At Pythian we’re known for, and proud of, our diverse group of strong women employees. One of the ways the company shares and celebrates the experiences of the women who work for Pythian is through our Pythia Slack channel. Topics…

Pythian Postcards: Fraijanes, Guatemala

March 2, 2021

Editor’s Note: Welcome to the most recent post in our “Pythian Postcards” series! We’ve visited employees around the world, including Toulouse, France and Singapore. Today, we’re very pleased to have a post from Jose Solares who’s going to help us…

Pythian Postcards: Markham, Ontario

January 22, 2021

Editor’s Note: Welcome to the fourth post in our “Pythian Postcards” series! So far we’ve visited Toulouse, France, Singapore and met Mayuri Lalwani who had recently moved from India to Mississauga, Ontario. Today, we’re so happy to have a post…

Pythian Postcards: Mississauga, Ontario … by Way of India

December 4, 2020

Editor’s Note: Welcome to the third post in our “Pythian Postcards” series! So far we’ve visited Toulouse, France and Singapore. Today, Mayuri Lalwani takes us to her new home of Mississauga, Ontario: Q: Where are you located? A: Currently in Mississauga,…

Pythian Postcards: Selamat Datang Ke Singapore!

November 4, 2020

Editor’s Note: Welcome to the second post in our “Pythian Postcards” series! Post one came to us from Toulouse, France. Today, Pio Balistoy takes us to Singapore: I usually stick to SQL Server when writing for the Pythian blog because…

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 COVID-19, business is no longer as usual. Recently I have had a few contacts ask me for tips on how to work remotely. Why? Well, I have been working from home for ten years now. Working remotely is just…

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…

More Articles >