Post
Ask Question
Related resources for Functions
  • Python Functions and Variable Scope LEGB11/29/2024 7:28:30 AM. This article explores Python variable and function scopes, including the LEGB model: Local, Enclosing, Global, and Built-in. Learn practical examples and understand scope behavior for effective coding
  • Rank Functions in SQL server11/26/2024 6:44:08 AM. In this article, we will learn about Rank functions in SQL Server, like RANK(), DENSE_RANK(), ROW_NUMBER(), and NTILE(), are used to assign rankings to rows within a result set.
  • User-Defined Functions in SQL Server11/21/2024 5:14:12 AM. 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 valu
  • Library Component Type in SharePoint Framework (SPFx)11/9/2024 7:06:52 AM. SPFx Library Components enable the creation of reusable, modular code in SharePoint. By centralizing utility functions, services, and UI elements, developers can enhance maintainability and consistenc
  • Exploring the New T-SQL Enhancements in SQL Server 202211/5/2024 5:39:41 AM. In this article we will explore the powerful new T-SQL enhancements in SQL Server 2022, including features like DATE_BUCKET, DATETRUNC, and IS DISTINCT FROM, designed to simplify data handling and opt
  • BIT Functions New T-SQL Enhancements in SQL Server10/30/2024 5:58:33 AM. In this article, we’ll explore some of BIT functions new enhancements in SQL Server 2022, their practical applications, and a modified example to demonstrate their usage.
  • Automate SharePoint Site Creation with Azure Functions and AD Auth10/28/2024 8:53:35 AM. This guide demonstrates how to automate SharePoint site creation using Azure Function Apps with custom Azure Active Directory (AD) authentication. It covers prerequisites, creating an Azure Function A
  • Understanding the Role of Servers in Modern Networking10/25/2024 4:56:40 AM. Servers play a crucial role in modern networking by managing data storage, processing, and communications across networks. From web hosting and cloud computing to secure data transfer, servers enable
  • DATETRUNC New T-SQL Enhancements in SQL Server10/9/2024 6:48:59 AM. This new feature simplifies date truncation by allowing developers to truncate dates to specific intervals, such as year, month, or day. It improves query performance and data manipulation in SQL.
  • Exploring Aggregate Functions in Azure Cosmos DB10/7/2024 4:43:48 AM. 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 insig
  • DATE_BUCKET Function New T-SQL Enhancements in SQL Server10/5/2024 6:28:43 AM. This article will delve into the DATE_BUCKET function, its syntax, and its practical use cases using the AdventureWorks2022 sample database. We’ll also compare DATE_BUCKET with other similar T-SQL fun
  • Understanding Service, Factory, And Provider10/3/2024 11:38:34 AM. AngularJS provides three methods for creating reusable utilities: Service, Factory, and Provider. All serve the same purpose but differ in implementation. Services are singletons, Factories return new
  • User Record Management in C9/29/2024 5:22:32 AM. This content focuses on implementing functions in C programming to efficiently add and display user records. It covers the creation of structures for storing user details, such as name, age, and conta
  • A Comprehensive Guide to Migrating Azure Functions C# to C# 12 with .NET 8 Isolated9/21/2024 4:12:20 AM. Ziggy Rafiq shows how to leverage modern C# features, and how to optimize the performance and scalability of Azure Functions by migrating them to .NET 8 Isolated Processes.
  • Learn Higher Order Functions in JavaScript9/18/2024 4:33:53 AM. A higher-order function in JavaScript is a function that takes another function as an argument, returns a function, or both. This allows for reusability, code abstraction, and functional programming.
  • Dealing With Excel Sheets9/17/2024 10:25:24 AM. Learn essential techniques for managing Excel sheets effectively! This guide covers everything from basic data entry and spreadsheet formulas to advanced features like automation and troubleshooting.
  • Creating Azure Functions For SharePoint Operations Using Managed CSOM9/10/2024 11:53:12 AM. This article explains how to create Azure Function Apps to perform SharePoint operations using Managed CSOM code. It covers setting up an HTTP-triggered function, uploading required assembly files via
  • Centralizing String Utility Functions in Java9/10/2024 6:26:13 AM. This article explains how to consolidate common string utility functions in Java by creating a utility class like StringUtils. It covers methods for checking if a string contains only alphanumeric cha
  • Learn Factory Functions in JavaScript9/10/2024 4:25:39 AM. In this article, we will learn about Factory Functions in JavaScript. This article introduces factory functions in JavaScript, demonstrating how they create objects efficiently without code duplicatio
  • Working With Azure Functions From SharePoint Components9/9/2024 11:48:43 AM. This article explains how to trigger Azure functions from SharePoint pages using HTTP trigger functions. It covers creating a SharePoint list from an Azure function using C# and SharePoint CSOM, passi
  • Type Of Functions In Javascript8/21/2024 10:46:06 AM. This content explores various types of functions, including function declarations, expressions, arrow functions, and callbacks, offering insights into their usage, syntax, and differences in JavaScrip
  • Image Scaling by Slider Using HTML58/16/2024 5:02:08 AM. Learn how to scale images dynamically with an HTML5 slider in this tutorial. Using the drawImage method on a canvas element, we adjust image size based on slider input. The article covers HTML setup,
  • How to Call JavaScript Function in Angular 18 Component?8/8/2024 9:38:18 AM. Learn how to integrate JavaScript functions within an Angular 18 component. This guide covers how to call and use JavaScript functions effectively in your Angular components, ensuring seamless interac
  • Understanding the NTILE Window Function in SQL8/7/2024 4:10:20 AM. Understanding the NTILE Window Function in SQL" delves into the NTILE function, a powerful SQL tool used to divide result sets into a specified number of roughly equal groups.
  • Understanding ROW_NUMBER() in SQL Window Functions8/2/2024 4:46:39 AM. 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
  • @@ROWCOUNT in SQL Server7/29/2024 9:28:40 AM. @@ROWCOUNT is a SQL Server function used to retrieve the number of rows affected by the last executed statement. It provides valuable insights for data manipulation and validation processes, helping t
  • JavaScript Functions to Simplify Your Code7/26/2024 5:02:58 AM. Discover how to streamline your JavaScript code with our comprehensive tutorial on essential functions. Learn best practices, coding tips, and techniques to simplify your programming. Perfect for begi
  • SQL Essentials: GROUP BY vs. PARTITION BY Explained7/26/2024 4:08:59 AM. Discover how GROUP BY aggregates data into summary rows, while PARTITION BY divides data into partitions for window functions. Master these techniques to enhance your SQL querying skills.
  • Practical approach to EF Core with Scalar functions7/21/2024 6:32:25 PM. Learn how to implement and migrate scalar SQL functions in an ASP.NET Core application using Entity Framework Core. This guide covers creating a scalar function to calculate total unit prices, integra
  • Error handling in Transact-SQL (T-SQL) 7/13/2024 10:59:58 AM. Effective error handling in T-SQL (Transact-SQL) is vital for managing unexpected issues in database operations. Using TRY-CATCH blocks, RAISEERROR, and error functions like ERROR_MESSAGE and ERROR_NU
  • How to Convert varbinary to Base64 String in SQL Server7/12/2024 8:47:14 AM. Learn how to convert varbinary data to Base64 strings in SQL Server using XML functions and the CAST method. This tutorial provides clear steps and SQL examples for encoding binary data, crucial for w
  • Lambda Functions and High Order Functions in Android kotlin7/11/2024 4:59:01 PM. The provided Kotlin examples demonstrate basic and high-order functions. In lambda. kt, a lambda function adds two integers. In HighOrder.kt, a high-order function accepts another function as a parame
  • Azure Functions Hosting Models: In-Process and Isolated Models7/8/2024 8:37:11 AM. Explore Azure Functions' hosting models: In-Process offers low latency and simplicity with shared process hosting, while Isolated ensures enhanced isolation and custom dependencies with each funct
  • Ranking Functions in SQL: RANK, DENSE_RANK, and ROW_NUMBER7/3/2024 12:19:25 PM. Learn how these powerful functions operate within SQL queries to assign ranking values based on specified criteria, enhancing your ability to analyze and manipulate data efficiently in relational data
  • Learn Use of Lambda Operator in C#7/1/2024 6:28:21 AM. Explore the versatility of lambda expressions in C#, powerful tools for creating inline functions without the need for traditional method declarations. Discover their syntax, applications in LINQ quer
  • Find and Replace in PowerApps6/27/2024 10:52:39 AM. Learn to streamline data entry and enhance user experience by implementing powerful text manipulation techniques within your canvas apps, leveraging Microsoft's Power Platform capabilities seamle
  • Integrating Azure SQL Database with Azure Functions - Azure Essentials Series - Ep: 46/24/2024 8:23:23 AM. In this episode, you'll learn how these two services can work together to build scalable, serverless applications that efficiently manage and process data.
  • Predicate Delegates in .NET Core C#: Syntax, Usage and Examples6/22/2024 10:26:47 AM. Like Func and Action delegates, the predicate is a delegate. It symbolizes a procedure that verifies that the passed parameter satisfies a set of requirements. One input parameter must be provided by
  • Implementing Webhooks with Next.js6/21/2024 6:42:03 AM. In this article we will learn about implementing webhooks in Next.js empowers our application with real-time capabilities, allowing seamless integration with external services and automating business
  • Integrating Azure SQL Database with Azure Functions6/17/2024 9:26:04 AM. Azure SQL Server is a fully managed database service by Microsoft Azure, offering scalability, high availability, and robust security features. It integrates seamlessly with Azure Functions for buildi
  • Working With Timer-Triggered Azure Functions6/14/2024 10:41:52 AM. In this article, you will learn about Time-Triggered Azure functions, the basics of CRON expressions, and how to define CRON expressions for timer-triggered Azure Functions.
  • Understanding SQL Window Functions6/13/2024 5:33:18 AM. SQL window functions perform advanced analytics by computing values over a defined set of rows, using partitions and ordering. They enable operations like running totals, moving averages, and rankings
  • Advanced SQL Techniques in PostgreSQL6/7/2024 6:21:38 AM. PostgreSQL, a powerful open-source relational database management system, offers a wide range of features and functionalities to handle complex data queries and manipulations efficiently.
  • Understanding Decorators in Python6/4/2024 5:51:05 AM. In this article, we explore Python decorators, which allow you to modify the behavior of functions without altering their source code. By using decorators, you can add functionality, log information,
  • Arrow Function Variants in JavaScript6/3/2024 8:14:29 AM. 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 fun
  • Integrate Azure Load Testing with Function App6/3/2024 7:44:56 AM. This article provides a guide on combining Azure Load Testing services with Azure Function Apps to evaluate performance and scalability. It emphasizes automated testing, monitoring, and stress testing
  • Azure Functions: A Comprehensive Guide6/3/2024 3:01:49 AM. Azure Functions is a serverless compute service from Microsoft Azure that allows you to run event-driven code without managing infrastructure. It supports various programming languages, integrates wit
  • Understanding Durable Functions in Azure: A Comprehensive Guide6/2/2024 10:36:46 AM. Explore the comprehensive guide to understanding Durable Functions in Azure. This guide delves into the concepts of serverless computing, function orchestration, and workflow automation using Azure Du
  • Streamline Your Python Code with Asynchronous Functions6/2/2024 10:26:52 AM. Discover how to enhance the efficiency of your Python code using asynchronous functions. This guide delves into the benefits of asynchronous programming, covering the basics of async and await, and sh
  • Identifying Missing Sequence Numbers in SQL5/31/2024 9:45:12 AM. In this article, we explore a method to identify missing sequence numbers in a database table using SQL. SQL code utilizes window functions and CTEs to efficiently find gaps in the sequence of region
  • Leveraging Azure Tables with Azure Functions5/31/2024 8:30:59 AM. Azure Tables provide a NoSQL key-value store for rapid development using massive semi-structured datasets. They are part of Azure Storage and are designed for large-scale data storage and high-perform
  • Leveraging Azure Tables with Azure Functions - Azure Essentials Series - Ep: 15/30/2024 1:08:56 PM. In this episode, we'll delve into how Azure Tables, a NoSQL data storage solution, can be seamlessly integrated with Azure Functions, Microsoft's serverless compute service, to build efficient
  • An In-depth Look at Kusto Query Language (KQL)5/28/2024 10:40:36 AM. Delve into Kusto Query Language (KQL), the powerful syntax behind Azure Data Explorer. From data querying to advanced analytics, KQL facilitates efficient data analysis, aggregation, and visualization
  • Asin function from Power Fx using Power Apps5/21/2024 10:04:38 AM. Reading this article, you can learn how to perform Asin function from Power Fx using in Microsoft Power Apps. Also, you will be able to learn Button control, Label control and TextInput control in the
  • How To Use Sort And SortByColumn Functions In Microsoft PowerApps5/21/2024 9:48:46 AM. Learn how to efficiently manage data in Microsoft PowerApps using the Sort and SortByColumn functions. Discover the intricacies of sorting records, leveraging these functions to organize data effectiv
  • How To Use Filter, Search, And LookUp Functions In Microsoft PowerApps5/21/2024 9:43:26 AM. In this article, you will learn how to effectively use the Filter, Search, and LookUp functions in Microsoft PowerApps to enhance your app development skills.
  • LAG and LEAD Functions in SQL Server5/21/2024 9:42:14 AM. In this article, you will explore the LAG and LEAD functions in SQL Server, powerful tools for accessing data in previous or subsequent rows within a result set.
  • Working with Lambda Functions in Python5/21/2024 6:08:29 AM. Lambda functions in Python are concise, anonymous functions defined with the lambda keyword. They're ideal for short, disposable tasks and commonly used with map(), filter(), and reduce() function
  • Working with LEAD and LAG Window Functions in SQL5/20/2024 9:19:14 AM. SQL's LEAD and LAG functions access data from different rows within the same result set, facilitating complex calculations. LEAD retrieves subsequent rows, while LAG retrieves previous rows.
  • Prevent Function Call Repetition in ReactJS for Efficient Development5/20/2024 6:12:07 AM. In React, events follow two phases: capture and bubble. Capture phase descends from root to target, while bubble phase ascends. React allows specifying listeners for both phases, enhancing event contr
  • Demystifying customStringify: Filtering Functions in JSON5/13/2024 4:51:28 AM. In the vast world of data, JSON (JavaScript Object Notation) reigns supreme for its lightweight and human-readable format. But what if you want to control how specific data gets represented in your JS
  • Exploring Azure Bicep Functions: Syntax, Usage, and Examples5/9/2024 4:45:29 AM. This article is a comprehensive guide that takes you on a deep dive into Azure Bicep functions. It starts with logging into Azure and then moves on to explain the concept of functions in Azure Bicep,
  • Create Or Update Excel Sheet From Azure Web Job5/2/2024 9:55:28 AM. In this article, I would like to share the steps and code to create/update an Excel from an Azure web job. Using Microsoft.Interop.Excel, we can create and update the Excel sheet but in Azure web job,
  • How To Create A Function In R5/1/2024 11:53:37 AM. Learn how to create and use functions in R with this comprehensive guide. Understand the syntax for defining functions, specifying arguments, and defining default values. Explore examples demonstrati
  • Integrating Dynamics CRM To Azure Service Bus5/1/2024 11:16:16 AM. Integrating Dynamics CRM with Azure Service Bus enables seamless communication, leveraging Azure's robust messaging capabilities for efficient data exchange, automation, and event-driven workflows
  • What is Friend Function in C++4/30/2024 5:50:49 AM. Data hiding is a core principle in object-oriented programming, but C++ introduces friend functions that defy this rule, enabling access to private and protected class members from outside.
  • From Traditional to Modern: Understanding of JavaScript Functions4/30/2024 4:33:26 AM. JavaScript functions are versatile tools, organizing code, enabling reusability, and improving readability. Named, anonymous, arrow, IIFE, callback, higher-order, and constructor functions offer diver
  • Explain Lambda Functions in .NET C#4/26/2024 5:02:47 AM. In the realm of .NET programming, lambda functions represent a powerful and concise way to define anonymous methods or functions. In this article, we'll explore the fundamentals of lambda function
  • Mapping TVFs Using Entity Framework Database First4/24/2024 7:43:49 AM. Map table-valued functions (TVFs) in Entity Framework Database First by importing them as function imports. Utilize EDM Designer to create complex types for TVF results, enhancing data retrieval and m
  • Directives In Angular And Their Functions Using Node.js & VS Code4/23/2024 11:11:56 AM. Explore Angular directives in a Node.js environment with Visual Studio Code. Learn to leverage Angular CLI for efficient directive creation and management. Master frontend development using TypeScript
  • Explain Sorting Data In AngularJS4/22/2024 6:38:44 AM. Sorting data in AngularJS involves using the orderBy filter to arrange items based on specific criteria such as alphabetical order, numerical order, or custom sorting functions. This allows for dynami
  • Acos function from Power Fx using Power Apps4/21/2024 2:31:35 PM. Reading this article, you can learn how to perform Acos function from Power Fx using in Microsoft Power Apps. Also, you will be able to learn Button control, Label control and TextInput control in the
  • Difference Between Scalar and Aggregate Functions4/19/2024 5:10:46 AM. In this article, we'll discuss the differences between Scalar and Aggregate functions in MSSQL in detail. This article explores scalar and aggregate functions in Microsoft SQL Server, detailing th
  • Atan function from Power Fx using Power Apps4/18/2024 9:53:08 AM. Reading this article, you can learn how to perform Atan function from Power Fx using in Microsoft Power Apps. Also, you will be able to learn Button control, Label control and TextInput control in the
  • MySQL Queries Cheat Sheet4/18/2024 3:54:25 AM. In this article, we will learn about MySQL querying essentials, covering basic SQL commands, data manipulation functions, constraints, and frequently asked questions, providing valuable insights for b
  • How To Integrate Application Insights Into Azure Functions4/17/2024 8:06:12 AM. Learn the seamless integration process of Application Insights into Azure Functions. Enhance monitoring, logging, and performance tracking capabilities effortlessly. Harness the power of Azure service
  • How To integrate Dependency Injection In Azure Functions4/17/2024 8:05:24 AM. Learn how to integrate Dependency Injection in Azure Functions, creating HTTP trigger functions, and injecting service objects using DI. Understand the Dependency Injection pattern, steps to add DI in
  • How To Easily Create Azure Functions Using Azure Portal4/17/2024 8:04:43 AM. Learn to effortlessly build Azure Functions via Azure Portal. Explore serverless computing, diverse triggers like HTTP or Timer, bindings for seamless data integration, and easy deployment. Monitor, s
  • How to Send & Read Messages with Azure Service Bus Queues in Azure Functions4/17/2024 7:47:00 AM. Learn to efficiently manage message communication in Azure using Azure Functions. Discover how to send and read messages from Azure Service Bus queues seamlessly, leveraging the power of serverless co
  • Creating Azure WebJobs To Parse Message From Azure Storage Queues4/16/2024 8:53:11 AM. In this article, you will learn how to utilize Azure WebJobs to efficiently process messages from Azure Storage Queues. Explore background processing, message parsing, and event-driven architecture in
  • SQL Server System Functions: Aggregate, String, Math, Date4/15/2024 11:17:36 AM. Learn about SQL Server system functions including aggregate, string, mathematical, and date time functions. Explore their syntax and examples for efficient database operations. Ideal for beginners an
  • Automate Azure Key Vault Key Refresh with Managed Identity 4/15/2024 8:41:39 AM. Automate key refresh in Azure Key Vault using Azure Function with Managed Identity. Enhance security and efficiency by managing secrets automatically within your Azure environment, ensuring seamless a
  • Not all Functions are C# Methods4/13/2024 5:54:14 PM. How to write your functional programming functions in C#? That is the main question we're going to answer in this article.
  • Boosting Azure Function Performance with Isolated .NET Core4/9/2024 5:45:41 PM. In the article "Boosting Azure Function Performance with Isolated .NET Core," written by Ziggy Rafiq, readers learn about how Isolated .NET Core empowers Azure Functions. This piece explores
  • Arrow Functions in React: Concise Syntax & Lexical Binding4/3/2024 8:25:25 AM. Arrow functions, a staple of modern JavaScript introduced in ES6, offer concise syntax and lexical binding, making them ideal for React. They streamline event handlers, callbacks, and functional compo
  • String Handling Functions implementation in C Language3/29/2024 4:24:17 AM. In C programming, strings are fundamental for working with textual data. Unlike some other languages, C handles strings using character arrays with a null terminator.
  • Important PySpark Import Statements3/21/2024 5:28:24 AM. 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 stateme
  • JavaScript Map, Filter And Reduce3/19/2024 11:47:34 AM. In this article, I have explained how to leverage JavaScript's powerful array methods to Map, Filter, and Reduce. Explore functional programming concepts to manipulate data efficiently. Streamline
  • Refactoring Common Code with Azure Bicep User Defined Functions3/19/2024 5:22:47 AM. Learn how to use Bicep's new feature (in preview currently) called "User Defined Functions" to make deploying your cloud resources on Microsoft Azure easier. This blog will teach you a s
  • Creating Functions Dynamically In JavaScript3/18/2024 12:04:08 PM. Learn to dynamically create functions in JavaScript, enabling flexible code generation and execution at runtime. Explore techniques for defining functions programmatically to enhance your application&
  • Creating Distributed Map-Reduce Job via AWS Step Function 3/18/2024 9:11:39 AM. Example of distributed map-reduce job using AWS Step Function on the example of the generative art piece. The article explains using AWS Step Functions to orchestrate lambdas in a distributed serverle
  • Practical Introduction To Entity Framework: Day 23/6/2024 10:30:54 AM. This article provides a comprehensive guide on executing stored procedures using Entity Framework. It covers creating stored procedures in SQL Server, adding entity models to projects, and calling aut
  • Understanding FORMATMESSAGE() Function in SQL Server3/6/2024 4:58:24 AM. In this article, we will discuss how to use FORMATMESSAGE() function in SQL Server, its advantages and usages with example.
  • Asynchronous Programming in Angular Promises vs. Observables3/6/2024 4:33:48 AM. Asynchronous programming plays a crucial role in modern web development, especially in Angular applications where data fetching, event handling. In this article, we'll delve into the differences b
  • Difference Between Collect and ClearCollect in PowerApps3/1/2024 4:53:58 AM. In PowerApps, the Collect and ClearCollect functions play pivotal roles in managing data within your applications. Collect appends data to an existing dataset, while ClearCollect replaces the entire c
  • Java Applet Design: File, Edit, and Search Options with ActionPerformed Functions2/26/2024 6:00:39 AM. Create an Applet with the menu bar and add the following menus: File, Edit and Search. Add default menu items to the respective menus. In the File menu, add the following items: New, Open, Save and Cl
  • How to Pass a Parameter to Event Handler or Callback in React.js2/22/2024 11:13:06 AM. 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.
  • Learn SharePoint In Series - Part Eight - Validation Settings In List Settings2/15/2024 10:56:52 AM. This article delves into the list validation settings in SharePoint, elucidating their importance and practical applications. It provides step-by-step guidance on configuring validation settings at th
  • Mastering T-SQL Rank Functions2/6/2024 9:28:41 AM. SQL window functions like ROW_NUMBER, RANK, DENSE_RANK, and NTILE are vital for advanced data analysis. They organize, order, and rank data within result sets. ROW_NUMBER assigns unique sequential nu
  • Understanding Cross Language Interoperability With C# .NET2/1/2024 10:45:16 AM. This article explains case sensitivity/insensitivity of cross language interoperability in Microsoft .NET that allows compliant languages to interoperate with each other.