Business Insights
Business Insights

Making a business case for Machine Learning

August 13, 2019

The first step to kick off a Machine Learning (ML) project is to have a written proposition for the business problem, and second, to frame the ML problem. Before even discussing an ML method, it is necessary first to understand…

Comparing Data Science at an AI Startup and a Consulting Company

August 6, 2019

The difference between data science consultants and a data science team at a company depending on machine learning (ML) solutions is significant. In the first instance, the consultants need to have a good understanding of both the business and technology….

Datascape Podcast Episode 35 – Google Cloud Bigtable with Sandy Ghai

July 29, 2019

Today on the Datascape Podcast we are joined by Sandy Ghai, who is the Product Manager for Google Cloud Bigtable. Sandy is here to discuss her work and the ever-changing world of the cloud and why it is so exciting….

Low hanging fruit items that alleviate DataOps operational pressures

July 22, 2019

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

Datascape Podcast Ep 34 – Recapping Microsoft Build 2019 with Warner Chaves

June 20, 2019

Today on the Datascape Podcast we are joined by Warner Chaves to discuss the most exciting announcements from the recent Microsoft Build 2019 Conference! We run through a host of different products and services with Warner, hand-picking the most most…

Australian Red Cross gains speed, stability, and savings by optimizing cloud platforms

June 11, 2019

When the Australian Red Cross, a leading humanitarian aid and community services charity and an auxiliary to the Australian government, realized that their data platform was no longer performing optimally for their critical applications, they turned to Pythian for help….

Hadoop to the cloud: Is it time to make the move?

June 5, 2019

When Hadoop was introduced, it promised a faster time to insight because of simpler modeling using cheaper hardware. But over time, organizations have been finding that Hadoop’s complexity and need for specialized skills are adding cost and headaches. Now instead…

Gaming company benefits from increased responsiveness with help from Pythian’s Google BigQuery experts

May 28, 2019

When Skillz, a leading mobile eSports platform connecting 2.6 billion gamers across the globe, sought Pythian’s help with reducing storage costs, they learned they could not only reduce costs but also gain a more responsive application while providing an improved…

Pythian will be at Percona Live 2019 – Join us in Austin, Texas!

May 15, 2019

Percona Live provides the open source database community with an opportunity to discover and discuss the latest open source trends, technologies, and innovations. The conference includes the best and brightest innovators and influencers in the open source database industry. This…

Big mining gets a boost from big data

May 14, 2019

What do you do when the breakdown of a single vehicle could cost you a million dollars? Easy: you avoid breakdowns at all costs. That’s exactly what Canada’s largest mining company is doing through a Google Cloud Platform artificial intelligence…

Personal finance company develops secure data sharing with assistance from Pythian’s experts

May 7, 2019

A large personal finance company benefitted from Pythian’s expertise to help them share data securely and keep customer information safe. Pythian provided Google BigQuery expertise and developed innovative solutions to ensure secure multi-tenancy access to their data. The finance company…

Unleash the power of your data with Pythian at DBTA Data Summit 2019

April 30, 2019

Pythian is the Diamond Research and Keynote Sponsor at Data Summit 2019 in Boston on May 21 to 22. See you there! The theme of this year’s DBTA Data Summit is “unleashing the power of your data” – exactly what…

Online retailer gains business efficiencies with help from pythian’s cloud experts

April 25, 2019

A major online retailer joined forces with Pythian to help improve their efficiency delivering new service features. With the help of Pythian’s Cloud Consulting Services, the retailer determined that they needed to migrate their two large on-premises data centers to…

3 key data analytics announcements from Google NEXT 2019

April 25, 2019

Google NEXT 2019 was a momentous event for the Pythian team. We celebrated winning the Google Cloud Global Data Analytics Partner of the Year award, had a chance to meet with customers and Googlers, and had many conversations about the…

Is application refactoring right for your organization?

April 17, 2019

The following is the first in a series of blog posts covering Pythian’s Application Migration webinar series, where host Chris Presley discusses several application migration-related topics. Recently, he spoke with Alex Zadoroshnyi and Pierig Le Saux about the topic of…

Reduce costs by adding a data lake to your cloud data warehouse

April 17, 2019

