C# Corner
Tech
News
Videos
Forums
Trainings
Books
Live
More
Interviews
Events
Jobs
Learn
Career
Members
Blogs
Challenges
Certifications
Bounties
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
Tags
No tag found
Content Filter
Articles
Videos
Blogs
Resources
News
Forums
Interviews
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Tuhin Paul(22)
Dashrath Hapani(5)
Jalpa Dhola(3)
Ananya Desai(2)
Krish Kanakiya(2)
Akshay Amin(2)
Aarav Patel(2)
Ziggy Rafiq(2)
Naveen Kumar(2)
Uday Dodiya(2)
Lokendra Singh(2)
Jithu Thomas(2)
Henil Patel(1)
Nidhi Sharma(1)
Divyesh Chauhan(1)
Niharika Gupta(1)
Rijwan Ansari(1)
Ketan Sathavara(1)
Victor Horlenko(1)
Rajkiran Swain(1)
Ismail Sayyad(1)
Sandhiya Priya(1)
Rajesh Gami(1)
Abhishek Yadav(1)
Vishal Gami(1)
Cynthia Sathuragiri(1)
Nishant Raj(1)
Sriganapathi Sekar(1)
Malintha Wijewardana(1)
Lokesh Varman(1)
Jayant Kumar(1)
Sudhir Vaghela(1)
Asfaque Ansari(1)
Baibhav Kumar(1)
Aanchal Tyagi(1)
Jaimin Vakhare(1)
Kapil Singh Kumawat(1)
Rikam Palkar(1)
Neel Shah(1)
Alagunila Meganathan(1)
Morteza Mousavi(1)
Shiv Sharma(1)
Sangeetha S(1)
Devesh Omar(1)
Aradhana Tripathi(1)
Vijay Sisodia(1)
Muhammad Imran Ansari(1)
Aman Gupta(1)
Amar Srivastava(1)
Kafeel Ahmad(1)
Jejji Arora(1)
Muhammad Asif(1)
Ashutosh Singh(1)
Ayush Gupta(1)
Suraj Vishwakarma(1)
Jitendra Mesavaniya(1)
Tural Suleymani(1)
Shikha Tiwari(1)
Shweta Lodha(1)
Anandu G Nath(1)
Sardar Mudassar Ali Khan (1)
Subarta Ray(1)
Keyur (1)
Bhavesh Raval(1)
Resources
No resource found
Event-Driven AI Agents with Azure Functions and Semantic Kernel
Jun 08, 2026.
Learn how to build event-driven AI agents using Azure Functions and Semantic Kernel. Discover serverless AI architectures, event processing patterns, and best practices for enterprise .NET applications.
Mastering URI & Data Conversion Functions in Power Automate (Step-by-Step Guide)
Apr 13, 2026.
Master Power Automate's URI & data conversion functions! Learn to use dataUri(), encodeUriComponent(), and more with practical examples for seamless API integration.
How to Use Window Functions in SQL Server With Practical Examples?
Apr 06, 2026.
Unlock SQL Server's power with window functions! Learn to calculate rankings, running totals, and more without losing row details. Boost your data analysis skills!
If() vs Switch() Functions in Power Apps
Apr 03, 2026.
Master PowerApps formulas! Learn when to use If() vs. Switch() for efficient and readable code. Explore examples and best practices for optimal performance in your apps.
Getting Started with Azure Functions in .NET
Mar 04, 2026.
Dive into serverless computing with .NET and Azure Functions! Learn to write, deploy, and configure your first function app, including essential post-publish environment setup.
Difference Between Azure Functions and Azure App Service?
Feb 25, 2026.
Explore the key differences between Azure Functions and Azure App Service for cloud-native apps. Optimize cost, scalability, & performance on Microsoft Azure. Choose wisely!
What is the Difference Between Azure Functions and Azure App Service?
Feb 24, 2026.
Explore Azure Functions (serverless, event-driven) vs. App Service (PaaS, continuous). Understand architecture, scaling, cost, and use cases for optimal cloud solutions.
Migrate C# Azure Functions from In-Process to the Isolated Worker Model
Feb 20, 2026.
Microsoft Azure Functions has been a popular platform for building serverless applications in .NET using the in-process execution model. However, with the evolution of .NET and the need for greater control, isolation, and long-term support, Microsoft now recommends migrating to the .NET isolated worker model. In this article, we’ll walk through why this migration is necessary, what drivers make it critical for enterprises, how the in-process and isolated worker models differ, the trade-offs and cost impact, and a practical step-by-step migration approach with code samples based on Microsoft’s official guidance.
How to Use logical functions in PowerApps
Feb 17, 2026.
Master PowerApps logical functions (If, And, Or, Not) to build dynamic, responsive apps! Learn to validate input, control behavior, and enhance user experience.
SQL Window Functions Explained – Examples & Best Practices
Feb 18, 2026.
Unlock the power of SQL Window Functions! Master ranking, aggregation, and value-based functions with practical examples and best practices for data analysis.
Building a Serverless PAN Validation API Using Azure Functions & Power Platform
Jan 16, 2026.
Build a serverless PAN validation API using Azure Functions, Power Automate, and Power Pages. Validate identity details without backend infrastructure code.
Remove and RemoveIf Functions in PowerApps
Jan 08, 2026.
Master PowerApps data management! Learn to use Remove and RemoveIf functions to efficiently delete specific records or those matching conditions from your data sources.
Power Apps Quick Functions – A Simple Guide
Jan 05, 2026.
Power Apps functions are built-in formulas that help developers control how an app works. These functions are used to handle logic, manage data, control user actions, and improve the overall user experience. They allow you to build powerful applications with minimal code by defining what should happen when users interact with the app.
Understanding Views, Indexes, Functions & Stored Procedures in SQL Server
Dec 01, 2025.
Master SQL Server! This beginner's guide explains Views, Indexes, Functions, and Stored Procedures with syntax and examples. Boost performance and simplify queries.
Improving Slow Scalar Functions Using Inline Table-Valued Functions
Nov 27, 2025.
Boost SQL Server performance by replacing slow scalar UDFs with inline table-valued functions (iTVFs). Eliminate row-by-row processing and enable set-based optimization.
Building Real-Time Cloud-Native Architectures on Azure Using Event Hub, Functions & Cosmos DB
Nov 26, 2025.
Build real-time cloud apps on Azure using Event Hub, Functions, and Cosmos DB. Achieve massive scale, low latency, and high availability with serverless architecture.
SQL Views vs Stored Procedures vs Functions — What’s the Difference?
Nov 25, 2025.
Understand the core differences between SQL Views, Stored Procedures, and Functions. Learn when to use each for optimal database performance, maintainability, and scalability.
SQL Server Functions in .NET Core (with EF Core)
Nov 18, 2025.
Leverage SQL Server functions in .NET Core with EF Core! Explore system functions, UDFs, and EF Core helpers for efficient data manipulation and query optimization.
📌SQL Server String Functions — SUBSTRING, CHARINDEX, LEN, and REPLICATE (With Real Examples)
Nov 14, 2025.
Master SQL Server string manipulation! Learn SUBSTRING, CHARINDEX, LEN, and REPLICATE with a practical email masking example. Enhance data security and readability.
Python - Advanced Python Functions and Operations
Nov 04, 2025.
Explore advanced Python functions: lambda, map, filter, *args, **kwargs, nested functions, and returning multiple values. Enhance your Python skills now!
Webhooks + Azure Functions (.NET 9 Isolated Worker)
Oct 31, 2025.
Build a serverless webhook endpoint in Azure Functions using .NET 9 and Visual Studio. Receive, validate, and process webhook events without writing any PowerShell commands.
Chapter 12: Polymorphism: Virtual Functions and Abstract Classes in C++
Oct 23, 2025.
Learn about virtual functions, the 'virtual' keyword, and how it facilitates runtime method resolution. Discover abstract classes and pure virtual functions for defining interfaces and ensuring derived class implementation. Understand the importance of virtual destructors for proper memory management in polymorphic hierarchies.
Chapter 13: Operator Overloading and Friend Functions in C++
Oct 23, 2025.
Learn to overload binary and unary operators, enabling seamless operations like addition for custom classes. Discover how to overload stream operators (<<, >>) for easy object output with std::cout. Understand friend functions and classes, granting access to private members for non-member functions like overloaded stream operators, ensuring efficient and elegant code.
PostgreSQL Tips for BI Professionals: From Window Functions to LOD Alternatives
Oct 23, 2025.
Unlock the power of PostgreSQL for Business Intelligence! This guide provides practical tips for BI professionals to leverage PostgreSQL's advanced SQL capabilities, including window functions, CTEs, and LOD alternatives. Improve dashboard performance, ensure data consistency, and streamline your BI workflow by moving complex logic upstream. Learn how to pre-aggregate data, create reusable logic, and optimize queries for faster insights and more reliable metrics. Master PostgreSQL and elevate your BI game!
Handling Large Payloads in Azure Functions — Smarter Ways to Scale Without Breaking Limits
Oct 22, 2025.
Don't let large payloads break your Azure Functions! This article explores payload size limits in Azure Functions for HTTP, Queue, Service Bus, Event Hub, Event Grid, and Blob triggers. Learn how to overcome these limitations by offloading large files to Blob Storage and triggering functions upon upload. Discover smart tricks for handling big data, including compression, chunking, asynchronous queues, and timeout monitoring, ensuring scalable and cost-efficient serverless solutions.
Cold Starts in Azure Functions and How the Premium Plan Solves Them
Oct 20, 2025.
Eliminate Azure Functions cold starts with the Premium plan! This article dives into a real-world healthcare IoT telemetry pipeline scenario where cold starts caused critical alert delays. Learn how pre-warmed instances in the Premium plan guarantee sub-100ms latency, ensuring real-time performance for mission-critical applications. Includes production-ready Bicep code and best practices for enterprise deployments, securing PHI/PII data with VNET integration and optimizing function performance.
Orchestrating Serverless Workflows: Calling Functions Within Azure Function Apps Using Durable Functions
Oct 18, 2025.
Orchestrate serverless workflows in Azure Function Apps using Durable Functions! This article demonstrates how to call functions within the same app, using a healthcare claims processing pipeline as a real-world example. Learn about orchestrator, activity, and client functions, error handling, and best practices for building resilient, scalable, and auditable enterprise workflows. Unlock the power of serverless orchestration!
Using Managed Identity with Azure Functions to Connect to Azure SQL Database
Oct 18, 2025.
Secure your Azure Functions and Azure SQL Database integration using Managed Identity! This article demonstrates how to eliminate hardcoded credentials and connection string secrets, especially crucial in regulated industries like healthcare. Learn how to implement a zero-secret, zero-maintenance architecture for enhanced security, compliance, and simplified deployments using a real-world claims processing scenario.
Azure Functions at the Edge: IP Restrictions and Azure AD Authentication in a Global Payment Gateway
Oct 18, 2025.
Secure your Azure Functions with a zero-trust approach! This article demonstrates how to implement IP restrictions and Azure AD authentication for HTTP-triggered functions, using a global payment gateway as a real-world example. Learn how to protect sensitive data, prevent unauthorized access, and meet compliance requirements by leveraging platform-level security features. Implement defense in depth without writing authentication code, ensuring a robust and auditable serverless architecture. Essential for finance, healthcare, and government workloads.
Secure Configuration for Azure Functions Using Azure Key Vault References
Oct 18, 2025.
Eliminate hardcoded secrets in Azure Functions using Azure Key Vault references for enhanced security and compliance. This guide demonstrates a real-world smart grid anomaly detection scenario, showcasing how to securely store and manage secrets like database passwords and API keys. Learn how to implement zero-trust secret management, enabling instant secret rotation without redeployment and ensuring full auditability. Protect your sensitive data and achieve compliance with industry standards.
Azure Functions Configuration: A Logistics Optimization
Oct 17, 2025.
Optimize Azure Functions for enterprise logistics like SwiftFreight! This guide covers critical configurations: host.json for runtime behavior, local.settings.json for local dev, and App Settings with Key Vault for secure environment configs. Learn to mitigate cold starts using Premium Plans, lazy loading, and proactive scaling. Master these techniques to ensure your functions perform at scale and keep your cargo safe and customers satisfied.
Azure Functions Bindings in Real-Time Disaster Response Systems
Oct 17, 2025.
Learn how RescueNet, a disaster response platform, uses Azure Functions bindings to orchestrate real-time rescue operations. Discover how Service Bus, Blob Storage, Cosmos DB, Event Grid, and HTTP bindings are leveraged for critical tasks like processing SOS alerts, managing drone imagery, and updating victim status. Explore best practices for configuring connection strings securely using Azure Key Vault and understand the importance of Service Bus for guaranteed message delivery and ordered processing in high-stakes environments. Achieve 99.999% reliability even during outages.
Azure Functions Timeouts and Auto-Scaling in Real-Time Healthcare Diagnostics
Oct 17, 2025.
Explore Azure Functions timeouts and auto-scaling strategies in a real-world healthcare diagnostics scenario. Learn how MediScan AI overcame timeout errors and scaling challenges in their serverless pipeline for processing medical imaging requests. Discover the Consumption plan's 10-minute limit, configuration techniques, and the benefits of migrating to the Premium plan for predictable, low-latency performance, reducing diagnostic latency by 68% and improving patient outcomes.
Event-Driven Intelligence: Triggers and Bindings in Azure Functions for Smart City Traffic Management
Oct 17, 2025.
Explore Azure Functions triggers and bindings in a smart city traffic management system (MetroPulse). Learn how triggers initiate functions based on events like Service Bus messages, blob storage updates, and HTTP requests. Discover why Azure enforces a single-trigger-per-function model for scalability and maintainability. See how input and output bindings simplify integration with Cosmos DB, Application Insights, and Teams, reducing code and improving performance. Optimize your serverless architecture for real-world applications.
Beyond the Timeout: Architecting Resilient, Long-Running Functions in Azure
Oct 16, 2025.
Overcome Azure Functions' 10-minute timeout limit! This guide explores architecting resilient, long-running functions for data-intensive tasks like image processing and AI inference. Learn how to migrate from the Consumption plan to the Premium plan, configure timeouts, and implement best practices for reliable execution. Discover how to avoid timeouts and ensure successful outcomes for critical workloads in climate tech, defense, and more.
Running Azure Functions in Containers for Mission-Critical Emergency Response
Oct 16, 2025.
Discover how to containerize Azure Functions for mission-critical applications like emergency response. Learn to leverage Docker for environment fidelity, dependency control, and enhanced security. Explore a real-world wildfire scenario, step-by-step containerization, and best practices for production deployment, ensuring consistent performance across cloud, edge, and disconnected environments. Unlock hybrid flexibility and mitigate cold starts for optimal results.
Observability Is Non-Negotiable: Logging and Debugging Azure Functions in Life-Critical Systems
Oct 16, 2025.
Ensure reliability in critical Azure Functions with robust observability. This article demonstrates how to effectively log and debug Azure Functions, using a real-world vaccine cold chain monitoring scenario. Learn to leverage Application Insights for end-to-end transaction tracing, custom dimensions, and proactive alerting. Master local debugging techniques with Azure Functions Core Tools to replicate production behavior and resolve issues swiftly, preventing costly failures and ensuring data integrity in mission-critical systems. Build, debug, and deploy with confidence!
Locking Down Financial Transaction APIs: Enforcing IP Restrictions on Azure Functions in Real-Time Payment Systems
Oct 16, 2025.
Secure real-time payment systems using Azure Function IP restrictions. This article provides a step-by-step guide to implementing network-level access control, crucial for financial services compliance (PCI DSS, PSD2). Learn how to allow traffic only from trusted sources, preventing unauthorized API calls and bolstering zero-trust security. Includes Azure CLI scripts, testing strategies, and operational best practices for enterprises processing instant SEPA or FedNow payments.
Surviving the Surge: How Azure Functions Handle Traffic Spikes in Emergency Response Systems
Oct 16, 2025.
Discover how Azure Functions provide a resilient, scalable solution for emergency response systems facing unpredictable traffic spikes. Learn from a real-world wildfire evacuation coordination system built on Azure, handling 100,000+ requests per minute with sub-second latency and zero data loss. Explore the architectural blueprint, .NET 8 implementation, and operational best practices for mission-critical workloads, ensuring communities receive timely assistance during disasters. See how serverless architecture builds lifelines.
Beyond Cold Starts: Building Always-Ready Azure Functions for Life-Critical Workloads
Oct 16, 2025.
Eliminate cold start latency in Azure Functions for mission-critical applications. This article explores the impact of cold starts on real-time systems like emergency response and provides actionable strategies to mitigate them. Learn how the Premium plan, pre-warming techniques, and code optimization can ensure instant responsiveness, transforming Azure Functions into a reliable solution for life-critical workloads. Discover best practices for enterprise deployments and optimize for instantaneity.
Orchestrating the Real World: Mastering the Three Pillars of Azure Durable Functions in Enterprise Workflows
Oct 15, 2025.
Unlock the power of Azure Durable Functions! This article explores the three core function types (Client, Orchestrator, Activity) and demonstrates how to orchestrate complex, stateful workflows in serverless environments. Learn how to automate real-world scenarios like insurance claims processing with resilience, scalability, and minimal overhead. Master the stateful future of serverless computing and transform your enterprise workflows.
The Illusion of Memory: How Azure Durable Functions Preserve State Across Replays in Airline Disruption Management
Oct 15, 2025.
Discover how Azure Durable Functions tackle complex, stateful workflows like airline rebooking using the orchestrator pattern. Learn how deterministic replay and durable storage create the illusion of persistent memory, ensuring fault tolerance and scalability. Explore a real-world example of managing flight disruptions and enterprise-grade design principles for building resilient serverless applications that survive chaos and never lose state.
Stateful Orchestration at Scale: How Azure Durable Functions Power Mission-Critical Infrastructure
Oct 15, 2025.
Discover how Azure Durable Functions provide stateful orchestration at scale for mission-critical infrastructure. Learn about Orchestrator Functions, Durable Entity Functions, and Durable Timers through a real-world smart grid load-shedding scenario during heatwaves.
Azure Functions Decoded: Hosting, Scaling, and Secure Bindings for Financial Workloads
Oct 14, 2025.
Unlock the power of Azure Functions for financial workloads! This article dives into hosting plans (Consumption, Premium, App Service), language support (C#, Python), automatic scaling, triggers & bindings, and input/output binding differences. Learn how to build a real-time fraud detection system using Azure Functions, achieving sub-250ms latency and automatic scaling. Master serverless architecture for secure and scalable fintech solutions.
Azure Functions Under the Hood: Runtime Identification, Isolated Process Entry Points
Oct 14, 2025.
Unlock the power of Azure Functions! This article dives deep into the runtime, addressing critical questions about function discovery, local development, versioning, and organization. Learn how to build robust, scalable serverless solutions using .NET Isolated Process, dependency injection, and best practices for real-world scenarios like logistics anomaly detection. Master the execution model and avoid costly anti-patterns in production.
Zero-Plumbing Architecture: How Azure Functions Bindings Power Real-Time Supply Chain Risk Intelligence
Oct 14, 2025.
Discover how Azure Functions bindings streamline data flow in serverless architectures, enabling real-time supply chain risk intelligence. This article explores passing data between input and output bindings using a practical example of monitoring global suppliers and responding to disasters. Learn best practices for building secure, observable, and resilient event-driven systems with zero-plumbing architecture, ensuring data integrity from edge to action.
Binding the Future of Healthcare: Azure Functions in Clinical Trial Data Pipelines
Oct 14, 2025.
Unlock the power of Azure Functions bindings for building robust and compliant clinical trial data pipelines. Learn how to leverage input/output bindings to streamline data ingestion, validation, and processing in healthcare. Discover best practices for secure, scalable, and auditable serverless architectures using function.json and Managed Identities. Explore a real-world example with code and configuration details, emphasizing data integrity and regulatory compliance.
Azure Functions vs. Azure Logic Apps: A Practical Comparison
Oct 03, 2025.
Confused about Azure Functions and Logic Apps? This practical comparison clarifies their distinct roles in cloud automation and integration. Discover when to choose Functions for code-intensive tasks and Logic Apps for low-code workflows. Explore real-world examples, key differences, and how to leverage both for optimal serverless solutions, combining custom code with visual workflow design for powerful results.
User-Defined Functions (UDFs) in Power Apps
Oct 03, 2025.
Discover Power Apps User-Defined Functions (UDFs), an experimental feature for creating reusable formulas. Learn how UDFs enhance modularity, simplify maintenance, and clean up complex logic in your canvas apps. This guide covers enabling UDFs, creating functions with parameters and return types, and calling them within your app. Note: UDFs are currently in preview and not recommended for production apps due to potential instability and limitations.
Processing File Uploads and Scheduled Tasks in Azure Functions with Shared Services
Sep 22, 2025.
The article demonstrates processing file uploads with a Blob Trigger and scheduling cleanup tasks with a Timer Trigger, both leveraging a shared service for core logic. Discover the best practices for structuring production-ready Azure Functions apps using triggers and shared services for file validation, and ETL.
What are arrow functions and how are they different from regular functions?
Aug 20, 2025.
Arrow functions provide a simpler and more concise way to write functions in JavaScript. This article explains what arrow functions are, their syntax, and how they differ from regular functions in behavior and use cases.
What are Difference between Regular functions and Normal Functions?
Aug 20, 2025.
Arrow functions in JavaScript provide a shorter and cleaner way to write functions. This article explains what arrow functions are, how they differ from normal functions, and when to use them effectively.
Creating Self-Signed Certificates with Azure Functions and App Registration in Azure AD
Aug 16, 2025.
Step-by-step guide on creating self-signed certificates with Azure Functions and Azure AD App Registration. Learn how to securely generate, manage, and use certificates for authentication and app integration in Microsoft Azure.
Understanding Functions in JavaScript
Aug 13, 2025.
Learn all about JavaScript functions — from declarations, expressions, and arrow functions to callbacks and best practices — with syntax examples, tips, and explanations for writing clean, reusable, and efficient code.
What Are Generators vs Regular Functions in Python?
Aug 08, 2025.
Learn the key differences between generators and regular functions in Python. Understand how they work, when to use them, and how they impact memory and performance with real Python code examples.
Top 10 Matplotlib Functions Every Data Analyst Should Know
Jul 18, 2025.
Unlock the power of Python data visualization with this quick articleto the top 10 Matplotlib functions every data analyst should know. From plot() to subplot(), learn how to create line charts, bar graphs, histograms, and more — with clear examples to get you started fast.
Modularize Your Power Apps with User-Defined Functions & Types
Jun 16, 2025.
In this blog, we’ll explore how these powerful features can simplify your logic, reduce duplication, and bring modular design to your app-building workflow.
Best Practices and Code Examples for Azure Functions using C# 13
Jun 09, 2025.
Ziggy Rafiq shares best practices for structuring, testing, and deploying production-grade serverless functions using Azure and xUnit in this article.
Transforming Data Insights with Snowflake's LLM Functions – PART 2
Jun 04, 2025.
Snowflake Cortex LLM functions like TRANSLATE and SUMMARIZE, enabling powerful in-database AI for multilingual translation and concise text summaries, thereby enhancing data analytics without the need for external tools or APIs.
How to Pass Functions & Params in React + TypeScript
May 27, 2025.
You’re passing functions around like candy in your React app, but when TypeScript throws a tantrum, you start hacking with any or begging Google for help. Let’s fix that.
Unleashing Serverless Power: Azure Functions Use Cases & Hands-On Guide
Apr 03, 2025.
Discover the power of serverless computing with Azure Functions! This guide explores real-world use cases, from automation to event-driven processing, and walks you through a hands-on implementation.
How to Build Serverless APIs with Azure Functions in Azure Portal
Mar 28, 2025.
Learn how to build and deploy serverless APIs using Azure Functions in the Azure Portal. This article covers creating an HTTP-triggered function, testing, securing, and scaling it efficiently.
Understanding Numeric Functions in SQL
Mar 27, 2025.
SQL numeric functions simplify mathematical operations like rounding, power calculations, and random value generation. Functions like ABS(), CEILING(), FLOOR(), ROUND(), SQRT(), MOD(), and LOG() help with financial calculations, data analysis, and scientific computing.
Understanding Conversion Functions in SQL
Mar 27, 2025.
SQL conversion functions like CAST(), CONVERT(), TRY_CAST(), TRY_CONVERT(), and FORMAT() help change data types, format values, and handle errors efficiently.
Explanation of Date and Time Functions in SQL
Mar 26, 2025.
SQL date and time functions help efficiently manipulate and retrieve date-related information. Common functions include GETDATE() for the current timestamp, DATEADD() for adding time intervals, DATEDIFF() for date differences, FORMAT() for formatting, and EOMONTH() for month-end dates.
Understanding Scalar Functions in SQL
Mar 21, 2025.
This article explores common functions like LEN(), UPPER(), LOWER(), ROUND(), GETDATE(), ABS(), SQRT(), SUBSTRING(), and REPLACE(), along with advanced usage, computations, and custom scalar functions for efficient queries.
Understanding Aggregate Functions in SQL
Mar 21, 2025.
SQL aggregate functions help perform calculations on multiple rows, returning a single result. This article covers COUNT(), SUM(), AVG(), MIN(), MAX(), and advanced uses like GROUP BY, HAVING, CASE, PARTITION BY, and DISTINCT.
Explaining Aggregate Functions in SQL
Feb 14, 2025.
Learn about SQL Aggregate Functions like SUM, COUNT, AVG, MIN, and MAX. These functions help perform calculations on grouped data, such as finding totals, averages, and minimum or maximum values, making data analysis more efficient.
Difference Between Collect & ClearCollect Functions in Power Apps
Dec 31, 2024.
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.
Python Functions and Variable Scope LEGB
Nov 29, 2024.
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 server
Nov 26, 2024.
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 Server
Nov 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.
BIT Functions New T-SQL Enhancements in SQL Server
Oct 30, 2024.
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 Auth
Oct 28, 2024.
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 App, configuring authentication, setting up permissions, and testing the function.
Exploring Aggregate Functions in Azure Cosmos DB
Oct 07, 2024.
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 insights from large datasets.
A Comprehensive Guide to Migrating Azure Functions C# to C# 12 with .NET 8 Isolated
Sep 20, 2024.
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 JavaScript
Sep 18, 2024.
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. Common examples include map(), filter(), and reduce(), which simplify complex tasks.
Learn Factory Functions in JavaScript
Sep 10, 2024.
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 duplication. It also covers memory optimization techniques using `Object.create()` for shared functionality.
Centralizing String Utility Functions in Java
Aug 27, 2024.
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 characters with underscores and if a string consists solely of letters, improving code organization and reusability.
Type Of Functions In Javascript
Aug 21, 2024.
This content explores various types of functions, including function declarations, expressions, arrow functions, and callbacks, offering insights into their usage, syntax, and differences in JavaScript.
JavaScript Functions to Simplify Your Code
Jul 26, 2024.
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 beginners and seasoned developers looking to optimize and enhance their JavaScript skills.
Lambda Functions and High Order Functions in Android kotlin
Jul 09, 2024.
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 parameter to add two doubles. These examples highlight Kotlin's functional programming capabilities.
Azure Functions Hosting Models: In-Process and Isolated Models
Jul 08, 2024.
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 function running in its own process.
Ranking Functions in SQL: RANK, DENSE_RANK, and ROW_NUMBER
Jul 03, 2024.
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 databases.
Understanding Durable Functions in Azure: A Comprehensive Guide
Jun 02, 2024.
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 Durable Functions.
Working with Lambda Functions in Python
May 21, 2024.
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() functions for streamlined code.
Working with LEAD and LAG Window Functions in SQL
May 20, 2024.
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.
Demystifying customStringify: Filtering Functions in JSON
May 13, 2024.
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 JSON string? That's where the customStringify function comes in.
Explain Lambda Functions in .NET C#
Apr 26, 2024.
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 functions in .NET, understand their syntax and usage, and uncover their practical applications in real-world scenarios.
Not all Functions are C# Methods
Apr 13, 2024.
How to write your functional programming functions in C#? That is the main question we're going to answer in this article.
Arrow Functions in React: Concise Syntax & Lexical Binding
Apr 03, 2024.
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 components.
String Handling Functions implementation in C Language
Mar 29, 2024.
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.
Calling Your Own Functions In Chatbot - OpenAI Function Calling
Jan 22, 2024.
This article explains how we can make a call to external functions using OpenAI’s Assistant API. Learn to call external functions using OpenAI's Assistant API. Get API keys, create an assistant, invoke tools, and make API calls. A step-by-step guide for building AI assistants.
Iterating Over an Array Using Arrow Functions in JavaScript
Jan 19, 2024.
The ways for Iterating Over an Array using arrow functions in JavaScript. Explore concise array iteration in JavaScript using arrow functions and methods like forEach, map, filter, reduce, and find. Simplify array tasks with clear, short, and effective code examples.
SQL Functions and Examples.
Jan 10, 2024.
This article provides you with many built-in SQL functions including aggregate functions, date functions, string functions, control flow functions, window functions, and math functions.
Azure Functions in ASP.NET Core Web API
Jan 01, 2024.
Azure Functions, a component of Microsoft's serverless computing offerings in Azure, enable developers to create and deploy small, event-driven code without managing infrastructure. These functions, supporting languages like C# and JavaScript, automatically scale and integrate with Azure services, streamlining the development of serverless applications and microservices.
Guard Functions in Angular
Dec 07, 2023.
Angular's guard functions are the gatekeepers of seamless navigation in applications. From securing routes to managing authentication and implementing role-based access, these functions enforce crucial rules before users can access specific components. This article takes a deep dive into Angular's guard functions, exploring their types and providing practical implementations with code snippets.
Understanding Window Functions in PostgreSQL
Nov 30, 2023.
In this article, we will learn how to use window functions in PostgreSQL, what are the different types of window functions, and how to write window function queries with examples.
Azure Functions C#
Oct 23, 2023.
Microsoft’s primary compute service is Azure function C#. We gain agility in development by focusing on our code and not worrying about server maintenance by using Azure functions. We are seeing the advantages of Azure functions and the simplicity of the event-driven model functions for integrating Azure services.
Windows Functions in SQL Server
Oct 17, 2023.
Windows functions in SQL Server are a powerful set of functions that operate across a specific "window" of rows defined by the OVER() clause. These functions allow for computations and aggregations over this defined window, enabling analytical and statistical calculations without altering the overall result set. Commonly used functions include ROW_NUMBER(), RANK(), DENSE_RANK(), SUM(), AVG(), and COUNT(). These functions greatly enhance query capabilities, aiding in tasks such as ranking data, calculating running totals, and performing comparative analyses within specified partitions or orderings. They play a vital role in advanced SQL operations and reporting.