Official Pythian® Blog
Official Pythian® Blog
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…
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….
“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…
“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…
“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…
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…
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…
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…
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…
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…
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…
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…
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…
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….
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…
“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…
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…
“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…
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…
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…
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…
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)…
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…
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…
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…
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…
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…
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….
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…
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….
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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….
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…
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…
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…
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…