SQL Server Data Warehousing/business Intelligence

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!

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...

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?