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 currently focusing on within … [Read more…]
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 new system that is quicker and less expensive to maintain for … [Read more…]
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 and document the physical data model. This should be … [Read more…]
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…]
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…]
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 … [Read more…]
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…]
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…]
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…]
Data Mining SQL Server 2012 Included in your purchase of Microsoft’s SQL Server 2012 is the ability to perform data mining techniques. This feature comes as part of Analysis Services via the Data Mining model. There are 9 total algorithms included broken into 5 types within SQL Server. The types of Data Mining are: Classification … [Read more…]