Resources  
  • Introduction To SQL-APIAug 08, 2014. This provides the fundamentals of the SQL-API and covers the general concepts using the SQL-API
  • Mastering Connection Pooling with Dapper in ASP.NET Core Web APIJun 27, 2025. In modern web development, one of the key challenges when working with databases is efficiently managing database connections.
  • Building a CRUD API with Express.js and MongoDBJun 27, 2025. Backend engineers should gain a thorough understanding of how to construct a RESTful CRUD API, which stands for construct, Read, Update, and Delete activities. This tutorial will guide you step-by-step through the process of creating a simple CRUD API with Node.js, Express.js, and MongoDB.
  • Minimal API with Authorization JWT Token in .NET 9Jun 27, 2025. This article explains how to implement JWT authentication and authorization in Minimal API using .NET Core 9.0, Visual Studio 2022, and Swagger for testing secured endpoints via generated bearer tokens.
  • Understanding SESSION_CONTEXT in SQL ServerJun 26, 2025. This article explains SQL Server's SESSION_CONTEXT, a session-scoped key-value store introduced in 2016, useful for securely passing metadata like User ID or flags between procedures, triggers, and applications.
  • 10 .NET Core Features You’re Not Using (But Definitely Should!)Jun 26, 2025. .NET Core (now just “.NET” from .NET 5 onwards) has become a powerhouse for modern, cross-platform development. But while most developers are busy writing APIs or deploying Blazor apps, there’s a treasure trove of underutilized features that could make your code faster, cleaner, and more maintainable.
  • Basic SQL Queries for Database TestingJun 23, 2025. Learn essential SQL queries used in database testing. This guide covers SELECT, JOIN, WHERE, and more—ideal for QA testers and beginners ensuring data accuracy and integrity in applications.
  • How to Collaboratively Work with SQL Server 2025, Visual Studio Code, and GitHub Copilot (Step-by-Step Guide)Jun 21, 2025. This article walks you through how to collaboratively work using SQL Server 2025, Visual Studio Code (VS Code), and GitHub Copilot. With clear steps and screenshots, this guide helps beginners and professionals enhance productivity and collaboration in database development.
  • Best Generative AI APIs in 2025Jun 19, 2025. Discover the top Generative AI APIs in 2025, including OpenAI GPT-4o, Anthropic Claude 3.5, Google Gemini 1.5, and open-source models like Mistral and LLaMA 3. This guide offers detailed comparisons of text, code, and image generation APIs, covering features, pricing, use cases, and performance. Ideal for developers, startups, and businesses integrating AI-powered solutions in chatbots, search, automation, and creative tools.
  • Difference Between Minimal API and Controller API .NET CoreJun 20, 2025. Explore the key differences between Minimal API and Controller API in .NET Core, including structure, performance, routing, and use cases—helping you choose the right approach for your project.
  • Database Testing: A Complete GuideJun 19, 2025. Database Testing ensures data accuracy, integrity, and performance by validating schemas, procedures, and operations. This guide covers types, tools, scenarios, and best practices for robust, high-quality data-driven applications.
  • What is DBT (Data Build Tool)?Jun 19, 2025. Learn how DBT (Data Build Tool) transforms raw data using SQL, enabling version control, testing, and documentation to bring software engineering best practices into modern, scalable, and reliable data workflows.
  • 🚨 A Backend Developer’s Pain 🚨Jun 18, 2025. Postman tests may pass, but real issues begin with frontend calls, often due to CORS. Browsers enforce security checks that Postman skips. Understanding CORS is key to debugging real-world API problems.
  • How to use Ngrok in ASP.NET CoreJun 18, 2025. When building modern web applications, developers often face a common challenge: testing locally developed webhooks, APIs, or third-party integrations that require a publicly accessible URL.
  • Health Checks in .NET 8 Web API: A Comprehensive GuideJun 18, 2025. Ensure your ASP.NET Web API’s reliability with .NET 8 health checks—monitor SQL Server, external APIs, and network connectivity using JSON-formatted diagnostics for proactive monitoring, easier debugging, and improved application resilience.
  • API Rate Limiting in .NETJun 17, 2025. In the world of web APIs, especially public ones, controlling how many requests a user or client can make is very important. This is known as API Rate Limiting. Without it, one careless or malicious user could overload your server, slow down services for others, or even bring down your entire application.
  • Fixed Window vs. Sliding Window Rate Limiting in .NETJun 17, 2025. Learn the difference between Fixed and Sliding Window Rate Limiting in .NET. Understand how each algorithm controls API traffic, prevents abuse, and suits different use cases like login or public endpoints.
  • Handle Entity Framework TransactionsJun 15, 2025. Learn how to manage transactions in Entity Framework to ensure data integrity. This article covers built-in handling, explicit transactions, rollbacks, commits, and managing multiple DbContexts for consistent operations.
  • Should We Train Our Own LLMs or Use Existing Ones via APIs?Jun 13, 2025. Learn whether to train your own LLM or use existing APIs, with pros, cons, cost considerations, and expert tips to guide your enterprise AI strategy.
  • SQL vs NoSQL: Making the Right Database Choice for Your ApplicationJun 12, 2025. Learn the core differences between SQL and NoSQL databases. Explore their advantages, disadvantages, top database options, and when to use each. A must-read for software developers and DBAs making architectural decisions.
  • Secure API Payloads Using AES and RSA Encryption in Angular and .NET CoreJun 11, 2025. Learn how to secure API payload using AES and RSA encryption in Angular and .NET Core. This step-by-step guide covers hybrid encryption, key exchange, and best practices for protecting sensitive data in web applications.
  • Table Sharding in SQL: Types, Examples, and Best PracticesJun 10, 2025. Table sharding improves database scalability and performance by splitting large tables into smaller, distributed shards. It enhances speed, fault tolerance, and cost-efficiency—ideal for growing applications with heavy data loads.
  • Testing with Moq for Clean and Reliable Code in ASP.NET Core with C# 13 and xUnitJun 08, 2025. With this tutorial, you will learn how to use C# 13, xUnit, and Moq to test your APIs in ASP.NET Core using best practices. The guide was written by Ziggy Rafiq.
  • Building Scalable APIs with Vertical Slice Architecture in .NETJun 09, 2025. Vertical Slice Architecture organizes code by features rather than technical layers. Each “slice” encapsulates all aspects of a specific feature, including the UI, business logic, and data access.
  • Database Fragmentation: Understanding, Managing, and MitigatingJun 06, 2025. Learn how to detect, manage, and resolve SQL Server fragmentation with live examples. Improve query performance, reduce I/O overhead, and optimize indexes and heaps using proven best practices and tools.
  • Horizontal vs Vertical Partitioning in SQLJun 04, 2025. Horizontal and vertical partitioning are techniques in SQL to improve performance and manage large datasets. Learn how each method works, their use cases, and how they impact database design.
  • Transforming Data Insights with Snowflake's LLM Functions – PART 2Jun 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.
  • Calling REST APIs in Blazor Server: A Beginner's Guide with ExampleJun 04, 2025. In this article, we will learn how to call REST APIs in a Blazor Server application using HttpClient. We’ll walk through how to send GET, POST, PUT, and DELETE requests, and handle JSON responses using strongly-typed models.Whether you're building a dashboard, e-commerce site, or internal tool, REST API integration is a must-have skill for Blazor developers.
  • Deploy a Website Using AWS Amplify ConsoleJun 04, 2025. AWS Amplify is a cloud-based development platform that simplifies the building and deployment of web and mobile apps, featuring CI/CD hosting, authentication, APIs, storage, and low-code tools such as Amplify Studio.
  • Logging in ASP.NET Core Web API Using MongoDBJun 03, 2025. Logging is one of the most important parts of building a real-world application. It helps you track errors, monitor behavior, and understand what your app is doing behind the scenes.
  • Building a Clean ASP.NET Core API with C# 13, EF Core, and DDDJun 02, 2025. The guide is written by Ziggy Rafiq and follows real-world architecture and testing best practices to provide a clean, scalable REST API using ASP.NET Core, C# 13, EF Core, and MS SQL.
  • Mastering API Development in .NETJun 02, 2025. This article provides a practical guide for .NET developers to build clean, scalable, and maintainable APIs using ASP.NET Core.
  • Understanding DBCC Commands in SQL Server: Use Cases and ImportanceMay 31, 2025. Learn the essentials of DBCC commands in SQL Server—powerful tools for monitoring, maintaining, and troubleshooting databases. Mastering them ensures performance optimization, deadlock resolution, and proactive database health checks.
  • Ethereum 2.0 API Migration GuideMay 29, 2025. Ethereum 2.0 revolutionizes development with scalable, secure Proof of Stake, introducing new REST APIs for validators, staking, and consensus—essential for upgrading tools, dashboards, and infrastructure post-Merge.
  • HTML Pages in .NET 9 Web API [GamesCatalog] 22May 28, 2025. Explore HTML Pages integration in .NET 9 Web API with the [GamesCatalog] project. Learn how to serve dynamic content, enhance user experience, and simplify front-end delivery in APIs.
  • SQL Server Transaction Locks: Identification & ResolutionMay 28, 2025. Learn how SQL Server transaction locks ensure data integrity, identify locking issues using DMVs and Activity Monitor, and explore strategies like query optimization, isolation levels, and deadlock resolution for better performance.
  • How to Install and Configure SQL Server 2025 in WindowsMay 22, 2025. This articlee walks you through installing SQL Server 2025 on Windows, from system requirements to setup and configuration. Learn how to enable features, set authentication modes, and ensure your server runs smoothly ideal for beginners and advanced users alike.
  • Private AI for Fintech: How PT-SLMs Enable Scalable and Secure IntelligenceMay 22, 2025. Private Small Language Models (PT-SLMs) empower fintechs with secure, compliant, and scalable AI, ensuring privacy, integration, cost control, and real-time decisioning without relying on public LLM APIs.
  • Azure: Secure Web API-to-Web API Authentication with Azure Managed IdentityMay 21, 2025. This article simplifies authentication between services, eliminating secrets and improving security using Azure’s built-in identity management features. Ideal for developers building secure cloud apps.
  • Service Discovery using ConsulMay 21, 2025. Explore how to implement service discovery in .NET using Consul, enabling microservices to dynamically locate and communicate with each other without hardcoding service addresses or configurations.
  • Event-Driven CQRS with C# 14 and the SQL Outbox PatternMay 15, 2025. Learn how to implement a reliable event-driven CQRS microservice using the SQL Outbox Pattern with C# 14. Ensure strong consistency, transactional event publishing, and fail-safe asynchronous processing for scalable distributed systems.
  • Real-Time Data Retrieval from APIs Using SSISMay 14, 2025. This article explains how to integrate APIs with SQL Server Integration Services (SSIS) to automate data retrieval using HTTP requests. It covers API setup, SSIS package creation, and script task configuration.
  • .NET Aspire Integrations (SQL Server Integration in Aspire Applications)May 14, 2025. In this chapter, you'll learn how to integrate SQL Server into your .NET Aspire applications with minimal configuration and maximum flexibility.
  • Microsoft Fabric Warehouse Integration in VS Code for DevsMay 13, 2025. Experience seamless development with Microsoft Fabric and VS Code integration. Write, debug, and manage SQL queries directly in your editor, connect to Fabric Warehouse, and boost productivity with real-time data access.
  • Advanced ETL from OLTP Databases to a Data Warehouse with C# 14May 12, 2025. Build scalable and efficient ETL pipelines using C# 14 and .NET 9. Leverage Dapper, SQL Server, Azure Synapse, and cloud integration for seamless data extraction, transformation, and loading to data warehouses and lakes.
  • How to Resolve NuGet Package Manager Issues with v3 API DowntimeMay 09, 2025. If you're working with NuGet in Visual Studio and encountering issues due to the NuGet v3 API being temporarily unavailable, you're not alone. Many developers have experienced downtime with the NuGet v3 API, leading to errors and hindering package management workflows.
  • Improved CRUD operations for GridView with Redshift in ASP.NET Core MVC (Utilizing C# 14 Features)May 08, 2025. Learn how to enable CRUD operations in an ASP.NET Core MVC application using Amazon Redshift and C# 14 features. This guide covers setup, connection, SQL commands, data manipulation, security, and best practices.
  • What’s New in Grafana 12.0May 08, 2025. Explore Grafana 12.0's new features like Git Sync, dynamic dashboards, and enhanced drilldowns. Perfect for beginners seeking practical insights.
  • Construction of Polyglot Microservices using C# and .NETMay 07, 2025. Learn how to design C# microservices for polyglot systems that integrate multiple languages like Python, Node.js, and Go. Explore strategies for using open protocols, defining contracts, and ensuring resilience in distributed environments.
  • Build & Deploy Azure Function Using C# and Integration with Azure SQLMay 05, 2025. This article walks you through creating the function, connecting to SQL, and deploying it to Azure perfect for developers looking to build serverless apps with database support.
  • NoSQL vs. SQL: Which One to UseMay 02, 2025. Explore the key differences between SQL and NoSQL databases, including structure, scalability, use cases, and performance.
  • Authenticated Requests in .NET 9 Web API [GamesCatalog] 21May 02, 2025. We aim to create a mobile app and its backend using C# and .NET. We will use the IGDB game review API: https://api-docs.igdb.com/#examples With it, we can build a mobile game catalog app and store our reviews.
  • Vibe Coding with AI: Using Prompt Engineering to Build a Full C# Database SolutionMay 02, 2025. Discover how to harness the power of AI and prompt engineering to build a complete C# database solution.
  • Building a School Administration Solution with C# 14 and .NET 9May 01, 2025. Build a scalable School Administration System using C# 14 and .NET 9. Leverage features like primary constructors, minimal APIs, and performance optimizations to manage student info, attendance, grades, schedules, and more.
  • Advanced C# Database Tricks for Power UsersMay 01, 2025. Explore advanced C# database techniques using ADO.NET, Entity Framework Core, and Dapper.
  • Encrypting User Passwords [GamesCatalog] 20May 01, 2025. This article covers the best practices for protecting user data, including using strong hashing algorithms and salting techniques to prevent unauthorized access and ensure data privacy.
  • Validations with DataAnnotations and User Creation [GamesCatalog] 19Apr 29, 2025. We aim to create a mobile app and its backend using C# and .NET. We will use the IGDB game review API: https://api-docs.igdb.com/#examplesWith it, we can build a mobile game catalog app and store our reviews.
  • Creating a WebApi Project in .NET 9 [GamesCatalog] 18Apr 28, 2025. Learn how to set up an ASP.NET Core Web API with MySQL using Entity Framework Core. This guide covers creating projects, configuring the database, defining DTOs, adding migrations, and creating a users table in the database.
  • Artificial Intelligence and Education: Shaping the Future of LearningApr 28, 2025. Discover how Artificial Intelligence is transforming education by enabling personalized learning, smart classrooms, and intelligent tutoring.
  • Leveraging Databases with .NET 9 in Financial ApplicationsApr 25, 2025. .NET 9 enhances financial app development with improved performance, minimal APIs, and better cloud-native support. Paired with SQL Server, PostgreSQL, or MongoDB, it enables scalable, secure, and data-intensive fintech solutions.
  • Advanced Database Programming with C# 14 and Microsoft SQL ServerApr 24, 2025. As of C# 14, Microsoft continues to evolve the language to provide more expressive, safe, and performant coding patterns.
  • SQL Server CLR Integration and SSIS Automation with C#Apr 24, 2025. Learn how to enhance SQL Server functionality using CLR integration and automate SSIS packages with C#.
  • Implementing Discord Social Login in PythonApr 24, 2025. Implement Discord social login in a Flask app using OAuth2. Authenticate users, fetch profile data, and manage tokens securely with Python, requests-oauthlib, and environment variables. Includes Swagger API docs and avatar URL support.
  • Building a Versioned REST API in C# with SwaggerApr 23, 2025. In this article we will learn how to build a versioned REST API using C# and ASP.NET Core with Swagger support.
  • Understanding Change Data Capture (CDC) and Its TypesApr 23, 2025. In this article we are going to learn about the CDC and types of CDC approaches. It helps keep data in sync without causing a heavy load on the database.
  • Introduction to Azure Web App ServiceApr 23, 2025. Azure App Service is a fully managed PaaS for hosting web apps, APIs, and mobile backends. It supports .NET, Java, Python, Node.js, and more, offering autoscaling, security, CI/CD, and Docker support.
  • Why Developers and AI Engineers Are Embracing Private Tailored SLMsApr 23, 2025. Private Tailored SLMs empower developers to deploy secure, customizable AI models locally—integrating with internal systems, safeguarding data, and enabling enterprise-grade performance without relying on public LLMs or external APIs.
  • Implementing TOTP (Time-Based One-Time Password) MFA in .NET CoreApr 22, 2025. TOTP (Time-based One-Time Password) is a secure two-factor authentication (2FA) method that generates temporary, single-use codes for user verification.
  • Order of Execution in LINQ QueriesApr 22, 2025. This article explains the difference between deferred and immediate execution, outlines the execution order, and shares best practices to write efficient and optimized LINQ queries for real-world applications.
  • Execution Process of SQL Queries vs Stored Procedures Apr 21, 2025. Dive deep into the internal execution process of SQL Server queries with this one-of-a-kind article comparing normal SQL queries and stored procedures.
  • Django's Built-in Libraries and FunctionsApr 18, 2025. Explore Django's built-in libraries and functions that simplify web development. From handling URLs and forms to using shortcuts and utility tools, Django offers powerful features out of the box to help developers build robust, scalable apps faster and easier.
  • Building a Stock Market API with FastAPI and PythonApr 16, 2025. In this tutorial, we'll walk through the process of creating a backend API for a stock market application using Python and the FastAPI framework.
  • Learn Class Components - ReactApr 15, 2025. this article is basic about class component and its functionality based
  • Introduction to Event Driven Architecture [EDA]Apr 15, 2025. Event-driven architecture (EDA) is a software design pattern where decoupled components communicate via events. It enables real-time, scalable, and flexible systems, commonly used in microservices, IoT, payment processing, and real-time analytics.
  • .NET 8 - System.Linq.Dynamic.Core – using SQL LIKEApr 11, 2025. System.Linq.Dynamic.Core library does not support SQL LIKE, and I added support for it. Added SQL LIKE support to the System.Linq.Dynamic.Core in .NET 8 using a custom patch. Enables dynamic SQL pattern matching in EF8 projects where built-in LIKE functionality was missing.
  • Implementing JWT Authentication in Python APIsApr 10, 2025. Learn how to implement JWT authentication in a Python Flask API with step-by-step guidance. Secure your routes, generate tokens, and validate users with best practices for modern web API security.2/2
  • Docker Deployment for ASP.NET Core API & Blazor AppsApr 10, 2025. Learn to Dockerize ASP.NET Core APIs and Blazor apps with real-world examples, Compose setups, and pro tips to avoid pitfalls.
  • Create Foreign Keys Dynamically in SQL Server DatabaseApr 10, 2025. Create the referential integrity constraint i.e. Foreign key dynamically in SQL Server database. This script dynamically adds foreign keys to all tables with a CompanyID column by scanning the database, ensuring they reference the Company table—ideal for retrofitting relational integrity.
  • Unit Test CRUD operation in Web API using NUnit Testing FrameworkApr 07, 2025. Testing a Web API Crud Operation's test scenarios using NUnit Framework. Learn how to implement unit testing in C# using the NUnit framework for efficient CRUD operation testing. Explore test case scenarios, NUnit features, and the AAA pattern for reliable, high-quality code validation.
  • Automating News Publication with .NET: A Deep Dive into the AI News Automation SystemApr 04, 2025. AI News Automation is a .NET 8 solution that auto-discovers, summarizes, and publishes trending news using AI, HTML parsing, and scheduling for real-time, scalable, and intelligent content delivery.
  • How does Microservices Architecture WorkApr 02, 2025. Microservices Architecture breaks applications into small, independent services that communicate via APIs. It enhances scalability, resilience, and flexibility but adds complexity. Ideal for cloud-native, scalable apps needing independent deployments.
  • Building Your First API with FlaskApr 02, 2025. Learn how to build a simple student management API using Flask in Python. This guide covers CRUD operations (GET, POST, PUT, DELETE), API endpoints, JSON responses, and testing with Postman for a hands-on learning experience.
  • Deploy Go REST API to Azure Container Apps in Easy StepsApr 02, 2025. This blog post will guide you through the process of containerizing a simple Go REST API and deploying it to Azure Container Apps. We'll cover everything from creating the Go application to configuring Azure Container Apps for seamless deployment.
  • Azure Synapse Analytics Serverless and Dedicated SQL PoolsApr 02, 2025. This article explains in detail about what Azure Synapse Analytics is and a brief comparison of the different SQL runtime environments it provisions.
  • Mitigate OWASP A03:2021 – Injection Web Security TipsApr 01, 2025. ?Injection attacks, such as SQL Injection and Cross-Site Scripting (XSS), exploit vulnerabilities where untrusted data is improperly handled, leading to unauthorized command execution or data access. Mitigation strategies include input validation, parameterized queries, and adhering to secure coding practices to enhance web application security.
  • Mastering Eager Loading in ASP.NET Core Web APIMar 31, 2025. Eager Loading in ASP.NET Core Web API is a technique using Entity Framework Core to load related data (like child entities) alongside the main entity in a single query. It helps improve performance by reducing database round-trip use.Include() and .ThenInclude(). Ideal for situations where related data is always needed.
  • Advanced APIs with ASP.NET Core: Middleware, EF Core, and VersioningMar 28, 2025. Learn how to build advanced APIs with ASP.NET Core using middleware, Entity Framework Core (EF Core), and API versioning. This guide covers request handling, database management with EF Core, and implementing versioning strategies for scalable and maintainable APIs.
  • How to Build Serverless APIs with Azure Functions in Azure PortalMar 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.
  • Consuming HTTP Calls in .NET MAUI Using HttpClientMar 27, 2025. Learn how to use HttpClient in .NET MAUI to perform GET, POST, PUT, and DELETE operations on a REST API. Build a simple UI and display JSON responses using alerts.
  • Understanding Numeric Functions in SQLMar 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.
  • Implement idempotent APIs in ASP.NET CoreMar 27, 2025. Idempotent APIs ensure repeated requests yield the same outcome, preventing duplicate operations. This article explores idempotency in HTTP methods, real-world examples, and implementation techniques for robust and reliable web services.
  • Creating DataFrames in PySpark Using Fabric NotebookMar 27, 2025. This article walks through defining schemas, specifying column names, and using SQL-like DDL in a Fabric Notebook. Explore StructType, StructField, and various ways to display and verify DataFrame content efficiently.
  • Understanding Conversion Functions in SQLMar 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 SQLMar 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.
  • Lazy Loading in ASP.NET Core Web APIMar 26, 2025. Learn how to implement Lazy Loading in ASP.NET Core Web API using Entity Framework Core. This complete guide covers configuration, models, DTOs, controllers, and best practices with a working example.
  • Prevent Accidental Data Deletion with Two Simple StrategiesMar 25, 2025. Recently, I came across several discussions on Communities where users shared their experiences with accidental data deletion.
  • Understanding System-Versioned Tables in SQLMar 25, 2025. System-versioned tables in SQL automatically track data changes, maintaining historical records for auditing and recovery. They consist of a main table (current data) and a history table (past records).
  • Mastering SQL String FunctionsMar 25, 2025. SQL string functions help manipulate and process text data efficiently. This guide covers key functions like UPPER(), LOWER(), LEN(), LEFT(), RIGHT(), SUBSTRING(), REPLACE(), CONCAT(), LTRIM(), RTRIM(), CHARINDEX(), REVERSE(), and FORMAT(), demonstrating their usage with examples to improve query performance and readability.
  • Understanding Parameter Sniffing in SQL ServerMar 24, 2025. In SQL Server and other relational database systems, query execution performance is critical for handling large datasets efficiently. One common yet sometimes problematic optimization technique is Parameter Sniffing. While it can improve query performance.
  • Automating SCD Type 4 in Azure SQL Database with Azure Data FactoryMar 24, 2025. Learn how to automate Slowly Changing Dimension (SCD) Type 4 implementation in Azure SQL Database using Azure Data Factory.