Kovid Rathee

Data & Infrastructure Engineer who writes about tech, music, and other things.

Recently Published

What is a multi-model database?
Top SQL GUIs for Your Data Warehouse (Snowflake, BigQuery, Redshift)
Overcoming database scaling issues with Fauna’s serverless offering
Edge computing reference architectures
What is Change Data Capture? Common CDC methods
Choosing Effective SLIs
Doing SRE The Right Way
Automatic Instrumentation and OpenTelemetry
Browser-based Database Clients
Data Warehouse Migration with AWS DMS
QuestDB vs. TimescaleDB
The Art of Discarding Data
AWS RDS Cheatsheet
Git for Data Engineers

Proof of Concept Work

Build a Crypto Price Tracker using Node.js and Cassandra
Real-time Stock Price Alerts using Python, Grafana & QuestDB
SQL Extensions for Time Series Data in QuestDB
Schemaless Ingestion in QuestDB using InfluxDB line protocol

Database Testing

Common Database Testing Problems
Automation Testing for Data Systems

ML/AI

Machine Learning Reliability Engineering
The MLOps Toolkit

Data & Infrastructure Engineering

Handling Geospatial Data in AWS
The New Data Engineering Stack
The Case for Using Timeseries Databases
Data Pipeline Design Principles
Numbers Every Data Engineer Should Know
Git Best Practices for SQL
Rookie Git Mistakes to Avoid
Ultimate PySpark Cheat Sheet
Easy Fixes for SQL Queries
Complete Data Engineer's Dictionary
Easy Fixes for Redshift Performance
How to Think About Data
How to Avoid Writing Sloppy SQL
4 Advanced SQL Features You Haven't Used Enough
Easy Fixes for SparkSQL Performance

Newsletters & other Publications

Updates on Amazon Redshift's RA3 Type Instances
How to Think about Data (Spanish Translation), Featured in datasource.ai
Featured in The Institute for Ethical AI & Machine Learning Newsletter
AWS HealthLake & Redshift ML
Featured in Software Testing Weekly Issue #65
Featured in DBWeekly Newsletter

Year in Writing

2020

View on mobile