The Hidden Power of C#: Lazy Iteration with the Yield Keyword
Introduction In C#, writing performance-oriented code is often a critical goal. When working with large data sets, memory usage and performance become essential considerations. The yield keyword is a hidden gem in C#, offering developers a way to improve performance, especially when iterating over large collections. In this article, we’ll explore how the yield keyword…
MSSQL’s Hidden Power: FileTable for File Management and Real-Life Usage
MSSQL is widely recognized as a relational database management system (RDBMS), but its advanced file management capabilities often go unnoticed by many developers. One of these features is FileTable, which uniquely integrates database management and file system access. In this article, we’ll explore what FileTable is, how it works, and how it can be applied…
Customizing Swagger for .NET 7 and Beyond: Taking Your REST API Documentation to the Next Level
With the evolution of REST APIs, developers have increasingly turned to various tools to better document and present their APIs. One of the most popular tools is Swagger, also known as the OpenAPI Specification (OAS). Swagger provides a standard set of rules for documenting APIs, defining endpoints, data models, sample requests and responses, and error…
A Comprehensive Guide to System Functions in MS SQL
Microsoft SQL Server (MS SQL) offers a wide range of built-in functions to facilitate data management and analysis. These functions streamline data manipulation, analysis, and transformation, making development processes more efficient. In this article, we will explore the system functions available in MS SQL. 1. Introduction to System Functions System functions in SQL Server are…
Using WITH in MSSQL
Using WITH in MSSQL In Microsoft SQL Server (MSSQL), the WITH clause is commonly used to create Common Table Expressions (CTEs). CTEs are temporary named result sets that simplify complex queries, making them easier to read and write. In this article, we will explore how to use the WITH clause and how it can be…
Gökhan Aravi
Code is like humor. When you have to explain it, it’s bad.
