Business Insights
Business Insights

5 key skills you should expect from your DBA team in the era of cloud

February 21, 2017

Do businesses have the right skills and expertise internally to take full advantage of both the tactical and strategic benefits of the cloud? To help you determine what skills are needed on your team, we’ve developed a list of 5 key skills of modern DBAs in the era of cloud. And for a complete picture of what cloud means for your DBA team, Warner Chaves, one of Pythian’s principal consultants, has written a white paper outlining how database management is different in the cloud, and the key skills the modern DBA must have.

Four Tips for Migrating Your Enterprise Applications to AWS

January 4, 2017

Learn our four tips for migrating your enterprise applications to a cloud platform like AWS.

Pythian’s Top Five Business Blogs of 2016

December 28, 2016

From upgrades and cloud migration to Pokémon Go and the modern DBA role, Pythian bloggers had plenty on their minds in 2016. Sit back and enjoy these top performing posts from our business blog, and let us know what you’d like…

LISA16 Conference Highlights: Change is Coming!

December 12, 2016

Chris Stankaitis, Team Manager, Site Reliability Engineering at Pythian, reflects on the theme of change at LISA16.

Pythian Next Generation Service Strategy Attracts New IT Leadership

November 28, 2016

Pythian, a global technology company that helps businesses adopt and manage disruptive technologies to better compete, is pleased to welcome Matthew Abarbanel and Marc St. Louis to the Pythian team. As VP of Technology Services, Matthew Abarbanel is responsible for…

Microsoft’s Latest Announcement Gives You More Reasons to Upgrade to SQL Server 2016

November 24, 2016

Find out what Microsoft’s announcement around the SQL Server 2016 upgrade means for you.

Five Things to Know Before Migrating Your Data Warehouse to Google BigQuery

November 23, 2016

Find out if Google BigQuery is the right tool for what you want to do and how to migrate your data into it.

Goals for my Clients in 2017

November 7, 2016

Warner Chaves outline the goals he is setting for his clients in 2017.

Will Oracle Fly Higher Than Amazon in Cloud?

October 28, 2016

Can Oracle rise up to meet Amazon’s success in the cloud? Fahd Mirza makes the case for Oracle Cloud.

Going PaaS? Think Google Cloud Platform for big data.

October 26, 2016

How to know when your enterprise needs a platform-as-a-service and why Google Cloud Platform is a good option.

What New Storage Classes from Google Mean for Your Business

October 21, 2016

What new Google Cloud Storage options, including Regional, Multi-regional, Nearline and Coldline, mean for businesses

Pythian Announces New Board of Directors

October 17, 2016

New Board Positions Pythian For Next Level Success In IT Driven Business Landscape Ottawa, ON – October 17, 2016 – Pythian, a global IT company that helps businesses adopt and manage disruptive technologies to better compete, is pleased to announce…

Join Us For Breakfast At PASS Summit 2016

October 7, 2016

With PASS SUMMIT 2016 around the corner, we’re gearing up for a special Pythian and ScaleArc co-sponsored breakfast presentation you won’t want to miss. Be our guest for breakfast, and find out about the best practices for improving uptime and…

Pythian Now Offers Google BigQuery Services To Its Enterprise Customers

September 29, 2016

Pythian is equipped to plan, implement and manage enterprise migrations to Google Cloud Platform and help enterprises take advantage of BigQuery’s capabilities, utilizing Google Cloud Platform Qualified Solutions Developers and Data Analysts.

Google Cloud Platform Can Help You Work With Complex Data

September 29, 2016

Find out how Google Cloud Platform can help your enterprise get insight and value out of complex data on a massive scale.

Join Pythian at Percona Live Europe in Amsterdam!

September 28, 2016

  The Percona Live Data Europe Conference in Amsterdam is being held October 3-5, 2016. It is quickly approaching, and Pythian is excited to show you how we Love Your Data in a big way! We have an awesome lineup of speakers this year:…

Join Pythian at Oracle OpenWorld 2016

September 19, 2016

Find out information on Pythian’s Oracle OpenWorld speakers, and details about our annual blogger meetup.

Pythian Named One of Canada’s Fastest-Growing Companies on the PROFIT 500

September 15, 2016

Canadian Business and PROFIT today ranked Pythian No. 151 with a five-year growth rate of 437% on the 28th annual PROFIT 500

