-
North America: +1-866-798-4426
-
APAC: +61 (0) 2 9191 7427
-
Europe: +44 (0) 20 3411 8378
Pythian will be at Percona Live 2019 – Join us in Austin, Texas!
Percona Live provides the open source database community with an opportunity to discover and discuss the latest open source trends, technologies, and innovations. The conference includes the best and brightest innovators and influencers in the open source database industry. This…
Big mining gets a boost from big data
What do you do when the breakdown of a single vehicle could cost you a million dollars? Easy: you avoid breakdowns at all costs. That’s exactly what Canada’s largest mining company is doing through a Google Cloud Platform artificial intelligence…
Personal Finance Company Develops Secure Data Sharing With Assistance from Pythian’s Experts
A large personal finance company benefitted from Pythian’s expertise to help them share data securely and keep customer information safe. Pythian provided Google BigQuery expertise and developed innovative solutions to ensure secure multi-tenancy access to their data. The finance company…
Unleash the power of your data with Pythian at DBTA Data Summit 2019
Pythian is the Diamond Research and Keynote Sponsor at Data Summit 2019 in Boston on May 21 to 22. See you there! The theme of this year’s DBTA Data Summit is “unleashing the power of your data” – exactly what…
Online Retailer Gains Business Efficiencies With Help From Pythian’s Cloud Experts
A major online retailer joined forces with Pythian to help improve their efficiency delivering new service features. With the help of Pythian’s Cloud Consulting Services, the retailer determined that they needed to migrate their two large on-premises data centers to…
3 Key Data Analytics Announcements from Google NEXT 2019
Google NEXT 2019 was a momentous event for the Pythian team. We celebrated winning the Google Cloud Global Data Analytics Partner of the Year award, had a chance to meet with customers and Googlers, and had many conversations about the…
Is Application Refactoring Right for Your Organization?
The following is the first in a series of blog posts covering Pythian’s Application Migration webinar series, where host Chris Presley discusses several application migration-related topics. Recently, he spoke with Alex Zadoroshnyi and Pierig Le Saux about the topic of…
Reduce costs by adding a data lake to your cloud data warehouse
By Lynda Partner, VP Analytics as a Service and Danil Zburivsky, Director of Engineering When it comes to data warehouse modernization, we’re big fans of moving to the cloud. The cloud brings unprecedented flexibility that allows you to easily accommodate…
Top big data analytics trends hold true well into 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…
Anthos Is The Future of Cloud Transformation
This blog post is co -authored by Alex Zadorozhniy – DevOps Technical Director and Bill Fraser – Principal Consultant in Customer Service Delivery at Pythian. On Tuesday, Google announced the general availability of Anthos, a re-branding of its Cloud Services Platform,…
Pythian Wins 2018 Google Cloud Data Analytics Partner of the Year Award
Google Cloud Recognizes Pythian’s Technical Proficiency and Proven Success In Data Analytics Pythian announced that it has received the 2018 Google Cloud Global Data Analytics Partner of the Year award. This award was presented at the Partner Summit at Google…
How AEG Presents uses data to boost client engagement for Coachella and other events
AEG Presents is a seasoned veteran when it comes to staging high-profile concerts with first-class artists and venues like Coachella and the New Orleans Jazz Festival. But the organization recently realized it had a problem getting the most out of…
How Pythian and Google helped reduce pesticide use in high-value crops
Semios is a Vancouver-based data analytics company for growers of high-value crops such as almonds and apples. It uses a combination of machine learning, in-crop wireless networks and half a million IoT sensors across 80,000 acres to offer real-time monitoring…
Pythian is at COLLABORATE 19 – Join us in San Antonio!
COLLABORATE is the largest independently run Oracle conference in the world and as always, Pythian will be there in full force with several of our Oracle experts speaking on topics ranging from Oracle to open-source to cloud and more. This…
How Pythian Helped a Company Migrate 1,100 Websites to GCP in Just 30 Days
When VerticalScope, a Canadian digital media and entertainment firm, wanted to automate the cloud migration of their digital assets and inventory, they came to Pythian for help with accelerating the process. VerticalScope operates a large number of high-traffic websites and…
Pythian Loud and Proud at Google Cloud Next ’19
I’ve just celebrated my 9th anniversary at Pythian. Wow, have we ever grown from the 65-person Oracle database-focused company we were in 2010. Today, we have significantly elevated conversations with clients to be much more transformative and strategic, over and…
Workload migration: Staying calm when it’s more than just lift and shift
To no one’s surprise, the world’s migration to the cloud is continuing to ramp up in both speed and volume. According to forecasts from Gartner, the worldwide public cloud services market will grow by 17.3% this year. Revenues are expected to total…
How to get more from marketing data with a Marketing Data Platform on Google Cloud Platform – Part 1
The power behind today’s most successful online marketing programs is the sheer abundance of data available to drive strategy, engagement and activation. But before you can use that bounty of insight to segment, target and engage prospects, as well as…
Kubernetes: The Easy Button for Enterprise
Krista Colby-Wheatley explains why Kubernetes has recently become the dominant player in the deployment, scaling and management of applications.
Dismantling data silos through cloud integration
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…
More Articles >
Troubleshooting Failed Database Startup after GRID Out Of Place (OOP) Rollback
GRID Out Of Place (OOP) patching completed successfully for 18.6.0.0.0. GRID_HOME=/u01/18.3.0.0/grid_2 ORACLE_HOME=/u01/app/oracle/12.1.0.1/db1 Here is an example of the inventory after patching. Run cluvfy was successful, too. GRID OOP Rollback Patching completed successfully for node1. GRID OOP Rollback Patching completed successfully…
Pythian will be at Percona Live 2019 – Join us in Austin, Texas!
Percona Live provides the open source database community with an opportunity to discover and discuss the latest open source trends, technologies, and innovations. The conference includes the best and brightest innovators and influencers in the open source database industry. This…
Exposing MyRocks Internals Via System Variables: Part 4, Compression and Bloom Filters
In this blog post, we continue on our series of exploring MyRocks mechanics by looking at the configurable server variables and column family options. In our last post, I explained at a high level how data moves from its initial…
How To Remove Grid 12.2 After an 18c Upgrade
The environment started with a GRID 12.1.0.1 installation, upgraded to 18.3.0.0, and performed out-of-place patching (OOP) to 18.6.0.0. As a result, there are three GRID homes and, ideally, we should remove 12.1.0.1 to save space because it’s longer required. This…
Five Ways to Migrate Your On-Premises SQL Database to Azure
There are currently three deployment options for SQL Server Database on the cloud. Well, four, if you count Azure SQL Databases in elastic pool. But Azure SQL DB in elastic pool is essentially just Azure SQL Databases grouped into an…
How to use mount-dbfs.sh to resolve “Device or resource busy”
I was not satisfied with using fuser -mv to identify processes causing DBFS failure to unmount and killing the processes haphazardly. Upon further investigation, mount-dbfs.sh can be used to kill processes causing “Device or resource busy” and unmount DBFS. One…
Exposing MyRocks Internals Via System Variables: Part 3, Compaction
In this blog post, we continue our series of exploring MyRocks mechanics by looking at the configurable server variables and column family options. In our last post, I explained at a high level how data moves from immutable memtables to…
How to Fix SQL Backup to URL Error: The remote server returned an error: (400) Bad Request
Problem: You are trying to take a native SQL Backup to URL and you receive the error below: Msg 3271, Level 16, State 1, Line 1 A nonrecoverable I/O error occurred on file “https://MyStorageAccount.file.core.windows.net/MyContainer/Adventureworks_full_20190420.bak:” Backup to URL received an exception…
How to run DBSAT against Oracle RDS database
The scope of this article is to show how to run DBSAT (Oracle Database Security Assessment Tool) against an Amazon RDS Oracle instance. This is based on a real-life execution. The DBSAT version used was 2.0.2 over an RDS database…
Harnessing the power of Jinja2 with Ansible
Configuration files management is the core component of every configuration management tool. Templates are one of the best methods for creating configuration files as they allow dynamic variables. Ansible has a template module that uses Jinja2 in its core. Jinja2…
A Simple Command That Saved Me
So there I was, reviewing the environment to create an action plan for patching. To my surprise, I noticed the following when checking DBFS: I will demonstrate the simple command I used to ensure that all services that are supposed…
How to run DBSAT on RAC Instances
The scope of this article is to provide a brief summary of how to run Oracle Database Security Assessment Tool (DBSAT) on Oracle Real Application Cluster using the parameters to exclude sections on the Reporter to avoid duplicated information into…
Unleash the power of your data with Pythian at DBTA Data Summit 2019
Pythian is the Diamond Research and Keynote Sponsor at Data Summit 2019 in Boston on May 21 to 22. See you there! The theme of this year’s DBTA Data Summit is “unleashing the power of your data” – exactly what…
Exposing MyRocks Internals Via System Variables: Part 2, Initial Data Flushing
In this blog post, we continue on our series of exploring MyRocks mechanics by looking at configurable server variables and column family options. In our last post, I explained at a high level how data first entered memory space and…
How to Fix SQL Backup to URL Failure – Operating system error 50
Problem: You run an SQL backup to URL and get the following error: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device ‘https://<mystorageaccountname>.blob.core.windows.net/<mycontainername>/AdventureWorks_full_20190420.bak’. Operating system error 50(The request is not supported.). Msg 3013, Level 16, State 1,…
How to fix the status of of the Oracle GI CRS after a failed upgrade
A couple of weeks ago I was working on a two-node Oracle Grid Infrastructure upgrade from 12.1 to 18.5. Everything was going great as both rootupgrade.sh scripts ran correctly, so the only thing pending to run was the gridSetup.sh -executeConfigTools …
3 Key Data Analytics Announcements from Google NEXT 2019
Google NEXT 2019 was a momentous event for the Pythian team. We celebrated winning the Google Cloud Global Data Analytics Partner of the Year award, had a chance to meet with customers and Googlers, and had many conversations about the…
How to troubleshoot a failure to mount DBFS
Stop a CRS error with [Stop of ‘ora.crsd’ on ‘host02’ failed.]. I will demonstrate my attempts to troubleshoot and identify the cause for failure. # crsctl stop crs DBFS is registered and managed by CRS: $ $GRID_HOME/bin/crsctl stat res -w…
How to fix SSIS Deployment Error “Please Create a Master Key”
Problem: You are deploying a SQL Server Integration Services Package to the SSIS Catalog and keeps on failing with the following error: The error is succinct and direct to the point: “Please create a master key in the database or…
Exposing MyRocks Internals Via System Variables: Part 1, Data Writing
Series Introduction Back in 2016 I decided to write a blog series on InnoDB in hopes that it would help give a good description of the high level mechanics of the storage engine. The main motivating factor at that time…
More Articles >
Achieving rock-solid maintenance with template-based action plans
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
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!
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
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
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
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
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
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
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
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
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
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!
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
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
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
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?
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
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
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
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…