Tales & Tips from the Trenches: Agile Principles in Data Projects, Part 3
Data Modeling in Agile Projects This is the third in a series of columns about applying Agile techniques to data projects. The column’s goal is to share …
Death by Spreadsheet
I suppose most of us have heard the phrase “death by PowerPoint,” referring to those occasions when the burping, animated clip art gets in the way of the …
The Data Centric Revolution: The Core Model at the Heart of Your Architecture
We have taken the position that a core model is an essential part of your data centric architecture. In this article, we will review what a core model is, how …
High-level Intro to the Corepula Method of Data Modeling
Recent advances in data analytics have produced an insatiable appetite for data. Satellites, cell phones, and computers constantly churn out streams of …
Celebrating 20 Years of TDAN.com
On June 22, 1997, The Data Administration Newsletter (TDAN.com) went live on the internet. The publication started online at stargate.net/TDAN and moved to …
Autonomics to Modernize DB Administration
There is a clear trend to automate and enable computerized tasks to streamline and optimize administrative and maintenance tasks. Many database (DB) management …
Recursive Queries for Hierarchical Data Retrieval
One of the most fascinating features of SQL is its ability to execute recursive queries. Like sub-queries, recursive queries save us from the pain of writing …
SQL Drawing Blanks? It’s NULL a Surprise!
Is your SQL drawing a blank? It’s NULL a surprise! The title of this post is a play on words, but very appropriate. We are going to discuss the …
Understand Relational to Understand the Secrets of Data
I don’t like talking about the relational theory of data. It is absolutely fundamental to any deep understanding of data, but most practitioners get along …
Benefits of Modeling Apply to NoSQL
Information drives businesses who make decisions based on data. Data is a corporate asset. Data modeling is critical to understanding data, its …