SSRS Report switch for Operational DB to DWH
We currently are running a large report off of the operational DB but in turn used this report to create a DWH in order to get this report to run faster. Before we used a stored procedure with many smaller queries that summed our numbers. Since we have the DWH that stores all this needed [...]

Answer Question   |  February 16, 2011  2:43 PM
SQL Server data warehousing/business intelligence, SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008

Sage Mas 500 setting up Microsoft Project link.
I am running Sage M500 – I need to be able to link my project files to my M500/SQL data and vice versa. I see lots of information on functionality but only consultants that want to set it up! HELP Me do this for free and save the day!

Answer Question   |  July 10, 2008  2:03 PM
MAS 500, Microsoft Project, Sage Software, SQL Server data warehousing/business intelligence

When designing a data warehouse in SQL Server what is the best setting for the varchar data type?
I am designing a data warehouse database to be implemented in SQL Server. There are a number of variable length character fields for which I intend to use the varchar field type. On previous data warehouse implementations in Oracle, I frequently set the length for the varchar fields higher than the current data length. I [...]

Answer Question   |  April 9, 2008  11:14 PM
SQL Server data warehousing/business intelligence

Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?
Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?

Answer Question   |  April 9, 2008  10:38 PM
SQL Server Analysis Services, SQL Server data warehousing/business intelligence, SSAS