sql203

SQL203 — Indexes can help|hurt

Yeah, I used a pipe in my title. That's because indexes can help some things, but hurt others. The brief of it is indexing helps reads, but comes at a cost:

microsoft sql

SQL 201 – APPLY

Let's finish up with the SQL 210 series today with the APPLY operator. After you learn how to create your own functions, you're going to want to use them in new

The Pipeline Isn't the Product

Last year I finished a project where we delivered a data warehouse with over forty SSIS packages, a dozen SQL Agent jobs, and about two hundred stored procedures. Each piece worked. The integration testing passed. We signed off and moved on. Three months later the client called. Someone had added

Your Hive Script Is Code: Why Data Teams Need to Learn Git

A client called me in January because their daily aggregation pipeline had broken over the weekend. The pipeline read from HDFS, ran three Hive transformations, and landed results in a reporting table the business reviewed every Monday morning. It had been working fine for months. Then it wasn't.

SQL 202

This is the second DBA course. As I add articles, they'll appear here.

SQL 101

After helping others learn SQL for several years now, I keep coming back to the same topics over and over. So, I decided to write down these SQL tutorials,

SQL 103

This is my SQL architecture and design course. In this series you'll get an idea of what kind of objects you can build, and what they're used for. Once you

SQL 301

Time to take your database development to the next level! As I add articles to this series, they will appear below.

SQL 102

This set of articles will be about Database Administration. As I add articles to the series, they'll appear below.

SQL 201

It’s that time again! Time to start up a new class and cover some more advanced topics in SQL Development. Before beginning these lessons, You need to be

Data Engineers Have a Network Problem Too: Latency Patterns in ETL Pipelines

Most of the writing about cloud latency and connection resiliency focuses on application developers. It's their connection pools that drain and their N+1 queries that explode. But data engineers running ETL pipelines against cloud endpoints had their own version of the same problem, and the failure modes

SSDT: The Moment Database Deployments Became Repeatable

For most of my career before 2012, deploying a database schema change meant running a SQL script. Maybe you wrote it yourself. Maybe someone emailed it to you. Maybe you'd been collecting changes in a text file since the last release and you were about to run all