Business Insights
Business Insights

The Changing Role of BI Professionals: Why managers think beyond BI skills when hiring analytics talent

June 18, 2018

The following is the second in a series of four blog posts on the evolving roles, skills, and functions played by business intelligence and data professionals. We learned in our first post in this series how the role of business…

The Changing Role of BI Professionals: From Analysts to Scientists

June 11, 2018

The following is the first in a series of four blog posts on the evolving roles, skills, and functions played by business intelligence and data professionals. It’s been estimated that 65 percent of current primary school students will eventually hold…

GitHub and Microsoft – Did you hear?

June 6, 2018

Open-Source, GitHub and Microsoft. If I heard that during the Ballmer era of Microsoft, I’d ask if it was April 1st or not. If you are not a Microsoft junkie or just been busy working, you may not have heard…

Pythian’s Vice President of Business Development Recognized as One of CRN’s 2018 Women of the Channel

May 14, 2018

OTTAWA, ON, May 14, 2018 – Pythian, a global IT company that helps businesses leverage disruptive data technologies to better compete, announced today that CRN, a brand of The Channel Company, has named Vanessa Simmons, Vice President of Business Development…

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…

More Articles >

Technical Track
Technical Track

Interesting happenstance when installing Ansible dependencies in a MySQL Docker container

June 25, 2018

I’ve been posting quite a bit about Docker as I’ve been working with it a lot as of late. I thought I would share something interesting I discovered a couple weeks ago while working on setting up a Docker container-based…

Getting started with Orchestrator

June 22, 2018

Orchestrator is a MySQL high availability and replication management tool. In this blog post, we will cover the first steps for getting started with it on an existing topology. The code examples assume you are running Centos 7, but the…

SQL Server and Azure Soft Delete

June 22, 2018

Microsoft just announced the public preview for Azure Soft Delete of Storage Blobs. From the documentation, “When turned on, soft delete enables you to save and recover your data when blobs or blob snapshots are deleted. This protection extends to…

How To Restore Encrypted Backups

June 21, 2018

SQL Server started having encrypted backups since SQL Server 2014. You can see the technical details here. This is a very good feature that allows you to encrypt the backups upon creation with different algorithms that will meet your security…

Data Modeling for Cloud DW

June 21, 2018

In this blog post, I would like to share some options that you can consider to model your cloud DW for better query performance.  With a traditional EDW, we would either come up a STAR, Snowflake or similar schemas. These…

Pythian at DataOps Barcelona

June 20, 2018

DataOps Barcelona is an event organized by Binlogic and will be taking place June 21-22, 2018 in Barcelona, Spain. Pythian is proud to be supporting this inaugural open source-focused conference in Europe! DataOps is of course short for “Database +…

Orchestrator Datacenter Detection

June 19, 2018

Orchestrator is datacenter-aware, meaning that it takes nodes location into consideration when performing a topology change. Let’s explore the options to make Orchestrator automatically detect this configuration.   Using MySQL server One option is to use the monitored database server…

SQL Server 2017 Automatic Tuning

June 19, 2018

Introduction Every new version of SQL Server ships with exciting new features. One of the simplest but important features is Automatic Tuning. Before covering this new feature, let’s analyze the old ways so we can understand what is really automated…

Linux File System for SQL Server DBAs

June 18, 2018

With Microsoft releasing SQL Server on Linux and a lot of SQL Server DBAs coming from a predominantly Windows background, this post is going to arm the DBA with the fundamental knowledge of the Linux file system. If you come…

Datascape Podcast Episode 29 – A Tour of Microsoft Azure Cognitive Services

June 15, 2018

On today’s show, we welcome back Warner Chaves. Warner is here to fill us in on Microsoft Azure Cognitive Services (as well as related updates from Microsoft Build). In our discussion, we will be covering everything you need to know…

HAProxy MySQL Lag Awareness via systemd

June 15, 2018

In one of the projects I have been working on, one requirement was the ability to stop traffic from reaching a MySQL host which has been lagging behind its master for longer than a specific amount of time and then…

Cassandra CQL Cheatsheet

June 15, 2018

Every now and then I find myself looking for a couple of commands I do often. In some other software/technologies we sometimes find a thing called a “cheatsheet” that displays the more used (and some more obscure commands) of that…

Setting up Docker on Oracle Linux

June 15, 2018

Over the last couple of years, I have been hearing about Docker at different conferences. It’s a container technology that seems to have gained a lot of popularity. In recent months, I have started exploring how Docker can be used…

Neo4j Cluster using Vagrant, Ansible and Virtualbox

June 14, 2018

Recently, I was faced with the need to create and configure a Neo4j cluster. In order to be able to easily experiment with different settings and configurations, I decided I needed to create a local to Neo4j cluster using Vagrant,…

Azure Total Cost of Ownership Calculator

June 13, 2018

Microsoft has released a new Azure Total Cost Ownership (TCO) Calculator. This calculator allows you to quickly enter in your current on-premises workload and review the expected savings or costs of moving to Azure. Workloads You simply enter in your…

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

June 13, 2018

This Log Buffer edition covers Oracle, SQL Server and MySQL.

Azure Data Lake basics for the SQL Server DBA / developer and… for everyone!

June 13, 2018

The basics If you’re a Microsoft SQL Server DBA or developer and have not been introduced to the Microsoft Azure Data Lake and would like to understand what it’s all about and how to get started, this article is for YOU….

Oracle SQL Developer – Now in Web!

June 11, 2018

For some time, I was trying to use a Google Pixelbook for my work. It was kind of a challenge and among other things, I struggled to work without a good web-based SQL client or tool. I used a jump…

Cassandra backups using nodetool

June 11, 2018

Cassandra nodetool provides several types of commands to manage your Cassandra cluster. See my previous posts for an orientation to Cassandra nodetool and using nodetool to get Cassandra information. My colleague has provided an in-depth analysis of backup strategies in…

Cloudscape Podcast June 2018

June 8, 2018

Welcome back to the Cloudscape Podcast! Today on the show we are once again joined by a panel of industry experts: Greg Baker who will be discussing Amazon’s AWS, Kartick Sekar discussing the Google Cloud Platform (GCP), and Warner Chaves…

More Articles >

Pythian Life
Pythian Life

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…

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.’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…

More Articles >