Business Insights
Business Insights

Black Friday is coming. Is your customer data ready?

October 10, 2018

As a retailer, Black Friday can make or break your end-of-year sales targets. It’s when customers expect savings on their favorite products, and you expect deal-seeking customers to line up at your door or flock to your website. But special…

Cloudscape Podcast Episode 10: October 2018

October 9, 2018

Welcome back to the Cloudscape Podcast! In this month’s edition, we are joined by Greg Baker who will discuss the latest from Amazon and Kartick Sekar who will discuss the latest from Google. Warner Chaves will have his own Microsoft…

Pythian Achieves Machine Learning Partner Specialization in the Google Cloud Partner Specialization Program

October 4, 2018

Toronto, Canada – Google Cloud Summit Oct 4, 2018,  Pythian, a global IT company that helps businesses leverage disruptive data technologies to better compete, announced today that it has achieved the Machine Learning Partner Specialization in the Google Cloud Partner…

Top Talks to Watch for at Google Next London

October 3, 2018

On October 10 & 11, 2018, Google Next London will be running in full force. Pythian will be attending with a booth and many of our top executives and technical leaders ready to discuss our cloud strategies and offerings. This…

How AEG Worldwide Delivers Superior Customer Experience With A Cloud-based Analytics Platform

September 19, 2018

We recently helped AEG Worldwide, a leader in the live entertainment industry, align their marketing programs with their individual ticket buyers with a big data solution that provides AEG with a full view of their customers’ behaviors and preferences and…

A Look at GCP Helsinki Data Center’s Opening Event

September 13, 2018

Pythian was recently invited to attend the very successful opening of the new GCP Helsinki Data Center. Based on the number of attendees and their excitement level, Finland is very ready to jump on a local cloud provider with over…

Dismantling Data Silos through Cloud Integration

September 12, 2018

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…

Cloudscape Podcast Episode 9: September 2018

September 6, 2018

Welcome back to another episode of the Cloudscape Podcast. In this episode, we are joined by Greg Baker who will be discussing AWS, and Warner Chaves who will be discussing Microsoft Azure. I recently released a special episode of Cloudscape…

How to Avoid 5 Common Mistakes in Hybrid Cloud Implementations

September 6, 2018

Hybrid cloud solutions are growing in popularity and for good reason. They have the potential to bring significant cost savings, agility, flexibility and scalability to the modern enterprise. But the key word here is “potential” because missteps in planning and…

Data integration: Which data platform type does it best?

August 30, 2018

This is the third in a series of four posts on breaking down data silos and its importance for organizations. In this post, we look at which types of data platforms work best for a centralized, integrated data program. In…

Top 5 Considerations for a Hybrid Cloud Environment

August 29, 2018

The options in hybrid cloud environments are infinite. No two are the same. The decision to embrace hybrid cloud computing will trigger a number of other decisions that may be unique to your organization, and not all of them are…

Humanizing Data Visualization

August 27, 2018

What is the ultimate goal of data and why is it so important? From the dawn of civilization, data has been the key to power. Ancient Indians captured data from living experiences and captured them in the Vedas and the…

What is the Hybrid Cloud and What are its Benefits?

August 23, 2018

Not so long ago, the debate about the virtues of cloud versus data center was pretty straightforward: Did your business want to maximize scalability, flexibility and cost efficiency in computing? While cloud has continued its relentless march to dominance, the…

Why you can’t ignore master data management and data governance

August 23, 2018

This is the second in a series of four posts on breaking down data silos and its importance for organizations. In this post, we look at master data management and data governance strategy. In our first post in this series,…

Breaking down data silos: BI’s broken data integration promise

August 16, 2018

This is the first in a series of four posts on the breaking down data silos to gain more complete, accurate business insights. When setting up a data program for your organization, it can make sense to start by adopting…

Cloudscape Podcast: Highlights from Google Next 2018

August 16, 2018

Welcome to a special edition of the Cloudscape Podcast! Today’s show is dedicated to the recent Google Cloud Next conference and the announcements that were made at the event. We welcome back Greg Baker, Pythian’s AWS expert and our guest…

DevOps: Five Trends For 2019 And Beyond

August 15, 2018

The 2019 technology forecasts are still a few months away, but some predictions are already a safe bet — especially when it comes to DevOps. New estimates from IDC suggest that the DevOps software market will grow from its 2017…

DevSecOps: What All DevOps Should Be

July 31, 2018

Today the value of DevOps is well understood, at least by IT professionals. In the IT community, DevOps is almost universally accepted as being superior to traditional software development. By breaking down departmental silos, DevOps unifies development and operations teams…

Google NEXT 2018: Google Cloud Platform and the Pythian Partnership

July 26, 2018

On day one of the Google NEXT 2018 conference which has a sold-out attendance at San Francisco’s Moscone center, Google’s drive and mission for cloud dominance and on-boarding of enterprise clients couldn’t be more poignant. At this conference, Google Cloud…

Three Reasons You Need a Customer Data Platform Right Now

July 25, 2018

A Twitter user recently turned to the platform to issue an appeal to her bank: “Please don’t send me emails asking if I’m ready to buy a house ten minutes after emailing me an overdraft notice.” That one tweet neatly…

More Articles >

Technical Track
Technical Track

Oracle Parallel Query Hints Reference – Part 7: PQ_DISTRIBUTE and Partitioned Tables

October 19, 2018

In Part 1 of the series, we covered in detail how the PQ_DISTRIBUTE can change the data distribution method across parallel query workers and the importance of avoiding BUFFERED hash joins. Through the remaining parts of the series, I showed…

