Business Insights
Business Insights

Top big data analytics trends hold true as we look toward 2020

October 4, 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…

How the England and Wales Cricket Board scored with big data

October 1, 2019

The England and Wales Cricket Board governs every aspect of the sport in those two countries, and it holds massive amounts of data generated by professional and amateur players alike. Since its founding in 1997, the ECB has collected information…

How to migrate from Teradata to Google BigQuery

September 30, 2019

Google BigQuery is a serverless, highly scalable, low-cost enterprise data warehouse that helps data analysts become more productive. It enables extremely fast analytics on a petabyte scale. And its pay-as-you-go model makes it attractive for organizations looking to move away…

Join Pythian for Percona Live Europe 2019 Amsterdam

September 23, 2019

Percona Live is always a great opportunity to learn from the best and brightest in the open-source database community. This time, Percona Live Europe is being held at the Hilton Amsterdam Airport Schiphol, The Netherlands from September 30 to October…

Can you run Hadoop in the cloud?

September 17, 2019

As a solutions architect at Pythian, I often get questions from clients about the many solutions available to them to address their big data needs. Between Hadoop, cloud-based, and hybrid solutions, finding the best option for their unique needs can…

The top 8 things every database practitioner should know

September 5, 2019

I’ve been interviewing and mentoring candidates for technical database positions for almost ten years, and a common question from those who either don’t make it or feel they’re not ready yet to apply to the position they’re looking for is:…

Report: Data Warehouses Are Heading To The Cloud

September 4, 2019

Unisphere Research Report uncovers the trends that are driving analytics workloads to the cloud, including real-time analytics and machine learning.   Data strategies are now commonplace, machine learning adoption has doubled in a year, and data warehouses are still a go-to…

Pythian migrates company’s global assets to GCP without downtime

August 21, 2019

Many businesses migrate to the cloud to take advantage of cost savings and improved agility. Optiva, a Canada-based company that develops software for communications service providers, recently migrated to Google Cloud Platform (GCP) with help from Pythian’s team of experts. Since…

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…

More Articles >

Technical Track
Technical Track

Creating secure access architecture on Google Cloud Platform (and building it with Terraform)

October 17, 2019

Often we get involved in projects where there are all sorts of stringent security requirements. In this post, I will share a few of the methods used to meet these security requirements within Google Cloud Platform (GCP), while still allowing…

Troubleshooting Oracle Cloud Infrastructure Automatic Backups

October 16, 2019

I could start this blog the same way I started this one because everything is supposed to be easy and at a 1 click distance in any cloud, so it should be the same for the database backups in Oracle…

Exadata Smart Scan: A Quick Overview

October 15, 2019

I decided to write about Exadata Smart Scan feature for this blog post. Why Smart Scan? Well, because it is awesome and I don’t know any other relational database system that has this feature. So what is Smart Scan and…

Using MDBUtil To Create Grid Infrastructure Management Repository Database

October 7, 2019

Whether Grid Infrastructure Management Repository (GIMR) database MGMTDB is required or not depends on the version of Oracle you are using. For 19c, GIMR is not required –  About the Grid Infrastructure Management Repository However, GIMR is being created to…

Top big data analytics trends hold true as we look toward 2020

October 4, 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…

How to manage Oracle Flashback Log size

October 3, 2019

Here we will learn how to manage the size of flashback logs generated in our environment. This is useful especially when you are hitting the error “ORA-00242: maximum allowed filename records used up in control file” which can be related…

How to migrate from Teradata to Google BigQuery

September 30, 2019

Google BigQuery is a serverless, highly scalable, low-cost enterprise data warehouse that helps data analysts become more productive. It enables extremely fast analytics on a petabyte scale. And its pay-as-you-go model makes it attractive for organizations looking to move away…

How to work around OMS 12.1.0.3 error: Metric evaluation error start – Get dynamic property error

September 30, 2019

Have you received this error on OMS 12.1.0.3? “Metric evaluation error start – Get dynamic property error,” After performing some research on MOS and a confirmation SR, it seems related to Bug 17575631 CLUSTER DB HOME PAGE ERRORS- REGIONS FETCH…

ProxySQL Configuration File & Startup Process Explained

September 26, 2019

When learning ProxySQL, we have seen some confusion around the configuration and especially around the usage of the configuration file. In this post, we will explain how ProxySQL treats its internal configuration and its configuration file. The proxysql.cnf For the…

How to Reduce Exadata Core Count

September 25, 2019

During preparation for a client’s datacenter migration, we decided to move services one-by-one to the datacenter / hardware in order to keep the scope of changes controlled. To accomplish this, we also needed to resize the CPU count of Exadata…

Working with Ansible, PostgreSQL and Docker

September 24, 2019

While working on creating some of our internal training labs for PostgreSQL, I have had the pleasure of working with PostreSQL in Docker and working with it in different ways.  One of the most important ways that I worked with…

Join Pythian for Percona Live Europe 2019 Amsterdam

September 23, 2019

Percona Live is always a great opportunity to learn from the best and brightest in the open-source database community. This time, Percona Live Europe is being held at the Hilton Amsterdam Airport Schiphol, The Netherlands from September 30 to October…

Stop Migrating Databases to 12c!

September 19, 2019

If you are starting an upgrade plan, do it directly to Oracle Database 19c. Why? Well, let’s agree that 19c is “equivalent” to 12.2.0.3 on previous version models, and 18c would be 12.2.0.2, after the latest in the old format:…

Three Announcements from Oracle OpenWorld You Probably Didn’t Hear

September 18, 2019

The buzz from OpenWorld this year was the permanently free Oracle Cloud offering, the new Exadata X8M (reportedly capable of 12 million I/O per second!), Oracle Autonomous Cloud at Customer, and the new Blockchain table. Here are three interesting or…

Can you run Hadoop in the cloud?

September 17, 2019

As a solutions architect at Pythian, I often get questions from clients about the many solutions available to them to address their big data needs. Between Hadoop, cloud-based, and hybrid solutions, finding the best option for their unique needs can…

How to Fix: The Selected Subscriber does not satisfy the minimum version compatibility

September 16, 2019

Problem: You are trying to add a new subscriber to a SQL Server Publication using the SQL Server Management Studio and you receive an error similar to the one below: “The selected Subscriber does not satisfy the minimum version compatibility…

Exadata: 7 Useful Commands to check Port/Sensor Alarms

September 12, 2019

Some days ago I was checking for the alarm below, with a very generic message: Message=The aggregate sensor /SYS/CABLE_CONN_STAT has a fault. So, I decided to document some useful commands I used to verify all ports/sensors in my Exadata cluster….

Minimal Networking Knowledge Recommended for DBAs

September 11, 2019

In a recent post, I summarized what I consider to be the minimal topics one should be familiar with in order to do technical work with databases.  One thing I left out, except for it being implicitly included in “Hardware…

Pythian sponsors first Google DevFest Montreal 2019

September 10, 2019

Pythian would like to announce Diamond sponsorship of the first cloud and machine learning (ML) DevFest in Montreal, September 27th, at École de Technologie Supérieure (ÉTS). More details can be found on the website: https://devfest.cloud-montreal.ca/. DevFests are large-scale community-driven events…

What to expect at ProxySQL Technology Day in Ghent

September 9, 2019

On October 3rd ProxySQL will have it’s very first technology day. They have chosen the lovely city of Ghent, Belgium, my home town, as the place to be. For those attending Percona Live Europe in Amsterdam, this is a great…

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 www.google.co.nz….

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 >