Business Insights
Business Insights

Infographic: Five ways to make analytics for everyone

April 17, 2018

It’s not a stretch to say that data is taking over the world. You can see the signs everywhere, from news stories highlighting the breathtaking pace of data creation—projected to hit 163 zettabytes per day by 2025—to the ongoing and…

Why your data hub belongs in the cloud

April 10, 2018

Whether your core infrastructure is on-prem or in the cloud, there’s only one choice for your data hub
The public cloud effectively provides you with three options:  Infrastructure as a Service, Platform as a Service or Software as a Service. And with IaaS, people often face the choice of “rent vs buy”.

Cloudscape Episode 3: March 2018 roundup of the key AWS, GCP and Azure Updates

April 9, 2018

Welcome back to the Cloudscape Podcast. Today on the show we are once again joined by our panel of experts, Greg Baker who is representing Amazon Web Services, John Laham representing Google Cloud Platform, and Warner Chaves representing Microsoft Azure….

Datascape Podcast Episode 23 – Private vs. Public Blockchains

April 8, 2018

On today’s show, we welcome Adam Muise to chat with us about the ins and outs of the private and public blockchain. This is a somewhat intermediate discussion and is not an introduction to the blockchain or cryptocurrency, so if…

What is the Role of Configuration Management in the World of Immutable infrastructure and Serverless Architectures?

March 28, 2018

On March 20th, we spoke with industry experts Greg Baker and Ryan Bezdicek to discuss this topic and others relating to configuration management. There is an argument that configuration management is on its way out now—that we’re ready to usher…

Pythian creates a seamless “pipeline” between Google and AWS

March 14, 2018

Using machine learning, a software engineering company developed a solution on behalf of a global agriculture biotechnology firm. The accelerated process was able to analyze and derive insight from massive volumes of data. The app was developed to enable farmers…

Is configuration management still relevant?

March 14, 2018

What is the role of configuration management in the world of immutable infrastructure and serverless architectures? Configuration management has come a long way and there are several mature solutions available. Everyone who chooses a configuration management tool needs to decide,…

No DR is the Worst DR!

March 8, 2018

What does a disaster recovery strategy mean to you? Disaster recovery (DR) is defined as a subset of business continuity and involves a set of policies, tools and procedures to enable the recovery or continuation of vital technology infrastructure and systems following a…

Five ways to build a data-driven culture within your organization

March 7, 2018

In this post guest blogger Jim Donnelly introduces some of the concepts in our latest eBook, Analytics for Everyone, discussing what it takes to drive a data-first culture across your organization. Imagine that it’s been about a year since you…

Disaster Recovery in the Cloud, Are you ready? Join us for a live CrowdChat.

February 26, 2018

Disaster recovery (DR) is defined as a subset of business continuity and involves a set of policies, tools and procedures to enable the recovery or continuation of vital technology infrastructure and systems following a natural or human-induced disaster. Does your business have a…

Is blockchain a good fit for your business?

February 22, 2018

While there may be a lot of hype around blockchain, the technology is here to stay, and it’s already delivering value. In fact, the global blockchain technology market is predicted to grow to 2.3 billion U.S. dollars by 2021, according…

Questions to ask when migrating to a new database platform

February 20, 2018

As systems come online and new technologies are made available, companies are faced with a decision point: Should we fragment our existing technology stack to attempt to take advantage of these new tools, or continue with our current environment at…

How businesses are using blockchain today

February 13, 2018

Despite the hype surrounding the fluctuating prices of cryptocurrencies, their underlying technology, blockchain, is driving innovation and generating real value. According to an article published today in Forbes, there are nine blockchain startups on the Forbes Fintech 50 list for…

Cloudscape Podcast – Episode 1: Cloud Vendor News and Updates for January 2018

February 8, 2018

Welcome to the first episode of the Cloudscape Podcast. In this series we will be looking at the most current developments in the public cloud sphere and bringing you all the information from an array of industry experts. On today’s…

Advanced Analytics from Pythian Improves CrowdTwist’s Loyalty Program Outcomes

February 6, 2018

CrowdTwist provides a SaaS based omni-channel loyalty and analytics platform that is designed to allow marketers to acquire, engage and retain customers. They power the most innovative and engaging loyalty programs in the market today. The platform is used internationally…

