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 approach to existing implementations … [Read more…]
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 (ETL) ETL is … [Read more…]
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 Big Data space. Each … [Read more…]
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 or perhaps delete information … [Read more…]
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 want to store like … [Read more…]
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 several common steps that … [Read more…]
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 as gender that can … [Read more…]
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 or understanding to the … [Read more…]
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”. While the technology may … [Read more…]
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. It is like a … [Read more…]