Creating and populating Date dimension in a DW for use in SSAS

Here is a script I found on SQLDusty’s blog on how to populate a Date dimension.

I am re-posting this script here so I can have access to it at any time. Props to Dustin!

 

?View Code TSQL–Make sure you set the Start and End Date below on row 58 and 59
–Create the tables
BEGIN TRY

Continue reading […] Creating and populating Date dimension in a DW for use in SSAS […]

 

A few words on social media and why it is evil

I usually try to post only technical articles on this blog, especially articles which are related to SQL Server and databases. This one is a bit moreĀ general, even though the topic of data warehousing and analysis comes up a few times.

Lately I have been thinking about the social media and its role in our social

Continue reading […] A few words on social media and why it is evil […]

 

SSRS and report caching, dynamic refresh for Data Warehouses

I have a Data Warehouse, in which the data is loaded once a day and during the rest of the time the data does not change.

There are several heavy reports in SSRS used to cater data to the users, and it really saves the day to cache them. The performance improvement is great, but there

Continue reading […] SSRS and report caching, dynamic refresh for Data Warehouses […]