Table partitioning splits large tables into smaller, manageable pieces while appearing as one table. Essential for billion-row tables. Partition Function Partition Scheme Partitioned Table Benefits Fast archival with partition switching Partition elimination for queries Per-partition maintenance References Partitioned Tables
Read more →Author: Nithin Mohan TK
Hello Namaste! 👋🏻
I'm an accomplished Enterprise Solution Architect & Engineering Leader with 20+ years of progressive experience architecting, building, and scaling transformative enterprise solutions.
⚜️ Solution Architect / AI & Cloud 📌 Galway, Ireland
Node.js Authentication: JWT and Passport.js
JWT authentication is the standard for Node.js APIs. Here’s how to implement it properly with Passport.js. Setup Generate Token Passport Strategy Protect Routes References Passport JWT
Read more →SharePoint Online Lists: CRUD Operations with SPFx
Interacting with SharePoint lists is the most common SPFx task. Here’s how to do it properly with PnP JS. Setup PnP JS Read Items Create Item Update Item Delete Item References PnP JS Documentation
Read more →Entity Framework Core Migrations: Managing Schema Changes
EF Core migrations track database schema changes alongside your code. Here’s how to use them effectively. Basic Commands Migration File Best Practices Always review generated migrations Test Down() methods Use SQL scripts for production Consider data migrations separately References EF Core Migrations
Read more →React Custom Hooks: Extracting Component Logic
Custom hooks let you extract and reuse stateful logic. They’re one of the best features of React Hooks. Creating a Custom Hook useFetch Hook Rules Name must start with “use” Can call other hooks Each use creates independent state References Building Your Own Hooks
Read more →React useReducer: Complex State Logic Made Simple
useReducer is useState’s more powerful sibling. When state logic gets complex, useReducer brings predictability. Basic Usage With Context Combine useReducer with Context for app-wide state management – a simpler alternative to Redux: When to Use useReducer Multiple related state updates Next state depends on previous state Complex state objects Want Redux-like patterns without Redux
Read more →