A Line in the Sand. It has been a long time since I posted here on my blog. Both with private life commitments as well as work. Many people have asked me what I am doing with my time these days. That being said, I wanted to draw a line in the sand and wrap up the history of this blog nicely. When I resurface, this blog will shift its foc.

Data Warehousing, BI and Data Science. Using a Data Warehouse for CRM. A dimension with only one attribute. Storing Percentage Measure in the Fact Table. Primary Key in Accumulating Snapshot Fact Tables. Disk Space in Data Warehousing. Why a 400 GB Data Warehouse Requires 20 TB of Disks. Data type of Is Current Flag column.

This blog is mostly a blog for me with hints to remember those little bits of code etc where ever I am. Please be aware of this when reading any of the posts as they are mainly reminders for me. When I get time I will try to flesh out those sections that are a little ambiguous. Friday, 1 May 2015. Getting Column Descriptions of a Table in MS SQL. Run in the Context of the Database where the table resides.