Considering Alternatives To RDBMS? NoSQL May Be The Answer

September 7, 2016

Depending on your specific needs, your applications, the type and volume of your data, NoSQL could be the right choice as either a complementary technology to an existing RDBMS, or a complete replacement. Find out if NoSQL is right for your business.

Pythian at Cassandra Summit 2016

August 24, 2016

Vanessa Simmons, Director of Business Development at Pythian, provides a sneak peek of Pythian programming at Cassandra Summit 2016.

More Articles >

Technical Track
Technical Track

DATASCAPE PODCAST EPISODE 4 – Discussing Oracle Licensing in the Public Cloud

February 24, 2017

Bjoern Rost (@ROST) explains Oracle licensing on prem and in the public cloud.

Reading Execution Plans for Parallel DML

February 23, 2017

Parallel execution in Oracle seems to be a topic of myths, mysteries and misunderstandings. In this post I hope to clear up at least one of them by diving into a discussion about parallel DML. Actually, I want to show…

An Introduction to the MongoDB Database Profiler

February 23, 2017

MongoDB’s database profiler lets us collect some performance data about operations happening on a MongoDB instance. In this post, I will show you how we can enable the profiler, what kind of information it can store for us, how to query this…

Datascape Podcast Episode 3 – All About Data Lakes with Danil Zburivsky

February 22, 2017

