Related resources for BA
  • Understanding Distributed and Monolithic SQL Architectures11/5/2024 10:01:52 AM. In this article, we explore the key differences between distributed and monolithic SQL architectures. We delve into their respective advantages and disadvantages, focusing on scalability, performance,
  • Handling Transient Failures in .NET 8 With Polly11/5/2024 4:30:31 AM. This article discusses implementing a retry mechanism for handling transient faults in service interactions. It defines transient faults, such as temporary network issues or resource exhaustion, and e
  • Object Oriented Design Balancing with Anti-Single Responsibility11/5/2024 4:18:47 AM. This article will change your perspective on working with the Single Responsibility Principle (SRP). The main point is to focus on finding balance when designing object-oriented systems and applying S
  • Creating Azure SQL Database with Tables11/4/2024 4:59:13 AM. In this video, I demo how to create Azure SQL database, create and insert records into the table, and query the data.
  • Implement a RAG Solution Using Azure SQL Database11/1/2024 11:03:43 PM. In this brief video I walk you through the components of retrieval augmented generation (RAG). I talk about embeddings and vectors and even show you how they are created. Finally, I'll show you
  • Difference Between Delegated and App Only Access10/29/2024 9:39:47 AM. Delegated access allows an application to act on behalf of a signed-in user, requiring user authentication and permission via OAuth 2.0, while app-only access enables an app to operate independently w
  • JWT Token Based Implementation using ASP.NET Core Web API10/29/2024 6:30:51 AM. JWT (JSON Web Token) is a way to share information securely between two or more systems and JWT structure allows for secure information exchange and user authentication.
  • Create a Model with Database Table in .NET 8 using EF Core10/28/2024 7:16:12 AM. This article guides you through creating a data-driven application using .NET 8 and Entity Framework Core. You'll learn to define a model, configure a DbContext, set up a SQL Server connection str
  • Efficient Data Handling in SQL Server with Table-Valued Parameters10/27/2024 5:52:26 AM. This article delves into how TVPs enhance performance by enabling the transfer of multiple rows of data in a single parameter, streamlining stored procedures, and optimizing database operations.
  • Manage Azure SQL Roles with Azure Data Studio10/26/2024 5:43:14 AM. Azure SQL Database is a managed cloud database service enabling secure, scalable applications. With Azure Data Studio, a free, cross-platform tool, database admins can view and manage user roles and p
  • TRIM Function New T-SQL Enhancements in SQL Server10/25/2024 10:44:09 AM. The enhanced TRIM function in SQL Server 2022 adds flexibility for removing unwanted characters in strings, beyond just spaces. Now, developers can use BOTH, LEADING, and TRAILING keywords to trim fro
  • Web api call in Android10/25/2024 4:55:38 AM. This article explains how to call a Web API in an Android app using Java. It covers key concepts like HTTP methods (GET, POST), status codes, headers, and the use of the OkHttp library for making API
  • A 4-Year Retrospective : Lessons Learned from Building a Video Player from Scratch with React Native10/24/2024 5:05:25 AM. React Native, React, ReactJS
  • Redis: RedisString and RedisJSON10/23/2024 8:19:31 AM. RedisString has long been the basic and most common data type in Redis. Recently, RedisJSON has gained popularity as a module that allows you to store, query, and manipulate JSON data natively.
  • Searching Items in Sitecore without Solr Indexes10/22/2024 7:24:39 AM. In Sitecore, we often need to perform searches for items without using Solr. This article explores a recursive search approach using the ManualSearch class to retrieve specific items or lists from the
  • Vertical Slice Architecture with Code Examples in C# 1210/22/2024 5:02:12 AM. Get an overview of vertical slice architecture in C# 12 with Ziggy Rafiq. Build maintainable, scalable applications using feature-based organization with code examples, MediatR, and record types.
  • Using Span<T> To Improve Performance Of C# Code10/21/2024 10:13:00 AM. To enhance application performance, reducing IO calls and utilizing stack allocation is crucial. Leveraging value types and the Span&lt;T&gt; structure in C# allows efficient memory management and imp
  • Activate Server-Side Encryption for Azure Disks with Customer Keys10/21/2024 6:21:07 AM. Azure Disk Storage offers server-side encryption (SSE) with customer-managed keys, allowing users to control encryption for managed disks. By utilizing Azure Key Vault, users can manage access and enh
  • Getting Started with Databrick Dataset10/19/2024 3:05:37 PM. This article dives into how to use databricks preloaded datasets. Databricks Datasets provide ready-to-use, real-world data built into the Databricks platform, enabling users to easily access, analyze
  • Use Cases of Alchemy in Web310/19/2024 2:02:21 PM. Alchemy is a powerful platform for developing decentralized applications on blockchain technology. It supports various sectors, including DeFi, NFT marketplaces, and DAOs, by providing essential tools
  • The Basic SKU Public IPs will be Retired in Azure10/16/2024 11:48:25 AM. Microsoft Azure is set to retire the Basic SKU public IPs, impacting users who rely on this pricing tier for their cloud networking needs. This change highlights the platform&#39;s evolution toward mo
  • STRING_SPLIT() Ordinal New T-SQL Enhancements in SQL Server10/16/2024 9:01:22 AM. The STRING_SPLIT() function in SQL Server, introduced in 2016, allows for splitting delimited strings into rows. The 2022 enhancement introduces an optional ordinal parameter, enabling retrieval of ea
  • Databricks: Provision and Analyze Azure SQL Database Table10/16/2024 7:38:47 AM. In this video, I covered how to read and analyse Azure SQL Database Table in Databricks Notebook.
  • Is PostgreSQL the Future of Databases?10/16/2024 5:00:45 AM. This article explores whether PostgreSQL is the future of databases, highlighting its advantages in scalability, performance, and innovation. Discover how it compares to other database systems in toda
  • Least and Greatest New T-SQL Enhancements in SQL Server10/15/2024 11:42:36 AM. Discover the least and greatest T-SQL enhancements in SQL Server 2022! This article explores the new features and improvements that elevate data manipulation and performance.
  • Write Data from Fabric Dataflow Gen2 to Azure SQL Database10/15/2024 5:16:17 AM. In this new video, I am going to walk you through how to write data from Fabric Dataflow Gen2 to Azure SQL Database.
  • Database Dictionary (1) --- Schema10/14/2024 2:07:16 PM. This article will discuss the database schema.
  • Exclude Exchange Databases from Auto-Provisioning in New DAG - Exchange 201910/10/2024 3:49:52 AM. In a multi-DAG Exchange environment, there are often scenarios where we want to ensure that primary mailboxes remain on a specific DAG, while a new DAG is reserved solely for archive mailboxes. This c
  • Change Background Color Dynamically Using AngularJS10/8/2024 9:24:54 AM. In this tutorial, learn how to dynamically change the background color of a web application using AngularJS. We’ll explore Angular directives and event handling to allow users to select colors interac
  • Customize Scrollbars Using CSS310/8/2024 9:02:58 AM. This guide covers essential CSS properties, such as scrollbar width, scrollbar-color, and ::-webkit-scrollbar for cross-browser compatibility, enabling you to create sleek, modern scrollbars.
  • Backup And Restore Your Database Using SQL Server Management Studio (Step by Step)10/8/2024 8:54:22 AM. In this article you will learn how to upload your App to Windows Store (Step by Step), backup and restore your database using SQL Server Management Studio (Step by Step).
  • Passing Connection String Dynamically While Using a Model First Approach10/8/2024 3:57:28 AM. We&#39;ll discuss the importance of dynamic configuration for database connections, demonstrate effective techniques for setting up runtime connection strings, and highlight best practices for managin
  • What is Alibaba Cloud Object Storage Service (OSS)10/8/2024 3:55:37 AM. Discover Alibaba Cloud OSS, scalable and secure cloud storage for unstructured data, offering high durability, cost-effectiveness, and global accessibility.
  • Simple Load Balancer in .NET Core with YARP10/8/2024 3:40:14 AM. Load balancing ensures efficient traffic distribution in distributed systems. YARP enables load balancing with sticky sessions for consistent routing, improving scalability, performance, and availabil
  • Programming in Practice - Delegates and Events 10/7/2024 8:38:26 AM. Events and delegates control flow, exchange data, and notify a condition change backed by code samples.
  • Read Multiple PARQUET Files from GCS to Azure SQL Database using Azure Data Factory10/7/2024 4:56:25 AM. In this Data Engineering episode, I covered how to read multiple sales parquet files resident in Google Cloud Storage to Azure SQL Database leveraging Azure Data Factory.
  • Basic Linux Commands10/6/2024 5:36:24 PM. Learn about basic Linux commands including listing files and managing directories as part of fundamental of DevOps.
  • Real-World Expression Trees: Dynamic Filtering in C# with Minimal API10/6/2024 7:51:48 AM. This article explores the practical use of expression trees in C# by building an ASP.NET Core web API with dynamic filtering functionality. It demonstrates how to construct flexible queries using expr
  • IS [NOT] DISTINCT FROM New T-SQL Enhancements in SQL Server10/4/2024 6:15:00 AM. The &quot;IS [NOT] DISTINCT FROM&quot; operator is one of the key new T-SQL enhancements in SQL Server 2023. It simplifies SQL queries by handling NULL comparisons more efficiently, improving data int
  • A Fix To PolyBase Issue In SQL Server 2019 Developer Edition10/3/2024 1:16:46 PM. This article will introduce the problem, the reason and the fix related to a PolyBase issue when installing the SQL Server Developer Edition 2019.
  • Generate or find Connection String from Visual Studio10/3/2024 11:44:59 AM. This guide covers various methods, including using the Connection String Builder, accessing app.config and web.config files, and integrating with SQL Server and Entity Framework. Mastering connection
  • Creating Stored Procedures with Managed Code10/3/2024 11:41:01 AM. This article demonstrates how to create a stored procedure in Microsoft SQL Server 2005 using managed code in C#. It details the process of setting up a SQL Server project in Visual Studio, writing th
  • Routers in Backbone.JS: Part 710/3/2024 11:31:21 AM. Backbone.Router enables URL routing and history management for web applications. It allows creating bookmarkable, shareable URLs and mapping them to application actions. This article covers the basics
  • How to Use a Cursor in SQL?10/3/2024 11:08:13 AM. A cursor in SQL is a database object that allows row-by-row processing of query results. It enables you to iterate through a result set, perform operations on each row, and manage data more efficientl
  • Integrate Azure AD OAuth2 SSO Authentication RBAC for AKHQ Kafka-UI10/3/2024 10:58:48 AM. This content explores the integration of Azure Active Directory (Azure AD), OAuth2, and Single Sign-On (SSO) for authentication, along with Role-Based Access Control (RBAC) for authorization, specific
  • Database, Data Warehouse, and Data Lake: A Comparative Analysis10/2/2024 4:49:26 AM. Databases handle structured, real-time transactional data. Data warehouses focus on structured, historical data for analytics. Data lakes store raw, unstructured data, which is ideal for advanced anal
  • Types of Keys in SQL10/1/2024 6:09:16 AM. In SQL, keys play a crucial role in maintaining data integrity and defining relationships between tables. Common types include the Primary Key, which uniquely identifies records; the Foreign Key, link
  • Web Based Game Using JavaScript10/1/2024 4:50:21 AM. In this article, you&#39;ll learn how to create a simple web-based game, &quot;Catch My Santa,&quot; using HTML, CSS, JavaScript, and jQuery. The game features a 3x3 grid where players must tap on box
  • Understanding the Working of Garbage Collector in .NET 99/30/2024 10:27:30 AM. The .NET 9 Garbage Collector enhances memory management through dynamic tuning, improved generation collections, and a refined compaction algorithm, ensuring efficient, automated memory handling while
  • How to Decide Between Relational Database and NoSQL Databases?9/30/2024 7:12:38 AM. Choosing between relational databases and NoSQL databases involves understanding their key differences, strengths, and weaknesses. Relational databases excel in structured data and ACID compliance, ma
  • Background Job Management with Hangfire in .NET Core 89/30/2024 6:37:52 AM. Discover how to effectively manage background jobs in .NET Core 8 using Hangfire. This guide covers job scheduling, asynchronous processing, and monitoring, ensuring your applications run efficiently.
  • How To Enable The Modern Command Bar Experience In The Canvas Apps9/30/2024 5:16:53 AM. This article guides you on enabling the modern command bar in PowerApps Canvas Apps. It details the steps to activate this preview feature, starting from creating or opening a Canvas App, navigating t
  • Managing Amazon S3 Buckets9/29/2024 5:04:09 AM. This guide walks through managing AWS S3 Buckets, covering file and folder uploads, enabling bucket versioning for version control, and restoring files in case of accidental deletion.
  • How to Send Mail Using SQL Server: Part 39/27/2024 10:16:21 AM. In this third installment of our series, &quot;How to Send Mail Using SQL Server,&quot; we delve into the configuration and implementation of Database Mail. Learn how to set up SMTP settings, create m
  • Selection Based Crystal Report using Stored Procedure9/27/2024 10:11:28 AM. This project demonstrates creating a Crystal Report in a Windows Form application. It includes setting up a SQL database connection, populating a ComboBox with data, generating reports using parameter
  • Inserting Form Data Into DataBase Using Stored Procedure In ASP.NET C#9/27/2024 10:10:24 AM. Learn how to insert form data into a database using stored procedures in ASP.NET with C#. This guide covers setting up a form, handling user input, creating a stored procedure, and securely inserting
  • Getting Started with Azure SQL Database – A Beginners Guide9/27/2024 7:19:23 AM. A quick introduction to Azure SQL Database that showcases some key offerings and highlights the flexibility and scalability that comes with it.
  • Definitive Guide to Mirror Azure SQL Database in Fabric Warehouse9/26/2024 9:45:47 AM. In this Definitive Guide to Mirror Azure SQL Database in Fabric Warehouse episode, I am going to walk you through how to -- Enabling System Assigned Managed Identity required to publish data to Fabr
  • Understanding Callbacks with Func and Action Delegates9/26/2024 4:11:38 AM. This article explains how to use Func and Action delegates in C# to implement callbacks, providing flexible and reusable code. It includes practical examples for both returning and non-returning metho
  • Create Dynamic Pivot Table Using Store Procedure9/25/2024 6:58:27 AM. Learn how to create a dynamic pivot table using a stored procedure in SQL. This guide covers transforming rows into columns dynamically, automating pivot table creation, and efficiently querying large
  • Searching And Search Bar In Xamarin.Forms9/24/2024 11:57:01 AM. This guide explores implementing a search bar in Xamarin.Forms, focusing on enhancing user experience through effective searching techniques. It covers key concepts such as UI design, data filtering,
  • Schedule Background Jobs Using Hangfire In ASP.NET Core9/24/2024 9:04:17 AM. Hangfire is an open-source library for ASP.NET Core that simplifies scheduling and monitoring background tasks like data processing and email reminders. By using Hangfire, you can create fire-and-forg
  • Understanding Database Sharding in Programming9/24/2024 5:41:14 AM. Learn how sharding improves scalability and performance in distributed databases, key strategies for partitioning data, best practices for shard key selection, and techniques to optimize data manageme
  • How Does Your "Code Smell"9/24/2024 4:16:49 AM. &quot;Code smell&quot; refers to indicators in code that suggest potential problems. Common examples include poor exception handling, magic numbers, and inefficient string operations. Other issues inv
  • SharePoint Based Triggers In MS Flow - Part Two9/23/2024 11:26:54 AM. This article explores SharePoint triggers in MS Flow, detailing five key trigger points: file deletion, item creation, item modification, item deletion, and file creation/modification in a folder. It
  • SharePoint Based Triggers in MS Flow - Part One9/23/2024 11:13:16 AM. Learn how to set up automated processes using SharePoint lists and events, enabling efficient task management and real-time notifications. This is Part One of a comprehensive series.
  • Claim Based And Policy-Based Authorization With ASP.NET Core 2.19/23/2024 9:48:11 AM. Authorization is the process of determining if a user can access system resources. Claim-based authorization checks specific user claims (e.g., &quot;DateOfJoining&quot; or &quot;IsAdmin&quot;) for ac
  • Role Base Authorization In ASP.NET Core 2.19/23/2024 9:34:36 AM. In this article, we explore Role-Based Authorization in ASP.NET Core 2.1, explaining how to secure applications by assigning user roles and managing access control.
  • Learn about Garbage Collector in .NET9/23/2024 9:23:17 AM. This article discusses the .NET Garbage Collector and its role in memory management, distinguishing between managed and unmanaged resources. It highlights the limitations of using Objects. Finalize fo
  • Check Disk Space Utilization by Tables in SQL Server Database9/23/2024 8:53:17 AM. In this guide, learn how to effectively check disk space utilization by tables in a SQL Server database. We’ll cover essential SQL queries and techniques to analyze table sizes, identify storage usage
  • Learn Sliding Window Technique9/23/2024 8:26:33 AM. The Sliding Window Technique is an efficient method for solving problems involving subarrays or substrings. It uses a &quot;window&quot; that slides across the data structure, allowing for dynamic adj
  • Integrate Azure AD OAuth2 SSO Authentication and RBAC for Kafka-UI9/23/2024 7:29:57 AM. This article explores the integration of Azure Active Directory (AD), OAuth2, and Single Sign-On (SSO) for secure authentication and Role-Based Access Control (RBAC) for authorization within the Prove
  • Advanced ADF: Integrate Multiple Category of Files Leveraging FILTER and other Activities9/23/2024 6:37:08 AM. In this episode, I am going to walk you through how to integrate multiple category of files in ADLS Gen2 to Azure SQL Database via Azure Data Factory data pipeline activities focusing on filter and o
  • C#.NET - Access OAuth REST Web API Method9/23/2024 5:23:38 AM. C#.NET applications can access OAuth-protected REST APIs. You&#39;ll obtain an access token through OAuth flow (often via a separate request) and include it in the authorization header of your HttpCli
  • What is the Notify Function in Power Apps?9/23/2024 5:09:43 AM. The Notify function in Power Apps displays messages to users, providing instant feedback on their actions. It supports various notification types, such as success, error, warning, and information, hel
  • Looking deep inside PostBack and ViewState in ASP.NET 3.59/20/2024 9:28:54 AM. In ASP.NET 3.5, PostBack and ViewState play crucial roles in managing web form data between client and server during the page lifecycle. PostBack handles user-triggered events by sending requests to t
  • Database Backup With Compression in SQL Server9/20/2024 9:18:22 AM. This article explains how to perform database backup compression in SQL Server 2012 using SQL Server Management Studio or a Transact-SQL statement. It provides a step-by-step guide to visually create
  • Session State Behavior Per Action in ASP.NET MVC9/20/2024 8:07:03 AM. This guide explains how to control session state behavior in ASP.NET MVC using the SessionState attribute and a custom ActionSessionStateAttribute. While the SessionState attribute applies to an entir
  • Download Multiple Excel Files via Web API .NET and Angular9/20/2024 6:02:37 AM. To export multiple Excel files, various approaches can be used, including downloading a zip file, creating multiple worksheets in a single Excel file, or calling APIs multiple times to retrieve files.
  • Exploring the Performance Boosts in .NET 99/20/2024 4:22:58 AM. .NET 9 introduces key performance improvements, including Native AOT for faster startup times and reduced memory usage, optimized garbage collection, enhanced threading for multicore systems, and HTTP
  • Cleaning the Resources: Finalize vs Dispose9/19/2024 10:13:39 AM. This article explores the concepts of Destructor and Dispose in C#. It illustrates the object&#39;s lifecycle, highlighting how constructors allocate memory and destructors clean up. The role of the G
  • Client-Side Chart Widget in HTML 5: Part 2 (Pie Chart)9/19/2024 10:05:08 AM. Learn how to create a client-side Pie Chart using HTML5 and Chart.js. This guide covers loading data, defining chart properties like values, colors, and labels, and using JavaScript to render the char
  • Why We Should Prefer To Use Dispose Method Than Finalize Method9/19/2024 6:09:09 AM. This article explores the benefits of Dispose for efficient resource cleanup, improved performance, and reliable memory management in C#. Discover best practices for handling managed and unmanaged res
  • How to Keep SQL Server Table Columns in Sync9/19/2024 4:29:35 AM. how to keep columns in sync across SQL Server tables using efficient methods like triggers, SQL scripts, and the MERGE statement.
  • In-Memory Databases- Unit Testing With C#, EFCore and XUnit9/18/2024 12:13:03 PM. Learn to unit test EF Core repositories using an in-memory database with C# and xUnit. This approach simulates database operations without overhead, ensuring fast and isolated tests. Set up involves i
  • Create Backup and Restore Database in SQL Server9/18/2024 9:01:35 AM. This tutorial covers essential techniques for backing up your databases, restoring them when needed, and ensuring data safety. Master these skills to safeguard your SQL Server environment effectively.
  • Background Task in Universal Windows Program - Part One9/18/2024 8:53:52 AM. This article explains implementing background tasks in mobile programming for notifications and data processing. It covers creating a background task component using UWP and Windows Runtime, registeri
  • AngularJS Interview Questions And Answers - Part One9/17/2024 10:36:14 AM. In this guide, &quot;AngularJS Interview Questions And Answers - Part One,&quot; you&#39;ll find a comprehensive list of essential questions and detailed answers to help you prepare for AngularJS inte
  • Singleton Pattern: Ensuring a Single Instance in .NET Core9/17/2024 7:19:37 AM. In this article, we learn about Singleton Pattern: Ensuring a Single Instance in .NET Core. The Singleton Pattern ensures a class has only one instance, providing global access. It&#39;s commonly used
  • Why Does the Big Ball of Mud Keep Happening and How to Stop it 9/17/2024 7:06:38 AM. In this video, you will learn Avoiding the Big Ball of Mud
  • Abstract Factory Pattern: Designing Families of Related Objects in C#9/17/2024 5:10:34 AM. The Abstract Factory Pattern provides an interface for creating families of related objects without specifying their concrete classes. It ensures consistency and flexibility in object creation, useful
  • Derived Class Constructors in Java9/17/2024 4:38:08 AM. Constructors are used to initialize an object of a particular type, as well as to allocate memory, and have the same name as the class.
  • Categorizing Design Patterns: Creational, Structural & Behavioral9/16/2024 8:17:37 AM. In this article we will learn about Categorizing Design Patterns: Creational, Structural, and Behavioral. It provides real-life examples, benefits, and challenges, offering developers insights for be
  • The Importance of Design Patterns in .NET Core Development9/16/2024 6:11:56 AM. This article discusses the importance of design patterns in .NET Core development, highlighting how they enhance scalability, maintainability, and flexibility. Key patterns include Singleton, Reposito
  • What Are Design Patterns? Understanding the Basics9/16/2024 5:51:51 AM. Design patterns are essential in software development, offering reusable solutions to common problems. By applying patterns like Singleton, Factory Method, and Observer, developers create flexible, ma
  • Data Virtualization from Azure Blob Storage in Azure SQL Database9/16/2024 5:17:34 AM. This solution enables Azure SQL Database to directly access and read files from Azure Blob Storage using External REST Endpoints, bypassing the need for physical data loading. It leverages database-sc
  • Builder Pattern: Constructing Complex Objects9/14/2024 1:58:12 PM. In this article, we learn about Builder Pattern: Constructing Complex Objects. The Builder Pattern simplifies the creation of complex objects through step-by-step construction. It enables flexibility,
  • Introduction to Office Script9/13/2024 5:26:23 AM. Office Scripts is a feature in Microsoft Excel that allows you to automate repetitive tasks using JavaScript. This can significantly streamline your workflow by enabling you to create custom scripts t
  • CRUD Operations Using Knockout in MVC Application- Part 19/12/2024 12:14:23 PM. This article covers implementing CRUD operations in MVC applications using Knockout.js. It details how to set up models, repositories, and controllers, demonstrating how to manage items through add, u
  • Authenticate your Azure OpenAI Based App - Key or Key-less9/12/2024 10:39:21 AM. Key-based authentication for Azure OpenAI is simple but unsuitable for production due to security risks like key exposure and lack of granular control. Using Managed Identities offers enhanced securit