ETL DBA.com

Business Intelligence Through Better Data Warehousing

Services

Analysis

  • MS SQL Server Security Review
  • MS SQL Server Migration Planning
  • MS SQL 2000 / 2005 / 2008 up-conversions
  • Data Model Evaluation
  • Data Lifecycle Planning
  • Storage Analysis / Processing Analysis
  • Hardware / Software Evaluation

Development

  • Data Modeling OLTP Systems
  • Data Modeling OLAP / DSS Systems
  • MS SQL SSRS - Reporting Services
  • MS SQL SSIS - Integration Services
  • MS SQL SSAS - Analysis Services
  • Data Conversion / Integration Coding
  • SQL Views, Procedures, Triggers, Functions

Issue Resolution

  • Performance Problem Identification
  • Database Restoration
  • Failed Server Recovery
  • Data Corruption Repair

 

 


Service Guidelines

People

Provide resources with the proper skills and experience to do the job.

Goals

State the purpose and the intent of the work.  State the timeline and timeline factors.  State the methods to be used to reach the goal.  Agree on the measures of success.

Engagement

Perform quality work aligned with the stated goals.  Provide continuous feedback on the timetable and impact to it.  Measure success throughout the engagement.

Communication

Ask the customer for feedback.  Ask what was done correctly.  Ask what could be done better.  Refine and improve as necessary.

Write a project summary statement.