Business Insights
Business Insights

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…

Pythian Achieves Cloud Migration Partner Specialization in the Google Cloud Partner Specialization Program

July 23, 2018

Today, Pythian is pleased to share the news that it has achieved the Cloud Migration Partner Specialization in the Google Cloud Partner Specialization Program. By earning this Partner Specialization, Pythian has proven its expertise and success in building customer solutions in…

Pythian Achieves Google Cloud Platform Partner Specialization In Infrastructure

July 19, 2018

Today, Pythian is pleased to announce that it has achieved a Google Cloud Partner Specialization in Infrastructure. The Google Cloud Partner Specialization Program is designed to connect customers to qualified partners with demonstrated technical proficiency and proven project success in areas including…

Pythian recognized as the winner of the Microsoft Canada Application Innovation IMPACT Award  

July 17, 2018

Today Pythian is proud to announce that our team has won the 2018 Microsoft Canada Application Innovation IMPACT Award. These annual awards recognize Microsoft partners who demonstrate excellence in innovation and implementation of customer solutions based on Microsoft technology. Microsoft…

Workload Migration: What Should Go To The Cloud First?

July 17, 2018

There’s no longer any question: Cloud is winning, and the on-premises data center seems doomed to a future of declining relevance. The results of a recent survey by LogicMonitor confirm this, suggesting that 83 percent of enterprise workloads will be…

More Articles >

Technical Track
Technical Track

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…

Analytics in the Cloud – Azure Analysis Services

September 13, 2018

Azure Analysis Services is a fully managed platform as a service (PaaS) that provides enterprise-grade data models in the cloud. Advanced mashups and modeling features are used to combine data from multiple data sources, define metrics, and secure your data…

How to Test an Oracle Database Upgrade using a Physical Standby

September 13, 2018

It was a Thursday morning. I started my day at work and found out that I was tasked with running a test upgrade to 11.2.0.4 right on Friday. This is just to make clear that I did not have much…

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…

News and Updates from Amazon Web Services

September 12, 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: Amazon Elastic…

Shutdown while upgrading to 18c

September 12, 2018

My colleague and friend Gleb Otochkin has already blogged about installing 18c – Installing Oracle 18c using command line – but I thought that I would share my experience. My plan was to upgrade my 12.2 pluggable database to 18c…

Releasing puppet-proxysql version 2.0.0

September 11, 2018

Everyone knows those situations where there is a task that you need to do and you want to do, but you just don’t come around to actually doing it. Well, for me, this new release was such a task. Early…

Loading Data into Azure Data Warehouse with Data Factory – SQL On The Edge Episode 18

September 11, 2018

Earlier this year Microsoft released the next generation of its data pipeline product Azure Data Factory. The first release of Data Factory did not receive widespread adoption due to limitations in terms of scheduling, execution triggers and lack of pipeline…

Oracle Live SQL revised

September 7, 2018

If you’re not familiar with the Oracle Live SQL environment, then you should definitely try it. I wrote a blog some time ago on what it is and how to work with execution plans there. Here I will provide an…

MySQL Plugin For Oracle Enterprise Manager 13c Cloud Control

September 6, 2018

This is the same plugin that Alex Gorvachev created back in the day. I’ve simply modified it to be compatible with both 12c and 13c versions. I created this in response to a comment on the blog about issues deploying…

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…

Working with Resource Groups in MySQL 8

September 5, 2018

MySQL 8 is GA and it has a variety of new features. Recently, we happened to work with resource groups to restrict resource utilization for a MySQL thread. That’s why I thought of writing this blog post: to give you…

How to Fix the Skip Scan Bug in 18c

September 5, 2018

A recent Twitter thread had an interesting test case of the optimizer choosing sub-optimal skip scan over range scan. I’ve checked what’s going on, and it happens to be a known bug. Here’s a slightly simplified test case: We have…

Oracle Autonomous Transaction Processing – A Good Start

August 30, 2018

It has been almost a year since the last Open World where Oracle CTO and founder Larry Ellison proclaimed the new upcoming fully autonomous cloud database service. It created a lot of attention and almost everybody in the Oracle community…

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…

So you have a broken Cassandra SSTable file?

August 28, 2018

Every few months I have a customer come to me with the following concern: my compactions for one of my Cassandra tables are stuck or my repairs fail when referencing one of the nodes in my Cassandra cluster. I take…

Using Ansible Role to Setup Oracle ACFS on Multiple Nodes

August 28, 2018

This post contains step by step instructions for creating an Ansible role acfssetup to setup Oracle ASM Cluster Filesystem (ACFS) on multiple nodes of a cluster. This assumes that Grid Infrastructure 12.1.0.2.0 is already installed on the nodes, and ASM…

More Articles >

Pythian Life
Pythian Life

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…

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…

More Articles >