Business Insights
Business Insights

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…

Cloud Automation Is Winning. Will Your Organization Share In The Prize?

July 12, 2018

If you’re an IT leader, you don’t need us to tell you that cloud automation has become the lifeblood of the future-ready enterprise. And you don’t need us to make you feel a sense of urgency around becoming a 100%…

The Changing Role of BI Professionals: The Importance of a Modern Data Platform

July 4, 2018

The following is the fourth and final in a series of four blog posts on the evolving roles, skills, and functions played by business intelligence and data professionals. The first three blog posts on the changing roles of BI Professionals…

The changing role of BI professionals: The perfect candidate

June 26, 2018

The following is the third in a series of four blog posts on the evolving roles, skills, and functions played by business intelligence and data professionals. In our first two posts on the changing role of BI professionals, we offered…

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”.

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…

More Articles >

Technical Track
Technical Track

Troubleshooting RAC GoldenGate Relocation

August 17, 2018

During RAC online patching, GoldenGate resource is required to be relocated to surviving node. When relocation fails, there are a few logs which can be useful for troubleshooting. Oracle Grid Infrastructure Standalone Agents for Oracle Clusterware (XAG) was not installed…

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…

Proposal for a New Cassandra Cluster Key Compaction Strategy

August 15, 2018

Cassandra storage is generally described as a log-structured merge tree (LSM). In general, LSM storage provides great speed in performing writes, updates and deletes over reads. As a general rule, a write in Cassandra is an order of magnitude faster…

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…

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

August 14, 2018

This Log Buffer Edition covers Cloud, Oracle, and MySQL. Cloud: Increasingly, enterprise backends combine legacy systems, modern microservices, and various SaaS applications. More and more of the modern applications are built on the cloud or are migrating there. Account management,…

News and updates from Microsoft Azure

August 14, 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 Data Factory Copy Tool updates         Microsoft…

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

August 9, 2018

This Log Buffer Edition covers Cloud, Oracle, and MySQL. Cloud: AWS Config is a service that maintains a configuration history of your AWS resources and evaluates the configuration against best practices and your internal policies. AWS released a new IAM…

Cloudscape Podcast Episode 7: August 2018

August 9, 2018

In this episode of The Cloudscape Podcast, we are joined by AWS expert Greg Baker and Microsoft Azure expert Warner Chaves. We will be doing the usual round-up of the latest developments from the cloud vendors and filling you in…

Oracle DBSAT Discoverer Feature

August 8, 2018

Oracle’s Database Security Assessment Tool (DBSAT) is a nice and powerful free tool that performs Database and OS Security Audits and provides recommendations based on the findings. The tool and documentation can be downloaded from the following Oracle link (although…

Oracle Parallel Query Hints Reference – Part 5: PQ_DISTRIBUTE_WINDOW

August 8, 2018

Welcome to Part 5 of the series. First, some background: if you want to skip to the reference part, scroll down. This hint was introduced relatively recently – in Oracle 12.1 – where for the first time, SQL Windowing functions are…

Introduction to Azure SQL Managed Instance – SQL On The Edge Episode 17

August 7, 2018

SQL Server is one of the most adopted and widely-used database engines in the world. Almost every company either builds on it or uses some enterprise third-party software that uses it as the back end. For this reason, it makes…

Installing SQL Server 2008 R2 on Windows 2012 Cluster

August 7, 2018

Despite being an older version, some applications may require you to install a SQL Server 2008 R2 clustered instance on a Windows 2012 environment. You will quickly find out that there are a number of compatibility issues that can make…

Getting Started with the Oracle Database Backup Service in 2018

August 3, 2018

A few years ago I wrote an article on getting started with the Oracle Database Backup Service which can be found here. It’s no surprise that in the last few years things have changed significantly.  Trying to use this service…

Oracle Parallel Query Hints Reference – Part 4: GBY_PUSHDOWN

August 2, 2018

Welcome to Part 4 of the series. The GBY_PUSHDOWN is a very interesting hint, introduced in 10.2 – it doesn’t have the PQ prefix, but nevertheless plays a crucial role in Parallel query plans. Purpose: When GBY_PUSHDOWN is activated, an…

News and Updates from Google Cloud Platform

August 2, 2018

I recently joined Chris Presley for Episode 5 of his podcast Cloudscape to talk about what’s happening in the world of cloud. My focus was the most recent events surrounding Google Cloud Platform (GCP). Some of the highlights of our…

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…

Choosing Best Index for your MongoDB query

July 31, 2018

Indexing plays a quintessential role in database query performance and MongoDB is no exception. Choosing the best index for a query will improve its performance, while a bad one could lead to huge execution times and high memory utilization. In…

Text index usage within MongoDB

July 30, 2018

Recently a client came to me asking “How do we verify if a full text search index is being used on MongoDB?” The db.showIndexes() command shows an index on a text field, but explain() shows COLLSCAN and the query is…

How to Manage Multiple MySQL Binary Installations with SYSTEMD

July 30, 2018

This blog will go into how to manage multiple MySQL binary installations with SYSTEMD using the systemctl command.  With package installations of MySQL using YUM or APT, it’s quick and easy to manage your server’s state by executing systemctl commands…

How to efficiently back up and restore crontab

July 27, 2018

When a database environment is being patched, entries from crontab are commented and then removed when patching is completed. The process works well when there are only a few entries from crontab, but it does not scale when crontab has…

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 >