Every year, tens of thousands of IT professionals and executives visit Pythian’s blog to tap into our team’s deep expertise and experience. As 2022 comes to a close, we’d like to highlight a few of our reader’s favourites over the past year. From Pythian Life (glimpses into Pythian’s culture) to our Technical Track and Business Insights, there’s something for everyone. Did your favourites make the list?
Top ‘Pythian Life’ Blogs of 2022
‘What to Expect When Interviewing with Pythian’
From application through to your final preparation to become a Pythianite, Andrew Lang’s blog sheds some light on the interview process. Learn about our open positions, how to prepare for your first interview, and what to expect when you meet the hiring manager in ‘What to Expect When Interviewing with Pythian.’ And don’t forget to check out the FAQs!
‘Namask?ra from Bangalore’
Every month, a member of the Pythian team shares their story—including their path to Pythian, their largest challenges, their home office, what they do for fun, and much more. Readers loved learning about Archita Chauhan from Bangalore. As a Database Administrator at Pythian, she shares her rich culture, unique life experiences—from Gujarat to Bangalore—and more.
There was no better way to celebrate National Women’s History Month!
‘A Recruiter Recruited to Recruit at Pythian’
If you’ve been recently recruited at Pythian, chances are you’ve met Kirsty Harris, Global Talent Acquisition Partner at Pythian. In her blog ‘A Recruiter Recruited to Recruit at Pythian,’ she shares what drew her to the global IT services company. Between the work-life balance, collaboration, knowledge sharing, innovation, or the ‘customer-first, people always’ approach, Kirsty found a home here at Pythian.
Top ‘Technical Track’ Blogs of 2022 (per category)
In Advanced Analytics, Open Source, & MySQL: ‘Migrate RDB to Cloud SQL Using Google’s Dataflow’
Using a RDBMS (relational database management systems) to manage your organization’s data? Want to reduce error rates and make datasets easier to manage? Read Vincent Sun’s blog on migrating RDB to the cloud with Google’s Dataflow.
In AWS: ‘Build a Data Lake Using Lake Formation on AWS’
Building a data lake can be a massive, time-consuming undertaking requiring proper governance, access controls, and semantic consistency. However, if you’re looking to build one on AWS, Sandeep Arora has you covered—from understanding AWS Lake Formation to database creation to permissions management.
In Azure: ‘Leveraging Azure Synapse Analytics Service Integrations’
First-party services are driving cloud adoption. Microsoft’s release of Synapse Analytics delivered a flexible service that integrates numerous third-party services—a perfect fit for those looking to build an enterprise data platform on Azure. Learn how your company can leverage Azure and Synapse Analytics in Warner Chaves’s blog.
In Cassandra: ‘Batch Operations in Apache Cassandra’
The commonly held belief that batch operations can improve Apache Cassandra performance is a misconception. In many cases, batches can decrease performance—read Anil Mittana’s popular blog on batch operations in Apache Cassandra to learn more.
In Cloud: ‘An Initial Test of Google’s AlloyDB Columnar Engine’
Earlier in 2022, Pythian had the pleasure of testing and evaluating Google’s AlloyDB—a customized cloud version of PostgreSQL with significant performance gains. Simon Pane ran some initial tests of the new Columnar Engine, and you will surely be impressed by his early findings.
In Google Cloud: ‘Securing your Application with Google’s WAF Cloud Armor’
With enterprise web applications under constant threat, multiple layers of checks and defences—including Web Application Firewalls—are becoming commonplace. Google’s Cloud Armor is a managed service that helps protect your valuable applications from numerous threats, including Distributed Denial of Service (DDoS) Attacks. Dennis Sheen shares how to set up Cloud Armor, tune it to your needs, and deploy it—adding another robust security layer to your security strategy.
In Microsoft SQL Server: ‘How to Install SQL Server Reporting Services 2019’
Running into issues trying to install SQL Server 2019? Feature selection SSRS nowhere to be found? Pio Balistoy helps readers navigate this common installation issue in his popular installation guide.
In MongoDB: ‘MongoDB Database Backups Series’
Igor Donchovski’s series on MongoDB replica set backups highlights the best practices using a Logical Volume Manager (LVM) snapshot, followed by incremental backups using the Operations Log (OPLOG). Don’t miss this detailed three-part series!
How to backup MongoDB database using LVM snapshots – Part 1:
MongoDB incremental backups using the OPLOG – Part 2:
MongoDB Backups and Point In Time Recovery – Part 3:
In Oracle: ‘CVE-2022-21500 and Your Oracle E-Business Suite’
If you follow Oracle’s E-Business Suite update, you might have heard about the Oracle Security Alert Advisory on CVE-2022-21500 in May. If not, Andrejs Prokojevs has you covered.
In PostgreSQL: ‘Using Kafka to Replicate Data from Postgres to MS SQL Server – Part 1’
When the data your organization needs for critical decision-making isn’t easily accessible, or in one place, initiatives and projects can slow to a crawl. Marcelo Adade shares a creative solution to a client issue (inability to replicate tables between SQL Server and Oracle) using PostgreSQL and Kafka.
In SAP: ‘How a Well-Planned SAP S/4HANA Migration Can Be a Catalyst for Digital Transformation’
Organizations worldwide are considering migrating to SAP S/4HANA—the next-generation Enterprise Resource Planning (ERP) platform aimed at driving organizational digital transformation. However, with three-quarters of digital transformation efforts failing, how do you plan your transformation with confidence? Huseni Kapasi shares his wealth of experience in formulating a roadmap and getting the best start possible.
In Snowflake: ‘Snowflake Feature Applicability At a Glance’
Enrique Lopez de Lara will tell you that preparing for the Snowflake SnowPro Advanced: Architect Certification is no easy feat. If you’ve been studying for your certification, you may have found that Snowflake has generous documentation—however, feature applicability can be difficult to discern at a high level. Read Enrique’s blog post to get a comprehensive overview of Snowflake’s feature applicability.
P.S.—good luck with your exam!
Top ‘Business Insights’ Blogs of 2022
‘Why Migrate Your PostgreSQL, MySQL or SQL Server to Google Cloud SQL?’
It doesn’t matter if you’re on MySQL, SQL Server, or PostgreSQL: transitioning to Google Cloud SQL can unlock a wide range of enhancements. From task management automation to business continuity, Michael McKee shares how Google Cloud SQL can take things to another level.
‘Moving your Oracle Database to the Cloud? Here’s Why You Should be Thinking Google Cloud’
Oracle continues to be a go-to for relational databases—but they’re often large and complex, making cloud migrations challenging. When the typical lift and shift isn’t an option, Whit Walters shares why Google’s Bare Metal Solution (BMS) and open-source options on Google Cloud are excellent migration destinations.
‘Data is the Heart of Business’
In a truly enlightening Love Letter to Data, Paul Lewis shares how his relationship with data has changed over the years. At first, he thought scarcely about data—but in time, his appreciation for it grew, and data became his truth.
‘Defining Your Data Strategy’
Joey Jablonski’s ongoing series on data strategy outlines fundamentals, methodologies, and powerful processes to enhance your organization’s data strategy. From to prioritization, his deep expertise help demystifies the often abstract and ambiguous world of data strategy, governance, and more.
That’s a wrap for this year—a big thank you to all of our readers and contributors that made 2022 an incredible year. Be sure to sign-up and receive updates when our team publishes new articles—see you in the New Year!