It’s tempting just to replicate all databases in the cloud, but it’s a much better approach to get your data house in order as part of the move. Last week I discussed database normalization as a best ...

Many people seem to become filled with anxiety over the word “normalization.” Mentioning the word causes folks to slowly back away toward the exits. Why? What might have caused this data modeling ...

When normalizing data structures, attributes congregate around the business keys that identify the grain at which those attributes derive their values. Attributes directly related to a person, ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...

Microsoft offers two paths for running enterprise databases: SQL Server, which you install and manage yourself, and Azure SQL, which Microsoft runs for you as a managed service. Both use the same ...