I started hearing the term ‘data lake’ a few years ago but didn’t pay a ton of attention to it. Today, the term’s still around and so is the hype. According to this article on Wikipedia ( the term is…

Datascape Podcast Episode 2 – Running SQL Server on Linux – Say whaaat??!

February 22, 2017

SQL Server is a conventional RDBMS created in partnership between Microsoft and Sybase in ~1989. Since then, SQL Server has only ever run on the Windows operating system. Infoworld ranked SQL Server as the second most popular database (along with…

Datascape Podcast Episode 1 – Discussing the Future of the DBA Career

February 22, 2017

For much of my career as a DBA, I spent a lot of time working on issues that technology and software are eliminating. Issues like space management, performance management, building new systems and configuring complex availability options like Clustering. Why…

Oracle New Public Cloud Licensing Policy – Good or Bad?

February 22, 2017

A little while ago after a question from a customer about supporting Oracle products on the Google Cloud Platform (GCP) I decided to take a look for any updates to the Oracle public cloud support policies. The document can be…

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

February 21, 2017

This Log Buffer Edition searches through various blogs of Oracle, SQL Server and MySQL and picks a few contemporary ones.

DBAs: The 5 key skills you will need in the cloud

February 21, 2017

In this new landscape, your role as a DBA will change significantly. Getting ready for the cloud now will set you apart from your peers, making you an indispensable resource to your organization. Here are just a few reasons you need to get your cloud skills up to speed

Backup Oracle Databases to AWS S3

February 21, 2017

There are different options for backing up Oracle databases to Cloud, but using Oracle Secure Backup module to take backups into AWS S3 is one of the most efficient methods in terms of costs and backup/restore performance. In this post…

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

February 14, 2017

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

MySQL may return results in non-deterministic order with ‘order by’

February 13, 2017

Whenever we want a query’s results sorted, you may think of using the clause “order by.” You are correct: most of the time, MySQL will return the results in expected order with “order by.” Be careful, though. Sometimes MySQL may return…

Parting With ocm.rsp Isn’t Really Sweet Sorrow…

February 7, 2017

Now that we’re well into 2017, let’s sit back and ask the question: “What was the best news of 2016 in the Oracle ecosystem?” The 12.2 beta ? (no, that was announced in October 2015 :)) The fact that we…

Customizing pt-stalk to Capture the Diagnostics Data You Really Need

February 7, 2017

Valeriy Kravchuk’s great recent post on using oprofile to profile MySQL mentioned how pt-stalk, the script from Percona Toolkit to capture diagnostics data based on a detected condition, currently does not support the new operf comand, and relies instead on the deprecated and soon…

I’m launching a podcast!

February 6, 2017

Chris Presley announces the launch of The Datascape Podcast.

SQL Server Default Configurations That You Should Change

February 6, 2017

Who here takes the time to adjust default values for SQL Server Configuration after installing it? Unless your company has specific Post-Installation Tasks procedures/document, SQL Server configurations are left as is until an issue comes along. If you are doing your…

ORA-30926 While Using impdp Over a Database Link

February 3, 2017

The other day I was doing an import using impdp in, and received the following error:’ORA-30926: unable to get a stable set of rows in the source tables’.   Starting "SYS_PYTHIAN"."SYS_IMPORT_TABLE_03": sys_pythian/******** parfile=table_import.par Processing object type TABLE_EXPORT/TABLE/TABLE Processing object…

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

February 3, 2017

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

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

January 31, 2017

This Log Buffer edition covers the latest blog posts around Oracle, SQL Server and MySQL.

A Data Warehouse Guide for the IT Manager

January 27, 2017

A quick guide to help you compare certain data warehouse options.

More Articles >

Pythian Life
Pythian Life

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.

Pythian Opens New European Office in London

January 18, 2017

Pythian is expanding its global footprint in Europe with a new larger office in the tech hub of London and a significant investment in sales and technical resources. Pythian’s revenue from its European region has grown by more than 150%…

2016 Last Minute DBA Holiday Gift Guide

December 16, 2016

Do you have a hard-to-buy-for DBA on your list? Whether you’re a manager looking for something to give your talented people, or someone with a special DBA in your life, we know it’s not always easy to choose the right…

Being a Pythianite

September 26, 2016

  It has been seven months since I started working for Pythian and it doesn’t feel like it at all. The main reason is the full time work from home option that we enjoy here. I couldn’t agree more when my…

Aim for Exceptional: Reflecting on my Employment at Pythian

August 5, 2016

Shawn Melton, SQL Server Database Consultant at Pythian, discusses how his employment at Pythian differs from past jobs, and why.

Embracing Lifelong Learning In The IT Industry

June 20, 2016

Alejandro Cordero, Lead Database Consultant at Pythian, discusses the importance of lifelong learning in the IT industry.

Pythian Sponsors Another Successful Technovation Challenge!

May 30, 2016

Stephanie Caron, Marketing Manager at Pythian and Ottawa Chapter Program Coordinator for Technovation, talks about the conclusion of this year’s event.

What’s Holding You Back From Giving Back?

April 15, 2016

Heidi Hauver, VP of HR at Pythian, reflects on the importance of giving during National Volunteer Week.

There’s more to IT than just coding

March 15, 2016

Stephanie Caron, Marketing Manager at Pythian, and Ottawa Chapter Program Coordinator for Technovation, updates us on the 2016 Technovation program so far.

Sources of Inspiration on International Women’s Day

March 8, 2016

Heidi Hauver, Vice President of Human Resources as Pythian, shares her sources on inspiration on International Women’s Day.

Learning To Be Present

February 25, 2016

Heidi Hauver, VP of Human Resources, writes about her journey of mindfulness, and learning to be present in her daily life.

The Value of Pythian’s Internship Program

February 19, 2016

Software Development Intern Roni Peled writes about his experience in the Pythian Internship Program.

The Little Big Company With The Huge Heart

February 17, 2016

Tara Ghazouly, Pythian Sales Representative, talks about the many random acts of kindness she’s experienced in Pythian’s Ottawa office.

My Virtual Internship with Pythian

January 28, 2016

Claudia Cornali-Motta, project management virtual intern, shares her experiences at Pythian, and her excitement around the Pythia Program.

Pythian – Through the Eyes of a CO-OP Student

January 11, 2016

Joseph Baroud, Human Resources co-op student at Pythian, provides the next wave of interns a candid perspective on what it’s like to experience the Pythian culture first hand.

Big Data Co-op Experience at Pythian

December 31, 2015

Zunaira Jamil, Pythian co-op student, describes her experiences while fulfilling her experience working with one of our Big Data teams and what she learned.

Good Habits & Gratitude

December 31, 2015

Heidi Hauver, VP of Human Resources, explains how you can unlock the power of gratitude by simply developing a good habit to record all the things you can be thankful for in 2016.

Pythian Champions Gender Diversity in Tech

November 18, 2015

  At Pythian, we embody and value diversity in every form—in our religion (or lack thereof), our geography, our culture, and of course the location we’ve chosen for our home.  We deeply believe that the best teams are diverse and…

Gotta Love English

October 21, 2015

  I do love to write, and have always enjoyed the idiosyncrasies of this wonderful language. One of my favourite features of English is how I struggle with the following items almost daily: I am doing a few things to…

More Articles >