PinnedDushyantha 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…3 min read·Aug 24, 2023----
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…3 min read·Oct 5, 2023--2--2
Dushyantha KalehewatteSQL Server CursorStructured Query Language (SQL) is a powerful tool for managing and manipulating data in relational databases. While SQL excels at…5 min read·Aug 21, 2023----
Dushyantha KalehewatteMastering Cross-Server Query Optimization with Synonyms, Views, and Partitioning in SQL ServerIntroduction2 min read·Aug 11, 2023----
Dushyantha KalehewatteEnhance SQL Query Performance: Practical TipsIntroduction2 min read·Aug 11, 2023----
Dushyantha KalehewatteStreamlining Data Integration: Uploading Excel File Data to a Database in ASP.NETIntroduction2 min read·Aug 11, 2023----
Dushyantha KalehewatteHow to Utilize Execution Plans for Query Optimization with Nested Loops, Hash Match, Index Seek…Introduction:3 min read·Aug 2, 2023----