Tag Info

New answers tagged

1

No, you do not have to buy a VS licence to use SSDT or SSDT-BI, you have the licence for the services (IS, AS, RS) if you have a SQL Server licence. SSDT and SSDT-BI are just tools to use those services. You can freely download SSDT and SSDT-BI from Microsoft: SSDT: http://msdn.microsoft.com/en-us/data/hh297027 (for SQL Server Database projects) SSDT-BI: ...


1

Your server has to be a member of the SharePoint farm before it will allow you to install SSRS in integrated mode. Refer to this article for more information.


0

I just completed a 4 day course with the Kimball group and they had this to say on naming conventions: Always use full descriptive names ie. Brand Name. and don't use abbreviations. Otherwise you may need to spend time training users. Don't use Dim or Fact in your table names because you end up spending a lot of time deleting these from the reporting ...


0

My approach has always been to store as much business logic in the database layer. The reason for this is that if you change the reporting layer, then you need to rewrite all the business rules. It is more likely that you'll change the reporting layer, than the database layer as this is what your department sees, not the database. Also I'm seeing many ...



Top 50 recent answers are included