Business Insights
Business Insights

Why Achieving Quick Business Wins Should Be Built Into Your D&A

June 28, 2022

Having worked in the Data & Analytics (D&A) space for decades, the struggle to gain business insights through data is constant. I’ve used many approaches; some have worked, while others looked better on paper. Over time, however, the path to…

5 Reasons to Partner with a Google Cloud Managed Services Provider

June 24, 2022

You’ve taken the leap and decided to migrate some of your workloads to Google Cloud, which are now being managed by your internal IT team. But how will you extract the most value out of your investment in the Google…

Metadata-Driven Data Governance: the How and Why

June 23, 2022

In our previous discussion, we explored the role of data stewards and their vital function for data governance programs. They’re the champions that identify data quality shortfalls and work with business partners to improve data quality. Data stewards are the…

Are You in the Right Google Workspace Relationship?

June 22, 2022

When it comes to licensing Google Workspace, one size doesn’t fit all. So how do you know if you’re getting the most out of your licenses?      When Google made the change from G Suite to Google Workspace, they…

 5 tips for businesses to build a strong relationship with data

June 22, 2022

A heart flutter. An adrenaline rush. The constant wondering of what will happen and where things will go. Wanting to spend more time, ask more questions and uncover new information to learn all you can. These are the telltale signs…

Data is the heart of business

June 21, 2022

Dear Data, Years ago, when you worked in another department, I admit that I spent only fleeting amounts of time thinking about you.   Certainly, I appreciated the fact that you were important enough to be stored securely and backed up…

Data and analytics make the world go round

June 21, 2022

Dear Data, I remember when we first met. It was waaaaay back in university when I signed up for a stats course thinking it would be easy. Turned out it was, but I didn’t really get you back then. All…

How Can Google Vault Keep You on the Right Side of Compliance?

June 17, 2022

Remote work is now the norm, not the exception. And while working from home or other locations comes with several benefits, it also has a few drawbacks—namely, security and compliance—for those tasked with managing remote and hybrid workforces.    …

Is Your Google Workspace Environment Secure?

June 13, 2022

Everyday productivity applications can hold a significant amount of corporate data, creating risk for an organization—particularly with remote and hybrid workforces, where data could reside at the ‘edge’ of the organization in laptops, mobile phones and even unregistered devices.  …

Identifying and Engaging Data Stewards

June 10, 2022

In our previous discussions, we evaluated how to kickstart our data governance programs. We discussed the cultural principles to be set, priorities to be communicated, and roles and responsibilities to be established. These elements ensure alignment in execution for data…

Top Tips for Finding a Google Cloud Partner

June 9, 2022

You’ve decided to make the move to Google Cloud—perhaps as part of a hybrid or multi-cloud strategy—for its open, secure platform and robust built-in services. But maybe you’re looking for a partner to be an extension of your IT team…

Trends in Retail

June 8, 2022

Every industry is getting transformed by data, with retail amongst the most dramatic and fastest paced. As consumers become  increasingly demanding, a seamless experience between the digital and in-store expectations for both customers and employees also evolve.     The retail industry is experiencing a…

How to Kickstart Your Data Governance Program

May 27, 2022

In our previous discussions we reviewed the two primary dimensions to a data governance program. First are the functions necessary to be successful including compliance and risk management, policy, data management, literacy, and architecture. Second is the organizational model for how these capabilities…

Building Organizational Models for Better Data Governance

May 20, 2022

In our previous post we discussed the five phases of data governance programs. These include define, design, build, transition and measure. These phases allow us to plan work, execute, and understand a program’s impact while adjusting future prioritization and maximizing…

Why Choose Google Cloud for Your Data Warehouse Migration

May 11, 2022

You’ve already moved some of your workloads to the cloud—probably the ones that were easiest to migrate, or the ones that provided a quick win. But your most complex workloads are probably still sitting in an on-prem data warehouse. While…

A Closer Look at Data Governance Program Phases

May 5, 2022

In a previous post, I outlined how designing data governance programs can deliver business value. In this post, we’ll look in greater detail at the life cycle of a typical program.     Data governance programs thrive on established and…

Why Migrate Your PostgreSQL, MySQL or SQL Server to Google Cloud SQL?

May 2, 2022

