Business Insights
Business Insights

Infographic: What is Data Governance?

March 25, 2020

An explainer on achieving consistency, trustworthiness, and accessibility across your data estate. The Wild West might be entertaining in movies or TV, but it’s the equivalent of a horror show when it comes to your organization’s data. That’s why strong…

Our Commitment to You During COVID-19

March 17, 2020

In light of the continued spread of Coronavirus (COVID-19) globally, we want to let our clients know how Pythian is prepared to continue providing the high standard of service you’ve come to expect. Our leadership team has developed an action…

The top 5 reasons you need a data governance strategy

March 17, 2020

The concept of good governance is key to any high functioning society and economy. It helps establish and maintain trust between constituents and their representatives, along with setting the stage for people and organizations to operate within a well-defined framework…

Advice for Remote Work Planning

March 12, 2020

With many companies investigating or enacting remote work options in response to the COVID-19 outbreak, the Pythian team would like to share their best advice to those companies considering a move to remote work. Here are some of our remote…

Defining “real-time’ or ‘streaming’ analytics and its use cases

March 5, 2020

This is the first in a series on real-time or streaming data analytics best practices, including terminology, system design and examples of real-world success. In this initial post, we’ll focus on terminology and possible use cases. When launching a multi-part…

Datascape Podcast Episode 39 – February 2020 Cloud updates

February 26, 2020

In this episode, Warner Chaves, Stephane Frechette, Pierig LeSaux and I distill the most interesting, recent updates from Google, Amazon and Microsoft.

Cloud Maturity: How cricket, fashion and mining organizations adopted cloud for data success 

January 21, 2020

Lynda Partner, Pythian VP Marketing and Analytics, is presenting tales of cloud analytics success at the Big Data and Analytics Summit Canada in Toronto. It’s not often said that cricket batsmen, luxury fashion buyers, and mining engineers have much in…

Are reverse cloud migrations a thing?

January 13, 2020

At Pythian, we spend the vast majority of our time helping our customers take full advantage of the public cloud. But there is always that tiny percentage that comes to us asking if we can move them from the cloud…

Datascape Podcast Episode 38 – December Cloud Update

December 20, 2019

Welcome to the December episode of our cloud update podcast. We are joined today by three industry experts who talk about the latest developments from the leading public cloud vendors: Google Cloud Platform (GCP), Amazon Web Service (AWS), and Microsoft…

Black Friday is in the books. Did your IT systems keep up?

December 11, 2019

Black Friday weekend is over. If you’re either an online or bricks and mortar retailer, then congratulations – you made it! We at Pythian hope you crushed your online sales targets these last few days with the help of your…

Three Agile Fixed Price Contract Types You Should Consider

December 10, 2019

We all know that Agile methods provide great flexibility and allow us to manage priorities and constantly changing requirements. The caveat here is that these flexibilities and adaptabilities will eventually create problems when we package it in a fixed-price contract…

2019 Tech Geek Gift Giving Guide

December 5, 2019

It’s that time of year again!  Each year around the holidays, we offer gift ideas for the tech geek on your list — any data lover, IT pro, or fan of cool technology. And this year is no exception. The…

Pythian Announces Support for AWS Outposts As A Launch Partner

December 4, 2019

Today at AWS re:Invent, Amazon Web Services (AWS)’s most important tech conference of the year, AWS Outposts was announced. As Amazon says in its release notes, “AWS Outposts is a natural extension of AWS cloud services towards on-premises and bringing…

Datascape Podcast Episode 37 – Recapping Microsoft Ignite 2019 with Warner

November 21, 2019

If you don’t want to read through a 78-page PDF document but still want to know what went down at Microsoft Ignite 2019, then this episode is for you! Warner Chaves joins us for our third recap episode of the…

Cutting Costs And Building Sales By Migrating To Google Cloud Platform

November 7, 2019

If you’re running any kind of e-commerce enterprise, you already know that your business lives and dies by the speed of your page loads. Online shoppers are notoriously impatient, and every second of delay for the user increases the likelihood…

Top big data analytics trends hold true as we look toward 2020

October 4, 2019

The overall importance of data and information within organizations has continued to grow. We’ve also seen the continued rise of megatrends like IoT, big data – even too much data – and of course, machine learning. That’s along with the…

How the England and Wales Cricket Board scored with big data

October 1, 2019

The England and Wales Cricket Board governs every aspect of the sport in those two countries, and it holds massive amounts of data generated by professional and amateur players alike. Since its founding in 1997, the ECB has collected information…

How to migrate from Teradata to Google BigQuery

September 30, 2019

Google BigQuery is a serverless, highly scalable, low-cost enterprise data warehouse that helps data analysts become more productive. It enables extremely fast analytics on a petabyte scale. And its pay-as-you-go model makes it attractive for organizations looking to move away…

Join Pythian for Percona Live Europe 2019 Amsterdam

September 23, 2019

Percona Live is always a great opportunity to learn from the best and brightest in the open-source database community. This time, Percona Live Europe is being held at the Hilton Amsterdam Airport Schiphol, The Netherlands from September 30 to October…

Can you run Hadoop in the cloud?

September 17, 2019

As a solutions architect at Pythian, I often get questions from clients about the many solutions available to them to address their big data needs. Between Hadoop, cloud-based, and hybrid solutions, finding the best option for their unique needs can…

More Articles >

Technical Track
Technical Track

World Backup Day – The MySQL perspective

March 31, 2020

