Resources   No resource found

• What Is the DOM(Document Object Model)Jul 04, 2025. The DOM (Document Object Model) is a browser-generated tree structure representing HTML. JavaScript utilizes the DOM to access, modify, and interact with page elements dynamically in real-time.
• Page Object Model Design Pattern: Benefits and ImplementationJun 30, 2025. The Page Object Model (POM) design pattern in Selenium improves test automation by separating UI structure from test logic, ensuring maintainability, reusability, readability, and scalability for growing web applications.
• .NET Core Web API Features with Code ExamplesJun 30, 2025. Learn the key features of .NET Core Web API with real code examples. From routing, dependency injection, and middleware to authentication and versioning—build robust, scalable RESTful APIs easily.
• When Should I Use useEffect in React?Jun 26, 2025. Wondering when to use useEffect in React? This guide explains the most common use cases like fetching data, subscriptions, and more—with examples and best practices.
• Why Does useEffect Run Multiple Times in React? Explained with FixesJun 26, 2025. Struggling with useEffect running multiple times in React? Learn the real reasons behind multiple executions and how to control it using dependency arrays and best practices.
• 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.
• Service Lifetimes in ASP.NET Core: Transient vs Scoped vs SingletonJun 25, 2025. Learn the differences between Transient, Scoped, and Singleton service lifetimes in ASP.NET Core with real-world examples
• Introduction to Dagger Hilt for Android DevelopmentJun 24, 2025. Learn how to use Dagger Hilt in Android to simplify dependency injection, reduce boilerplate code, and build cleaner, more maintainable apps with modern architecture best practices.
• 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.
• 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.
• Building Objects in JavaScriptJun 18, 2025. JavaScript is an object-based language, which does not Completely support object oriented programming concepts. It provides a mechanism by which user-defined Objects can be created.
• 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.
• How To Run JavaScript in Power Automate Desktop Using “Run JavaScript” ActionJun 17, 2025. Learn how to run JavaScript directly in Power Automate Desktop using the “Run JavaScript” action. Build objects, return JSON via WScript.Echo(), and integrate JS logic seamlessly into your PAD flows.
• 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.
• 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.
• Best Practices and Code Examples for Azure Functions using C# 13Jun 09, 2025. Ziggy Rafiq shares best practices for structuring, testing, and deploying production-grade serverless functions using Azure and xUnit in this article.
• Mastering the Factory Pattern in C# 13: Best Practices with Real-World ExamplesJun 08, 2025. With this best practices guide by Ziggy Rafiq, you will learn Factory Pattern in C# 13 with clean architecture, DI, and testable design.
• 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.
• 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.
• Liquid Objects in Power Pages Portal – Explained with ExamplesJun 02, 2025. Learn how to use Liquid Objects in Power Pages Portal with clear examples. This guide helps you customize dynamic content, enhance user experience, and master Power Platform Liquid syntax.
• 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.
• 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.
• Creating a "Pooled" Dependency Injection Lifetime in C# 13May 19, 2025. Discover how Ziggy Rafiq demonstrates how to set up a custom "pooled" dependency injection lifetime in C# 13 using ObjectPool<t> with best practices, DI registration, and high-performance service examples.</t>
• 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.
• 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.
• 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.
• The Spread Operator in JavaScriptMay 04, 2025. The spread operator (...) in JavaScript lets you quickly expand arrays or objects into individual elements. This article covers how to use it for copying, merging, and passing values, with real examples and common pitfalls explained.
• Destructuring in JavaScriptMay 03, 2025. How to use destructuring in JavaScript. We’ll cover the basics, real-life use cases (like working with functions, APIs, and nested data), and throw in some practical tips along the way.
• 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.
• 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.
• Advanced C# Database Tricks for Power UsersMay 01, 2025. Explore advanced C# database techniques using ADO.NET, Entity Framework Core, and Dapper.
• 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.
• How to Convert a DataTable to a List of Objects in C#Apr 27, 2025. Learn how to convert a DataTable to a List<T> in C#. Explore manual, reflection-based, and LINQ methods for better performance, type safety, and cleaner code. Improve maintainability in modern C# applications.
• 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#.
• How to Convert a List of Objects to a DataTable in C#Apr 23, 2025. In real-world C# applications, especially when working with data layers or exporting data (e.g., to Excel, reports, or grids), you may often need to convert a generic list of objects (List<T>) to a DataTable.This article shows you how to do that in a clean, reusable way using reflection.
• 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.
• 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.
• Primary Constructors in C# 12Apr 18, 2025. Primary constructors in C# 12 simplify class and struct initialization by allowing parameters to be declared directly in the class signature. This new feature reduces boilerplate code, making object creation cleaner and more concise. Great for writing modern, readable C# code.
• Clean Code with Onion ArchitectureApr 11, 2025. Onion Architecture structures code into layers—Domain, Application, Infrastructure, and UI—ensuring separation of concerns, maintainability, and testability by isolating business logic from external dependencies.
• .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.
• Stop Overwriting Your Services: The Case for Keyed DI in .NET 8Apr 11, 2025. Avoid service conflicts and boost flexibility with .NET 8’s Keyed Dependency Injection—supporting multiple implementations of the same interface.
• 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.
• Understanding the Dependency Inversion Principle (DIP) in SOLID DesignApr 08, 2025. The Dependency Inversion Principle (DIP) promotes decoupling by ensuring high-level modules depend on abstractions, not concrete implementations, enhancing flexibility, testability, and maintainability in code.
• Interface Segregation Principle (ISP)Apr 08, 2025. The Interface Segregation Principle (ISP) is one of the SOLID principles of object-oriented design. It promotes creating small, specific interfaces so that implementing classes don’t need to depend on methods they don’t use, leading to cleaner, modular code.
• Simple Best Practices for Code Quality and Performance in .NETApr 07, 2025. Let's break down some best practices for writing good and fast code in .NET, using simple examples and including important principles that anyone can understand.
• Updating an Object in the Local Database in MAUI .NET 9 [GamesCatalog] - Part 11Apr 03, 2025. Learn how to retrieve and update game statuses in a local database using MAUI .NET 9. Implement async functions in GameRepo and GameService, manage game status, and enhance UI interactions efficiently.
• 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.
• Adding Objects to a Local Database in MAUI .NET 9 [GamesCatalog] - Part 10Apr 02, 2025. Learn how to store game reviews in a local SQLite database using MAUI .NET 9. This guide covers setting up repositories, handling images, adding games, and implementing dependency injection for seamless functionality.
• 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.
• Understanding the Page Object Model (POM) in Test AutomationMar 28, 2025. The Page Object Model (POM) enhances test automation by improving maintainability, readability, and scalability. Implementing POM with best practices ensures efficient and reliable UI testing.
• Integrating Java with QA Automation: Selenium WebDriver TestingMar 28, 2025. Java and Selenium WebDriver offer a robust foundation for QA automation, enabling scalable, maintainable, and efficient testing. Implementing best practices ensures a high-quality software delivery process.
• 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 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.
• 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.
• 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.
• 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).
• How to Dependency Inject in Blazor ApplicationsMar 24, 2025. Dependency Injection (DI) is a design pattern that enhances code maintainability and testability by injecting dependencies into components rather than creating them internally. Blazor, being part of the ASP.NET Core ecosystem, has built-in support for DI.
• 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.
• SQL Tag Library in Java Server PageMar 21, 2025. JSTL SQL tags are used to access databases and are designed for low-volume Web-based applications.? JSTL SQL tags facilitate database interactions in JSP pages, enabling data source setup, query execution, updates, and transactions through tags like <sql:setDataSource>, <sql:query>, <sql:update>, and <sql: transaction>
• Understanding Aggregate Functions in SQLMar 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.
• Understanding Scalar Functions in SQLMar 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 SQL Execution PlansMar 20, 2025. An SQL execution plan outlines how a database executes a query, detailing operations like table scans, index seeks, and joins. Analyzing these plans is essential for optimizing query performance.
• Understanding SQL CTE (Common Table Expression)Mar 19, 2025. A Common Table Expression (CTE) in SQL is a temporary result set that improves query readability and performance. CTEs simplify complex queries, support recursive operations, and help with aggregation and multi-step calculations.
• A Simpler Way to Initialize ObjectsMar 18, 2025. With the release of C# 12, Primary Constructors were introduced to simplify class and struct initialization. This feature allows parameters to be declared directly in the class or struct definition, eliminating the need for boilerplate code and improving readability.
• Explicit Loading in ASP.NET Core Web APIMar 18, 2025. Explicit Loading in ASP.NET Core Web API is a technique used to manually retrieve related data from the database when needed, using LoadAsync() on navigation properties. Unlike eager loading (Include()) or lazy loading, explicit loading provides better control over database queries, improving performance and efficiency. It is useful when related data is conditionally required.
• The Object Oriented ProgrammingMar 17, 2025. The Object Oriented Programming (OOP)  improves the scalability and reusability of the code. This comprise of class and objects.
• Implementing SCD Type 4 in Azure SQL Database: A Step-by-Step GuideMar 16, 2025. Learn how to implement SCD Type 4 in Azure SQL Database using a structured approach with staging, dimension, and history tables. This guide covers real-world use cases, SQL implementation, and execution scenarios for efficient historical data management.
• Azure Computer Vision - Object DetectionMar 10, 2025. This article is about exploring object detection in images using Azure Computer Vision service. Azure AI Vision offers robust object detection capabilities, enabling applications to identify and locate objects within images by providing bounding box coordinates and confidence scores.
• Passing an Object from a List to Another Page in MAUI MVVM .NET 9 [GamesCatalog] - Part 6Mar 10, 2025. This article covers object passing techniques using navigation, data binding, and command binding in the GamesCatalog app. Enhance your cross-platform development skills with structured MVVM patterns for seamless data transfer.
• Setting Up Microsoft Entra Service Principal for Azure RBAC and Connecting to Fabric SQL DatabaseMar 03, 2025. This article explains creating a Service Principal, assigning role-based access, and securely authenticating to the database, ensuring seamless integration and enhanced security in your Azure environment.
• Eliminating Unnecessary DELETE OperationsFeb 28, 2025. SQL Server performance issues often stem from easy fix bottle necks that can be fixed with the right tuning strategies. This short blog will focus on the DELETE statement.
• Automate Email Sending Using SSIS Script TaskFeb 28, 2025. This article is about Automate Email Sending Using SSIS Script Task
• Scope Communication Object in JSP Feb 28, 2025. The Scope Communication object consist of session object, application object and pageContext object.
• Azure SQL Database: Scalable & Secure Cloud SolutionFeb 26, 2025. Azure SQL Database is a fully managed cloud database service by Microsoft, offering high availability, scalability, security, AI-driven performance tuning, automated backups, threat protection, and seamless integration with Azure services.
• Boost SQL Server Performance with Memory-Optimized TablesFeb 25, 2025. Memory-optimized table variables in SQL Server provide a powerful way to enhance query performance by leveraging In-Memory OLTP. Unlike traditional table variables, they reduce disk I/O and improve execution speed.
• Getting Started with EF Core: Part 1Feb 24, 2025. Entity Framework Core (EF Core) is a powerful ORM for .NET applications, simplifying database interactions. In this comprehensive guide (Part 1), we’ll cover the basics, including setup, configuration, and the code-first approach.
• Entity Framework Core 9: Ultimate Performance Tuning & Best PracticeFeb 21, 2025. Entity Framework is a versatile and powerful ORM, but its performance depends on how it’s used. By following these best practices and leveraging the new features in .NET 9, you can build high-performance applications that scale efficiently.
• Invisible Architects of Scalable Apps Services & DependencyFeb 19, 2025. Ever wondered how Angular apps seem to effortlessly manage complex logic and dependencies? The secret often lies in the behind-the-scenes magic of services and dependency injection (DI). While they may sound like buzzwords, Angular features are the unsung heroes that power your app’s scalability and maintainability.
• Detailed Explanation of Use of Private Class vs Private MethodFeb 19, 2025. A private class and a private method serve different purposes in object-oriented programming. A private class is restricted to its containing class, ensuring encapsulation, while a private method is used within a class to perform internal operations.
• Power of Dapper in .Net Core Feb 16, 2025. Dapper is a high-performance micro ORM for .NET Core, known for its speed and efficiency in database access. It simplifies SQL execution, object mapping, and data retrieval while maintaining flexibility.
• Explaining Aggregate Functions in SQLFeb 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.
• Track Deployments Easily Using az.deployer().objectIdFeb 13, 2025. Bicep v0.32 introduces az.deployer().objectId, enabling retrieval of the principal ID executing deployments. This enhances governance, audit trails, and resource tagging, improving visibility, compliance, and automation in Azure infrastructure.
• Understanding Bridge Design PatternFeb 13, 2025. This article explains its benefits, use cases, and implementation in C# with a real-world message-sending example using SmsMessageSender and EmailMessageSender.
• A C# 13 Tip for building Data Transfer Objects (DTOs) Using RecordsFeb 12, 2025. C# records, introduced in C# 9 and improved in C# 13, offer immutable data models ideal for DTOs. They provide value semantics, concise syntax, automatic method generation, and enhanced data integrity for clean, maintainable code.
• Databricks Unity Catalog: Mastering Metastore and NamespaceFeb 10, 2025. Databricks Unity Catalog provides a unified governance layer with a three-level namespace (Catalog, Schema, Table) for efficient data organization, access control, and sharing across workspaces, improving security and collaboration.
• Getting Started with dbt (Data Build Tool) in Microsoft FabricFeb 10, 2025. In this article, we will learn how to get started with DBT (Data Build Tool) in Microsoft Fabric for efficient data transformation and modeling.