Category ECM

Building Performance Monitoring Layers for SQL Server Farm

One of my banking clients has a large SQL Server farm which hosts support data. Another client uses SharePoint as ECM (Enterprise Content Management) system which relies on underneath SQL Server farm. Both are dependent on the infrastructure operating 24*7*365, both have strong needs to monitor the performance of SQL Server farm.

Let’s see how to build performance monitoring layers for a SQL Server farm. Though this might not be the best approach, it can be a great reference based on technical implementation feasibility under existing IT environment.

A picture is worth a thousand words. Let’s assume that we utilize NetApp as storage, VMware ESXi (vs. Hyper-V) as bare-metal OS. The guest OS is Windows Servers on which SQL Server instances run. As illustrated, scale-out (vs...

Read More

Adobe AEM Technology Stack in Brief

In 2008, I worked on a Web Content Management (WCM) project for Accenture BPO. The client of Accenture spent 1.5 M on purchasing the license and package of the WCM system called Day Communique / CQ. The core team of Day Software contributed to Apache Jackrabbit – an open source content repository, then created the commercial CQ, which includes a content hierarchical repository CRX, an IDE CRX DE and the browser-based authoring and deployment interface. The unique tight bundle of content repository, IDE and smooth web-based deployment environment gains quite a bit clients quickly, especially for those who have deep pocket. In 2009, Day released CQ 5. In 2010, Day CQ 5 was acquired by Adobe and renamed to Adobe AEM (Adobe Experience Manager).

It has been ten years! Now Adobe AEM released ver...

Read More

Building a Content-as-a-Service Platform using Alfresco and Crafter

Content-as-a-Service (CaaS) is a service-oriented mode, where service provider provides content on demand to the content consumer as a service which is licensed under subscription. Many research institutions adopt this mode to provide services on line, such as Gartner, Forrester and Infotech, etc.

The core digital assets are stored in Enterprise Content Management (ECM) system. ECM manages the authoring, versioning, approval workflow, archiving and content retention policies, etc. Web Content Management (WCM) / Content Management System (CMS) is in charge of presenting these content on line.

In previous career life, I experienced multiple combinations between ECM and WCM in different organizations...

Read More