PinnedDushyantha KalehewatteImplementing an Application with a Secure Authentication System in the MERN StackThe MERN stack of MongoDB, Express.js, React, and Node.js has become one of the most popular choices for building robust web applications…Jun 272Jun 272
PinnedDushyantha KalehewatteBest Practices for Developing Middleware in ASP.NET CoreMiddleware in ASP.NET Core plays a crucial role in processing HTTP requests and responses. It allows developers to modify, inspect, or…Oct 5, 20232Oct 5, 20232
Dushyantha KalehewatteUnderstand useEffect and Common mistakes and best practicesOne of the most basic utilities that a React function component can use is the useEffect hook. But there are pitfalls that can be avoided…Jul 5Jul 5
Dushyantha KalehewatteUsage of PIVOT and UNPIVOT in SQL serverIn the world of data manipulation, UNPIVOT and PIVOT operations in SQL Server stand out as versatile techniques to transform data…Aug 24, 20231Aug 24, 20231
Dushyantha KalehewatteSQL Server CursorStructured Query Language (SQL) is a powerful tool for managing and manipulating data in relational databases. While SQL excels at…Aug 21, 2023Aug 21, 2023
Dushyantha KalehewatteMastering Cross-Server Query Optimization with Synonyms, Views, and Partitioning in SQL ServerIntroductionAug 11, 2023Aug 11, 2023
Dushyantha KalehewatteEnhance SQL Query Performance: Practical TipsIntroductionAug 11, 2023Aug 11, 2023
Dushyantha KalehewatteStreamlining Data Integration: Uploading Excel File Data to a Database in ASP.NETIntroductionAug 11, 2023Aug 11, 2023
Dushyantha KalehewatteHow to Utilize Execution Plans for Query Optimization with Nested Loops, Hash Match, Index Seek…Introduction:Aug 2, 2023Aug 2, 2023