Business Insights
Business Insights

Myths of Google Workspace

May 3, 2021

At Pythian we know Google Workspace is a comprehensive suite of business productivity tools that drives enterprises to become more agile, more data driven, more collaborative, more productive and more engaged. Those already using Workspace understand the competitive edge it…

COVID-19’s Impact on Enterprise Cloud Adoption

April 26, 2021

While public cloud adoption has been growing rapidly, it’s not surprising that 2020 brought it to a new level as the global pandemic made “remote” the default for schooling, working and meetings. What’s interesting is how cloud adoption is happening….

Move Forward by Working Faster

March 18, 2021

“If you’re not moving forward, you’re falling back.” — Sam Waterston Despite – and, in some cases, because of – all the uncertainty we’ve faced recently, organizations are working hard to keep up with delivering the experiences, products and services…

Supporting Your Remote Workforce by Improving Access to Information and Ideas

March 12, 2021

“The value of an idea lies in the using of it.” — Thomas Edison Previously, many ideas were used and shared in classic “water cooler” situations – bumping into colleagues in the hall, sharing a coffee or even washing hands…

Embracing Flexibility to Improve Your Remote Team’s Performance

March 8, 2021

“Flexibility is the key to stability.” — John Wooden Hands up if you could use a little stability these days. With businesses facing so many factors beyond their control, stability can seem like an unattainable dream. We’d argue you can…

Cloud Cost Management and Optimization at Pythian: An Introduction

March 1, 2021

The shift to the cloud as “the new normal” has materially changed not just the technical, but also the financial landscape of computing. Centralized purchasing and price/volume negotiations have given way to ad hoc purchases of cloud resources throughout the…

Datascape Podcast Episode 46: Recapping Re:Invent 2020 With Apoorva

February 22, 2021

Episode 46: Show Notes The recent AWS re:Invent conference came with a barrage of updates and releases that have innovated what we can do on the cloud. Today we welcome Pythian Cloud Architect, Apoorva Wathodkar to recap our top highlights…

Datascape Podcast Episode 45: Recapping Microsoft Ignite 2020

February 18, 2021

Episode 45: Show Notes Our good friend Warner Chaves joins us again today on the show, this time to discuss some favorite updates from the Microsoft Ignite 2020 virtual conference. We start out hearing some pros and cons of the…

Pythian Achieves Managed Services Provider (MSP) Status

February 16, 2021

More than ever, Pythian is positioned to deliver value to clients using Google Cloud by leveraging our extensive managed service experience. After passing a rigorous third-party audit requiring the company to demonstrate our end-to-end customer lifecycle service delivery capabilities, Pythian…

Pythian Earns Data Management Partner Specialization

February 12, 2021

Here at Pythian, our mission is simple – we want you to love your data. To ensure our 650+ clients located around the world – spanning industries from SaaS, media and gaming, to financial services, e-commerce and more – keep…

Top Five Chrome Myths Debunked

December 17, 2020

Sometimes the best way to dispel a myth is to start with a concrete example. Here’s a great example from a client we worked with: QAD Inc. provides enterprise resource planning software and related enterprise software to manufacturing companies. By…

Migrating Oracle Workloads to Google Cloud – PostgreSQL on Cloud SQL or GCE

December 14, 2020

When working with clients on database migration, there are a range of options we help them assess and evaluate. These include: Bare Metal Solution (BMS) PostgreSQL On Cloud SQL On GCE (Google Compute Engine) Cloud Spanner Some organizations choose BMS…

Migrating Oracle Workloads to Google Cloud – BMS

December 9, 2020

In these challenging and ever-changing times, most organizations would welcome the opportunity to reduce overhead, drive innovation and become more agile. While all these benefits are possible with a move to the cloud, many organizations are overwhelmed at the thought…

2020 Tech Geek Gift-Giving Guide

December 3, 2020

Here at Pythian we love being helpful, and that desire to help extends to the holidays. It’s become a tradition for us to offer a round-up of gifts for lovers of all things techie, and this year is no exception….

Will Your Database (and Sales) Survive Christmas 2020?

December 1, 2020

The 2020 edition of Black Friday and Cyber Monday is now behind us. But smart organizations are still studying it closely. That’s because, for better or worse, Black Friday and Cyber Monday have a lot to say about how well…

Embracing the New Normal With Google Workspace – Part Three

November 2, 2020

“Companies that change may survive, but companies that transform thrive.” — The 4 Dos of Change Management, Nick Candito, Forbes.com For many people and companies, the first part of the COVID-19 pandemic was all about holding on. Survival alone was…

Embracing the New Normal with Google Workspace – Part Two

October 28, 2020

In the first post of our “New Normal” series, we outlined our predictions for the future of remote work. Here’s a brief recap of what we, at Pythian, see coming: Remote work will become the norm. Businesses will reconsider the need…

Embracing the New Normal with Google Workspace – Part One

October 23, 2020

“The only thing that is constant is change.” – Heraclitus, Greek Philosopher, 535 BCE to 475 BCE While change might be a hot topic of discussion since the arrival of the novel coronavirus, the above quote is a reminder that…

Thriving Through Change with Google Workspace