Today is World Backup Day, reminding us of the importance of backups. Here at Pythian we LOVE YOUR DATA and as database consultants we are therefore very much focussed on making sure that our client’s data is always secure and…

World Backup Day – Protect Your Oracle Databases

March 31, 2020

How do you know your Oracle Backups can be used to restore a database? Here is how to find out.

Backup Oracle to Amazon AWS S3 – Part 1

March 30, 2020

Backups of Oracle Databases can be made directly to s3, without licensing additional software.

SQL – Managing Jobs in Availability Groups

March 26, 2020

This blog post will show how to dynamically add logic at the beginning of jobs in Availability Groups in order to avoid job execution errors in the replica or replicas. Problem In SQL Availability Groups the SQL jobs have to…

Managing SQL Jobs in Availability Groups – Method Job Category

March 26, 2020

Method – Job Category This blog post will show how to setup SQL Jobs in multiple availability groups. This method will allow you to dynamically detect the role of the SQL Server replica and avoid job execution errors in the…

Upgrade SQL Server Reporting Services to 2017

March 24, 2020

In the past, we could run the SQL installer to do an in-place upgrade of SQL server including the SSRS instance to a newer version. As of 2017, SSRS is a separate install from SQL server, so this is no…

Datascape Podcast Episode 40 – What is Azure Analytics Synapse?

March 19, 2020

If you were a preexisting SQL Data Warehouse customer, then you’re technically now a Synapse customer using an SQL pool. In this episode, Chris sits down with Warner to discuss Azure’s SQL DW rebranding to Azure Synapse Analytics. The rebranding…

The Shift in Top Big Data Analytics Trends for 2020

March 18, 2020

In 2019, we forecasted and highlighted the top trends in big data analytics. Today we will be revisiting this topic to explore how the trends have progressed as time has evolved. As we dive deeper into the digital age, the…

Webinar | Azure SQL Database: Serverless & Hyperscale

March 18, 2020

I wrote a blog post on this subject last year when Azure SQL Database Serverless was first introduced. This year I was excited to present it for Microsoft Ignite: The Tour Singapore before it was canceled because of the growing…

Using FreeRadius to Authorize Oracle Connections

March 18, 2020

Jared Still shows you how to setup the open source RADIUS server FreeRadius so it may be used to authenticate database connections.

Our Commitment to You During COVID-19

March 17, 2020

In light of the continued spread of Coronavirus (COVID-19) globally, we want to let our clients know how Pythian is prepared to continue providing the high standard of service you’ve come to expect. Our leadership team has developed an action…

Advice for Remote Work Planning

March 12, 2020

With many companies investigating or enacting remote work options in response to the COVID-19 outbreak, the Pythian team would like to share their best advice to those companies considering a move to remote work. Here are some of our remote…

Resolving an Availability Group Sync Issue – HADR_AR_CRITICAL_SECTION_ENTRY

March 10, 2020

We recently ran into an interesting issue on a three-node SQL Server Availability Group (AG) cluster. There was a cluster failure that impacted the availability group for a few minutes during which the replicas changed to resolving state. Once the…

CRS-10051: CVU found following errors with Clusterware setup

March 9, 2020

I recently found this interesting message error in a CRS alert log from a client environment: 2019-08-26 16:33:53.277 [SRVM(9624)]CRS-10051: CVU found following errors with Clusterware setup : PRCW-1015 : Wallet pythiandb does not exist. CLSW-9: The cluster wallet to be…

Defining “real-time’ or ‘streaming’ analytics and its use cases

March 5, 2020

This is the first in a series on real-time or streaming data analytics best practices, including terminology, system design and examples of real-world success. In this initial post, we’ll focus on terminology and possible use cases. When launching a multi-part…

How to Read Oracle Traces from SQL*Plus

March 4, 2020

Let’s say you need to read trace files from Amazon Relational Database Service (RDS). How do you do it? Here is an example of how to list and read those files using rdsadmin: SQL> select * from dba_directories; OWNER DIRECTORY_NAME…

Getting started with Cloud SQL for SQL Server

March 3, 2020

Finally Cloud SQL for SQL Server is now available in beta. Announced at Google Next ‘19, Cloud SQL Server is a managed database service that makes it easy to set up, maintain, manage, and administer your SQL Server databases on…

How to Quickly Ignore ORA Error on Agent Layer

March 2, 2020

I had a very specific situation where I wanted to ignore an error from a specific agent. It turns out that it is easier and quicker to ignore a specific error using an OEM Metric. How? By using an agent parameter….

Datascape Podcast Episode 39 – February 2020 Cloud updates

February 26, 2020

In this episode, Warner Chaves, Stephane Frechette, Pierig LeSaux and I distill the most interesting, recent updates from Google, Amazon and Microsoft.

Use RMAN KEEP Backup To Roll Back From an Upgrade

February 25, 2020

There is a requirement to back up a database before an application upgrade to be able to rollback. Guarantee Restore Point (GRP) was first considered by us; however, it looks like there is insufficient space from Flash Recovery Area (FRA)….

More Articles >

Pythian Life
Pythian Life

Ten Tips When Working from Home During These COVID-19 Times

March 30, 2020

During this COVID-19 time, business is no longer as usual. Recently I have had a few contacts asking me for tips on how to work remotely. Why? Well, I have been working from home for ten years now. Working remotely, …

22 Ways to Make Remote Work, Work!

October 29, 2019

If I offered you a job that would allow you to live anywhere you wanted, where you could wake up and start work at any time, and never be stuck in traffic… would that check some of the boxes on…

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…

More Articles >