Whether you’re using a PostgreSQL, MySQL or SQL Server relational database, a migration to Google Cloud SQL can take it up a notch—automating management tasks, ensuring business continuity and staying up-to-date with security and compliance requirements. And, with a solution…

How to Migrate VMware to Google Cloud

April 28, 2022

If you’re planning to migrate VM workloads from your data center to Google Cloud, or from one cloud to another, it may be considered a relatively straightforward lift and shift. But, like most things cloud-related, migrating virtual machine (VM) workloads…

Designing Data Governance Programs that Deliver Business Value

April 19, 2022

As organizations embark on their Data Governance journey, many struggle with justifying the costs with program outcomes that have traditionally been viewed as required but not delivering significant business value. This often pits data governance programs against product initiatives in…

Moving your Oracle Database to the Cloud? Here’s Why You Should be Thinking Google Cloud

April 19, 2022

Oracle has long been a top choice for relational databases—but migrating those workloads to the cloud requires a lot more effort than a simple lift and shift. Oracle databases are typically large and complex, so if you’re looking to migrate…

More Articles >

Technical Track
Technical Track

Why Achieving Quick Business Wins Should Be Built Into Your D&A

June 28, 2022

Having worked in the Data & Analytics (D&A) space for decades, the struggle to gain business insights through data is constant. I’ve used many approaches; some have worked, while others looked better on paper. Over time, however, the path to…

5 Reasons to Partner with a Google Cloud Managed Services Provider

June 24, 2022

You’ve taken the leap and decided to migrate some of your workloads to Google Cloud, which are now being managed by your internal IT team. But how will you extract the most value out of your investment in the Google…

Datascape Episode 59: Google BigQuery Architecture, Cloud Migrations, and Working from Home with Megha Bedi

June 21, 2022

Episode 59 Shownotes Welcome to another episode of the Datascape Podcast. Cloud consultant Megha Bedi joins us from Meerut (near New Delhi) to discuss Google Cloud migrations and architecture. Megha’s impressive track record includes data and cloud project management, data…

Data Streaming with Kafka and Flink on AWS – Part 1

June 17, 2022

Apache Kafka and Apache Flink are popular data streaming applications platforms. However, provisioning and managing your own clusters can be challenging and incur operational overhead. Amazon Web Services (AWS) provides a fully managed, highly available version of these platforms that…

How to Create an Oracle SE2 Database and Avoid Licensing Problems

June 16, 2022

If you recently created an Oracle Standard Edition 2 database, you might not be in compliance with Oracle after all. There are several obscure traps you could fall into during the SE2 database creation process. This post details each step…

Build a Data Lake Using Lake Formation on AWS

June 14, 2022

A data lake is a centralized repository for large amounts of structured and unstructured data to enable direct analytics.The above image illustrates multiple functions of a data lake, such as data ingestion, data indexing, data processing, data analytics, machine learning,…

Datascape 58: Analytics in Gaming, Spark and the Data Engineer Role With Felipe Ferreira

June 14, 2022

Episode 58 Shownotes Welcome to another episode of the Datascape Podcast. In today’s episode, Brazilian native Felipe Ferreira joins us from Canada to delve into gaming data technology and analytics. Felipe has extensive experience in development, database administration, business intelligence,…

Token-Based Authentication for ADB with IAM: Part 2

June 10, 2022

In Part 1, we discussed the essentials of DB token-based authentication and looked at examples to set up authentication for IAM users with exclusive or shared schema mappings. In this second  part, we’ll look at use cases for setting up…

Online Data Migration from SQL Server to Cloud Spanner Using Striim

June 9, 2022

This post will focus on the implementation of a continuous migration from SQL Server to Cloud Spanner using Striim. It includes steps for configuring an initial load and a continuous data replication using change data capture. However, I don’t cover …

Top Tips for Finding a Google Cloud Partner

June 9, 2022

You’ve decided to make the move to Google Cloud—perhaps as part of a hybrid or multi-cloud strategy—for its open, secure platform and robust built-in services. But maybe you’re looking for a partner to be an extension of your IT team…

Trends in Retail

June 8, 2022

Every industry is getting transformed by data, with retail amongst the most dramatic and fastest paced. As consumers become  increasingly demanding, a seamless experience between the digital and in-store expectations for both customers and employees also evolve.     The retail industry is experiencing a…

How Google Cloud and Pythian Keep Your Data—and Your Reputation—Secure

June 7, 2022

