Uma Mahesh

Uma Mahesh

Author is working as an Architect in a reputed software company. He is having nearly 21+ Years of experience in web development using Microsoft Technologies.

Principles for microservices integration

Out of the many advantages of microservices, the most significant motivations are scale and autonomy for business units. These go hand in hand. However, we still need to create an integrated experience that makes sense for the end user. It’s…

Monolithic vs Microservices

Strengths of Monolotic Architecture Easier Debugging and End-to-End Testing: Unlike Microservice Architecture, Monolithic Applications are much easier to debug and test. Since a Monolithic Application is a single indivisible project, you can perform end-to-end tests much faster. Easy Deployment: One advantage associated with the Monolithic Applications being a single piece is easy…

Microservices

In short, a microservice building style is a way to build a single system as a bundle of small services, each running its own process and interacting with lightweight processes, usually an APT for HTTP resources. These services are built on business skills and operate independently with automated transmission systems. There is a small centralized management of these services, which can be written in different editing languages ​​and use different data storage technologies.

Reasons for Excessive Log Growth

There are several reasons for excessive log growth. Please go through the below possible reasons. Operating a database in FULL recovery model, without taking log backups Performing index maintenance Index maintenance operations are a very common cause of excessive transaction…

Physical Architecture of Transaction Log

The physical architecture of the transaction log is shown in below image. It is split internally into smaller chunks called virtual log files (or VLFs). These are simply an aid to easier internal management of the transaction log. When a…

Finding Size of Index

Below Store Procedure Provides the Indexes and its sizes for the given table CREATE PROCEDURE getIndexSizes ( @tblName VARCHAR(500) ) AS EXECUTE AS CALLER; BEGIN SELECT OBJECT_NAME(i.object_id) AS TableName , i.name AS IndexName , i.index_id AS IndexID , ( 8…