Singular or Plural

A debate that might be worth having in the database community.

The Power of the Data Model

A data model is far more powerful than simply a set of build instructions for DBAs. It can be used to shape business thought and actions for the benefit of all.

Numeric Data Types

Antipathy for Entity Attribute Value data models

EAV models have their uses but the costs are often hidden and if not hidden, more than anticipated.

Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services

This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.

PASS Data Architecture Virtual Chapter presents Audrey Hammonds – Database Makeover: Renovate You Data Model

On Thursday January 19th at 12 noon Central, Audrey Hammonds will discuss renovating your data model while keeping you’re the production system humming

Going Beyond the Relational Model with Data

SQL is a powerful tool for querying data, and for aggregating it. However, you can't easily use it to draw inferences, to make predictions, or to tease out subtle correlations. To provide ever more sophisticated inferences to businesses, the race is on to combine the power of the relational model with advanced statistical packages. Both IBM and PostGres are ready with solutions. And SQL Server? Hmm...

Restructure 100 Million Row (or more) Tables in Seconds. SRSLY!

Changing the structure of a very large table doesn't need to require a maintenance window.

Naturally Increasing Data Value with Hierarchical Structures

Hierarchical structures have an inherent ability for significant data value increases beyond the data collected. This will be shown to exist in hierarchical structures and even more powerfully in their natural hierarchical processing capabilities. These will demonstrate flexible and efficient ways to increase data value automatically and will be discussed in this article. SQL will be used to perform a wide range of hierarchical processing operations that easily demonstrate these increasing data value capabilities.

Extending Hierarchical Data Modeling Demonstrated in SQL

The capability of extending the limits of combining multiple node hierarchical structures has not been fully explored. Michael M. David presents a solution to advanced structure combining that is simple to use, generic and freely extends the way hierarchical structures can be semantically combined to produce advanced new hierarchical data structure mashups that dynamically increase the value of the data.