RDA Corporation

Blog

Top 5 Design Considerations for Business Intelligence Projects

By Ray Barley on August 9th, 2012 // No Comments

business intelligence = smart business

This is the fourth post in a series that is focusing on the top five design considerations you need to keep in mind for your projects. This post focuses on business intelligence projects specifically.   1. Data Model The most important design consideration for a Business Intelligence project is to define the data model that will be able to provide the information that the business users require for analysis and reporting. The data model is usually implemented as a relational database t...

Continue Reading

Overview of New Features in SSIS 2012

By Ray Barley on April 19th, 2012 // No Comments

SSIS_2011

Since SQL Server Integration Services (SSIS) was released with SQL Server 2005, there have been a variety of issues with the developer experience, deploying packages, and executing packages. SSIS 2012 has addressed a number of the key pain points, particularly in the area of deploying and executing packages. What's New in SSIS 2012 There are a number of new and useful features in SSIS 2012. They can be broken down into the following categories: Developer experience Deployment model ...

Continue Reading