A Google Cloud Platform in Montreal is good for all of Canada

February 1, 2018

The opening of the new Google Cloud Platform (GCP) region in Montreal is huge for Canada. Being closer to the cloud will give Canadian businesses powerful performance gains. But more importantly, it will also give our country a strategic foundation…

You might already own the last car you’ll ever buy

January 26, 2018

Chris Presley host of the datascape podcast discusses Tony Seba’s predictions of the immanent disruption of the auto, oil and gas industries.

Is the data warehouse dead?

January 22, 2018

Whether or not the data warehouse is dying or just in need of a major overhaul is a matter of opinion. But what we do know is that traditional data warehouses are challenged to deliver on new and emerging technology…

Choosing a data warehousing solution in the cloud

January 18, 2018

Your cloud data warehouse options from Google Cloud Platform, Microsoft Azure and Amazon Web Services When it comes to big data and analytics, more companies are heading to the cloud. In fact, according to a recent Forbes article 10 Predictions…

An update to “Autonomous RVs Will Disrupt The Airline Business”

January 18, 2018

I wanted to post an update to my article Autonomous RVs Will Disrupt The Airline Business. I need to give credit to a discussion with my father where we were discussing the points I’d made. I got something wrong in…

More Articles >

Technical Track
Technical Track

Restore a table / database from full backup – Yet another way

April 20, 2018

Restore requests are common and so are the restores of specific entities: a database, or one or more table(s). This has been discussed a lot and we have plenty of tools and solutions already available. In this blog post we…

Oracle Parallel Query Hints – Part 3: PX_JOIN_FILTER

April 19, 2018

In part one of this series on Oracle Parallel Query Hints, I looked at PQ_DISTRIBUTE, and part two was about PQ_Replicate. Now, for the third part in the series, I will take a look at PX_JOIN>FILTER. The PX_JOIN_FILTER is a…

Building Data Tests in PowerShell

April 19, 2018

While working with a client recently, we came across a problem while testing data for completeness or errors after running an ETL process to import & manipulate the data. The main issue we ran across was that the overall client…

Log Buffer #544: A Carnival of the Vanities for DBAs

April 18, 2018

This Log Buffer edition covers Cloud, Oracle, and MySQL.

Oracle Parallel Query Hints. A reference series Part 2: PQ_REPLICATE

April 18, 2018

In Part 1 of this series, we talked about the basic mechanics of the PQ_DISTRIBUTE hint. I did mention the PQ_REPLICATE, and here are all of the details. Oracle Database 12.2, has added a new feature that allows PQ processes…

Azure Cloud Shell – Cloud what?

April 16, 2018

What is Azure’s Cloud Shell? Azure Cloud Shell is a browser-based, interactive shell that comes in two flavors: PowerShell and Bash. Microsoft has had this in public preview for some time now. It offers you the ability to pretty much…

Debugging CBQT OR Expansion with 10053 trace

April 16, 2018

I had been working with a client to add a little bit of functionality to an analytical view that we had been running queries against for a while. The functionality was easy to implement but during testing we found that…

Spark UDF Memoization

April 16, 2018

Memoization is a powerful technique that allows you to improve performance of repeatable computations. Although it would be a pretty handy feature, there is no memoization or result cache for UDFs in Spark as of today. In fact it’s something…

Meetings That End With No Questions

April 14, 2018

Are there any questions? Crickets, absolute silence… Your meeting would have had one person speaking most of the time (you). The themes may have varied, but let us assume that it was about the need to “pull up” or otherwise…

Spark Scala UDF Primitive Type Bug

April 14, 2018

I was working on an instrumentation framework for Scala UDFs in Spark when I noticed a subtle difference in the execution plan depending on whether I used wrappers or not. It looked like some code was added or was not…

Datascape Podcast Episode 25 – Azure SQL Database & PaaS Offerings

April 12, 2018

Welcome to another episode of the Datascape Podcast. Today we are joined by our regular guest and friend, Warner Chaves to chat about Microsoft Azure SQL Database. We are always glad to have Warner on the show and today is…

Graceful master switchover with ProxySQL and Orchestrator

April 12, 2018

