PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them

Introducing PlanTrace — a free, browser-based tool that turns raw execution plans into interactive graphs and actionable tuning insights.

plantrace.studyyourdata.com

PlanTrace...

AWS RDS Aurora - our first approach

When starting with AWS RDS Aurora for managing relational databases in the cloud, many data engineers face the challenge of leveraging its cutting-edge features while maintaining performance and reliability....

How to Find Expensive Queries in Amazon Redshift

Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying the most expensive queries is crucial to optimize resource usage and improve overall system efficiency.

Step-by-Step...

Cloud Databases Made Simple: Creating Your First AWS RDS Instance

I recently started full time learning of Amazon Web Services (AWS). I found that AWS's Relational Database Service
(RDS) is really user-friendly. RDS simplifies many of the
complicated aspects of...

Introduction to IaC: Deploying Data infrastructure to Azure using Terraform (Part 4 - Using Github)

 In Part 1, we explain the basics and prerrequisites to work with Terraform.In Part 2, we created our first Azure resource.In Part 3, we deployed our fist solution (Azure...

Introduction to IaC: Deploying Data infrastructure to Azure using Terraform (Part 3 - Azure SQL Database)

In Part 1, we explain the basics and prerrequisites to work with Terraform.In Part 2, we created our first Azure resource.On this post we will create an Azure SQL...

Introduction to IaC: Deploying Data infrastructure to Azure using Terraform (Part 2 - our first Azure resource)

Continuing our Part 1, we already set up our environment, we can now setup our very first example (do not worry if is too simple at this point, but...

Introduction to IaC: Deploying Data infrastructure to Azure using Terraform (Part 1 - Intro and prerequisites)

IntroductionOne integral part of modern Continuous Integration and Continuous Development (CI/CD) pipelines is the ability to create the underlying infrastructure as part of the pipeline in a consistent and...

Install Python on Windows

Python is the most famous development language today.
This is because is open-source, scalable and robust. It can run in almost any device with a processor (or microprocessor, we will...

Checking Azure SQL DB service tier via T-SQL

If you have to manage or work with an Azure SQL database and want to know what service tier the database is currently operating, but you don't have access...