I would like to gauge what solutions other people put in place to get Team System functionality. We all know that Team System can be pricey for some of us. I know they offer a small team edition with five licenses with a MSDN subscription, but what if your team is bigger than five or you don't want to use Team System? ...
I'm wondering if there is a website that collects (and hopefully updates) information on available web services. Edit: Thanks for all the info; many good answers. I can only accept 1 as the "accepted answer" at this time, so I picked my favorite one. ...
Hello! Where I can download sample database which can be used for data warehouse creation? It should't be sample from Microsoft (Northwind etc.). Thanks in advance EDIT: Sorry for not clarifying my question. At my university we have class where we must create some data warehouse and since Northwind is so popular over net then professo...
I'm working on a Data Warehouse which, in the end, will require me to create reports based on business hours. Currently, my time dimension is granular to the hour. I'm wondering if I should be modifying my Time dimension to include a bit field for "business hour" or should I be creating some sort of calculated measure for it on the anal...
rm files are comparitively much smaller in size. how do they compare quality-wise? for a songs warehouse application, is it advisable to convert all mp3 to rm before archiving to save storage space? ...
I have an ETL process performance problem. I have a table with 4+ billion rows in it. Structure is: id bigint identity(1,1) raw_url varchar(2000) not null md5hash char(32) not null job_control_number int not null Clustered unique index on the id and non clustered unique index on md5hash SQL Server 2008 Enterprise Page level compr...
Is there a way to compare all information (aggregates, down to the detail level) between two OLAP cubes? For example, say I wanted to compare one cube created to work with sql server 2000 to that same cube, but migrated to run on sql server 2005/2008 - technically they should both return the same information for all dimension / measure c...
Hi, I have downloaded the 30-day trial of DWExplorer, and I also got 2 examples files, Financial Overview.dwew and Product Overview.dwew. But whenever I open one of those 2 files, I get the following error message: 1: An error occurred while connecting to the server: -> [SourceException] -> Type [SourceErrorType]: ConnectionLost -> Sou...
Hi! Can someone recommend me some data modelling, data warehouse tool for Mac? ...
Hello StackOverFlow, I am at my wit's end here after spending most of this week tearing my hair out and swearing at TFS so I hope someone can help :) We have recently migrated to TFS 2010 using the MSF For Agile process template and we make use of such reports as the Burndown, User Stories progress etc. Up until 13/10/10, our warehousi...