Reporting Services SharePoint Integrated Mode Overview     What is integrated mode?  In SharePoint integrated mode, a report server must run within a SharePoint server farm. A SharePoint site provides the front-end access to report server content ...[Read More]

Processing an Analysis Services Cube from a VBScript File or SSRS Report Giving users the ability to process an Analysis Services cube outside of SQL Server Management Studio and Visual Studio can free up time and developer resources. Both VBScript ...[Read More]

    In an effort to start framing the many considerations for data souring of a Business Intelligence Solution, first we must look at some of the reasons it is not desirable to simply use existing solution databases.     As a simple starting p ...[Read More]

Doug Harts, VP Enterprise Solutions is interviewed by Microsoft regarding Microsoft's cloud technology named Azure.     Questions answered include: Can you describe the components in the MS stack that are available in the cloud today? Do ...[Read More]

Map Intelligence with SQL Server 2008 R2, a first map-report with Report Builder 3.0.     The initial design screen of the ReportBuilder is shown in the following screenshot.       To determine the analytical data to be displayed on the ...[Read More]

Find Foreign Keys and their Parent and Referenced Objects Using TSQL     It is invaluable to understand relations within a database. Often in business intelligence designs these relations may never be physically created in the database.  Howeve ...[Read More]

Map Intelligence with SQL Server 2008 R2, 3 Steps to Installing Report Builder 3.0.       We can view BI data against a map background by adding a map report item to a report using Report Builder 3.0 which is part of SQL Server 2008 R2 CTP. The ...[Read More]