Category Archives: Database

Database

Monolith database to Microservice database using expand contract pattern

By | March 25, 2023

Splitting a monolithic database into microservice databases using the Expand-Contract pattern involves breaking down the monolith into smaller, more focused databases that are better suited to the individual microservices they support. This can help to reduce coupling between services, improve scalability, and simplify maintenance and updates. The Expand-Contract pattern involves the following steps: Identify the… Read More »

SQL Server Password

By | October 9, 2015

Introduction How to reset SQL Server password. This post is all about helping users to unlock, or have a backdoor access to SQL Server database when they are locked out. The post will help in resetting SA password or adding a new user with SysAdmin privileges. You can always trim down user role later but this… Read More »