Business Insights
Business Insights

Microsoft Data Platform 2017: new features and why you should upgrade – a webinar with Warner Chavez and Vitor Fava

February 12, 2019

Now is a great time to migrate to Microsoft Data Platform. Listen to Warner and Vitor, our Microsoft MVPs, discuss upgrading SQL 2008 R2 and previous versions, to the Microsoft Data Platform 2017. Given the many options available to the…

How to choose the best data management option

February 7, 2019

As your data estate ramps up to a data empire, more and more of your users are vying for––and expecting––better access to this wealth of internal and external information. That’s why finding the right home for your data is so…

Going from monolith to microservices: deciding when and how

February 5, 2019

As the migration of enterprise to the cloud accelerates, the monolithic approach to software development seems doomed to extinction. Cloud-based microservices are increasingly the preferred approach, and it’s easy to see why. Microservices break down large software projects into smaller,…

How the cloud many finally solve the data silo problem

January 28, 2019

Not loving your data? You’re not alone. Accessing corporate and external data to gain insight and get ahead is critical—but it isn’t easy. One source claims 90 percent of digital information is unstructured and locked in siloed repositories, meaning departments…

Achieving data integration zen: building your business case

January 20, 2019

The closely related issues of siloed data and a lack of data integration – stemming, in part, from reliance on older data warehouses and a general inability to establish proper data governance – aren’t just slowing down your business intelligence…

Cloud security: what you don’t know will hurt you

January 8, 2019

If your organization isn’t doing business in the cloud today, it might have some catching up to do. A 2017 report by LogicMonitor suggests that 83% of enterprise workloads will be in the cloud by 2020. Yet the same study…

Cloudscape podcast episode 13: recapping AWS re:Invent 2018

January 3, 2019

This episode of the Cloudscape is dedicated to recapping the most exciting announcements from the recent AWS re:Invent conference and to help us do that we are joined by Pierig LeSaux! Pierig is kind enough to take us through a…

The top seven big data analytics trends for 2019

January 3, 2019

2018 was a momentous year for data. Not only has the overall importance of data and information within organizations continued to grow, but we’ve also seen the continued rise of megatrends like IoT, big data – even too much data…

Pythian’s top bloggers provide insight and instruction: top posts from 2018

December 28, 2018

If you have questions about resolving encryption issues or you want some information about data platforms, where do you go? Pythian’s experts have valuable knowledge of a wide range of topics and have shared their expertise from written how-to instructions…

Istio: the new standard in making microservices behave

December 17, 2018

The cloud has opened up a world of new opportunities for enterprise. It’s also opened a world of new challenges, and probably no one is experiencing those challenges more acutely than your DevOps teams. As they work to deliver an…

Data lovers’ gift guide 2018

December 12, 2018

Can’t figure out what to get that special data professional on your list? Back by popular demand, our Data lover’s gift guide helps you choose the perfect gift for that data analyst, visualizer, engineer, BI pro or data scientist on…

The definitive data integration checklist

December 11, 2018

So, you’ve decided to upgrade your on-prem data warehouse to a cloud-based, modern data platform. Congratulations! You recognized your old system had become slow and results from it were inconsistent. It was also contributing to the culture of siloed data…

Cloudscape podcast episode 12: December 2018

December 10, 2018

Today we are carrying on with our monthly roundup of cloud vendor announcements. We are without Amazon expert Greg Baker, as the next episode will be a dedicated expose on AWS’ 2018 re-Invent summit, so stay tuned for that soon….

High-performance computing: waiting for the cloud to catch up

December 6, 2018

High-performance computing (HPC) was once limited to organizations that could afford to buy and maintain systems costing tens of millions of dollars. The cloud has changed all that, creating a democracy in which teraflops are accessible to people well outside…

Pythian helps AEG Presents target the right prospects at the right time

November 30, 2018

AEG Presents is a company focussed on driving ticket purchases for its global entertainment parent, AEG Worldwide. But it was getting tougher to compete against rival event companies by putting relevant offers in front of customers. Why? Simply because the…

How a social media platform benefits from upgraded security and performance

November 27, 2018

We recently helped a social media management platform improve its security and performance. The social media platform supports social network integrations for Twitter, Facebook, Instagram, LinkedIn and YouTube, and has more than 15 million users. The company needed to ensure…

Taking your hybrid cloud from automation to orchestration

November 14, 2018

Cloud computing has been accessible to enterprise for a little over a decade, and that milestone is significant. It’s fitting to think of the cloud as a technology that’s approaching its adolescence. Though it’s awkward and a challenge to understand…

Look sharp: an introduction to edge computing

November 8, 2018

For years, data consumption was associated with individuals: people who stream videos, play games and otherwise live life with the help of the internet. But even though the average user’s daily data consumption is expected to increase to 1.5 gigabytes…

How to get cloud analytics costs under control

November 7, 2018

Big data analytics can potentially cost big money. But being reactive instead of proactive about optimizing your analytics in the cloud can, unfortunately, cost you even more money. This may sound obvious, but making the right decisions when configuring your…

It’s official: Kubernetes is king

November 1, 2018

When it comes to container orchestration, nobody’s sitting on the fence anymore. In the four short years since it launched, Kubernetes has become the de facto standard, the platform chosen by a list of tech giants that includes AWS, Microsoft,…

More Articles >

Technical Track
Technical Track

An Oracle-based approach to the “taxi fare” prediction problem – Episode 2

February 18, 2019

This is the second part of the series on the Taxi Fare prediction problem from an Oracle perspective. You can read Episode 1 here. In this Episode, I will put our model to work. That is, I will show several…

