My Thoughts

My motivations

Here I share thoughts on various data topics, mostly about data warehousing, that I find worth writing about. Perhaps because I have a perspective that I don't think is shared enough in data circles. Perhaps because I hope to address a confusing or complex topic in a digestible form. Perhaps simply because I had fun writing it.

My hopes

Regardless, it is my hope that you will find (at least some of) these to be helpful. Keep in mind that these are my thoughts. Nothing more, nothing less. Should you adopt, utilize, or share these thoughts with others, I would be thankful (and hope that you give me due credit).

General data topics

Data storage terms
Sharing data between systems
What is a thing?
The temporality of data
Data modeling

Data warehousing topics

Architecture of an analytical data environment
What is an Enterprise Data Warehouse?
Multi-tier EDWs
Functional areas of an EDW
Data collection in a data warehouse
Managing clock time in a data warehouse
Effective periods in a data warehouse
Lookup tables in a data warehouse

SQL Server topics

Management of character data in SQL Server
Collation usage in SQL Server
Inter-database communication in SQL Server
Storing datetime values in a SQL Server-based EDW