Skip to main content

Monolith vs Microservices in .NET Core

  Monolith vs Microservices in .NET Core 1. Monolithic Architecture Definition : A single, unified codebase where all modules (UI, business logic, data access) are part of one large application. Deployment : Deployed as a single unit (e.g., one .exe or .dll ). Scaling : Scales by cloning the entire application (vertical/horizontal scaling). Communication : Internal method calls (no network). Tech Stack : Typically limited to a single framework/runtime. Example in .NET Core : An ASP.NET Core MVC app with controllers, services, and EF Core all in the same project. Single database, one codebase, deployed to IIS/Kestrel. 2. Microservices Architecture Definition : A collection of small, independent services, each responsible for a specific business function. Deployment : Each service runs independently (often in Docker containers). Scaling : Scale individual services based on demand. Communication : Via APIs (REST, gRPC, message queues). ...
Post a Comment

Recover SQL Database from Emergency Mode to Normal Mode

 The steps in the recovery plan are defined by the database administrator to recover SQL Server databases in an emergency situation or if they believe the databases have been compromised. These steps first begin with bringing the server into EMERGENCY mode, reading data from it using statements like SELECT statements and executing DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS command on it.


ALTER DATABASE DBNAME

SET SINGLE_USER WITH ROLLBACK IMMEDIATE 

DBCC CHECKDB (DBNAME, REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE DBNAME SET MULTI_USER


Now refresh the database and it will be back online.


The simplest way to revert a SQL database back to normal mode is to restore it from the latest available backup. In case, if no valid backup exists then the next option is to repair it online by re-copying the data pages and removing dangling objects. If there are no options left and you are still in a dire need of data from that corrupt database, then Stellar Repair for MS SQL software is highly recommended. It uses advanced recovery algorithms for optimum range of corruption ranges, fixes all detected errors, recovers deleted SQL Server data and table rows from FAT/FAT32/NTFS volumes under minimal downtime, making it possible to access almost all the SQL data lost due to index corruption. If your database is stuck in the EMERGENCY state due to errors like DBCC CHECKDB IN EMERGENCY MODE or OPENROWSET with SINGLE_PAGE_ALLOCATION failed when it should have been in ONLINE state, use Stellar Repair for MS SQL utility to recover your corrupt DB without taking any downtime.

Comments

Post a Comment

My Blog

How to Deploy a Full-Stack Web Application on a Cloud Server (Step-by-Step)

How to Deploy a Full-Stack Web Application on a Cloud Server (Step-by-Step) How to Deploy a Full-Stack Web Application on a Cloud Server (Step-by-Step) Keywords: cloud server and application, deploy full-stack app, cloud deployment tutorial Deploying a full-stack web application on a cloud server might seem intimidating, but with the right guidance, it’s simpler than you think. Whether you're building with Node.js, React, or Python, this guide will help you move from development to production step-by-step. 🚀 Step 1: Choose a Cloud Server Provider Popular cloud hosting providers include: Amazon EC2 Google Cloud Compute Engine DigitalOcean Microsoft Azure For this guide, we’ll use Ubuntu 22.04 LTS on DigitalOcean Droplets . 🔐 Step 2: SSH into Your Cloud Server ssh root@your_server_ip Make sure you have your SSH key or password set up. You can generate a key using: ssh...
Post a Comment
Read more

The Ultimate Guide to SQL Server Version Upgradation for Cloud Applications (2025)

  The Ultimate Guide to SQL Server Version Upgradation for Cloud Applications (2025) Upgrading your SQL Server version is no longer just a routine maintenance task—it's a strategic move that impacts performance , security , and cloud compatibility . Whether you're modernizing legacy systems or preparing your application for cloud migration , using the right SQL Server version is critical. In this blog, we’ll explore: Why upgrading SQL Server matters in 2025 Benefits of new SQL versions for cloud use Best SQL Server versions for cloud-based applications Real-world examples Tools & steps for smooth upgradation Image explanation External references for further reading Why SQL Server Version Upgrade Is Important in 2025 Security Compliance Older versions like SQL Server 2012 or 2014 are out of support , leaving you vulnerable to threats. Performance Gains New versions include intelligent query processing , in-memory database support , and fa...
Post a Comment
Read more

.NET C# interview questions – the kind that interviewers actually ask to test depth, not just theory.

  .NET C# interview questions – the kind that interviewers actually ask to test depth, not just theory. I’ll give you a structured list with Basic → Intermediate → Advanced → Architect-level questions. 🔹 Basic Level (C# / .NET Fundamentals) What is the difference between value type and reference type in C#? Explain boxing and unboxing with an example. What are generics in C#? Why do we use them? What is the difference between const , readonly , and static ? Explain the difference between abstract class and interface . How does Garbage Collection work in .NET? What are extension methods in C#? What’s the difference between IEnumerable , ICollection , IList , and IQueryable ? 🔹 Intermediate Level (OOP, LINQ, Async, EF) Explain Dependency Injection . How is it implemented in .NET Core? What are async/await keywords in C#? How do they work internally? Difference between Task , Thread , and ValueTask . How does LINQ work internall...
Post a Comment
Read more