Mastering Dimensions of Time
A method to create and populate Date and Time dimension tables for a data warehouse project.
2014-01-21
9,594 reads
A method to create and populate Date and Time dimension tables for a data warehouse project.
2014-01-21
9,594 reads
Big Data implementations bring their own problems and issues, and will require database administrators and support staff to redesign the data warehouse architecture. Here's how.
2013-12-02
4,609 reads
Introduction
You likely have heard about data warehousing, but are unsure exactly what it is and if your company needs one....
2013-07-25 (first published: 2013-07-18)
5,927 reads
The goal of this article to show how to get unique transactions per client per month from the data set containing multiple transactions per client per month.
2013-04-02
3,815 reads
Creates and populates a date-dimension table suitable for OLTP or data warehouse purposes.
2013-02-04
791 reads
This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
2018-07-17 (first published: 2012-06-05)
18,044 reads
RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions
2014-09-05 (first published: 2012-05-08)
20,089 reads
Using the Kimball Data Warehouse Modeling Tool in an agile setting supporting regular builds and integrated testing with work a rounds to cover non-SQL Server systems.
2011-10-31
8,079 reads
What do you do first when developing a data warehouse? MVP Andy Leonard brings us a look at the foundation he uses, which might surprise you.
2011-04-07
9,032 reads
This article will show you how to use SSIS to create inferred dimension members on the fly during a fact table load process.
2013-12-24 (first published: 2010-12-08)
13,403 reads
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers