Enterprise Architecture

Microsoft Azure Data Services

Azure Data Services

Microsoft’s Azure data services provides you with a method to enhance your enterprise architecture and business intelligence options.  No longer are you limited to building more servers or adding SAN storage in your on-premise datacenter.   By leveraging the data services in Azure you can become elastic in your...Read More »

ETL vs ELT Data Migration


ETL Process

Reporting databases need to consolidate data from across many applications within an organization.  In order to successfully pull data from source applications and make it into usable data for reporting and analytics.  There are two paths that most Business Intelligence strategies can leverage, ETL or ELT.

Extract Transform and Load...Read More »

Languages of Big Data Apache Hadoop

Languages of Big Data

Big Data is here and rapidly growing.  If you are just starting to learn about Big Data then it is important for you to understand all of the various pieces that can be used in Big Data architectures.  The Apache foundation is a major player in the...Read More »

SharePoint 2013 External Data Connections

SharePoint 2013 External Data Connections

SharePoint 2013 External Data Connections

SharePoint 2013 External Data Connections  are part of the Business Connectivity Services (BCS)  that can be leveraged to perform CRUD operations on data stored outside of SharePoint such as SQL Server or other databases.  This means that if you have users that need to insert, update...Read More »

What is MongoDB?

How does MongoDB Store Data?

What is MongoDB?  MongoDB is a document oriented database.  This means it stores its data in fields within a document.  Each document can contain a different number of fields making the database highly flexible.  You do not have to predefine each column for data that you...Read More »

Practical Data Migration Strategies

Practical Data Migration Strategies

As organizations mature their IT infrastructure must change to keep up with new applications and technologies. Many times this includes moving data housed in one technology (legacy) to the upgraded or new platform that is being implemented. Depending upon what you are trying to accomplish there are...Read More »

SQL Server Filtered Index

What is a SQL Server Filtered Index

A SQL Server Filtered index is a nonclustered indexes that can be used to increase query performance when selecting records from a table.  This type of index can be especially useful when there are a small count of  distinct values in a column such...Read More »

CISSP and Enterprise Architecture

CISSP and Enterprise Architecture

One topic that professionals pursing Enterprise Architecture roles should focus on is security.  Enterprise Architects are responsible for designing the structure and interaction of IT systems around fulfilling business needs for an organization.  However, not everyone moving to an EA role has had a broad exposure, experience...Read More »

When Good BI Goes Bad - Data Quality

Regardless of the Technology BI is about Data

Many BI projects are sold as a technology solution.  Vendors come in a wow executives with new features, visualizations, and dashboards.  Along with the software they offer simple and fast implementation that can “connect to all of your data and produce fantastic reports”. ...Read More »

Application Data Asset Library

Application Data Asset Library Base

The Journey to an Application Data Asset Library

Often times IT requirements are handed over to business users to review and are expected to understand what is provided.  The only problem is most business users do not know how to interpret the graphics and associated acronyms and arrows show data flows....Read More »

Technology Alignment

Technology Alignment with Enterprise Architecture

A critical component in your Enterprise Architecture program is assuring your organization is leveraging the best technology to achieve alignment of business objectives.  This includes reviewing the current technologies in place as well as understanding how new technology, if used would impact the organization. The total...Read More »

Preventative Maintenance Data Mining

Data Mining SCADA

Preventative Maintenance Data Mining Overview

One of the benefits of storing vast amounts of data is the ability to use this data to search for patterns to make your business more efficient.  For businesses that rely on equipment that needs regular maintenance data mining can provide an advantage over your competition. ...Read More »

Data Architecture Program

Enterprise Architecture – Parts of a Data Architecture

The data architecture program within an Enterprise Architecture initiative will include many documents about the data processes within your organization.  To begin this exercise you must determine what applications are in scope to explore and document.  Beginning with...Read More »

Data Management Foundation

Data Management – Beginnings

Every reporting project begins with the need for data from the applications presented to the users in the best format possible to enable business decisions.  This can be an easy process or very complex depending upon where the data is coming from.  Simple reporting can be accomplished...Read More »

Enterprise Architecture Interviews

What are you trying to accomplish in the Enterprise Architecture  Process?

When approaching an Enterprise Architecture project there are many questions to ask to gather requirements.  First review your projects stated goals and ensure you understand what the expected outcome is of the project.  Which of the 4 architectures are you...Read More »

Enterprise Architecture Vision

Enterprise Architecture Vision

I have created a sample Enterprise Architecture Vision article that includes the best practices described in the TOGAF specification. The scenario for this example is a fictitious health care company currently looking to replace their legacy claim processing system to a...Read More »

Data Architecture of an EA Program

Data Architecture Program

The data architecture program within Enterprise Architecture will include many documents about the data processes within your organization. To begin this exercise you must determine what applications are in scope to explore and document. Then start with the data stores for the applications...Read More »

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...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...Read More »

Parts of an Enterprise Architecture

Enterprise Architecture is consists of 4 areas within the business to document.  Each area is interdependent upon the others.  The process of creating multiple levels enables you to better capture the significant architectural pieces.

The four domains to research and create artifacts for include the following:

  • Business Architecture
  • Application Architecture
  • Data Architecture
  • Technology Architecture

Business Architecture...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...Read More »

What is Enterprise Architecture

Enterprise Architecture (EA) is a logical organization of the business and its supporting data, applications and IT infrastructure

A typical architecture consists of diagrams that show how aspects of the business relate:

  • EA aligns the following 4 areas:
  • Business – Processes, Strategies, Organization Charts and Functions
  • Information – Conceptual, Logical...Read More »