October 21, 2020

Work has been transforming as long as we’ve been doing work. Companies have always needed to adapt to new societal, technological, and global developments. The current pace of transformation, however, is something entirely new. It’s not an exaggeration to say…

Leading Through Crisis – What Ernest Shackleton Can Teach Us About the COVID Pandemic

September 17, 2020

In January 1915, polar explorer Ernest Shackleton’s ship became trapped in ice near Antarctica. For the next two years, he kept his crew of 27 men alive on a drifting ice cap, before leading them to safety. In this article…

More Articles >

Technical Track
Technical Track

Oracle April 2021 Update Security Improvements on TLS (Transport Level Security)

May 13, 2021

If your application uses Java 1.7 that connects to Oracle Database securely over TCPS (Transmission Control Protocol with SSL), and you keep your security patching up to date, the latest Oracle April 2021 security updates may raise some challenges for…

Enable Oracle Flash Cache on Red Hat Linux

May 6, 2021

The Oracle Smart Flash Cache feature was originally introduced in the 11gR2 version of Oracle Database. It works as an extension of the buffer cache in System Global Area (SGA). With this feature, instead of removing least recently used (LRU)…

Replicating MySQL to Snowflake with Kafka and Debezium—Part One: Data Extraction

May 5, 2021

What, Snowflake? Yes, Snowflake. While my core skills are based on the Oracle database, lately I’ve been working more on platforms like BigQuery and Snowflake—”lately” being the last one-and-a-half years or so. While this is my very first post related…

Near Real-Time Data Processing for BigQuery: Part Two

May 4, 2021

This post is part two of describing (near) real-time data processing for BigQuery. In this post, I will use Dataform to implement transforms as well as ASSERTS on the data and unit testing of BigQuery code and SQL statements. Part…

Myths of Google Workspace

May 3, 2021

At Pythian we know Google Workspace is a comprehensive suite of business productivity tools that drives enterprises to become more agile, more data driven, more collaborative, more productive and more engaged. Those already using Workspace understand the competitive edge it…

WebLogic Admin Console 12.2.1.4.0 Is Not Starting Due to Coherence GE 12.2.1.4.0

April 30, 2021

In this post I’ll address the situation where, after installing Fusion Middleware (FMW) 12.2.0.4, the WebLogic Admin Server won’t start due to an issue reported on Coherence, one of the embedded components of FMW (Forms/Service Bus/SOA Architecture). You will face…

Data Guard Broker—ORA-16714: The Value of Property LogFileNameConvert Is Inconsistent with the Database Setting

April 29, 2021

This seems like a simple message to fix, right? The parameter is different between the broker configuration and the database parameters—it was most likely changed directly on the database after the DG (Data Guard) broker configuration was created or the…

Automating APEX Applications Backup

April 28, 2021

In a previous post, I discussed that the APEXExport tool may be the best one to use when exporting APEX applications. You may also have experience using this tool. Today, I’d like to present some alternatives to the APEXExport tool….

“The Cluster Upgrade State is [ROLLING PATCH]” with Correct Patch Level in all Nodes

April 27, 2021

I was performing a spot health check in a client environment, when I encountered this: [oracle@dbserver1 ~]$ crsctl query crs releaseversion Oracle High Availability Services release version on the local node is [12.1.0.2.0] [oracle@dbserver1 ~]$ crsctl query crs activeversion -f Oracle…

COVID-19’s Impact on Enterprise Cloud Adoption

April 26, 2021

While public cloud adoption has been growing rapidly, it’s not surprising that 2020 brought it to a new level as the global pandemic made “remote” the default for schooling, working and meetings. What’s interesting is how cloud adoption is happening….

Post-Mortem Analysis Tools: Using Preliminary Connection

April 22, 2021

Editor’s note: This “post-mortem analysis” series consists of four posts in total. Make sure you also check out: Post-Mortem Analysis Tools: Systemstate Dump Post-Mortem Analysis Tools: ASH Dump Post-Mortem Analysis Tools: Hanganalyze Now, onto today’s post: Many DBAs have been…

Post-Mortem Analysis Tools: Hanganalyze

April 21, 2021

Editor’s note: This “post-mortem analysis” series consists of four posts in total. Make sure you also check out: Post-Mortem Analysis Tools: Systemstate Dump Post-Mortem Analysis Tools: ASH Dump Post-Mortem Analysis Tools: Using Preliminary Connection (publishing Thursday, April 22) Now, onto…

Post-Mortem Analysis Tools: ASH Dump

April 20, 2021

Editor’s note: This “post-mortem analysis” series consists of four posts in total. Make sure you also check out: Post-Mortem Analysis Tools: Systemstate Dump Post-Mortem Analysis Tools: Hanganalyze Post-Mortem Analysis Tools: Using Preliminary Connection (publishing Thursday, April 22) Now, onto today’s…

Post-Mortem Analysis Tools: Systemstate Dump

April 19, 2021

Editor’s note: This “post-mortem analysis” series consists of four posts in total. Make sure you also check out: Post-Mortem Analysis Tools: ASH Dump Post-Mortem Analysis Tools: Hanganalyze Post-Mortem Analysis Tools: Using Preliminary Connection (publishing Thursday, April 22) Now, onto today’s…

