The Enterprise Architecture Vision

The Enterprise Architecture Vision statement should be created while doing high level analysis of of the project scope.  The vision statement should clearly define the architecture and what the project will be addressing.  This includes the as-is and to-be state of the technology environment as it aligns with business goals to create value to the … [Read more…]

The TOGAF Architecture Development Method (ADM)

One method used to create an enterprise architecture is the TOGAF Architecture Development Method cycle or ADM.  This method is a cyclical process to manage the lifecycle of an Enterprise Architecture project.  By adopting this process you can create the required architectural documents for your EA project. The image below demonstrates the ADM and can … [Read more…]

More Acronyms to learn – IaaS, SaaS, PaaS

As more and more cloud technologies are developed they have introduced more IT acronyms for everyone to learn.  Listed below are definitions and examples of these common cloud terms. Infrastructure as a Service (IaaS) Infrastructure as a Service leverages cloud based hardware solutions.  Here you can create networks, Virtual Machines and Storage.  This model is … [Read more…]

How to create a Columnstore Index

Each table can have only 1 columnstore index, data from the index is stored in memory in the xVelocity engine.  Once a columnstore index has been created on a table you cannot update the table.  Microsoft recommends you take the following actions to update the data in a table containing a columnstore index. Drop the … [Read more…]

Value of Business Intelligence

Regardless of the technology that you choose and there are more and more being developed each year. Asking for money to start or extend a Business Intelligence project is not about the technology. It is about the value that data can deliver to the business. Data laying in a database does not provide value. To … [Read more…]