Understanding Fragmentation and its effects on SQL

Understanding Fragmentation and how it affects the performance of your database is critical.  Performing regular maintenance tasks that defragment and compact clustered and non-clustered indexes on tables and views. This will improve index-scanning performance. This should be run on weekly or fortnightly basis. Fragmentation can happen at several levels and if fragmentation […]

Ways to get data out of

Microsoft BI is easy to use and is the largest growing BI platform according to Gartner. In order to get data out of Essbase it requires some magic. Below is a list of options to get data out of Essbase into another stack like Microsoft BI.  One other option that I didn’t include […]

SSIS Logging Framework

The need for a Logging Framework for SSIS packages to track and log activity within ETL (Extract, Transform, Load) processes. This blog outlines the database schema, stored procedures and implementation practices within SSIS packages to be utilized for the SSIS packages used for the data applications.  I will build and use a […]