Introduction One of the things I like about Continuent Tungsten is how Tungsten Connector can hold traffic while a (graceful) master switch is taking place. This means the application may experience a brief spike in latency, but has not returned…

EI And Communicating Bad News

April 10, 2018

The Customer called us to cancel And now you have to break this news to the team. This is never an easy meeting. If you have read my previous post about emotional artifacts that manifest in High-Stress remote meetings, you…

Oracle Parallel Query Hints – Part 1: PQ_DISTRIBUTE

April 10, 2018

One of the most powerful features of the Oracle database is its ability to leverage multiple cores spread across many RAC servers to execute a single query. Oracle’s optimizer tries its best to execute queries in the most efficient manner,…

Log Buffer #543: A Carnival of the Vanities for DBAs

April 10, 2018

This Log Buffer Edition covers Cloud, Oracle, and MySQL.

Why your data hub belongs in the cloud

April 10, 2018

Whether your core infrastructure is on-prem or in the cloud, there’s only one choice for your data hub
The public cloud effectively provides you with three options:  Infrastructure as a Service, Platform as a Service or Software as a Service. And with IaaS, people often face the choice of “rent vs buy”.

Cloudscape Episode 3: March 2018 roundup of the key AWS, GCP and Azure Updates

April 9, 2018

Welcome back to the Cloudscape Podcast. Today on the show we are once again joined by our panel of experts, Greg Baker who is representing Amazon Web Services, John Laham representing Google Cloud Platform, and Warner Chaves representing Microsoft Azure….

Locally Debug Your Serverless Function

April 9, 2018

Serverless architecture opens an exciting new space for building cloud-native and event-driven applications. By going serverless development teams focus on business logic while leveraging managed services. But this new approach raises new questions. When all the infrastructure is on the…

Datascape Podcast Episode 23 – Private vs. Public Blockchains

April 8, 2018

On today’s show, we welcome Adam Muise to chat with us about the ins and outs of the private and public blockchain. This is a somewhat intermediate discussion and is not an introduction to the blockchain or cryptocurrency, so if…

Spark performance regression with sum aggregations

April 6, 2018

There is an interesting bug that was found during the latest performance tuning we performed for Spark 2.2 (2.3 is also affected). It was a batch Spark job scheduled to be executed hourly and to process about 1Tb worth of…

More Articles >

Pythian Life
Pythian Life

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…

PerconaLive Santa Clara 2017 in Review

May 3, 2017

PerconaLive Santa Clara 2017 happened last week and Pythian is pleased to have been able to sponsor the event. I really enjoyed several of the keynotes. In particular was Baron Schwarz’s keynote on Observability and Distributed Monitoring. Booking.com’s Monitoring without…

Pythian Named One of Canada’s Top Employers for the Fourth Consecutive Year

April 25, 2017

Ottawa, ON– April 25, 2017 Pythian, a global IT services company that helps businesses compete by adopting disruptive technologies, announced today that it has been named one of Canada’s Top Small & Medium Employers for the fourth consecutive year, a…

2017 Annual Open Source Database Community Dinner in Santa Clara

April 17, 2017

Once again, Pythian is organizing the traditional Open Source Database Community dinner in Santa Clara! When: Tuesday April 25, 7pm-10pm Where: David’s Restaurant, a short 5-minute walk from the Santa Clara Convention center. Tickets: Register here! Among the attendees will…

Collaborate 17 – Las Vegas, Pythian is Comin’ for Ya!

March 10, 2017

There are endless reasons to attend the upcoming Collaborate 17 conference (April 2 – April 6).  They include, but are not limited to, the following: Three of Oracle’s biggest and most influential users groups are hosting the event (shout out…

Pythian at the PerconaLive 2017 Open Source Database Conference

March 1, 2017

With PerconaLive 2017 coming up in a couple of months, go ahead and get excited! The conference is being held in Santa Clara, California from April 24-28, 2017. While you’re there, be sure to add these Pythian sessions to your…

Five Reasons Businesses Should Consider Pythian in 2017

January 24, 2017

Hilary Smith and Sarah Killoran discuss why businesses should work with Pythian in 2017.

Pythian: More Than Just a Co-op

January 23, 2017

Megan Macphee writes about her co-op experience in the Pythian HR department.

More Articles >