Migrating btrfs Root Partition to ext4 in OVM

October 18, 2018

Recently I spent some time trying to migrate root partition to another FS type in an OVM environment. The target was to migrate root partition from btrfs to ext4. Here is a short outline of how it was done. 1….

Is slave_exec_mode idempotent actually idempotent?

October 17, 2018

Co-Author: Rafael Alvarez When you look up the word idempotence in wikipedia you get the following definition: Idempotence is the property of certain operations in mathematics and computer science whereby they can be applied multiple times without changing the result beyond the…

Lifecycle Management and other new AWS features now GA

October 16, 2018

I recently joined Chris Presley for his podcast, Cloudscape, to talk about what’s happening in the world of cloud-related matters. My focus was to share the most recent events surrounding Amazon Web Services (AWS). Topics of discussion included: Registration is…

HCC Compression on Oracle Live SQL

October 15, 2018

I’ve written previously about “Oracle Live SQL”, a free service from Oracle where you can try your coding skills and learn using its vast code library. Today I want to mention one of its other features which may not be…

An Explanation of Machine Learning Algorithms

October 15, 2018

Machine learning algorithms help to identify hidden insights in data without needing explicit, complicated programmes. Machine learning uses algorithms which learn from previous data to help produce reliable and repeatable decisions. It’s important to know the iterative aspect of machine learning, as…

New features and service offerings from Microsoft Azure – September 2018

October 11, 2018

I recently joined Chris Presley for his podcast, Cloudscape, to talk about what’s happening in the world of cloud-related matters. I shared the most recent events surrounding Microsoft Azure. Topics of discussion included: Business Critical service tier in Azure SQL…

Cloudscape Podcast Episode 10: October 2018

October 9, 2018

Welcome back to the Cloudscape Podcast! In this month’s edition, we are joined by Greg Baker who will discuss the latest from Amazon and Kartick Sekar who will discuss the latest from Google. Warner Chaves will have his own Microsoft…

How to Tweak the Number of num_tokens (vnodes) in Live Cassandra Cluster

October 5, 2018

Some clients have asked us to change the number of num_tokens as their requirement changes. For example lower number of num_tokens are recommended is using DSE search etc.. The most important thing during this process is that the cluster stays…

Pythian Achieves Machine Learning Partner Specialization in the Google Cloud Partner Specialization Program

October 4, 2018

Toronto, Canada – Google Cloud Summit Oct 4, 2018,  Pythian, a global IT company that helps businesses leverage disruptive data technologies to better compete, announced today that it has achieved the Machine Learning Partner Specialization in the Google Cloud Partner…

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

October 4, 2018

This Log Buffer Edition covers Cloud, Oracle and MySQL. Cloud: Cloud Directory is a neglected serverless data store that deserves much more attention. Many of our large enterprise customers have this worry hanging over their heads … what are they…

Top Talks to Watch for at Google Next London

October 3, 2018

On October 10 & 11, 2018, Google Next London will be running in full force. Pythian will be attending with a booth and many of our top executives and technical leaders ready to discuss our cloud strategies and offerings. This…

How to find unused indexes and drop them safely in MongoDB

September 27, 2018

Indexes increase read performance and allow queries to access data faster. But they also need to be updated when the indexed keys are created or modified, which consumes additional time to complete C*UD operations. In this blog post, we will…

News And Updates From Microsoft Azure, Pt II

September 26, 2018

I recently joined Chris Presley for his podcast, Cloudscape, to talk about what’s happening in the world of cloud-related matters. I shared the most recent events surrounding Microsoft Azure. Topics of discussion included:         Azure DW – Instant Data Movement         Azure…

Microsoft SQL Server 2019 : Data Platform in a Box

September 25, 2018

I’m writing this blog post the day after Microsoft has unveiled SQL Server 2019 at their flagship Ignite 2018 conference. Officially named SQL Server 2019, it comes hot off the heels of the SQL 2017 release. This should be no…

News And Updates From Microsoft Azure, Pt I

September 25, 2018

I recently joined Chris Presley for his podcast, Cloudscape, to talk about what’s happening in the world of cloud-related matters and the most recent events surrounding Microsoft Azure. Topics of discussion included:         Azure Virtual WAN in preview         Azure Firewall in…

Does Oracle allocate PGA in HugePages?

September 24, 2018

The short question While preparing a presentation I am giving this year about HugePages, a colleague of mine at Pythian posed an interesting question: Does Oracle use HugePages for PGA? The short answer No, it doesn’t. The long question We…

Efficiency By Design when Creating Backup Strategies

September 21, 2018

Most backup implementations to not take log management into consideration. Example: Have you seen thousands of backup logs or backup log dating back to 2017? Is it necessary? Worse, paged in the middle of the night for disk filling up….

How to use procedures to increase security in MySQL

September 20, 2018

MySQL privilege system is small, almost all administrative tasks can be completed using a handful of privileges. If we exclude generic ones as ALL, SHOW DATABASES and USAGE, create and drop permissions as CREATE USER, DROP ROLE or CREATE TABLESPACE,…

Authenticating MySQL 8.0 (Enterprise) against active directory

September 17, 2018

Recently our team was tasked to implement MySQL 8.0 in production for a client. While MySQL 8.0 is looking very promising and has a lot of cool new features and revamped old features, it’s still pretty young. The MySQL development…

More Articles >

Pythian Life
Pythian Life

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…

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…

More Articles >