Want to become a Vibe Coder? Join Vibe Coding Training here
x
C# Corner
Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
Tags
No tag found
Content Filter
Articles
Videos
Blogs
Resources
News
Forums
Interviews
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Dashrath Hapani(8)
Jay Krishna Reddy (5)
Jignesh Kumar(5)
John Godel(4)
Naveen Kumar(4)
Muhammad Imran Ansari(3)
Praveen Raveendran Pillai(3)
Rohini Parade(3)
Ajay Kumar(3)
Divyansh Gupta(2)
Ayush Gupta(2)
Ashish Bhatnagar(2)
Vishal Yelve(2)
Mark Pelf(2)
Mohamed Azarudeen Z(2)
Suraj Vishwakarma(2)
Sanjay Kumar(2)
Onkar Sharma(2)
Priya Chavadiya(2)
Bimalshi Jayarathna(1)
Aishwarya Gupta(1)
Maria Joshua Roy(1)
Sridharan D(1)
Mukesh Sagar(1)
Siddhesh Chavan(1)
Mohomed Shihan(1)
Morteza Mousavi(1)
Satheesh Elumalai(1)
Kapil Singh Kumawat(1)
Jayraj Chhaya(1)
Arumilli Yamini(1)
Vijay Kumari(1)
Jaimin Shethiya(1)
Prarthana Bhat(1)
Rajeev Paliwal(1)
Rama Dabburi(1)
Poonam Beniwal(1)
Allen Oneill(1)
Nitin Pandit(1)
Omar Rodriguez(1)
Rajiv Singh(1)
Jin Necesario(1)
Shweta Lodha(1)
Swesh S(1)
Satish B(1)
Hamed Niazmand(1)
Tural Suleymani(1)
Arun Potti(1)
Gurpreet Arora(1)
Ayushi Jain(1)
Geo J Thachankary(1)
Nandan Hegde(1)
Arpit Shrivastava(1)
Shantha Kumar T(1)
Mohammad Hussain(1)
Nidhi Kumari(1)
Hanif Hefaz(1)
Uday Dodiya(1)
Vipul Kumar(1)
Sandip Jadhav(1)
Lokendra Singh(1)
Resources
No resource found
Mastering LINQ in C#
Jun 25, 2025.
Language Integrated Query (LINQ) is a game-changer in C#. It brings SQL-like data querying capabilities directly into your C# code, making data manipulation more intuitive, type-safe, and readable.
Basic SQL Queries for Database Testing
Jun 23, 2025.
Learn essential SQL queries used in database testing. This guide covers SELECT, JOIN, WHERE, and more—ideal for QA testers and beginners ensuring data accuracy and integrity in applications.
Understanding Select vs SelectMany in LINQ
Jun 19, 2025.
In this article, we are going to learn about the importance of LINQ features of select and SelectMany and the difference between them.
FirstOrDefault vs. SingleOrDefault in LINQ: Key Differences and Use Cases
Jun 16, 2025.
In this article, we'll dive into the key differences between FirstOrDefault and SingleOrDefault, examining their behaviours, ideal use cases, and guidance on when to use each one. By the end, you'll gain a better understanding of how to utilize these methods to optimize data queries in your C# applications.
Table Sharding in SQL: Types, Examples, and Best Practices
Jun 10, 2025.
Table sharding improves database scalability and performance by splitting large tables into smaller, distributed shards. It enhances speed, fault tolerance, and cost-efficiency—ideal for growing applications with heavy data loads.
MongoDB Filter Query Cheat Sheet
Jun 04, 2025.
This article explains how to use filters in MongoDB GUI tools (like MongoDBCompress or Compass) using simple query examples. You’ll learn how to search for records, use conditions, sort results, and filter by dates or partial matches, all without writing any code!
EJB QUERY LANGUAGE (EJB QL)
May 30, 2025.
EJB QL is a query language used to query enterprise beans and their relationships, supporting string and arithmetic functions, with syntax defined using Backus-Naur Form (BNF) for structured query creation.
PLINQ vs LINQ: Use Cases, and Performance Insights in C#
May 25, 2025.
Discover the key differences between LINQ and PLINQ in C#, including their syntax, execution models, performance benchmarks, use cases, and when to choose parallelism for processing large datasets efficiently.
How to Clean Data in Pivot Query in Excel
May 16, 2025.
In this article, we will learn how to clean and prepare your data directly within Pivot Queries in Excel.
Advanced Data Warehouse Modeling and Querying Using C# and .NET 9
May 13, 2025.
Use C# 14 and .NET 9 to design, query, and manage data warehouses efficiently. Automate schema creation, support SCD Type 2, integrate with BI tools, and run high-performance queries for real-time analytics.
Advanced ETL from OLTP Databases to a Data Warehouse with C# 14
May 12, 2025.
Build scalable and efficient ETL pipelines using C# 14 and .NET 9. Leverage Dapper, SQL Server, Azure Synapse, and cloud integration for seamless data extraction, transformation, and loading to data warehouses and lakes.
Improved CRUD operations for GridView with Redshift in ASP.NET Core MVC (Utilizing C# 14 Features)
May 08, 2025.
Learn how to enable CRUD operations in an ASP.NET Core MVC application using Amazon Redshift and C# 14 features. This guide covers setup, connection, SQL commands, data manipulation, security, and best practices.
How to Convert a DataTable to a List of Objects in C#
Apr 27, 2025.
Learn how to convert a DataTable to a List<T> in C#. Explore manual, reflection-based, and LINQ methods for better performance, type safety, and cleaner code. Improve maintainability in modern C# applications.
Understanding Change Data Capture (CDC) and Its Types
Apr 23, 2025.
In this article we are going to learn about the CDC and types of CDC approaches. It helps keep data in sync without causing a heavy load on the database.
Order of Execution in LINQ Queries
Apr 22, 2025.
This article explains the difference between deferred and immediate execution, outlines the execution order, and shares best practices to write efficient and optimized LINQ queries for real-world applications.
Execution Process of SQL Queries vs Stored Procedures
Apr 21, 2025.
Dive deep into the internal execution process of SQL Server queries with this one-of-a-kind article comparing normal SQL queries and stored procedures.
LINQ in C# Tutorial for Beginners: 101 C# LINQ Operations
Apr 17, 2025.
Learn LINQ in C# with 101 essential operations for beginners. Simple examples of filtering, sorting, and joining data to make your code better and faster. Perfect for new C# developers.
.NET 8 - System.Linq.Dynamic.Core – using SQL LIKE
Apr 11, 2025.
System.Linq.Dynamic.Core library does not support SQL LIKE, and I added support for it. Added SQL LIKE support to the System.Linq.Dynamic.Core in .NET 8 using a custom patch. Enables dynamic SQL pattern matching in EF8 projects where built-in LIKE functionality was missing.
Create Foreign Keys Dynamically in SQL Server Database
Apr 10, 2025.
Create the referential integrity constraint i.e. Foreign key dynamically in SQL Server database. This script dynamically adds foreign keys to all tables with a CompanyID column by scanning the database, ensuring they reference the Company table—ideal for retrofitting relational integrity.
New LINQ Features in .NET 9
Mar 29, 2025.
Discover the latest LINQ features in .NET 9 that enhance query performance, simplify data manipulation, and introduce new methods for better efficiency.
Exploring PLINQ (Parallel LINQ) for Parallel Processing
Mar 29, 2025.
PLINQ (Parallel LINQ) is a powerful feature in .NET that enables parallel processing of queries to improve performance on multi-core processors.
Understanding Parameter Sniffing in SQL Server
Mar 24, 2025.
In SQL Server and other relational database systems, query execution performance is critical for handling large datasets efficiently. One common yet sometimes problematic optimization technique is Parameter Sniffing. While it can improve query performance.
SQL Tag Library in Java Server Page
Mar 21, 2025.
JSTL SQL tags are used to access databases and are designed for low-volume Web-based applications.? JSTL SQL tags facilitate database interactions in JSP pages, enabling data source setup, query execution, updates, and transactions through tags like <sql:setDataSource>, <sql:query>, <sql:update>, and <sql: transaction>
Understanding SQL Execution Plans
Mar 20, 2025.
An SQL execution plan outlines how a database executes a query, detailing operations like table scans, index seeks, and joins. Analyzing these plans is essential for optimizing query performance.
Understanding SQL CTE (Common Table Expression)
Mar 19, 2025.
A Common Table Expression (CTE) in SQL is a temporary result set that improves query readability and performance. CTEs simplify complex queries, support recursive operations, and help with aggregation and multi-step calculations.
Understanding Expressions in C#: Dynamic Code and Query Generation
Mar 19, 2025.
Expressions in C# allow dynamic query generation, runtime compilation, and code transformation using Expression Trees. They are widely used in LINQ, ORM frameworks like Entity Framework, and reflection to optimize performance and enable flexible, data-driven logic.
Learn C#: Refactor Code
Mar 18, 2025.
Refactoring in C# enhances code readability, maintainability, and performance by eliminating redundancy, utilizing LINQ, extracting methods, applying null-coalescing operators, and implementing async/await patterns.
Select vs SelectMany in C# LINQ
Mar 17, 2025.
In C# LINQ, Select transforms each element of a collection individually, maintaining the original structure, while SelectMany flattens nested collections into a single sequence, combining all sub-elements.
Running Azure Resource Graph Queries in an Azure Logic App
Mar 12, 2025.
Learn how to run Azure Resource Graph queries within an Azure Logic App to automate resource management and gain insights into your Azure environment.
Most Used GlideRecord Methods in ServiceNow
Feb 27, 2025.
GlideRecord is a powerful ServiceNow API used to interact with database tables. This article explores the most commonly used GlideRecord methods, helping developers query, retrieve, update, and manipulate records efficiently.
Various Methods to Count Occurrences of Each Number in Array or List
Feb 17, 2025.
In this article, I'll show you different ways to count how often a number appears in C#. We'll look at methods like LINQ, Dictionary, GroupBy, and Parallel.ForEach, and see which ones work best for small and large datasets.
Explaining Aggregate Functions in SQL
Feb 14, 2025.
Learn about SQL Aggregate Functions like SUM, COUNT, AVG, MIN, and MAX. These functions help perform calculations on grouped data, such as finding totals, averages, and minimum or maximum values, making data analysis more efficient.
Most common GlideRecord objects in ServiceNow
Feb 04, 2025.
This article provides an overview of common GlideRecord methods in ServiceNow, which are essential for interacting with the platform's database. It covers key methods like querying, inserting, updating, deleting records, and managing permissions.
Be Careful Using Distinct and OrderBy in EF Core Queries
Feb 03, 2025.
Combining Distinct() and OrderBy() in EF Core queries can lead to performance issues. This article explains why and offers solutions for efficient data retrieval.
Installing and Using GitHub Copilot in Azure Data Studio
Jan 31, 2025.
Azure Data Studio helps manage databases and write SQL queries. With GitHub Copilot, it auto-suggests code completions, making complex SQL tasks easier, including writing queries, using JOINs, and generating reports efficiently.
Exploring Snowflake SQL New Capabilities Using SELECT Statement
Jan 29, 2025.
Learn how to leverage new features for efficient data querying, optimization, and advanced analytics in Snowflake’s cloud data platform. Perfect for data professionals.
How to Create A Pivot Table in PostgreSQL
Jan 22, 2025.
This article covers using crosstab functions, grouping, and SQL queries to pivot rows into columns, making it easier to analyze complex datasets. Perfect for data analysis and reporting tasks in PostgreSQL.
Learn Quantifier Operations in LINQ
Jan 21, 2025.
Quantifier operations in LINQ simplify logical evaluations of collections using methods like `Any`, `All`, and `Contains`. They enhance readability, reduce boilerplate, and support efficient data validation and filtering.
Learn about Delegates And Events
Jan 20, 2025.
Delegates and events are key concepts in C#. A delegate is a variable that holds a reference to a method, allowing flexible method calls. Events use the publisher-subscriber model, where a publisher triggers an event and subscribers handle it.
SQL Server – Query Performance – Database Maintenance can Help
Jan 14, 2025.
To improve query performance in an ASP.NET MVC application using SQL Server, periodic database maintenance steps like updating statistics and defragmenting indexes are essential. This includes manual or automatic execution for optimal results.
Local and Global Temporary Tables in SQL Server
Jan 13, 2025.
Discover the differences between local and global temporary tables in SQL Server. Learn how to create, use, and manage temporary tables effectively.
Simplify Your Queries With “AutoInclude” In EntityFramework Core
Dec 30, 2024.
In this article, we will discover how the "AutoInclude" feature in EntityFramework Core simplifies query writing by automatically including related navigation properties.
Printing "Hello, World!" in Java: Different Techniques and Examples
Dec 20, 2024.
This article explores various methods to print "Hello, World!" in Java, introducing beginners to Java's syntax and structure. Examples include basic output, methods, string variables, and StringBuilder for dynamic messages.
SQL Exists: Usage, Syntax, and Examples
Dec 19, 2024.
The "SQL EXISTS" clause is used to test whether a subquery returns any records. It's commonly used in conditional statements to improve query performance. This article covers the syntax, usage, and practical examples of how to implement the EXISTS clause in SQL queries effectively.
Understanding Responsive Applications
Dec 13, 2024.
Create seamless responsive applications compatible with all devices. Learn key tips, including viewport meta tags, CSS media queries, grid systems, accessibility, lazy loading, performance testing, and modern frameworks like Bootstrap or Tailwind CSS.
New LINQ Methods in .NET 9: Index, CountBy, and AggregateBy
Dec 11, 2024.
In this article, I will showcase the new methods: Index, CountBy, and AggregateBy. These powerful additions in .NET 9 bring significant enhancements to LINQ, aimed at improving your coding experience and simplifying data manipulation tasks.
Optimizing Performance in Azure Cosmos DB: Best Practices
Nov 29, 2024.
Azure Cosmos DB optimization enhances performance, scalability, and cost-efficiency. Key practices include selecting the right partition key, customizing indexing, optimizing queries, tuning consistency levels, and leveraging TTL and change feed.
What is a CTE, and How Do You Write a CTE in SQL Server?
Nov 29, 2024.
A Common Table Expression (CTE) in SQL Server is a temporary result set that can be referred to within a SELECT, INSERT, UPDATE, or DELETE query. CTEs simplify complex queries by breaking them into manageable parts.
Learning SEQUENCE in SQL Server
Nov 28, 2024.
A SEQUENCE in SQL Server is a user-defined object that generates a sequence of numeric values in a specified order. Unlike identity columns, SEQUENCE objects are independent of tables, offering flexibility in generating unique numbers.
C# Foundation - Implicitly Typed Variables
Nov 28, 2024.
Implicitly typed variables in C#, declared using the var keyword, let the compiler infer the data type from the initialization expression. This improves code readability and reduces verbosity, especially with complex types.
Webgrid and Gridview in ASP.NET Core and .NET Core Explained
Nov 21, 2024.
Learn dynamic paging and sorting in .NET Core using JavaScript and jQuery. Modify URLs with query strings for seamless server interaction, leveraging Bootstrap for responsive design and intuitive user experience.
.NET 9 CountBy: A New LINQ Powerhouse
Nov 20, 2024.
.NET 9 introduces the CountBy method, a powerful addition to LINQ that enhances querying capabilities. This feature allows developers to count elements based on specified conditions efficiently.
Temporary Tables vs Table Variables in SQL Server Explained
Nov 19, 2024.
This article explores their key distinctions, advantages, and ideal applications, helping users understand when to use each for better query performance and resource optimization.
Unlocking the Power of the SELECT Feature in SQL Server
Nov 18, 2024.
This article explores the basics of the SQL Server SELECT statement, demonstrating how to query data from tables using practical examples. Learn how to fetch specific columns, improve query performance, and understand best practices for using SELECT effectively, with a sample Employees table for clarity.
Data Professionals to LLM/GPT Prompting for Everyday Tasks
Nov 17, 2024.
A guide for data professionals on leveraging Microsoft OpenAI with Python for efficient workflows and enhanced data analysis. Focuses on prompt design, including clear instructions, context, and temperature adjustments.
Understanding IEnumerable In C#
Nov 14, 2024.
IEnumerable in C# is an interface that defines a standard way to iterate over a collection of objects. The IEnumerable interface in C# provides a standard, efficient way to iterate over collections using foreach, enabling cleaner, more readable code, and LINQ integration.
Understanding Distributed and Monolithic SQL Architectures
Nov 05, 2024.
In this article, we explore the key differences between distributed and monolithic SQL architectures. We delve into their respective advantages and disadvantages, focusing on scalability, performance, and data management.
Creating a CQRS Architecture in .NET Core 8
Nov 04, 2024.
This guide outlines a practical implementation of the CQRS (Command Query Responsibility Segregation) architecture using C# and MediatR, emphasizing the separation of read and write operations for better scalability and maintainability.
Windowing Enhancements New T-SQL Enhancement in SQL Server
Oct 29, 2024.
SQL Server 2022 introduces advanced T-SQL features, enhancing window functions, aggregations, and NULL handling. New options like the WINDOW clause and IGNORE NULLS optimize complex data queries, reduce code duplication, and improve readability.
How Select and SelectMany Works in C#
Oct 26, 2024.
Learn key differences, practical use cases, and examples that demonstrate how these methods simplify data manipulation, making it easier to work with nested and complex data structures in C#.
How To Delete Duplicate Rows From A Table In SQL Server
Oct 12, 2024.
This guide explains how to delete duplicate rows from a table in SQL Server. Using common techniques like ROW_NUMBER() with PARTITION BY, you can identify and remove duplicate rows while keeping the original.
TypeScript Object Spread
Oct 10, 2024.
Object spread in TypeScript allows for copying properties of objects or arrays using the spread operator (...), with later objects overwriting properties with the same name, and it can also be used to combine arrays or insert elements at specific positions.
Mastering SQL Query Generation with Azure OpenAI
Oct 09, 2024.
Leverage Azure OpenAI to transform natural language into SQL queries seamlessly. By integrating Azure OpenAI and Azure SQL Database, you can simplify data querying and enhance accessibility. Learn how to set up the environment, construct prompts, and generate SQL queries using powerful AI models.
Exploring Aggregate Functions in Azure Cosmos DB
Oct 07, 2024.
Aggregate functions in Cosmos DB allow efficient data summarization and analysis across multiple documents. They perform calculations such as AVG, COUNT, SUM, MAX, and MIN to retrieve meaningful insights from large datasets.
IS [NOT] DISTINCT FROM New T-SQL Enhancements in SQL Server
Oct 04, 2024.
The "IS [NOT] DISTINCT FROM" operator is one of the key new T-SQL enhancements in SQL Server 2023. It simplifies SQL queries by handling NULL comparisons more efficiently, improving data integrity and performance.
Hidden Gems - Adding the Custom Data to Generative Answers
Oct 03, 2024.
Learn how to input a string variable as custom data for the Generative Answers component in Copilot Studio. Overcome challenges like binding errors and formatting issues by converting large text into a table format using PowerFx. Process data efficiently and generate responses tailored to user queries.
A Detailed Explanation of COUNT in SQL Server
Oct 01, 2024.
This article explores the differences between SQL counting methods: COUNT(*), COUNT(1), COUNT(column_name), and COUNT(DISTINCT column_name). It highlights their purposes, performance considerations, and use cases, emphasizing the importance of choosing the right COUNT function for efficient queries.
Rank and Dense_Rank Function in SQL Server
Sep 30, 2024.
RANK and DENSE_RANK functions in SQL Server assign sequential numbers to rows based on ordering. RANK skips numbers for ties, while DENSE_RANK does not. Both can partition results using the PARTITION BY clause. These functions are commonly used to rank rows, find highest salaries, and more.
Explaning Joins in Azure Cosmos DB
Sep 30, 2024.
Azure Cosmos DB enables seamless querying using SQL-like syntax, allowing joins within JSON documents. This feature facilitates data retrieval from arrays and nested objects within a single container, enhancing the ability to manage complex datasets.
How Func Delegates Work in LINQ
Sep 27, 2024.
In this article, we explore how Func delegates operate within LINQ (Language Integrated Query) in C#. Func delegates enable concise and powerful data manipulation by allowing developers to pass methods as parameters.
Solid Introduction to Expression Trees in C#
Sep 26, 2024.
This article provides a comprehensive introduction to Expression Trees in C#. You'll learn about their structure, how they represent code as data, and their applications in LINQ queries.
How To Get Unique Records Without Using Distinct In SQL Server
Sep 26, 2024.
In this guide, you'll learn how to retrieve unique records in SQL Server without using the DISTINCT keyword. We'll explore alternative methods like GROUP BY, ROW_NUMBER(), and Common Table Expressions (CTE) to optimize performance and handle duplicates more efficiently in your queries.
Explaning MongoDB Logical Operators
Sep 24, 2024.
In MongoDB, logical operators are essential for constructing complex queries by combining multiple conditions. Key operators include $and (for all conditions), $or (for any condition), $not (to negate conditions), and $nor (to exclude all specified conditions).
Learn MongoDB Evaluation Operators
Sep 24, 2024.
MongoDB's evaluation operators enable advanced query operations, allowing for dynamic data retrieval beyond simple comparisons. Key operators include $regex for regular expression matching, $mod for modulus operations, $expr for expression evaluation, and $where for JavaScript-based queries.
Check Disk Space Utilization by Tables in SQL Server Database
Sep 23, 2024.
In this guide, learn how to effectively check disk space utilization by tables in a SQL Server database. We’ll cover essential SQL queries and techniques to analyze table sizes, identify storage usage, and optimize database performance.
Get First Row from Dataverse Table in Power Automate
Sep 22, 2024.
Learn how to retrieve the first row from a Dataverse table using Power Automate. This guide walks you through creating a flow, filtering contacts with emails, and using expressions to extract the first row's contact ID, full name, and email.
Exploring the Performance Boosts in .NET 9
Sep 20, 2024.
.NET 9 introduces key performance improvements, including Native AOT for faster startup times and reduced memory usage, optimized garbage collection, enhanced threading for multicore systems, and HTTP/3 support for improved network performance.
MongoDB Comparison Operators
Sep 20, 2024.
Learn how to use MongoDB comparison operators like $eq, $ne, $gt, $lt, and more in this comprehensive guide. Master querying and filtering data with practical examples and best practices for efficient database operations.
Create Calendar Table Using Power Query
Sep 20, 2024.
We’ll explore step-by-step instructions for transforming date data, implementing essential date functions, and enhancing your data analysis capabilities in Excel and Power BI. Perfect for improving your reporting and time intelligence skills!
Understanding Model Binding in ASP.NET Core with .NET 8
Sep 17, 2024.
Model binding in .NET Core simplifies the process of mapping HTTP request data to action method parameters. It automatically extracts data from various sources like query strings, form submissions, route parameters, HTTP headers, and request bodies, making it easier to handle client-server interactions efficiently.
POCO to Dictionary Conversion Techniques in C#
Sep 16, 2024.
This article explores five methods for converting a C# POCO to a dictionary using reflection, LINQ, JSON libraries, and ExpandoObject, comparing their performance through Benchmark.NET to find the best approach.
Data Virtualization from Azure Blob Storage in Azure SQL Database
Sep 16, 2024.
This solution enables Azure SQL Database to directly access and read files from Azure Blob Storage using External REST Endpoints, bypassing the need for physical data loading. It leverages database-scoped credentials with a shared access signature (SAS) to securely virtualize external data access.
Explain Switch Case Uses in C#
Sep 11, 2024.
In C#, the switch statement serves as a control structure that enables the execution of distinct code blocks based on the value of a variable. It is frequently utilized when there is a need to compare a variable with multiple constant values and to carry out various actions according to the outcome.
Explain Primary Constructor in C# 12
Sep 04, 2024.
The primary constructor in C# 12 introduces a new way to define and initialize properties directly within the class declaration, simplifying object creation and reducing boilerplate code.
Learn Common Table Expressions (CTE) in SQL
Sep 04, 2024.
Common Table Expressions (CTEs) in SQL are a powerful tool for simplifying complex queries. They allow you to create temporary result sets that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
SQL Subqueries: Correlated, Scalar, and EXISTS/NOT EXISTS
Sep 04, 2024.
Subqueries in SQL are powerful tools for complex queries. They include correlated subqueries, which depend on the outer query’s results, scalar subqueries that return single values, and EXISTS/NOT EXISTS subqueries used to check for record existence.
Filter and Display New Employees in Power Apps with Microsoft Graph
Sep 03, 2024.
Create a Power Apps app that lists new employees who joined this year by using the Microsoft Graph API. With a button click, retrieve and display user data filtered by hire date in a gallery. This app uses Office 365 Users, date pickers, and custom API queries to show employee names efficiently.
Power Query: Best Practices for Memory Consumption
Sep 02, 2024.
To optimize memory usage in Power Query, filter data early, minimize query steps, and utilize query folding to reduce data processed. Disable background data loading, optimize data types, use dataflows for repetitive tasks, split large files, and consider upgrading to a 64-bit version for better performance.
Introduction to SQL Server & Its History
Sep 02, 2024.
Learn how to create, manage, and query databases using SQL Server, with a focus on essential concepts like database design, data storage, and SQL queries. Perfect for beginners aiming to build a strong foundation in database management.
Dynamic LINQ with Gridify in .NET
Aug 30, 2024.
Learn how to leverage Gridify to simplify complex filtering, sorting, and pagination tasks. Perfect for developers seeking to optimize and extend their use of LINQ in C# applications.
Crafting Efficient and Maintainable C# Code
Aug 28, 2024.
This guide explores essential C# best practices for robust, maintainable code. It covers using meaningful variable names, following naming conventions, handling null values, and using var judiciously.
Inner Join vs Cross Apply and Left Outer Join vs Outer Apply
Aug 28, 2024.
In SQL, INNER JOIN and CROSS APPLY differ in functionality; INNER JOIN merges rows based on a condition, while CROSS APPLY uses a table-valued function for dynamic row operations. LEFT OUTER JOIN includes unmatched rows as NULL, whereas OUTER APPLY combines this with table-valued functions for enhanced flexibility.
Understanding IN vs EXISTS in SQL
Aug 22, 2024.
Explore the differences between the IN and EXISTS operators in SQL. Learn how each operator affects query performance, and understand their use cases in filtering and retrieving data. This guide provides insights into optimizing subqueries and improving SQL query efficiency.
Explain Subqueries in PostgreSQL
Aug 16, 2024.
Subqueries in PostgreSQL allow you to nest queries within other queries, enabling complex data retrieval. They can be used in various SQL clauses such as SELECT, FROM, WHERE, HAVING, and JOIN. Types include scalar, row, and table subqueries, with correlated subqueries providing powerful filtering capabilities.
Recursive CTE: Simplifying Complex Queries with SQL
Aug 16, 2024.
Recursive CTEs in SQL simplify querying hierarchical or recursive data by breaking down queries into anchor and recursive members. They are ideal for traversing structures like organizational charts or file directories, offering improved readability and performance.
How to Upload a File to Amazon S3 with NodeJS
Aug 06, 2024.
Implementing pagination and filtering in an ASP.NET Core 8.0 API with Entity Framework Core (EF Core) is crucial for efficiently managing large datasets. This guide covers setting up the project, creating models and context, and modifying controllers to handle pagination and filtering.
Learn About .NET 9 LINQ Enhancements
Aug 05, 2024.
In .NET 9, two new LINQ methods enhance code simplicity and readability: .CountBy and .AggregateBy. .CountBy counts elements by key, simplifying grouping and counting tasks. .AggregateBy streamlines aggregation operations, reducing complexity.
CQRS Design Pattern and Its Use Case
Aug 05, 2024.
In this article, we will explore its use cases in microservices and domain-driven design, focusing on event sourcing, command and query handling, and optimized data management.
Understanding ROW_NUMBER() in SQL Window Functions
Aug 02, 2024.
ROW_NUMBER() is a window function in SQL that assigns a unique number to each row within a partition of a result set. It’s useful for ranking, removing duplicates, pagination, and selecting the top N per group. Use PARTITION BY to group rows and ORDER BY to sort them within each partition.
LINQ Best Practices
Aug 01, 2024.
Discover essential LINQ best practices for writing efficient, readable, and maintainable code in C#. Learn tips on query and method syntax, performance optimization, and effective use of lambda expressions and extension methods to enhance your .NET applications and streamline data querying.