By Lynda Partner, VP Analytics as a Service and Danil Zburivsky, Director of Engineering When it comes to data warehouse modernization, we’re big fans of moving to the cloud.  The cloud brings unprecedented flexibility that allows you to easily accommodate…

Top big data analytics trends hold true well into 2019

April 16, 2019

The overall importance of data and information within organizations has continued to grow. We’ve also seen the continued rise of megatrends like IoT, big data – even too much data – and of course, machine learning. That’s along with the…

Anthos Is the future of cloud transformation

April 11, 2019

This blog post is co -authored by Alex Zadorozhniy – DevOps Technical Director and Bill Fraser – Principal Consultant in Customer Service Delivery at Pythian. On Tuesday, Google announced the general availability of Anthos, a re-branding of its Cloud Services Platform,…

Pythian Wins 2018 Google Cloud Data analytics partner of the year award

April 9, 2019

Google Cloud Recognizes Pythian’s Technical Proficiency and Proven Success In Data Analytics Pythian announced that it has received the 2018 Google Cloud Global Data Analytics Partner of the Year award. This award was presented at the Partner Summit at Google…

How AEG Presents uses data to boost client engagement for Coachella and other events

April 9, 2019

AEG Presents is a seasoned veteran when it comes to staging high-profile concerts with first-class artists and venues like Coachella and the New Orleans Jazz Festival. But the organization recently realized it had a problem getting the most out of…

More Articles >

Technical Track
Technical Track

How to deploy machine learning on Google Cloud Platform

August 15, 2019

In this blog post, I will describe a few takeaways on how to deploy or submit Machine Learning (ML) tasks on Google Cloud Platform (GCP). If you have less experience as a ML engineer or if you are a solution…

How to solve SELinux and MySQL log rotation issue

August 14, 2019

Disable SELinux? Think again! SELinux is always a complicated topic. If you search this on the web, most people will advise just disabling it, but that may not be acceptable from a security point of view in your organization. In…

Testing the 19c Grid Infrastructure by Performing a Dry-Run Upgrade

August 14, 2019

In reviewing Grid Infrastructure Installation and Upgrade Guide for Linux, I discovered the dry-run upgrade mode to test upgrades. With dry-run being a new feature, I tested it first using GUI. From the response file above grid_2019-08-06_00-20-31AM.rsp, create dryRunForUpgradegrid.rsp: Create…

Making a business case for Machine Learning

August 13, 2019

The first step to kick off a Machine Learning (ML) project is to have a written proposition for the business problem, and second, to frame the ML problem. Before even discussing an ML method, it is necessary first to understand…

Why it’s Good Practice To Run datapatch -prereq After Creating Database

August 13, 2019

Starting with 12c, running datapatch may be required after creating a database, depending on the database version and method for creating the database. Instead of having to remember all the variations, it’s much simpler just to run datapatch -prereq after creating…

An overview of best practices for implementing ML systems – Part 1

August 12, 2019

In this series of blog posts, we will recommend some best practices identified from our own failures and successes throughout our time implementing machine learning (ML) systems. We won’t discuss ML techniques here, but instead, provide an upper-level overview of…

How to delete an RAC Database Using DBCA silent mode

August 12, 2019

I was recently working on a Proof Of Concept to migrate RAC non-CDB to CDB. I faced multiple issues and wanted to start fresh. In order to do this, I needed to delete the newly RAC CDB database. Review database…

How to Implement Airflow Best Practices from a Data Scientist’s perspective – Part 1

August 8, 2019

This blog post is a compilation of suggestions for best practices drawn from my personal experience as a data scientist building Airflow DAGs and installing and maintaining Airflow. Let’s begin by explaining what Airflow is and what it is not….

How to Prevent Linux 7 Housekeeping from Breaking Oracle

August 8, 2019

Linux 7 introduced multiple changes and enhancements to the kernel. Among them was automated housekeeping for temporary files. In version 6, tmpwatch is available to manage unused files in temp directories. It can be scheduled via cron to automatically keep…

Comparing Pgpool-II and PgBouncer

August 7, 2019

While I was in the process of determining different HA solutions for PostgreSQL, Pgpool and PgBouncer both came into the equation on multiple occasions.  So I decided to evaluate them and determine what kind of performance they could handle.  I…

How to Find Cluster Resources Where Target!=State

August 7, 2019

