Topic: SSAS

       Page 39 of 403 blog posts
blog post –

Surrogate key generation in SSIS

In the last few days I tested several ways to generate surrogate keys when loading a dimension into a data mart. The classical approach with SQL Server is to rely on a INT IDENTITY column. It works fine, but you don’t know what surrogate key has been  Read more

blog post –

Cascading many-to-many dimensions: unsupported scenario?

I already opened a bug and written on newsgroup about this specfic scenario, but I still haven’t received an answer. This morning I met Chris Webb in Munich (I’m attending SQL Pass Europe ) and he told me that one year ago someone of MS told him that  Read more

blog post –

Database snapshots to feed a data warehouse?

I just attended the pre-conference of Kimberly Tripp at SQL Pass 2005 Europe . The topic was “New SQL Server 2005 features that a DBA need to learn” and I took advantage of this day to cover an area of SQL2005 I still haven’t explored. One consideration  Read more

blog post –

Useful Reporting Service Scripter tool

I just discovered Reporting Services Scripter , which seems a very useful tool to move Reporting Services objects between different servers. Thanks to Davide Mauri for the link.  Read more

blog post –

sp_OAxxx are evil

Today I’ve got a question from a student (I was teaching a DTS/AS course) that asked me if the use of sp_OAxxx stored procedures to launch a DTS package execution is a good thing (of course, in a production environment). My answer is very simple: never  Read more

blog post –

Populating a fact table with SSIS

Approaching SSIS (Sql Server Integration Services) from a DTS background one of the questions that comes to mind is: what is the better way to populate a fact table? Assuming you have a conventional star schema, you should have a fact table with two kind  Read more

blog post –

SQL Task in SSIS with external file

SSIS has a feature I desperately wanted in DTS for years: you can use an external SQL file as a source SQL statement for the SQL Execute Task. Unfortunately this is not available for Data Flow Source component. I tried using variables to load the SQL  Read more

blog post –

Useful webcast on MDX

Thanks to Chris Webb I discovered this useful webcast about MDX tips & tricks (rightly named Common MDX mistakes & solutions). It’s available even the whole transcript, so you can read it instead to listen after midnight :-)  Read more