SQL Server Business Intelligence

Shared Datasets in SQL Server 2008 R2

This article leverages the examples and concepts explained in the Part I through Part IV of the spatial data series which develops a “BI-Satellite” app. Overview In the spatial data series we looked at free-form text based address data and worked towards developing a Geospatial Dashboard . In this artilce we will look at using […]

Achieve Spatial Data Support in SSIS

Overview SQL Server 2008 introduced a new category of datatypes known as spatial datatypes which store spatial information. The new spatial datatypes are geography and geometry. SQL Server Management Studio comes with good good support for these spatial data types like the spatial results tab and facilitated access to .NET Common Language Runtime (CLR) functions […]

Working with Spatial Data Part IV – Developing a Geospatial Dashboard (GIS)

This article leverages the examples and concepts explained in the third part of this spatial data series which develops a “BI-Satellite” app ( Reporting spatial data with SSRS 2008 R2 and Reports Builder 3.0 Part-III ) Overview: In the previous part of this article series, we saw how we can report spatial data on a […]

Working with Spatial Data Part III – Reporting Spatial data using Reports Builder 3.0

Overview Development of any analytical solution normally ends with a form of  report, whether it is a normal tabular report or a sophisticated interactive dashboard.   In the first part of our BI-Satellite project, we devised a way to geocode location based spatial data using SSIS and Bing Maps. Thereafter in the next part we plotted […]

Working with Spatial Data Part II – Plotting Shapes and Storing Geocoded Data

This article leverages the examples and concepts explained in the first part of this spatial data series which develops a “BI-Satellite” app ( Geocoding Text-Based Spatial Data for Use In SSIS Packages Part-I ) Overview Text based location information is the starting point for spatial data analysis, but this information is generally not directly consumable […]

Using The Data Mining Query Task in SSIS

SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS I discussed how to use the Analysis Services Processing Task to […]

Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS

SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article Using WMI Data Reader and WMI Event Watcher Tasks in SSIS I discussed how to use the WMI Data Reader and WMI Event Watcher […]

SQL Server Analysis Services ( SSAS ) – Introduction

Microsoft SQL Server 2005 Analysis Services (SSAS) delivers both online analytical processing (OLAP) and data mining functionality for business intelligence applications. Analysis Services supports OLAP by letting the user design, create, and manage multidimensional structures that contain data aggregated from other data sources, such as relational databases. For data mining applications, Analysis Services lets the […]

Using The Data Profiler Task and FTP Task in SQL Server 2008 Integration Services

Introduction SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article entitled Using Web Service and XML Task in SQL Server 2008 Integration Services I discussed how to use the Web Service Task and […]

Using Web Service and XML Tasks in SQL Server 2008 Integration Services

Introduction SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article entitled Using the File System Task in SQL Server 2008 Integration Services I discussed how to use the File System Task which is […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |