Resources   No resource found

• Diving in OOP (Polymorphism and Inheritance – Part 1)Aug 03, 2026. Master C# method overloading and the params keyword in this hands-on OOP guide. Learn compile-time polymorphism with practical code examples.
• How to use ShowColumns() Function in Power Apps Jul 27, 2026. Master Power Apps' ShowColumns() function to select specific data columns, streamlining your apps and improving performance. Learn syntax and examples.
• Selecting the Right Embedding Model for a New DomainJun 20, 2026. Empirically select the best embedding model for specialized domains using LangGraph. Optimize RAG performance beyond general knowledge.
• AI Model Routing: Selecting the Right LLM for Every RequestJun 15, 2026. Optimize AI costs & performance by routing requests to the right LLM. Discover strategies for efficient model selection.
• Mapping Multi-Select Lookup Values with Comma-Separated Fields in Power AutomateApr 15, 2026. Learn how to map multi-select lookup values to comma-separated fields in Power Automate! This guide provides a solution for correlating supplier codes with POIds.
• How to Prevent SQL Injection Attacks in Modern Web ApplicationsMar 17, 2026. Protect your web applications from SQL Injection! Learn effective techniques like prepared statements, input validation, and ORM frameworks to secure your database.
• How to Prevent Resource Overload: A Beginner’s Guide to SemaphoreSlimMar 06, 2026. Master SemaphoreSlim in .NET to prevent resource overload! This beginner's guide covers async programming, real-world examples, and best practices for thread safety.
• Difference Between SELECT [Section] FROM sectionmaster and SELECT Section FROM sectionmaster in SQLFeb 27, 2026. Understand the subtle difference between `SELECT [Section]` and `SELECT Section` in SQL. Learn when to use square brackets for escaping identifiers and avoid syntax errors. Master SQL queries!
• SQL Fundamentals: Understanding SELECT, WHERE, ORDER BY and Limiting ResultsFeb 24, 2026. Master SQL basics! Learn SELECT, WHERE, and ORDER BY to retrieve, filter, and sort data. Optimize queries by limiting results for faster, scalable applications.
• Display Selected Date from Slicer in Card Dynamically in Power BIFeb 20, 2026. Dynamically display a selected date in a Power BI card and filter a table. Learn how to create interactive dashboards with date slicers and DAX measures.
• Control Statements in ProgrammingFeb 11, 2026. Master control statements in programming! Learn about decision making (if/else, switch), loops (for, while), and jump statements (break, continue) with clear examples.
• Conditional Statements in C#Jan 11, 2026. Master C# conditional statements! Learn to use if, if-else, switch, and the ternary operator for decision-making in your code. Includes practical examples and tips.
• Methods in C# – A Complete and Practical GuideJan 11, 2026. Master C# methods! This guide covers syntax, parameters, return values, overloading, static/instance methods, ref/out, and best practices for clean, scalable code.
• How to get lookup column records in Power Pages using Web APIDec 19, 2025. Learn how to retrieve data from Dataverse lookup columns in Power Pages using Web API and JavaScript. Access related records efficiently and securely with practical examples.
• How to Save Microsoft Forms Multi-Select Choices to a SharePoint Multi-Select Choice ColumnDec 12, 2025. Learn how to seamlessly transfer multi-select answers from Microsoft Forms to a SharePoint multi-select choice column using Power Automate. Streamline your data collection!
• How to Create or Update Multi-Select Person or Group Column in SharePoint Using Power AutomateDec 07, 2025. Learn how to create or update SharePoint multi-select Person or Group columns using Power Automate, including validating Office 365 users to skip invalid emails and ensure reliable, error-free flows execution.
• Polymorphism in C#: Simple Guide with Examples for BeginnersDec 04, 2025. Explore C# polymorphism: static (compile-time) and dynamic (run-time). Learn function/operator overloading, abstract classes, method overriding, and interfaces. Enhance code reusability!
• Building a Custom Merge Replication for Selected Tables Only (SQL Server + .NET)Nov 17, 2025. Build a custom merge replication system in SQL Server with .NET for selective table syncing, conflict resolution, and incremental updates. Control, version, and monitor your data!
• Python - Importance of Function and OperationsNov 04, 2025. Explore Python functions: syntax, parameters, variable arguments, and return statements. Learn to build practical tools like temperature converters and password checkers.
• Automating Bank Statement Analysis with LLMs & RAG TechniquesNov 04, 2025. Explore how this project automates bank statement processing, uses OCR + layout models + embedding + vector DB + LLM + RAG to convert PDF statements into structured data and enable natural-language querying and financial insights.
• SQL Injection — what it is, how it works, and how to stop it (with examples)Nov 04, 2025. SQL Injection (SQLi) explained: Understand how attackers exploit vulnerable SQL queries to steal or modify data. Learn practical defenses with code examples and best practices.
• Understanding Method Overloading and Overriding in C# WebFormsOct 29, 2025. Master C# WebForms with method overloading and overriding! This tutorial provides a real-time example, showcasing compile-time and run-time polymorphism in action.
• Understanding Constructor Overloading in C# WebFormsOct 29, 2025. Master C# constructor overloading in WebForms! Learn to initialize objects flexibly with different parameters. Real-time example included for practical use.
• Understanding Constructor Overloading in C# WebFormsOct 29, 2025. Master C# constructor overloading in WebForms! Learn to initialize objects flexibly with different parameters. Real-time examples & practical use cases included.
• Chapter 4: Control Flow: Decisions and Loops in C++Oct 23, 2025. Master C++ control flow with this guide to decision-making and loops. Learn to use if, else, switch statements for conditional execution. Explore while, for, and do-while loops for code repetition. Discover how break and continue keywords provide fine-grained control, enabling you to create dynamic and efficient C++ programs.
• Chapter 5: Functions: Modularizing C++ CodeOct 23, 2025. Master C++ functions! This chapter explores modular programming, covering function definition, calling, prototypes, parameters, and arguments. Learn about void functions, function overloading for code flexibility, and variable scope (local vs. global). Discover how functions enhance code reusability, readability, and overall program organization for efficient C++ development.
• Chapter 13: Operator Overloading and Friend Functions in C++Oct 23, 2025. Learn to overload binary and unary operators, enabling seamless operations like addition for custom classes. Discover how to overload stream operators (<<, >>) for easy object output with std::cout. Understand friend functions and classes, granting access to private members for non-member functions like overloaded stream operators, ensuring efficient and elegant code.
• All you need to know about switch expression and Modern Pattern MatchingSep 22, 2025. Explore the evolution of the C# switch statement from its traditional constant-based form to the powerful pattern matching capabilities of modern C#. This article covers type patterns, relational patterns, positional patterns, and switch expressions introduced in C# 7.0 and later. Learn how to leverage these features for cleaner, more expressive code and improved conditional logic.
• Can AI Summarize Long Articles or Emails Efficiently?Sep 01, 2025. Tired of information overload? Discover how AI summarization tools use NLP to condense lengthy articles and emails into concise summaries, saving time and improving retention. Explore the benefits, limitations, and best practices for using AI to efficiently manage digital information. Learn about extractive and abstractive summarization and the future of LLMs in this field. A game-changer for productivity!
• What are truthy and falsy values in JavaScript?Aug 27, 2025. Learn the difference between truthy and falsy values in JavaScript. Understand how Boolean conversion, type coercion, and conditional statements work with examples to write cleaner, bug-free code.
• Difference Between Method Overriding and Method Overloading in Python?Aug 25, 2025. Understand method overriding vs. overloading in Python. Learn how inheritance and polymorphism enable overriding, while default arguments simulate overloading. Master Python!
• Mastering the Filter Array Action in Power Automate: A Complete Guide for Dynamic Data Filtering 🔥Aug 22, 2025. Learn how to effectively use the Filter Array action in Power Automate to filter and extract specific data from arrays and objects. This guide covers practical examples, real-world use cases, and advanced tips to streamline your flow logic and handle complex conditions with ease.
• How to show slicer selected values in Power BI ReportsAug 20, 2025. This DAX measure in Power BI dynamically displays selected slicer values like Fiscal Year, Region, Business Type, and Channel, creating a clear, user-friendly title for reports when filters are applied.
• To Backup Data From the tables1 and table2 in SQL ServerAug 06, 2025. Learn how to back up data from specific tables in SQL Server using simple SQL queries. This article covers methods like SELECT INTO, INSERT INTO, and full database backup commands to help you secure data from individual tables without performing a full database backup.
• SQL Cheatsheet: A Simple and Complete GuideAug 07, 2025. Master SQL fundamentals with this comprehensive cheatsheet covering queries, joins, functions, constraints, and performance tips—ideal for beginners and professionals working with relational databases across any industry.
• What are indexers in C#?Aug 07, 2025. Exploring indexers in C# is a powerful feature that lets objects behave like arrays. We'll explain the basics in simple language, compare them to properties, cover multiple examples including overloaded and multi-parameter indexers, and share real-world use cases.
• To Delete a Row from Table in SQL ServerAug 06, 2025. Learn how to delete a row from a table in SQL Server using the DELETE statement. This guide explains the syntax, provides examples of deleting rows by specific conditions, and highlights the difference between DELETE and TRUNCATE. Whether you are removing a single record or multiple rows, this article covers the essential steps and best practices for safe data deletion.
• Real time Example of Constructor ChainingJul 23, 2025. Learn how constructors work in Java, including overloading, static constructors, and constructor chaining using the `this` and `base` keywords—demonstrated with real-time examples like the `BankAccount` class.
• Fixing Ambiguous Method Calls in AutoMapper with DI in .NETJul 14, 2025. AutoMapper simplifies object mapping in .NET, but using it with Dependency Injection can cause ambiguous method call errors. Fix this by using explicit types, avoiding objects, and defining clear mapping profiles.
• Understanding Select vs SelectMany in LINQJun 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.
• 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.
• Select vs SelectMany in C# LINQMar 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.
• Overload Resolution Priority in .NET 9Feb 07, 2025. The .NET9 framework introduced a new feature named overload_resolution_priority, which plays a crucial role in resolving method groups. This priority is represented as a 32-bit integer. By default, all methods have an overload_resolution_priority of 0.
• Exploring Snowflake SQL New Capabilities Using SELECT StatementJan 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.
• Using C# 13's Method Overloading and Method OverridingJan 23, 2025. With practical examples, key differences, and tips for mastering these core OOP concepts, Ziggy Rafiq explores Method Overloading and Method Overriding in C# 13.
• Check Input Character is a Vowel or Consonant in Java With codeJan 07, 2025. Learn how to identify vowels and consonants in Java using if-else and switch statements. This article explains character validation and control flow and provides example programs for clarity and practice.
• Checking Leap Year in Java with CodeJan 03, 2025. This article explains how to determine leap years in Java using conditional statements, ternary operators, functions, and Java's built-in `Year` class, with code examples and clear explanations for each method.
• INSERT INTO and SELECT INTO: Which is Better?Dec 06, 2024. In this article, we’ll explore the differences between these two methods, their impact on temporary tables, and practical recommendations for SQL developers, data engineers, and DBAs. Using examples from the AdventureWorks2022 database, we’ll make the concepts clear and actionable.
• Explaining CTE in SQL ServerNov 27, 2024. Common Table Expressions (CTEs) in SQL simplify complex queries by creating temporary result sets. They can be used in SELECT, INSERT, UPDATE, and DELETE statements, supporting scenarios like hierarchical data, aggregation, and filtering.
• Unlocking the Power of the SELECT Feature in SQL ServerNov 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.
• 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#.
• Difference Between Break and Continue in JavaScriptOct 24, 2024. In JavaScript, both break and continue are control flow statements used in loops. The break statement stops the loop entirely when a condition is met, while continue skips the current iteration and moves to the next.
• 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.
• Exaplain Copy Constructor in C#Sep 10, 2024. A copy constructor in C# allows creating a new object by copying an existing object. It duplicates the values of properties and fields from the original object. This method is useful for creating independent object copies, enhancing code readability, and managing object duplication efficiently.
• Create a Material-UI Custom Select Component with React js.Sep 05, 2024. Learn how to create a custom select component using Material-UI with React JS in this tutorial. We’ll walk through setting up Material-UI, designing a customizable select dropdown, and integrating it seamlessly into your React application.
• Introduction to Python OperatorsAug 30, 2024. This article explains Python operators, covering arithmetic, comparison, logical, bitwise, membership, identity, and operator overloading. It includes examples for each, emphasizing their importance in performing operations and comparisons.
• Difference between lock(this) and lock(privateObj) in C#Aug 22, 2024. In multi-threaded C# programming, the lock statement ensures that critical code sections are accessed by only one thread at a time. While lock(this) locks on the current instance, it can expose your object to external locking, leading to potential deadlocks.
• Mastering Site.Selected API Permissions in SharePoint OnlineAug 21, 2024. This guide explains how to configure Sites.Selected API permissions in SharePoint Online. It covers registering an app in Azure AD, adding the Sites.Selected permission, and granting admin consent. It also includes using PnP PowerShell for configuration and troubleshooting common issues like 403 Forbidden errors.
• Transitioning from Switch Statements To Switch Expressions in C#Aug 09, 2024. Explore how to modernize your C# code by transitioning from traditional switch statements to the more concise and powerful switch expressions introduced in C# 8.0.
• UNION vs UNION ALL in SQL ServerJul 24, 2024. The SQL UNION operator combines the results of two or more SELECT statements, removing duplicate rows. In contrast, UNION ALL combines results while retaining all duplicates. UNION may impact performance due to the overhead of duplicate removal, whereas UNION ALL is generally faster and more resource-efficient.
• Difference Between DELETE and TRUNCATE in SQL ServerJul 23, 2024. In SQL Server, DELETE and TRUNCATE are used to remove data from tables, each with distinct characteristics. DELETE is a DML command that logs each row deletion, supports triggers, and respects foreign key constraints, making it slower but more flexible.
• Inner Workings of a Query ProcessorJul 18, 2024. The query processor in a DBMS is pivotal, handling DML and DDL queries through stages like compilation, linking, and optimization. It ensures efficient execution, supporting operations like SELECT, INSERT, UPDATE, and DELETE while maintaining database integrity and performance.
• SQL Merge Statement: Syntax, Usage, and ExampleJun 25, 2024. The SQL MERGE statement combines INSERT, DELETE, and UPDATE operations into a single query, synchronizing data between source and target tables based on key fields. This powerful command efficiently handles data modifications, ideal for maintaining Slowly Changing Dimensions (SCD) in data warehouses.
• Understanding throw vs throw ex vs throw new Exception() in C#Jun 22, 2024. Explore the nuances of exception handling in C# .NET with a deep dive into 'throw', 'throw ex', and 'throw new Exception()'. Learn when to use each technique, their impact on stack traces and exception propagation, and best practices for effective error handling in your applications.
• IIF in Microsoft SQL ServerJun 21, 2024. IIF function in SQL, also known as "Immediate If," provides a concise way to perform conditional evaluations within queries. It allows SQL developers to return different values based on whether a specified condition is evaluated as true or false.
• Garbage Collection (3), C# using statement --- Language support for DisposeJun 17, 2024. This article will discuss the C# using a statement. Garbage collection (GC) in computer science reclaims unused memory automatically. Invented by John McCarthy in 1959, GC simplifies memory management. This series explores GC in .NET, focusing on managed, unmanaged code and the `using` statement for resource management.
• Overloading vs Overriding in JavaJun 12, 2024. Method overloading and overriding in Java, essential OOP concepts for code reusability and polymorphism. Overloading allows multiple methods with the same name but different parameters while overriding lets subclasses provide specific implementations of superclass methods and maintainability.
• Improved Performance by STORED PROCEDURESJun 08, 2024. Stored procedures in relational database management systems (RDBMS) encapsulate frequently used SQL statements for efficient execution. They offer dynamic SQL execution, return values via OUT keywords, and include procedural logic like IF-ELSE and loops.
• Break in C#May 24, 2024. The "break" statement in C# is a control flow statement that terminates the nearest enclosing loop or switch statement. It is commonly used to exit a loop prematurely when a specific condition is met, improving code readability and efficiency.
• Continue in C#May 23, 2024. In C#, the continue statement is used within loops (for, while, do-while, and foreach) to skip the current iteration and proceed to the next one. It's useful for bypassing specific conditions within a loop, enhancing control flow and loop efficiency.
• If Statement in C#May 16, 2024. Master the fundamentals of C# with if statements. Learn to control program flow based on conditions, enabling dynamic decision-making in your code efficiently."
• Understand Azure 900 Microsoft Privacy, Terms, DPAMay 15, 2024. This article is part of the Azure 900 course which describes what type of documents Microsoft shares with its users or customers. These documents deal with privacy, using online services, and handling data.
• Switch Statement in C#May 13, 2024. Learn how to use the switch statement in C# for efficient control flow. Explore its syntax, including case labels, break statements, and default handling. Discover how to leverage switch with enums and expressions for concise and structured decision-making in your code.
• Form Controls and Create Basic Form in Blazor Component Apr 18, 2024. Learn to build interactive forms in Blazor components using form controls like input fields, dropdowns, and buttons. Explore data binding techniques to connect form elements to your component's data model.
• MERGE Stored Procedures in SQL ServerApr 15, 2024. In this article, I present how to use the MERGE statement in a stored procedure to merge a single record and how to use it to merge a list of records by using Table-Valued parameters in SQL Server.
• jQuery Filters: Selecting, Manipulating, and Filtering DOM ElementsApr 05, 2024. jQuery Filters" refer to powerful methods in jQuery for selectively targeting elements within the DOM based on specific criteria. These filters allow developers to efficiently manipulate and interact with HTML elements, enhancing the dynamic behavior of web pages.
• Important PySpark Import StatementsMar 21, 2024. PySpark, the Python API for Apache Spark, has gained immense popularity for its ability to handle big data processing tasks efficiently. In this article, we'll explore the top five import statements in PySpark and delve into their significance in building robust data processing pipelines.
• What is Use of ‘Using’ Statement in .NET?Mar 15, 2024. In this article, we will cover What is the use of the ‘Using’ statement in .NET. The 'using' statement in .NET ensures efficient resource management, prevents memory leaks, and promotes cleaner, more reliable code.
• The Dangling If-Else Problem: A Common Pitfall in ProgrammingMar 08, 2024. Explore the often-overlooked issue of the "dangling if-else problem" in programming through our insightful article. We delve into the ambiguity that arises when multiple if-else statements are nested without clear indentation, leading to unexpected behavior and logical errors.
• Polymorphism Concept in Object-Oriented ProgrammingFeb 12, 2024. What do you mean by polymorphism? Polymorphism is explained with C# examples, Polymorphism, a concept extending beyond programming, is illustrated in everyday scenarios. Electrical outlets serve as an analogy, supporting diverse devices—an example of polymorphism manifesting in real life.
• Code readability is enhanced with C# 10 top-level statementsJan 30, 2024. Ziggy Rafiq discusses tackling challenges in software component specification standards through the implementation of solutions such as adapters and bridges for standard mediation, abstraction and encapsulation for complexity reduction, and version control and configuration management for change tracking. These strategies promote interoperability, simplify complexity, and uphold consistency and compatibility across components and systems.
• If-Else vs Switch Statement in C#Jan 16, 2024. Navigate the decision-making landscape in C# with clarity. Delve into the distinctions between if-else and switch statements, understanding their pros, cons, and optimal use cases for efficient code.
• Join vs. Except and Intersect in SQLDec 06, 2023. SQL Improvement Performance Tips & Tricks. Explore SQL data retrieval methods with JOIN, EXCEPT, and INTERSECT keywords. JOIN combines rows from multiple tables based on a related column, while EXCEPT and INTERSECT compare and combine SELECT statement results.
• How To Select an Avatar Image from Popup to Set as My Profile Picture In Blazor?Nov 22, 2023. In this article, we have learned how to show avatar images as profile pictures.
• Difference Between Overriding and Overloading Methods in C#Nov 10, 2023. Let's know the difference between Overriding and Overloading methods with example.
• Simplify Your Code with Switch Expressions: Patterns and ExamplesNov 06, 2023. In C#8 switch statement enhanced with powerful feature that can simplyfy your code and make it more readable and maintainable. In this article We will explore into C# 8 switch expression and how to use in our code and make it more readable and how to use in different way to write conditional logic and how to leverage pattern matching functionality using switch.
• How C# Continue and Break Statements are Different?Nov 02, 2023. Let's know the difference between continue and break statements.This article provides an explanation of the continue and break statements in C# effectively highlights their essential functionalities within loops. Both of these control flow statements play crucial roles in managing the behavior of loops based on specific conditions.
• Exploring Top Level Statements - Programs Without Main Methods in C#Oct 09, 2023. Top-level statements are a new feature introduced in C# 9 that allows you to write code directly at the root of a file, without having to wrap it in a class or a method.
• Control Structures in R ProgrammingSep 25, 2023. In this article, we will explore the various types of control structures in R, with their syntax, and present example programs with output to illustrate their usage.
• Conditional INSERT, UPDATE, DELETE with MERGE QuerySep 04, 2023. The MERGE statement is a versatile SQL command used for conditional INSERT, UPDATE, or DELETE operations, streamlining database management tasks efficiently in a single query.
• How to Create Stored Procedures for CRUD?Jul 23, 2023. In this article, we will learn how we can create Stored Procedures for CRUD operations in SQL Server.
• SQL: 3 Inserting MethodsJul 17, 2023. This article will discuss 3 SQL Inserting methods.
• C# LINQ With Select and SelectMany OperatorJul 10, 2023. C# LINQ with select and select many operator
• How to Select the Software Model for the Software projectJun 29, 2023. Every Software model provides the software development cycle that helps us to efficient and effective development. By using the Software development process model, we can get the requirements to form the customer very effectively. The software process model provides an effective way of requirement management. The software Process model defines the product business modeling. It provides the testing environment throughout the development cycle. It provides the complete details of the project by documenting all the processes during development. Selecting the software product is a challenging task in the software development process. Select the process model according to the nature of the software product given below we will discuss how can we select the right software process model in the right way.
• How To Use LIMIT in MySQL?Jun 20, 2023. The LIMIT clause is used to limit the number of rows returned by a SELECT statement in MySQL. It is typically used in combination with the ORDER BY clause to specify the order in which the rows should be returned. The syntax for the LIMIT clause is as follows.
• Power Pages - Custom "Select All - Unselect All" button in Lookup records dialogMay 11, 2023. In Power Pages (Earlier Power Apps Portal), OOB support for selecting / deselecting all grid rows in “Lookup records” dialog is not found. Hence, I have built one client-side custom generic feature using Jquery which will be reusable for all such “Lookup records” dialog.
• What is Default Keyword in JavaMay 11, 2023. In this article, you will learn about What is Default Keyword in Java
• SQL Where StatementMay 10, 2023. In this article we will discuss about SQL Where statement
• Conditional Statements in Rust: match StatementMay 04, 2023. In this article, we learn about Conditional Statements in Rust: match Statement
• Conditional Statements in Rust: if StatementMay 03, 2023. In this article we learn about if statement in rust language.