DBA typically checks cluster resources as part of patching efforts. However, when checking cluster resources returns 200+ results, it’s not feasible to verify the results and it’s too time-consuming. A better solution is to find a cluster resource where the…

Comparing Data Science at an AI Startup and a Consulting Company

August 6, 2019

The difference between data science consultants and a data science team at a company depending on machine learning (ML) solutions is significant. In the first instance, the consultants need to have a good understanding of both the business and technology….

How To Resize Oracle ACFS Volume

July 31, 2019

There may be many reasons as to why Oracle ACFS volume would need to be resized. Current Filesystem for ACFS is 299G. Free_MB is 872 which causes paging due to insufficient FREE space from ASM Disk Group ACFS_DATA. Option 1…

Three Cs to secure against leaks like Capital One

July 30, 2019

It was revealed today that about 100 Million records were leaked from Capital One and because the press has published court documents pertaining to this case, at least some details are known. According to that, data was stored in cloud…

How to Set Up REPMGR with WITNESS for PostgreSQL 10

July 30, 2019

This blog post will go over how to set up and implement repmgr which is the PostgreSQL application to manage replication between primary and replica nodes, allowing for quick and easy failover and rebuilding of replicas. For reference, all commands…

Datascape Podcast Episode 35 – Google Cloud Bigtable with Sandy Ghai

July 29, 2019

Today on the Datascape Podcast we are joined by Sandy Ghai, who is the Product Manager for Google Cloud Bigtable. Sandy is here to discuss her work and the ever-changing world of the cloud and why it is so exciting….

Addressing common challenges when scaling out MySQL horizontally

July 29, 2019

When we explore strategies to scale our MySQL-based database layer, we realize that there are many different options. As opposed to proprietary solutions, open-source products nourish themselves from their communities and novel architectures or enhanced versions are generated, often incorporating…

Inspiration and Announcements from Microsoft Inspire 2019

July 25, 2019

Thousands of Microsoft partners and employees filled T-Mobile Arena in Las Vegas on July 15 for the kick-off of Microsoft’s three-day partner event, Microsoft Inspire. Microsoft executives shared their thoughts on the tremendous growth opportunities of the continued digital transformation,…

Using rsync to Copy GoldenGate Trails from DBFS to ACFS

July 25, 2019

I am currently working on project to migrate GoldenGate trail from Oracle Database File System (DBFS) to Oracle Automatic Storage Management Cluster File System (ACFS). The migration is performed in two phases. This is the first phase, in which I create…

How to Test MySQL Server Hostname with ProxySQL Multiplexing

July 24, 2019

Overview While working on a MySQL Galera cluster with ProxySQL, I was in the process of testing traffic going to the MySQL nodes by using the @@hostname command to ensure which MySQL host behind the proxy the query ran on….

More Articles >

Pythian Life
Pythian Life

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…

My internship experience at Pythian

September 28, 2017

I remember nervously walking out of one of King’s Cross St Pancras Station’s numerous exits searching for the 7 Stanley Building. I wandered through the morning rush in the heart of London, and I was overwhelmed, out of place and…

Pythian at All Things Open 2017

September 25, 2017

All Things Open 2017 is coming up fast, and Pythian is proud to be supporting one of the largest open source-focused conferences in the US! All Things Open is a conference in Raleigh, North Carolina on October 23-24, 2017. ATO…

Has “Google-ing it” gotten better over time?

August 14, 2017

Just Thinking… Have you noticed the subtle shift in how we search for information on the Internet…? In the past when I wanted to find something, I would start a web browser (before Tabs came along) and go to….

How to hold a great team meeting with remote employees

July 21, 2017

I want to talk about something that I initially did very poorly when I first became a remote manager in hopes you can learn from my mistakes – Team Meetings. When I started having my first team meetings as a…

My co-op experience at Pythian

May 17, 2017

I returned to Pythian for my co-op term this past winter (it’s worth mentioning that previous to this, I had already completed two four month terms as a Software Development Intern at the company). The fact that I came back…

Join CEO Paul Vallée and top data experts at Pythian’s love your data conference in NYC

May 3, 2017

Every year, leaders from every industry are presented with a buffet of conference opportunities to choose from. The pull to attend the biggest and shiniest is strong as event organizers lure potential attendees with swag bags, explosive branding and the…

More Articles >