While more organizations are migrating their critical workloads to the cloud for scalability and agility, the ever-increasing complexity of the cloud environment makes it more challenging to secure that environment. The ramifications of a data breach or cyberattack can be…

Token-Based Authentication for ADB with IAM: Part 1

June 3, 2022

Oracle has introduced an authentication mechanism that enables Oracle Cloud Infrastructure (OCI) users to use their Identity and Access Management (IAM) credentials to access the Autonomous Databases (ADB) transparently.       Earlier, IAM credentials could be used to access…

How to Install SQL Server Reporting Services 2019

June 2, 2022

  Problem You’re trying to install SQL Server 2019 and when you reach the feature selection SSRS is nowhere to be found. You also get this notification banner below:   Cause SSRS installation has been separated from Microsoft SQL Server…

Securing your Application with Google’s WAF Cloud Armor

May 31, 2022

If you’re running an application on the public internet, security in this day and age is key. With the adage of defense in mind, you want to have multiple layers of checks as requests get further into your application layers…

An Initial Test of Google’s AlloyDB Columnar Engine

May 30, 2022

Google just recently launched the public preview of their new customized cloud version of PostgreSQL called AlloyDB. This Google Cloud Platform (GCP) managed database service is not the same as their Cloud SQL PostgreSQL service that still exists and is…

How to Kickstart Your Data Governance Program

May 27, 2022

In our previous discussions we reviewed the two primary dimensions to a data governance program. First are the functions necessary to be successful including compliance and risk management, policy, data management, literacy, and architecture. Second is the organizational model for how these capabilities…

Datascape Episode 57: Building Big Data Platforms in Azure With Luan Moreno

May 25, 2022

Episode 57 Shownotes Welcome to another episode of the Datascape Podcast. On today’s show, Big Data expert and Microsoft data platform MVP Luan Moreno tunes in from Brazil.  Luan talks about the start of his career as a DBA, his…

Slow Query in eBS AutoConfig with DB 19c

May 24, 2022

We recently completed a few e eBS R12.2 database upgrade installations and noticed an issue with a particular SQL running as part of the AutoConfig.       The query sql_id is 5da8tjzfafw6j and it looks like this (formatted): select…

CVE-2022-21500 and Your Oracle E-Business Suite

May 20, 2022

Something  exciting happened a few days ago. It started with a tweet and a blog post, and has evolved into an official CVE-2022-21500. I thought it would be good to publish some details beyond the official MOS note document.  …

More Articles >

Pythian Life
Pythian Life

Vanakkam from Chennai to Bangalore

June 3, 2022

Attention to detail is at the heart of project management. But it’s just one of the many skills you need to manage cross-functional projects and programs effectively. This month’s postcard is from Bangalore, where dynamic project manager Bruce Christie talks…

Namaskaram from Hyderabad!

May 2, 2022

This month’s postcard comes from southern India, where Pythian foodie Rohith Kumar supports multiple aspects of marketing campaigns, corporate events and tasks. Read on to learn more about life and work in a growing city.     Where are you…

Bună from Romania!

April 10, 2022

Think project management is all routine budgeting and scheduling? In this month’s postcard, Andrei Bumbu offers a behind-the-scenes peek into his daily life and how he addresses common challenges. Read on to learn more.     Tell us about where…

Namaskāra from Bangalore

March 9, 2022

This month’s postcard comes to us from India. This is our first Pythia—aka one of the women of Pythian—spotlight of 2022. What better way to celebrate National Women’s History Month? Read on to learn more about database administrator Archita Chauhan….

A Recruiter Recruited to Recruit at Pythian

February 10, 2022

Six months ago, I joined Pythian as a Global Talent Acquisition Partner (TA). I often get asked by candidates why I chose Pythian and what my experiences have been like so far. So, here’s the scoop straight from the front…

From Cambridge to West London

February 7, 2022

This month’s postcard is from West London, United Kingdom, where a charismatic Oliver Lee-Stevens does business development, account management and support for small and large-scale clients through their IT transformation. Sales isn’t for everyone, so where does he find his…

From Lake Simcoe to Oakville

January 3, 2022

Curious about data visualization? Think it’s all about geekdom? In this latest edition of Pythian Postcards, Michael McEvenue takes us to a lovely Canadian town located on the shores of Lake Ontario. Read on to learn more about Michael, his…

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…

More Articles >