Business Insights
Business Insights

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…

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

April 9, 2019

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…

Pythian is at COLLABORATE 19 – Join us in San Antonio!

April 4, 2019

COLLABORATE is the largest independently run Oracle conference in the world and as always, Pythian will be there in full force with several of our Oracle experts speaking on topics ranging from Oracle to open-source to cloud and more. This…

How Pythian helped a company migrate 1,100 websites to GCP in just 30 days

April 2, 2019

When VerticalScope, a Canadian digital media and entertainment firm, wanted to automate the cloud migration of their digital assets and inventory, they came to Pythian for help with accelerating the process. VerticalScope operates a large number of high-traffic websites and…

Pythian is loud and proud at Google Cloud Next ’19

April 1, 2019

I’ve just celebrated my 9th anniversary at Pythian. Wow, have we ever grown from the 65-person Oracle database-focused company we were in 2010.  Today, we have significantly elevated conversations with clients to be much more transformative and strategic, over and…

Workload migration: Staying calm when it’s more than just lift and shift

March 12, 2019

To no one’s surprise, the world’s migration to the cloud is continuing to ramp up in both speed and volume. According to forecasts from Gartner, the worldwide public cloud services market will grow by 17.3% this year. Revenues are expected to total…

How to get more from marketing data with a marketing data platform on Google cloud platform – Part 1

March 7, 2019

The power behind today’s most successful online marketing programs is the sheer abundance of data available to drive strategy, engagement and activation. But before you can use that bounty of insight to segment, target and engage prospects, as well as…

Kubernetes: the easy button for enterprise

March 5, 2019

Krista Colby-Wheatley explains why Kubernetes has recently become the dominant player in the deployment, scaling and management of applications.

Dismantling data silos through cloud integration

February 23, 2019

This is the fourth in a series of four posts on data integration and its importance for organizations. In this fourth and final post, we look at how to finally solve the data silo problem. Throughout the first three parts…

More Articles >

Technical Track
Technical Track

Examining distributed training of Keras Models

May 23, 2019

Creating deep learning models with Keras is pretty straightforward so it is often used for prototyping and creating proof-of-concept products. But when it comes to using it for training bigger models, or ones with very big datasets, we need to…

Exposing MyRocks internals via system variables: Part 5, Data Reads

May 21, 2019

In this blog post, we continue on our series of exploring MyRocks mechanics by looking at the configurable server variables and column family options. In our last post, I explained at a high level how compression and bloom filtering are…

Troubleshooting failed database startup after GRID Out Of Place (OOP) rollback

May 16, 2019

GRID Out Of Place (OOP) patching completed successfully for 18.6.0.0.0. GRID_HOME=/u01/18.3.0.0/grid_2 ORACLE_HOME=/u01/app/oracle/12.1.0.1/db1 Here is an example of the inventory after patching. Run cluvfy was successful, too. GRID OOP Rollback Patching completed successfully for node1. GRID OOP Rollback Patching completed successfully…

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…

Exposing MyRocks Internals via system variables: Part 4, compression and bloom filters

May 14, 2019

In this blog post, we continue on our series of exploring MyRocks mechanics by looking at the configurable server variables and column family options. In our last post, I explained at a high level how data moves from its initial…

How to remove grid 12.2 after an 18c upgrade

May 13, 2019

The environment started with a GRID 12.1.0.1 installation, upgraded to 18.3.0.0, and performed out-of-place patching (OOP) to 18.6.0.0. As a result, there are three GRID homes and, ideally, we should remove 12.1.0.1 to save space because it’s longer required. This…

Five ways to migrate your on-premises SQL database to Azure

May 9, 2019

There are currently three deployment options for SQL Server Database on the cloud. Well, four, if you count Azure SQL Databases in elastic pool. But Azure SQL DB in elastic pool is essentially just Azure SQL Databases grouped into an…

How to use mount-dbfs.sh to resolve “Device or resource busy”

May 8, 2019

I was not satisfied with using fuser -mv to identify processes causing DBFS failure to unmount and killing the processes haphazardly. Upon further investigation, mount-dbfs.sh can be used to kill processes causing “Device or resource busy” and unmount DBFS. One…

Exposing MyRocks Internals Via System Variables: Part 3, Compaction

May 7, 2019

In this blog post, we continue our series of exploring MyRocks mechanics by looking at the configurable server variables and column family options. In our last post, I explained at a high level how data moves from immutable memtables to…

How to fix SQL backup to URL error: The remote server returned an error: (400) bad request

May 6, 2019

Problem: You are trying to take a native SQL Backup to URL and you receive the error below: Msg 3271, Level 16, State 1, Line 1 A nonrecoverable I/O error occurred on file “https://MyStorageAccount.file.core.windows.net/MyContainer/Adventureworks_full_20190420.bak:” Backup to URL received an exception…

How to run DBSAT against Oracle RDS database

May 2, 2019

The scope of this article is to show how to run DBSAT (Oracle Database Security Assessment Tool) against an Amazon RDS Oracle instance. This is based on a real-life execution. The DBSAT version used was 2.0.2 over an RDS database…

Harnessing the power of Jinja2 with Ansible

May 2, 2019

Configuration files management is the core component of every configuration management tool. Templates are one of the best methods for creating configuration files as they allow dynamic variables. Ansible has a template module that uses Jinja2 in its core. Jinja2…

A simple command that saved me

May 1, 2019

So there I was, reviewing the environment to create an action plan for patching. To my surprise, I noticed the following when checking DBFS: I will demonstrate the simple command I used to ensure that all services that are supposed…

How to run DBSAT on RAC Instances

May 1, 2019

The scope of this article is to provide a brief summary of how to run Oracle Database Security Assessment Tool (DBSAT) on Oracle Real Application Cluster using the parameters to exclude sections on the Reporter to avoid duplicated information into…

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…

Exposing MyRocks Internals via system variables: Part 2, Initial data flushing

April 30, 2019

In this blog post, we continue on our series of exploring MyRocks mechanics by looking at configurable server variables and column family options. In our last post, I explained at a high level how data first entered memory space and…

How to fix SQL backup to URL failure – operating system error 50

April 29, 2019

Problem: You run an SQL backup to URL and get the following error: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device ‘https://<mystorageaccountname>.blob.core.windows.net/<mycontainername>/AdventureWorks_full_20190420.bak’. Operating system error 50(The request is not supported.). Msg 3013, Level 16, State 1,…

How to fix the status of of the Oracle GI CRS after a failed upgrade

April 29, 2019

A couple of weeks ago I was working on a two-node Oracle Grid Infrastructure upgrade from 12.1 to 18.5. Everything was going great as both rootupgrade.sh scripts ran correctly, so the only thing pending to run was the gridSetup.sh -executeConfigTools …

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…

How to troubleshoot a failure to mount DBFS

April 24, 2019

Stop a CRS error with [Stop of ‘ora.crsd’ on ‘host02’ failed.].  I will demonstrate my attempts to troubleshoot and identify the cause for failure. # crsctl stop crs DBFS is registered and managed by CRS: $ $GRID_HOME/bin/crsctl stat res -w…

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 >