Related resources for Func
  • How to use Databricks AI Mask Function To Protect Sensitive Data1/8/2025 6:10:51 AM. In this video, I demo how to use the powerful Databricks AI_Mask Function to obfuscate sensitive data
  • Python Import Modules with Example1/8/2025 4:27:37 AM. Learn Python's import module concepts, including importing entire modules, specific functions, and aliasing. This article demonstrates creating, reading, and writing employee data to a JSON file w
  • SharePoint Data from Azure Function using Self Signed Certificate1/6/2025 8:20:45 AM. This article covers configuring Azure Functions, setting up certificate-based authentication, and connecting to SharePoint Online, enabling secure integration for seamless data access.
  • Checking Leap Year in Java with Code1/3/2025 9:49:38 AM. 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 fo
  • C# 7.0 New Features - Binary Literal, Digit Separator And Local Function - Part One1/2/2025 5:26:55 AM. This Article explains the new features of C# 7.0 and it covers features like binary literal, digit separator and local function.
  • Use the Navigate Function for Seamless Transitions in Power Apps1/1/2025 6:46:08 AM. Learn how to use the Navigate function in Power Apps to create smooth user experiences by enabling seamless navigation between screens. This article covers basic navigation setup, custom transitions,
  • LookUp Function in Power Apps for Efficient Data Retrieval12/31/2024 11:47:38 AM. The LookUp function in Power Apps allows efficient data retrieval by searching for a single record in a data source based on a condition. It's ideal for scenarios like pulling specific employee de
  • Understanding JavaScript Closures12/31/2024 6:02:22 AM. Closures in JavaScript enable functions to retain access to their lexical scope, even outside their context. They aid in data encapsulation, creating private variables, function factories, and event h
  • Difference Between Collect & ClearCollect Functions in Power Apps12/31/2024 5:55:52 AM. Learn how to use these functions for data manipulation, including adding, updating, and clearing collections. Gain insights into their applications to streamline your app-building process effectively.
  • AI_GEN Function in Databricks SQL12/31/2024 5:14:12 AM. This video walks you through how you can use the new ai_gen function in Databricks SQL which leverages on generative AI models to process and respond to to user-provided prompts
  • VarP function in PowerFx using canvas App with Power apps12/28/2024 5:39:38 AM. Learn how to use the VarP function in Power Fx with Power Apps. Build a Canvas App, design controls like Labels and TextBoxes, calculate variance, and preview results on various devices in Power Apps
  • StdevP Function in PowerFx Using Canvas App with Power Apps12/27/2024 5:43:22 AM. Reading this article, you can learn how to perform the StdevP function from Power Fx using Microsoft Power Apps. Also, you will be able to learn Text box, Label control in the Power Apps environment.
  • Sum Function in PowerFx using Canvas App with Power Apps12/16/2024 10:40:06 AM. Learn how to use Power Fx's Sum function in Power Apps to build custom business applications quickly. This guide covers creating a simple Canvas app, using Text Box and Label controls, and integra
  • Min Function in PowerFx using Canvas App with Power Apps12/13/2024 12:16:52 PM. Reading this article, you can learn how to perform the Min function from Power Fx using Microsoft Power Apps. Also, you will be able to learn Text box, Label control in the Power Apps environment.
  • Understanding the AI_EXTRACT SQL Function in Databricks12/12/2024 7:17:56 AM. This article dives into the mechanics of AI_EXTRACT, its syntax, and various use cases with examples. AI_EXTRACT in Databricks extracts structured data, like names and dates, from unstructured text us
  • Max Fnction in PowerFx using Canvas App with Power Apps12/11/2024 4:51:08 AM. Reading this article, you can learn how to perform the Max function from Power Fx using Microsoft Power Apps. Also, you will be able to learn Text box, Label control in the Power Apps environment.
  • Average Function in Canvas App using PowerFx with Power Apps12/9/2024 6:29:35 AM. Reading this article, you can learn how to perform the Average function from Power Fx using Microsoft Power Apps. Also, you will be able to learn Slider control, Label control in the Power Apps enviro
  • 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
  • Azure Function to Read Incoming Message in Twilio11/27/2024 10:44:55 AM. Learn how to create an Azure Function that reads incoming SMS messages from Twilio. This tutorial covers the setup of Azure Functions, integrating with Twilio's API, and processing incoming messag
  • 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
  • Setting Default Dates in Power Apps: Using Today(), Date(), Year(), and DateAdd() 11/14/2024 6:39:41 AM. Learn how to set default dates in Power Apps using functions like Today(), Date(), Year(), and DateAdd(). This guide explains how to simplify date fields, enhance user experience, and improve app func
  • Explaining Deep Linking in Power Apps 11/12/2024 10:49:37 AM. 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 c
  • Explaning AWS Lambda Function11/12/2024 7:11:04 AM. AWS Lambda is a service that computes the code without any server. It doesn't need any server running, so It is said to be serverless computer. The code is executed based on the response of events
  • Build an Azure Blob Trigger Function to Compress Images with Sharp11/12/2024 5:17:35 AM. This guide walks through creating an Azure Blob Trigger Function that compresses images uploaded to Azure Storage using the Sharp image processing library. It covers setting up Azure Blob Storage, co
  • How to Sort a List of Objects in TypeScript by Property11/9/2024 10:11:36 AM. This guide covers sorting lists of objects in TypeScript, with examples for sorting by string, numeric, and date properties. It demonstrates using the sort() method, localeCompare for strings, custom
  • 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.
  • Map, Filter and Reduce in TypeScript with Examples10/30/2024 5:47:41 AM. This guide provides a comprehensive overview of these essential functions, complete with practical examples to illustrate their use in real-world applications. Enhance your coding skills and streamlin
  • Windowing Enhancements New T-SQL Enhancement in SQL Server10/29/2024 6:29:27 AM. SQL Server 2022 introduces advanced T-SQL features, enhancing window functions, aggregations, and NULL handling. New options like the WINDOW clause and IGNORE NULLS optimize complex data queries, redu
  • 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
  • How Select and SelectMany Works in C#10/26/2024 5:05:45 AM. 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#.
  • TRIM Function New T-SQL Enhancements in SQL Server10/25/2024 10:44:09 AM. The enhanced TRIM function in SQL Server 2022 adds flexibility for removing unwanted characters in strings, beyond just spaces. Now, developers can use BOTH, LEADING, and TRAILING keywords to trim fro
  • GENERATE_SERIES Function New T-SQL Enhancements in SQL Server10/25/2024 6:06:40 AM. The GENERATE_SERIES function in SQL Server 2022 creates sequences of numbers or dates between specified start and end values, with an optional step. It's beneficial for reporting, filling data gap
  • 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
  • TypeScript for advanced type inference in React10/24/2024 4:43:27 AM. In this article, Ziggy Rafiq discusses advanced type inference techniques in React with TypeScript, focusing on hooks and JSX elements.
  • Compiling Multiple Files to Build an Application10/22/2024 10:46:04 AM. This article explains how to compile multiple C files into a single executable using the C compiler. It covers two approaches: compiling multiple files with the cc command or using the #include direct
  • 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
  • NTile Function in SQL Server10/3/2024 11:44:37 AM. The NTile function in SQL Server divides a result set into a specified number of groups, assigning ranks to records within each group. Unlike Dense_Rank, NTile focuses on groups rather than individual
  • 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
  • How To Create An HTTP Trigger Azure Function App Using Visual Studio 201710/1/2024 8:24:46 AM. Azure Functions is a serverless cloud solution that allows you to run code on-demand without managing infrastructure. It supports multiple programming languages, offers a pay-per-use pricing model, an
  • What is the Filter Function in Power Apps9/30/2024 11:14:40 AM. The Filter function in Power Apps allows users to narrow down data sets by applying specific criteria. It is essential for creating dynamic applications that require user input to display relevant inf
  • What is the Collect Function in Power Apps?9/30/2024 8:32:00 AM. Power Apps enables users to create custom applications with minimal coding, utilizing features like the Collect function for data management. This function allows dynamic storage of various data types
  • Rank and Dense_Rank Function in SQL Server9/30/2024 4:48:24 AM. RANK and DENSE_RANK functions in SQL Server assign sequential numbers to rows based on ordering. RANK skips numbers for ties, while DENSE_RANK does not. Both can partition results using the PARTITION
  • 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
  • How to Download Code from Your Azure Function App9/27/2024 5:59:14 AM. In this article, we will learn how to easily download code from your Azure Function App using built-in tools like the Azure Portal, App Service Editor, or source control integration.
  • How Func Delegates Work in LINQ9/27/2024 4:31:27 AM. In this article, we explore how Func delegates operate within LINQ (Language Integrated Query) in C#. Func delegates enable concise and powerful data manipulation by allowing developers to pass method
  • Getting Dynamic Input Value and Post to the AJAX function9/27/2024 3:20:29 AM. This article explores how to dynamically retrieve input values from a user interface and send them to an AJAX function for processing. It covers essential concepts like event handling and asynchronous
  • Solid Introduction to Expression Trees in C#9/26/2024 4:50:55 AM. This article provides a comprehensive introduction to Expression Trees in C#. You'll learn about their structure, how they represent code as data, and their applications in LINQ queries.
  • Understanding Callbacks with Func and Action Delegates9/26/2024 4:11:38 AM. This article explains how to use Func and Action delegates in C# to implement callbacks, providing flexible and reusable code. It includes practical examples for both returning and non-returning metho
  • Implement Insert, Update and Delete Functionality in the WebGrid: Part 19/24/2024 11:54:26 AM. In this tutorial, we introduce how to implement essential CRUD (Create, Read, Update, Delete) functionality in a WebGrid. This is Part 1 of a series, focusing on adding new records, updating existing
  • What is the Notify Function in Power Apps?9/23/2024 5:09:43 AM. The Notify function in Power Apps displays messages to users, providing instant feedback on their actions. It supports various notification types, such as success, error, warning, and information, hel
  • 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.
  • How to create a language translator using Google's API and JavaScript9/17/2024 10:42:21 AM. This article demonstrates how to create a language translator using the Google API and JavaScript. It covers integrating the Google API for translating text, contrasting it with previous methods like
  • 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.
  • Action And Func Delegates In C#9/12/2024 6:18:26 AM. In C#, Action, and Func are generic delegates used to handle methods. Action is used for methods that don't return a value, while Func returns a value. Action<int> executes a method with an
  • Build a Smart Private Chatbot with Semantic Kernel and APIs9/12/2024 4:23:50 AM. This guide covers integrating advanced NLP techniques and machine learning to create a secure, efficient, and customizable AI chatbot with robust data privacy.
  • 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
  • SQL: Not Using Aggregate Function in WHERE Clause, instead, Using HAVING Clause9/5/2024 12:51:37 PM. This article will discuss the issue that SQL: Not Using Aggregate Function in WHERE Clause, instead, Using HAVING Clause
  • Atan2 Function From Power Fx Using Power Apps9/3/2024 6:26:24 AM. Reading this article, you can learn how to perform Atan2 function from Power Fx using in Microsoft Power Apps. Also, you will be able to learn Button control, Label control and TextInput control in th
  • Harnessing the Power of Function Calling with Local LLMs using Ollama8/25/2024 11:45:29 AM. Function calling with Local LLM (Ollama) using C# Semantic Kernel.
  • 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
  • CountDown Timer in JavaScript8/21/2024 6:07:01 AM. This article demonstrates how to implement a countdown timer using JavaScript's setTimeout method. It explains how to create a countdown function that updates the display every second, integrating
  • Describing Musical Domain with F#8/20/2024 7:47:25 AM. It covers domain-specific language (DSL) creation, music representation, algorithmic composition, and sound synthesis, showcasing how F# can facilitate advanced music analysis and generation.
  • 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,
  • Func, Action And Local Function In C# 78/9/2024 12:03:08 PM. This article covers using Func, Action, and local functions in C# 7. It explains how Func returns a value, Action does not, and how local functions can be defined within other methods. Examples includ
  • 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
  • Count(*) vs Count(1) in SQL8/1/2024 4:11:33 AM. When counting rows in SQL databases, both `COUNT(*)` and `COUNT(1)` are used, but there is no performance difference between them. Modern databases optimize both functions similarly. Prioritize code r
  • @@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
  • Blazor Web Assembly 3.2 Add/Edit/Delete Fully Functional Application - Part One7/29/2024 8:37:43 AM. This article guides you through creating a Blazor web assembly app with .NET Core hosting. It covers setting up .NET Core APIs, Entity Framework Core for SQL Server data access, and implementing CRUD
  • Functionality of DMA in C Programming7/28/2024 1:08:57 PM. Direct Memory Access (DMA) in C programming is a powerful technique for efficient memory management and data transfer. It allows peripherals to directly access memory without CPU intervention, enhanci
  • 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.
  • Tracking Visits and Visitor Details on PowerApps Page7/25/2024 12:07:39 PM. Learn to track unique page views in PowerApps by integrating SharePoint lists and using global variables. This guide covers designing lists, configuring PowerApps screens, and patching view counts. It
  • Understanding flatMap in Java7/23/2024 7:42:33 AM. The flatMap operation in Java is a powerful tool for transforming and flattening collections. Learn about Java's `flatMap` operation in this article, which maps each element to a stream and flatte
  • Detailed Explanation of Procedure and Function in SQL Server7/22/2024 6:22:57 AM. Stored procedures are precompiled sets of one or more SQL statements that can be executed together. Functions in SQL Server are essential database objects that contain a series of SQL statements and p
  • 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
  • Understand jQuery Ajax Function: Call Web Service Using jQuery Ajax Method7/18/2024 3:19:09 PM. Learn how to use the jQuery Ajax function to call web services and code-behind C# methods. This guide is perfect for novice developers. It covers creating a simple web service, setting up jQuery Ajax
  • Understand jQuery Ajax Function: Read XML Data Using jQuery Ajax Function7/18/2024 3:18:31 PM. This guide delves into using the jQuery Ajax function to read and parse XML data efficiently. It covers the basics of jQuery and Ajax, demonstrating how to make asynchronous requests to fetch XML file
  • How to Call C# Method/Function Using jQuery Ajax7/18/2024 3:18:09 PM. Learn how to call a C# method or function using jQuery Ajax in this step-by-step guide. We'll cover setting up your ASP.NET backend, writing the C# code, and creating the jQuery Ajax call to inter
  • Save as draft and Submit with required, optional functionality and by default required functionality in PowerApps7/18/2024 10:24:46 AM. This is most required feature in any app. If the form is lengthier, it is very useful feature. Any user can fill in the half of the forms and save the form as draft. Later can come in and pickup the f
  • Interactive Rating Control in PowerApps7/17/2024 2:23:06 AM. Explore the integration of rating controls in social media and user-interactive applications using SharePoint lists. Learn about setting display modes, default properties, and user validations to enha
  • 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
  • JavaScript - Closures Demystified7/10/2024 12:38:31 PM. Function closures in JavaScript encapsulate variables from their defining scope, allowing functions to retain access to these variables even when executed outside that scope. This tutorial explores cl
  • ACot function from Power Fx using Power Apps7/10/2024 9:23:53 AM. Build custom business apps swiftly with Power Apps, leveraging Power Fx for low-code development across Microsoft Power Platform. Learn to implement the ACot function and utilize Button, Label, and Te
  • Cot function from Power Fx using Power Apps7/10/2024 4:28:42 AM. Reading this article, you can learn how to perform Cot 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
  • 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
  • Essential Components of Prompt Design in GPT's Search7/8/2024 4:49:51 AM. Explore the crucial elements of prompt design within GPT's search capabilities through a comprehensive analysis. Delve into the intricacies of optimizing natural language prompts for enhancing use
  • Understanding @wraps in Python: Preserving Function Metadata7/7/2024 6:28:30 PM. Explore the intricacies of Python's @wraps decorator, essential for preserving function metadata. Learn how @wraps simplifies debugging, maintains docstrings, and ensures correct function signatur