We write articles and white papers on Microsoft Business Intelligence technologies on a regular basis. The list below showcases all our content sorted chronologically - you can filter through the content by post type, topic, and author.
     Page 91 of 918 posts
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

blog post –

Install Reporting Services SP2 Web Parts on SharePoint

I just installed the Reporting Services SP2 beta on my dev-test machine. I had to search into beta newsgroups how to install SharePoint Web Parts onto my SharePoint Services installation: to do that, you need to start a command like: stsadm.exe -o addwppack  Read more

blog post –

BI Portal for SharePoint

A new version of BI Portal Sample is available from Microsoft. It looks good, but I still haven’t tested it. Integrated with SharePoint and Reporting Services. Support of different localizations. It’s not the definitive solution, but may be useful.  Read more

blog post –

Don’t use quote inside comments with Analysis Services 2000

Yesterday I lost at least an hour (but only for a coincidence I haven’t lose more hours) because I came across a bug of Analysis Services 2000. If you put a single quote or a double quote inside a comment, the whole MDX expression is not considered. I  Read more