Resources   No resource found

• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• What Are The Basic HTML Form ControlsMay 02, 2023. The HTML is defined form controls to manage the form page, registration page, sign up page, etc. That means those controls are used in the HTML form page, called HTML form controls. Here controls mean handling the HTML form tags should be used for creating a responsive form page.
• Understanding Conditional Statements in C#Apr 27, 2023. In this article we are going to cover Conditional Statements of C#. We are going to cover all the statements in depth.
• How to use loops In Rust?Apr 26, 2023. learning for loop, while loop and loop, and also learn break and continue statements
• How to Use Aggregate Functions in SQL Server?Apr 20, 2023.
• How to use MySQL DML commands in RustApr 18, 2023. In this article We learned how to Select, insert, update, and delete data in our database using rust.
• Implementing C# 12's Top-level Statements for Faster, More Lightweight CodeApr 18, 2023. Implementing C# 12's Top-level Statements for Faster, More Lightweight Code
• C# 12's Switch Expressions: A More Powerful Alternative to Traditional Switch StatementsApr 17, 2023. C# 12's Switch Expressions: A More Powerful Alternative to Traditional Switch Statements
• Exception Handling (7), C# Exception Handling StatementsMar 14, 2023. This article will discuss Exception Handling Statements.
• How To Use SQL MERGE StatementJan 10, 2023. In this article, you will learn how to use the SQL MERGE Statement.
• Insight.Database .NET Micro ORM - Executing And Carrying Out SELECT SQL CommandsJan 09, 2023. Insight. The database micro-format for.NET is quick, light, and, dare we say it, fantastic. SQL commands are simple to run using Insight. SqlCommand class and parameters are no longer used. AddWithValue. Insight automatically converts command arguments from an object.
• Replace Multi Select Combobox With Checkbox In Edit FormSep 09, 2022. In this article, we will learn PowerApps edit form customization. We will specifically customize multi select combobox and use multi select checkbox instead.
• How To Execute SQL Statements From Command PromptJul 30, 2022. Here we discuss SQL and how to execute SQL statements in a command prompt.
• Flutter Common Control Flows And Statements 😎Jul 27, 2022. In this article, you will learn about Flutter Common Control Flows and Statements.
• Button On Command Bar Doesn't Appear When An Item Is Selected In Sub Grid Microsoft Dynamic CRM - IssueJun 27, 2022. The mentioned issue would have been commonly encountered by the developers who extensively play around with the sub gird’s, who would have encountered the scenario where in you have a button on the sub grid which gets disappear when you select a sub grid record or doesn’t appear on the sub grid. This article would provide a resolution for such issues whereas the customized button doesn’t appear on one or more grid items selection in MS CRM online as expected.
• How To Select Multiple Images From Gallery And Display On RecyclerView In AndroidJun 27, 2022. In this article, you will learn how to select multiple images from the gallery and display them on recyclerview in android.
• How To Query JSON File Stored In S3 Using S3 SelectMay 26, 2022. In this article, you will learn how to query JSON file stored in s3 using s3 select.
• How To Query Parquet File Stored In S3 Using S3 SelectMay 26, 2022. In this article, you will learn how to query parquet file stored in s3 using s3 select.
• Conditional Statement With C#May 16, 2022. conditional statements are used in a C# or any Object-oriented programming language for check the condition for particular output. In a C# are used four types of conditional statements, if(), else, else if(), switch().
• Understand Switch Statement In Power AutomateApr 12, 2022. Generally to handle multiple conditions then like in javascript and C# .net switch will be used, in the same way in Power automate also we can use Switch action. In this article we can see how it can be used to decide whether a person can take vaccination or not.
• Create, Insert, Update, Delete, Select, Truncate, Drop Statement In Oracle PL-SQLFeb 28, 2022. In this article, you will learn about Create ,Insert, update, delete , select table , truncate table , drop table statement in Oracle Database / PL-SQL.
• Top-level Statements in C# 10Feb 24, 2022. Learn what top level statements are in C# and why, what, and how top level statements work.
• How To Insert A Default Value In SQL StatementJan 03, 2022. This is SQL tips and interesting questions in developers mind how to insert default value in SQL statement when there is no other value
• CETAS (Creating External Table As Select) In Azure Synapse AnalyticsDec 28, 2021. In this article, you will learn about CETAS (Creating External Table As Select) in Azure Synapse Analytics.
• INSERT INTO SELECT vs SELECT INTO In SQL ServerDec 20, 2021. This tutorial will show you the difference between INSERT INTO SELECT and SELECT INTO In SQL Server.