The complete guide to XML support in MySQL and PostgreSQL
This article explores how MySQL and PostgreSQL handle XML data differently, including storage behavior, validation, XML querying, […]
Data
How to anonymize PII in LLM pipelines (5 key techniques ...
Large language models (LLMs) and the agents built on top of them ingest everything they are given, […]
From anthropology to analytics: how to build a data career ...
Kristyna Ferris didn’t come from a traditional tech background. She studied anthropology, stumbled into data through an […]
How data scientists work with PostgreSQL from Python (and how ...
In this article, learn how PostgreSQL powers data science workflows, including query execution, performance optimization, indexing, data […]
How DataOps principles help to reduce GenAI risk and improve ...
John Kerski explains how DataOps principles improve trust, quality, and governance when using GenAI in data solutions. […]
When, and when not, to use LLMs in your data ...
“Let’s add LLMs to the pipeline” has become a familiar refrain in modern data teams, but turning […]
Incrementally Loading Data into Parquet with Python
Parquet is a column-oriented open-source storage format increasingly used for “big data” analytics. Yet despite its growing […]
Takeaways from Data Grillen 2024
Before anyone tries to order something online from DataGrillen.com and thinks it will be delivered by them by […]
Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts
Introduction to SQL Window Functions In today’s data-driven world, SQL (Structured Query Language) stands as a cornerstone for […]