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
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.
This is the second DBA course. As I add articles, they'll appear here.
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,
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
Time to take your database development to the next level! As I add articles to this series, they will appear below.
This set of articles will be about Database Administration. As I add articles to the series, they'll appear below.
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
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
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
microsoft sql
Last time, we discussed three methods for inserting data into a destination table that has a recursive relationship. In this article we're going to cover how
SQL301
Earlier this week the question came up on how can we insert data into a table that has a hierarchical data structure. If you're not familiar with a hierarchical