Near Real-Time Data Processing for BigQuery: Part One

April 15, 2021

This post describes (near) real-time data processing for BigQuery with unique and other check constraints, and unit testing. This is part one of two, and describes the real-time ingestion of the data. Part two will describe how to implement ASSERTS…

Moving APEX Applications Repository with APEXExport

April 14, 2021

Most likely you’ve landed here because you need to migrate APEX applications/workspaces from one database to another. If so, you’re in the right place! We’ll use APEXExport to accomplish this. I’m providing a quick summary of the steps for using…

How to Clean up Trace and Audit Files for Multiple Homes

April 13, 2021

I’ve been working on a simple method to clean up audit and trace files for multiple homes. Let’s see how grid and database homes can be found from oratab. $ sort -u -t : -k 2,2 /etc/oratab | grep -v…

Creating a Read-Only Account on Database with VPD or Label Security

April 12, 2021

I have an interesting case to share in this post. The story started when a client asked for a read-only account (let’s call it RO_USER) with access to objects under another schema (let’s call it SCHEMA_OWNER). Easy going, right? Create…

Can Concurrent Processing Abort Help Automation and Predictable Maintenance?

April 9, 2021

On the surface concurrent processing (CP) looks simple; a new request is pending for a while, then it runs and is completed. However in the background it’s extremely complicated with all the statuses, schedules, permissions, incompatibilities, etc. If you’d like…

Datascape Podcast Episode 48: Recapping the Spring 2021 Microsoft Ignite Virtual Conference

April 8, 2021

Episode 48: Show Notes Spring Microsoft Ignite 2021 Conference Recap Today we are joined by Warner Chavez to hear about all the new updates in the Microsoft ecosystem that were discussed at the 2021 Microsoft Ignite Conference. We kick the…

More Articles >

Pythian Life
Pythian Life

The Pythian Talent Community

April 23, 2021

Welcome to our round up of everything new and exciting going on at Pythian! This blog post series highlights what #PythianLife is all about, from how we’re keeping our culture alive remotely to exciting new projects we’ve been working on,…

Pythian Named a 2021 Top Employer in the National Capital Region

April 16, 2021

At Pythian we recognize that to help you Love Your Data, it’s important for our employees to love what they do. That’s why we’re so gratified to be one of the 2021 winners of the National Capital Region’s Top Employers…

Top TV and Movie Picks from the Women of Pythian

March 19, 2021

At Pythian we’re known for, and proud of, our diverse group of strong women employees. One of the ways the company shares and celebrates the experiences of the women who work for Pythian is through our Pythia Slack channel. Topics…

Pythian Postcards: Fraijanes, Guatemala

March 2, 2021

Editor’s Note: Welcome to the most recent post in our “Pythian Postcards” series! We’ve visited employees around the world, including Toulouse, France and Singapore. Today, we’re very pleased to have a post from Jose Solares who’s going to help us…

Pythian Postcards: Markham, Ontario

January 22, 2021

Editor’s Note: Welcome to the fourth post in our “Pythian Postcards” series! So far we’ve visited Toulouse, France, Singapore and met Mayuri Lalwani who had recently moved from India to Mississauga, Ontario. Today, we’re so happy to have a post…

Pythian Postcards: Mississauga, Ontario … by Way of India

December 4, 2020

Editor’s Note: Welcome to the third post in our “Pythian Postcards” series! So far we’ve visited Toulouse, France and Singapore. Today, Mayuri Lalwani takes us to her new home of Mississauga, Ontario: Q: Where are you located? A: Currently in Mississauga,…

Pythian Postcards: Selamat Datang Ke Singapore!

November 4, 2020

Editor’s Note: Welcome to the second post in our “Pythian Postcards” series! Post one came to us from Toulouse, France. Today, Pio Balistoy takes us to Singapore: I usually stick to SQL Server when writing for the Pythian blog because…

Pythian Postcards: Toulouse, France … by way of Mexico

October 16, 2020

Welcome to post number one in our new “Pythian Postcards” series! These posts will spotlight Pythian employees living all over the world, to let Pythian employees learn more about each other and showcase the diversity of the Pythian workforce. We…

How To Get The Most Out Of Your Next Virtual Learning Event

September 2, 2020

COVID-19 pandemic has disrupted every aspect of our lives this year. But in July, in spite of all the upheaval, the All India Oracle Users Group (AIOUG) still managed to hold its annual Oracle Groundbreakers Yatra conference. By moving the…

We Need More Women in Tech!

May 14, 2020

Two years ago, I joined Pythian. This was my introduction to working in “tech.” The only hint of what working in tech might be like came from binge watching TV series such as “Silicon Valley” and movies like “The Social…

What to Expect When Interviewing with Pythian

May 12, 2020

Welcome to Pythian’s recruitment process! We haven’t met yet, but if you’re considering a role here at Pythian, you’ll likely be speaking with me or one of my colleagues on the Talent Acquisition team.  What We Do Our purpose at…

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

March 30, 2020

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

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…

More Articles >