Tag: sql

How to deploy a Cockroach DB Cluster in GCP – Part I

CockroachDB is a distributed SQL Database that has been gaining popularity in the last years because of its features. It is easy to deploy, with strong consistency, designed for the cloud, it has distributed transactions and easy to scale. Not…

Read More >

Slow Query in eBS AutoConfig with DB 19c

slow query

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…

Read More >

Oracle Scheduler Job is Not Running as Expected After Bouncing Databases

dev database

One of our clients had issues with their scheduler jobs in DEV and PROD databases and all scheduler jobs stopped running after July 31st, 2021. Both databases were 19c and patched with July 2021 19.12 RU and the parameter job_queue_processes…

Read More >

SQL Server Distributed Availability Group with Forwarder in Microsoft Azure

mysql queries

Architecture diagram Register the application with the name terraform. Leave all options as default. Add a secret that will be used as a password to authenticate terraform. Provide a description and expiry period for the secret. Copy the Secret ID…

Read More >

Google Recognizes Pythian’s Outstanding Data Management Work in 2020 with Inaugural Award

Love your data.  It’s far more than our tagline here at Pythian—it’s truly in our DNA.  That’s why we’re thrilled, honored and even a bit humbled to be named the first-ever Google Cloud Specialization Partner of the Year for Data…

Read More >

Data preparation with dbt and BigQuery

Raw incoming data needs to go through a series of data preparation steps before it can be used for analysis. These steps include tasks such as type casting, renaming columns, cleaning values and identifying duplicates. Writing code to perform these…

Read More >

How To Rename Interval Partition with More Meaningful Name

When using interval partitioning, the database automatically creates partitions for a specified interval. Unfortunately, the database creates partitions with non-meaningful names, e.g. SYS_P35714. It would be better if the partition was named using some sort of format, e.g. PYYYYMM –…

Read More >

DML by Unique Index Supposedly Affecting Many Rows

This blog post is based on a real customer case, and illustrates how v$sql reports execution statistics for certain DML types of operations (I purposely have not named which DML types … yet). These reports can be misleading when troubleshooting…

Read More >

Azure Synapse Analytics Q1 2021 Updates

Since Microsoft announced Azure Synapse Analytics back at the Ignite conference in 2019, the data community has expressed a lot of excitement and skepticism. A lot of people thought that integrating so many different components like MPP warehousing, Spark, pipelines,…

Read More >

Graph Algorithms and Inference

If you’ve used Google Maps for directions or “friended” someone on Facebook, you’ve experienced graph theory. Graph theory is all about connectedness, how things in the world relate to other things, and how those interactions affect the objects around them….

Read More >
Page 1 of 3123