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…
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…
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…
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…
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…
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…
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…
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. …
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. …
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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,…
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,…
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…
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 …
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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. …
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…
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…
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…
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….
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…
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…
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…
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,…
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…
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…
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…
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…
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,…
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…
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…
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…
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…
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…
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…
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…