Resources   No resource found

• Mastering Named, Positional, and Input/Output Parameters in Stored Procedures with EF CoreMay 22, 2025. Understanding Name Parameters, Positional Parameters, Input/Output Parameters, and Their Usage in Stored Procedures with EF Core
• Real-Time Data Retrieval from APIs Using SSISMay 14, 2025. This article explains how to integrate APIs with SQL Server Integration Services (SSIS) to automate data retrieval using HTTP requests. It covers API setup, SSIS package creation, and script task configuration.
• Passing Connection as Input Parameter in PowerShell FunctionsApr 14, 2025. Easily reuse a single SharePoint Online admin connection in PowerShell functions to fetch QA site info efficiently, reducing redundant logins and enhancing performance in M365 automation tasks.
• Understanding Parameter Sniffing in SQL ServerMar 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.
• Understanding in, ref, and out Parameter Modifiers in C#Mar 09, 2025. Learn how to use in, ref, and out parameter modifiers in C# with practical examples. Understand their differences, use cases, and best practices for passing arguments efficiently.
• Scope Communication Object in JSP Feb 28, 2025. The Scope Communication object consist of session object, application object and pageContext object.
• Remove IIS Log Files (4-1) --- Managing Sensitive Info in AWSFeb 24, 2025. This article will discuss parameter store and Secret Manger in AWS
• Essential C# KeywordsDec 25, 2024. This article explains important C# keywords that help in writing more efficient code. It covers keywords like volatile, value, get, set, yield, partial, and where, describing their uses in a simple manner. These concepts are essential for anyone looking to improve their C# programming skills.
• User-Defined Functions in SQL ServerNov 21, 2024. SQL Server supports two types of User-Defined Functions (UDFs): Table-Valued and Scalar-Valued. Table-valued functions return a table based on logic, while Scalar-Valued functions return a single value.
• Explaining Deep Linking in Power Apps Nov 12, 2024. Deep linking in Power Apps enables direct navigation to specific screens, improving user experience and engagement. By using URL parameters, custom schemes, and StartScreen functions, developers can create targeted, optimized user journeys.
• Mark Input Parameters in Triggers as OptionalOct 28, 2024. In this article, we’ll walk through how to mark input parameters as optional in Power Automate triggers and explore how this can improve flow flexibility.
• Efficient Data Handling in SQL Server with Table-Valued ParametersOct 27, 2024. This article delves into how TVPs enhance performance by enabling the transfer of multiple rows of data in a single parameter, streamlining stored procedures, and optimizing database operations.
• Detailed use of Action Delegate in C#Sep 11, 2024. In C#, the Action delegate represents a method that does not return a value and can accept up to 16 parameters. It's useful for passing methods as arguments, callbacks, and event handling. It supports lambda expressions and anonymous methods, making code more concise. Unlike Func<T>, Action always returns void.
• Different Ways to Redirect and Retrieve ID Parameters in AngularSep 02, 2024. Angular offers various methods for navigation and parameter handling in web applications. Use the RouterLink directive for simple navigation, the Router service for programmatic control, and ActivatedRoute to retrieve parameters.
• Stream Conversations with Amazon Bedrock API in .NET Console AppAug 12, 2024. Learn how to create a .NET console application that streams conversations using the Amazon Bedrock Converse API with the Anthropic Claude 3 Sonnet model. This guide covers setting up your AWS environment, configuring Visual Studio, and using the AWS SDK to handle streaming conversations and model responses.
• Encrypting Header & Request Body Parameters in .NET Core Web APIJul 24, 2024. In this article, we'll explore how to encrypt header and request body parameters in a .NET Core Web API to prevent them from being readable in the page source or by network sniffing tools. We'll use an example application developed by "Nikunj Satasiya" to illustrate the process.
• The Implementation of Pointer to FunctionJun 27, 2024. This content explores the implementation of pointers to functions in C and C++ programming. It delves into their syntax, usage, and benefits, such as dynamic function calls, callback functions, and efficient memory management.
• Editing JSON of Fabric Data Pipelines - Part 1Jun 21, 2024. Enable JSON editing in Fabric data pipelines by appending the 'feature.enableJsonEdit=1' to the pipeline URL. Switch from view-only to edit mode, make necessary JSON changes, then perform a minor UI adjustment to activate the Save option. Similar flexibility as Azure Data Factory's PaaS environment.
• C# .NET 8 SQL Bulk Insert Dapper vs BulkCopy vs Table-Value ParamsJun 18, 2024. Explore the performance of SQL bulk insert methods in C# .NET 8 by comparing Dapper, BulkCopy, and Table-Value Parameters. This comprehensive analysis covers implementation details, efficiency, and best practices for optimizing large data insertions, helping developers choose the right approach for their projects.
• Unlock Small Language Models Deep Dive Parameters Loss Optimization RAGJun 17, 2024. Language models have revolutionized the field of natural language processing (NLP), enabling machines to understand, generate, and respond to human language with remarkable accuracy. At the heart of these models are key concepts that drive their functionality: parameters, loss functions, and optimization.
• The Stochastic Gradient Descent Jun 16, 2024. This article delves into Stochastic Gradient Descent (SGD), a cornerstone algorithm in machine learning and optimization. It explains how SGD optimizes model training by iteratively updating parameters using random data subsets.
• Oracle Stored Procedure Output Parameters with Dapper in ASP.NET CoreJun 11, 2024. This article provides a detailed guide to integrating Oracle stored procedures with ASP.NET Core using Dapper, focusing on handling output parameters, which can often be a challenging aspect of database interactions.
• The Art of JavaScript Hoisting: Understanding the Ins and OutsJun 11, 2024. Discover the intricacies of JavaScript hoisting in this comprehensive guide. Understand how JavaScript handles variable and function declarations, the impact of scope, and the best practices to avoid common pitfalls.
• Delegates in .NET Core C#: Syntax, Usage and ExamplesJun 11, 2024. A delegate is an object that points to a method; alternatively, it may be thought of as a variable of the reference type that stores references to the methods. Function pointer in C/C++, delegates are used in C#. It offers a mechanism to specify which method should be invoked in the case that an event is triggered.
• Pagination in C#: Complete Guide with Easy Code ExamplesJun 08, 2024. Discover how to implement pagination in C# with this comprehensive guide. Learn to use ASP.NET Core, Entity Framework, and LINQ for efficient data paging. This guide covers server-side and client-side pagination, using Skip and Take methods, handling pagination parameters, and provides easy code examples for seamless integration.
• Arrow Function Variants in JavaScriptJun 03, 2024. Arrow functions in JavaScript offer concise syntax for writing functions. They simplify coding with features like no parameter handling, optional parentheses for single parameters, and streamlined function bodies. They're versatile, applicable in various scenarios, like callbacks and high order functions.
• Optimizing Performance with Dapper with .NET Core API May 30, 2024. Learn Dapper best practices for optimal database interaction in .NET applications. Explore techniques like using output parameters and handling multiple result sets in stored procedures. Enhance efficiency with optimized query writing for delete operations.
• UnderStanding nameof Operator in C#May 28, 2024. The nameof Operator retrieves names of variables or members dynamically, aiding in code maintenance. Raising PropertyChanged Event notifies property changes in INotifyPropertyChanged implementations. Argument Checking and Guard Clauses ensure robust code by validating inputs.
• Mastering Azure Bicep ParametersMay 07, 2024. This article is a comprehensive guide that takes you on a deep dive into Azure Bicep parameters. It starts with logging into Azure, then moves on to explain the concept of parameters in Azure Bicep, complete with code samples and explanations.
• Using Stored Procedures in MySQL Enhanced Code PerformanceApr 30, 2024. Stored Procedures in MySQL offer a streamlined approach to executing complex or frequently used SQL logic with a single call, supporting input parameters, procedural logic, and return values.
• Reversing Parameter Order with Named Arguments in C#Apr 24, 2024. In C#, methods often take parameters that are passed in a specific order defined by their method signature. However, there are cases where you might want to reverse the order of parameters when calling a method. One approach to achieve this is by using named arguments.
• Table-Valued Parameters in SQL ServerApr 16, 2024. Table-Valued Parameters in SQL Server enable passing multiple rows of data to stored procedures, enhancing performance for bulk operations. Utilizing user-defined table types, they streamline data manipulation tasks and allow parameterized queries, optimizing database development and improving overall performance.
• 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.
• How to Pass Credentials as Parameters in PowerShellMar 09, 2024. Learn how to securely pass credentials as parameters in PowerShell using PSCredential. This guide covers reading user input, updating a SharePoint Online site title, and using PowerShell modules for secure authentication and logging.
• How to Pass a Parameter to Event Handler or Callback in React.jsFeb 22, 2024. In React, passing parameters to event handlers can be done using arrow functions or the bind method. Choose the approach that suits your project for optimal performance and readability.
• Parameter Binding in Minimal API in ASP.NET CoreFeb 06, 2024. When building web applications using ASP.NET Core, developers often need to handle incoming data from HTTP requests. One crucial concept that helps achieve this is called parameter binding. Let's break down this fundamental idea in the context of Minimal API in ASP.NET Core.
• What is Params In C#?Jan 31, 2024. In C# programming, the "params" keyword plays a crucial role in enhancing flexibility and convenience when dealing with methods that accept a variable number of the same type of parameters.
• JavaScript Destructuring: Arrays, Functions, and ObjectsJan 31, 2024. Destructuring is a powerful feature in JavaScript that allows you to extract values from arrays, objects, and function parameters easily.
• Power BI Parameters for Efficient Data Source ConfigurationJan 30, 2024. This article is about using Power BI Parameters for Data Source Configuration. In this Power BI project, connecting to an on-premise Business Central instance posed challenges during deployment. The solution involved using Power BI Parameters for dynamic and configurable data source connections.
• How to Create Reusable Confirmation Modals in Blazor ServerJan 17, 2024. In this article, we will learn how to make confirmation pop-ups in your Blazor Server applications easily. Follow a step-by-step guide using parameters and EventCallback to create reusable models, making your app more user-friendly and efficient
• Default Lambda Parameters in C# 12Jan 05, 2024. C# 12 introduces a game-changer: default lambda parameters. This article delves into this powerful feature, showcasing its functionalities, advantages, and practical applications through detailed examples across diverse scenarios. Learn how to reduce code duplication and enhance readability.
• Ref Readonly Parameters in C# 12Jan 03, 2024. C# 12 unveils a hidden gem: ref readonly parameters. This article delves beyond the surface, offering a deep dive into their benefits, usage patterns, and how they differ from familiar options like ref and in. Embrace their power for safer, clearer, and more efficient code. In the current digital era, we try to de-couple applications from one another so it is supposed to adapt to plug it in another version or another application easily.
• Exploring Default Lambda Parameters in C# 12Jan 01, 2024. Default Lambda Parameters in C# 12.
• Table(s): Temp Table, Table Variable and CTE (Common Table Expression)Dec 26, 2023. This article will discuss SQL Table like items, including temp table, table variable, CTE, Table-valued Parameters.
• Clean Code : Avoid Too Many Parameters In MethodDec 18, 2023. In this article I will demonstrate code clean up by passing less number of parameters in method. One common challenge developers face is the Excessive parameters in their methods. Excessive parameters in methods can lead to code that is hard to understand, less readability, and challenging to maintain.
• Optional Parameters in SQL ServerOct 26, 2023. Optional parameters in SQL Server refer to the capability of defining parameters within SQL queries that can be left unspecified or set to default values if not provided by the user. This feature enhances the flexibility of SQL statements by allowing developers to create dynamic queries that adapt to different scenarios. By specifying default values or leaving parameters unassigned, optional parameters provide a means to simplify queries while accommodating various filtering or search criteria. This is particularly useful when constructing stored procedures, user-defined functions, or queries in applications where certain parameters may or may not be needed, offering a more versatile and adaptable approach to database interactions in SQL Server.
• PowerShell File Search AutomationSep 22, 2023. This PowerShell script automates file detail retrieval within a specified folder. It filters files by extension, displaying their name, size, and type, simplifying tasks like listing text files.
• Routing in ASP.NET CoreSep 18, 2023. In this article, we delve into ASP.NET Core routing, a fundamental component of web applications. Routing determines how incoming requests are matched to specific actions and controllers, playing a pivotal role in efficient HTTP request handling. We explore the key concepts of ASP.NET Core routing, such as route templates, route values, constraints, and route parameters. Additionally, we provide practical examples to illustrate the implementation of routing in ASP.NET Core.
• Power BI What-If AnalysisSep 12, 2023. Power BI What-If Analysis: Unleash Data-Driven Decision Making
• Insert JSON Array into Table with Stored Procedure ParameterSep 04, 2023. Learn how to efficiently save and insert JSON array data into a database table using SQL Server's T-SQL language, with adaptable concepts for other database systems.
• Gradient Descent OptimizationAug 03, 2023. Gradient Descent is a popular optimization algorithm used in machine learning.
• How to Access AWS Systems Manager Parameter Store using Python?Jul 02, 2023. Learn how to access AWS Systems Manager Parameter Store using Python. Set up the project folder, install required packages, and retrieve parameter values using the boto3 library. Test the code to access parameter values from the Parameter Store.
• Component {Parameters} in BlazorApr 19, 2023. In this article we are going to learn about the how to pass parameters between components in Blazor
• C# 12 Preview Features: Improving Productivity and PerformanceApr 17, 2023. C# 12 Preview Features: Improving Productivity and Performance
• How To Use RedirectToAction With ParameterApr 10, 2023. In this article we will see how we can implement RedirectToAction with parameter
• Stored Procedures Vs Functions In SQL - Types, Differences, And Best PracticesApr 03, 2023. This article provides a comprehensive guide to stored procedures and functions in SQL, including their types and differences. It explains how these powerful tools can simplify database management, enhance security, and improve performance. The article also provides examples of different types of stored procedures and functions, such as simple stored procedures, input and output parameters, scalar functions, and table-valued functions. Furthermore, it highlights the differences between stored procedures and functions in terms of their usage, purpose, and return values. Finally, it includes best practices for using these tools in SQL programming.
• How To Pass JSON As Parameter To Store ProcedureMar 17, 2023. In this article, you will learn how to pass json as parameter to store procedure.
• AWS Systems Manager (SSM) Parameter Store In .NET 3.1 Web APIMar 16, 2023. Grab all the AWS Systems Manager (SSM) Parameter store in .NET 3.1 Web API and use them in entire project through Configuration
• Working With Parameters In Dapper ORMDec 26, 2022. In this article, I'm going to explain how we can get values from In, Out, and return parameters while working with Dapper ORM
• Pass Parameters To A Webresource In Dynamics CRMOct 18, 2022. During certain scenarios we must send some parameters to a Webresource. To achieve this we must make use of comma separated list of parameters option that is present at event level of an form. As an example contact form was taken and passed first name logical name as parameter to get to know about the first name of the selected contact.
• Field Parameter In Power BI DesktopSep 01, 2022. This article will demonstrate the use of field parameter in Power BI Desktop.
• Functions In Flutter 3Jul 05, 2022. In this article, you will learn about functions in Flutter 3.
• Understand Bound Action In Power AutomateMar 25, 2022. During certain scenarios it is required to call bound action . To call a bound action we can do it with javascript , plugins and power automate. In all the other methods except power automate you have to write explicit logic to call an bound action. As an example, we call a sample bound action which was built for contact entity/table from power automate.
• How To Send Parameters To Event CallBacks In BlazorMar 01, 2022. In this article, we will learn what are the steps you need to take to send a parameter in event callbacks in blazor, we demonstrated the same with a Blazor server app.
• How To Call A Function With Parameters From Multiple Screens In PowerAppsFeb 28, 2022. In this article, we will learn how we can call a function with parameters in the canvas app powerapps. Similar to javascript function calling we can also call a reusable formula in PowerApps with the help of toggle control.
• Table As Input Parameters For Stored ProcedureFeb 21, 2022. This article will discuss the StoredProcedure Parameter: DataTable.
• AWS Secrets Manager Vs Parameter Store (Systems Manager)Feb 02, 2022. In this article, you will learn about AWS Secrets Manager Vs Parameter Store.
• How To Access Parameters From AWS Systems Manager Parameter Store In .NET 6 Web APIJan 05, 2022. In this article, you will learn how to access parameters from AWS Systems Manager Parameter store in .NET 6 Web API.
• A Fix To Typescript TS7006: Parameter 'xxxx' Implicitly Has An 'Any' TypeDec 27, 2021. In this article, you will learn about a fix to Typescript TS7006: Parameter 'xxxx' Implicitly Has An 'Any' Type.
• Usage Of uriQuery Function In Power AutomateAug 19, 2021. In Power Automate, most of the common scenario is to extract parameters that are present in website url, which can be achieved easily using uriQuery Function as an example.
• Out Parameters In C# 7.0Jun 02, 2021. In this article, you will learn about Out Parameters in C#.
• Fundamentals Of TypeScriptApr 24, 2021. In this article, you will learn about the fundamentals of TypeScript.
• Site Speed ParametersMar 18, 2021. In this article, you will learn about Site Speed Parameters
• Add Flyout And Identify Selected Option - Dynamics 365 CEFeb 17, 2021. This article is about adding custom flyout button in ribbon and writing script to identify which option is selected
• How To Use Query Parameters In AngularJan 12, 2021. In this tutorial, we'll be looking at Query Parameters feature in Angular which lets you pass data from one route to another.
• Parameters In Blazor Components (Deep Dive)Dec 30, 2020. Explore the intricacies of Blazor component parameters with this deep dive. Learn about data binding, lifecycle methods, and communication between parent and child components for interactive and reusable web applications.
• Working With Query String (Or Query Parameter) In BlazorOct 27, 2020. In this article, you will learn about Query string (or Query Parameter) in Blazor.
• WebAPI BasicsOct 21, 2020. In this article, we are going to learn what is ASP.NET WebAPI and why we need to use webAPI and parameter binding in WebAPI.
• Make Parameters Optional In C#Aug 27, 2020. In this article, you will learn about different ways to make parameters optional in C#.
• How To Use Parameters In Power BIAug 12, 2020. In this article, you will learn how to Use Parameters in Power BI.
• Parameters In Power BI DesktopAug 06, 2020. In this article, you will learn about Parameters in Power BI Desktop.
• Ref Vs. Out Parameter In C#Jul 06, 2020. These 2 widely-used keywords have advantages when it comes to returning multiple values.
• Filter Records By Passing Multiple Parameters In Stored Procedure Using MVCMay 27, 2020. Here we can filter records using by passing various input parameters to stored procedure and Dynamic Sql in MVC.
• ASP.NET MVC - How To Use AJAX With JSON ParametersMay 18, 2020. This article is about the integration of Ajax call by passing JSON format input query parameters using ASP.NET MVC5 platform
• ASP.NET MVC - How to Use Ajax with ParametersMar 18, 2020. This article is about integration of Ajax call by passing multiple input query parameters with ASP.NET MVC5 platform.
• ASP.NET MVC - How To Use Ajax without Passing ParametersMar 13, 2020. This article is about integration of Ajax call without passing any parameters with ASP.NET MVC5 platform.
• How to Make a Parameter Optional in MVCMar 07, 2020. In this article, I'm going to show you how to make parameters optional in MVC.
• Add Custom Parameters In Swagger Using ASP.NET Core 3.1Feb 17, 2020. This article showed you a sample of how to add custom request parameters in Swagger using ASP.NET Core 3.1 and Swashbuckle.AspNetCore 5.0.0
• SQL Bulk Insert And Update Records Using Stored ProceduresJan 20, 2020. Today we will learn how to insert and update multiple records using single stored procedure and user defined table type
• Out Parameter in c# 7.0Jan 17, 2020. Out Parameter in c# 7.0
• Method Parameter And Reference Changes - C# 6 To C# 9 New Features - Day TwoJan 16, 2020. This article covers the changes done for method parameters and method references and focuses on “in”, “out”, “ref” and “readonly” keywords related changes in the newer version of C#.
• Using Table Type Parameter In .NET CoreDec 30, 2019. In many cases, we need to send a list of objects to the stored procedure to save or update the list of data in the database, which helps in increasing the performance of the application. Here I'll explain how to send a list of data to stored procedure from WEB API (Entity Framework) .NET CORE.
• PowerQuery - Dynamically Pass Database Name as Parameter to fetch the Records from Different Datasets using Managed Parameters and FunctionsNov 05, 2019. In this article, we will talk about how we can get the database name using Stored Procedure based on the Customer ID and pass that Database Name to another stored procedure as a Parameter to load the records from that particular dataset using Functions.
• SPFx - Creating Custom Dialog Boxes Without A Javascript FrameworkJul 24, 2019. Learn how to implement custom dialog boxes in SharePoint using SPFx. This tutorial explores extending the Base Dialog class without a JavaScript framework, leveraging npm packages for popup displays.
• How To Pass Parameters To SPFx Extension By Creating A WebPart UI InterfaceMay 29, 2019. In this article, we will learn how to pass dynamic parameters to SPFx extensions by taking user input and enabling extension via custom action.
• How Can You Use Optional Parameters In C#Apr 10, 2019. C# Optional parameters allows us to define methods with optional arguments that are not required to pass by the caller. Learn how to pass optional parameters in C#.
• Send Method As Parameter Java Vs C#Mar 26, 2019. In C# you have delegates, which is pretty straightforward as far as sending a method as parameter in C#. This has not been the case with Java.
• ASP.NET Web API Query String ParameterJan 28, 2019. In this article, we are going to learn query string parameters in ASP.NET Web API.
• Python Print FunctionDec 21, 2018. In this article, we will learn how a Python Print Function works. The syntax of the Python print function is given in here and you can learn about the parameters of Python print function as well.
• Overview Of Optional Route Parameters In AngularNov 25, 2018. In this article, we are going to learn the optional route parameters in Angular. Sometimes it may be the requirements that we want the component view to be rendered on the basis of some values coming from the route parameter or we just want to render the component with some additional functionality with the help of some values coming from parameters.