Cloning a PDB with encrypted data in united mode – avoid ORA-00283

February 14, 2019

The purpose of this blog post is to give you some guidelines on how to avoid “ORA-00283: recovery session canceled due to errors” during a PDB clone operation and troubleshoot the same. In the Oracle documentation (link), it notes the…

An Oracle-based approach to the “taxi fare” prediction problem – Episode 1

February 14, 2019

Although I haven’t produced a lot of posts, those I have produced were always strictly related to the Oracle RDBMS as a whole product, basically a record of interesting findings that came up during my day-to-day job. Now, this is…

Automating Oracle patching with an Ansible module

February 13, 2019

This is a blog post I had on my To Do list for quite some time. I finally found some time to write about it. I will try to keep it short and clear. In 2017 when I discovered Ansible,…

How to build your very own Cassandra 4.0 release

February 13, 2019

Over the last few months, I have been seeing references to Cassandra 4.0 and some of its new features. When that happens with a technology I am interested in, I go looking for the preview releases to download and test….

Creating a custom Oracle EBS preinstall RPM for RHEL7

February 12, 2019

Oracle, by default, ships preinstall RPMs only for Oracle Linux. Preinstall RPMs make the life of DBA very easy by taking care of installing full laundry lists of required prereq RPMs for Oracle E-Business Suite, as well as setting all required…

Rotating your ProxySQL log files

February 11, 2019

Recently I received several questions about rotating log files for ProxySQL, so I decided to draft it up as a blog post. Let me go by this using an example. In my testing lab, I have set up a fairly…

Achieving rock-solid maintenance with template-based action plans

February 7, 2019

Pythian has always been serious about reducing human mistakes. Our consultants have always been required to log all terminal outputs for the work we execute so that the information is available to our clients, and to make sure the same…

Listener over Infiniband on Exadata (part 1)

February 6, 2019

Nice topic, right? Beautiful thing to work with when you have Oracle Engineered Systems. So, why would you configure a listener over the InfiniBand Network? How does that make sense in your environment and how would you leverage that? Background…

Monitoring your 5.7 InnoDB cluster status

February 4, 2019

Recently we had a customer who came to us for help with monitoring their InnoDB cluster setup. They run a 5.7 InnoDB cluster and suffered from a network outage that split up their cluster leaving it with no writeable primaries….

How to determine RMAN backup size

February 1, 2019

A time long ago, I wrote a SQL query to determine RMAN backup size. Here is another validation for the SQL query. Why is this important? Because, as part of a backup review, it’s good to know the growth for the backup…

Reviewing the operation modes of Oracle GoldenGate BigQuery Handler

January 31, 2019

GoldenGate for Big Data 12.3.2.1.1 introduces a new target – Google BigQuery. BigQuery handler can work in two Audit log modes: 1. auditLogMode = true 2. auditLogMode = false I want to review the differences between these two operation modes…

Examining select announcements from Microsoft Ignite 2018

January 30, 2019

I recently joined Chris Presley for a special version of his podcast, Cloudscape, to talk about some of the recent announcements at Microsoft Ignite 2018. Topics of discussion included: SQL 2019 Azure SQL DB Hyperscale and Managed Instance Cosmos DB…

How to creates Kubernetes jobs with Python

January 28, 2019

In this blog post I will do a quick guide, with some code examples, on how to deploy a Kubernetes Job programmatically, using Python as the language of choice. For this I’m using GKE (Google Kubernetes Engine), logging via StackTrace…

How to run RHEL5/Centos5 in Google Cloud

January 25, 2019

Google cloud instances run on top of KVM hypervisor. In newer KVM versions, such as the one used in Google Cloud, virtio-scsi is used instead of an older virtio-blk storage backend. The virtio-scsi disk devices looks like: In RHEL6, a module…

What to expect at FOSDEM 2019

January 24, 2019

In just over two weeks, on Feb 2-3, FOSDEM 2019 will take place. As happens every year, the first weekend of February The University Libre de Bruxelles (ULB) opens the doors of campus Solbosch to the worldwide open source community. What…

Handling a Cassandra transactional workload

January 24, 2019

Overview of Cassandra As previously mentioned in my notes on lightweight transactions, Cassandra does not support ACID transactions. Cassandra was built to support a brisk ingest of writes while being distributed for availability. Follow the link to my previous post…

Log buffer #558: a carnival of vanities for DBAs

January 22, 2019

This log buffer edition overs cloud, Oracle, PostgreSQL and MySQL. Cloud On December 4, 2018 Microsoft’s Azure Database for Open Sources announced the general availability of MariaDB. This blog intends to share some guidance and best practices for alerting on…

Achieving data integration zen: building your business case

January 20, 2019

The closely related issues of siloed data and a lack of data integration – stemming, in part, from reliance on older data warehouses and a general inability to establish proper data governance – aren’t just slowing down your business intelligence…

A brief look at recent Google Cloud Platform releases

January 17, 2019

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 Google. Topics of discussion included: New features & data platform:         Cloud Tasks: A…

More Articles >

Pythian Life
Pythian Life

Achieving rock-solid maintenance with template-based action plans

February 7, 2019

Pythian has always been serious about reducing human mistakes. Our consultants have always been required to log all terminal outputs for the work we execute so that the information is available to our clients, and to make sure the same…

A day in the life of a Red Cross volunteer

October 22, 2018

In addition to my day job working as a team manager at Pythian, I am fortunate to be part of a specialist Red Cross volunteer team called an Emergency Response Unit (ERU). There are many of these ERUs around the…

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…

More Articles >