Category Blogs

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

Enterprise Integration: API Management Vendors Landscape

In enterprise integration area, there are more and more REST APIs than ever. API management turns to be very important for every organization.

I collected the logos of some main API management vendors, along with the logos of those vendors who offer tools that have dependencies with API management, such as data modeling tool, service registry, identity management and application infrastructure, put them together with vendors’ logos who offer monitoring, DevOps and logging services. So we understand the technology stack of API management.

API Management Vendors’ Landscape

In API management box, I put vendors logos according to Gartner Magic Quadrant for API management...

Read More

The Essentials of Web Application UX Design

To outline the essentials of web application UX design is hard since it involves many contents, including design principles, interaction mode, screen pattern, navigation, workflow, visual design, theme, components, color palette, icon pattern, graphic, i18n and accessibility etc.

I would draft this based on my experience worked on a few large scale web application projects. This can be a great start point if you want to create a UX solution design for a web application.

Design principles: User-centric, know what user wants and support users their way.

Common interaction elements: masthead, utility bar, navigation, content pane, help drawer, footer, modal and notifications.

Navigation can include masthead and sub-navigation menu. Masthead represents the overall structur...

Read More