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]