Resources   No resource found

• Solving the Imbalanced Data Problem in RAGJul 24, 2026. Solve RAG imbalanced data with pure Python weighted sampling. Ensure critical edge cases are represented, boosting LLM performance without external dependencies.
• PostgreSQL Row-Level Security Explained with Practical ExamplesJul 08, 2026. PostgreSQL Row-Level Security (RLS) explained with practical examples. Secure multi-tenant apps by enforcing data access directly in the database.
• Delete Rows from an Excel Template Using Office Scripts and Power AutomateJul 02, 2026. Streamline Excel data management in Power Automate. Learn to use Office Scripts to efficiently delete rows, clear filters, and prepare templates for fresh data.
• USERPRINCIPALNAME DAX FunctionJul 02, 2026. Unlock Power BI dynamic security with USERPRINCIPALNAME(). Securely filter data by user email for personalized, scalable reports in the Power BI Service.
• Managing Roles in Power BI Desktop: A Guide to Row-Level Security (RLS)Jul 03, 2026. Master Power BI RLS to secure sensitive data. Learn to create, manage, test, and deploy roles for granular data access control.
• Implementing Row-Level Security in SQL ServerJun 03, 2026. Learn how to implement Row-Level Security in SQL Server. Secure data access, restrict rows by user, and simplify multi-tenant application security.
• How to Handle Concurrency in SQL Server with Locking Mechanisms?Apr 13, 2026. Master SQL Server concurrency! Learn locking, row versioning, isolation levels, and performance tuning to prevent deadlocks and ensure data integrity. Optimize your database!
• How to Fix Delegation Warnings and Handle 10,000+ Records in Power Apps with SharePointFeb 26, 2026. Delegation issues can break your Power Apps solution when working with large SharePoint lists. This article explains why delegation warnings occur and provides a practical, step-by-step solution to build scalable, high-performance apps without data loss.
• Common Power BI Access Control MistakesJan 29, 2026. Avoid Power BI security risks! Learn common access control mistakes like overusing workspace permissions and neglecting reviews. Secure your data & boost trust.
• Power BI Security Mistakes Enterprises Commonly MakeJan 23, 2026. Avoid Power BI security pitfalls! Learn from real-world examples of common enterprise mistakes like overusing admin roles and poorly designed RLS. Secure your data!
• Why Power BI Reports Feel Fast for Some Users and Slow for OthersJan 22, 2026. Unravel why Power BI reports feel fast for some and slow for others. Explore factors like RLS, location, data volume, and user behavior for optimal performance.
• How Row-Level Security Slows Down Power BI ReportsJan 21, 2026. Discover why Row-Level Security (RLS) slows down Power BI reports and how to optimize it. Learn to balance security with performance for responsive dashboards.
• How Do I Return the ID of a Newly-Inserted Row in Access SQL?Jan 14, 2026. Learn how to retrieve the auto-generated ID of a newly inserted row in Access SQL! Explore methods like @@IDENTITY, DAO, and ADO with practical examples and VBA code.
• Understanding LLM Generation (Decoder) Parameters (Sample/Inference Parameter): Control, Creativity, and OutputJan 08, 2026. Master LLM text generation! Control creativity, length, & repetition with temperature, top-k, top-p, penalties, & more. Fine-tune outputs for any task.
• PeerDAS on Ethereum: What it is and how it scales data availabilityJan 06, 2026. Learn what PeerDAS is on Ethereum and how it uses data availability sampling, erasure coding, and peer-to-peer custody to scale rollups without raising node requirements.
• Understanding Filter rows and Expand Query in Dataverse (Power Automate)Dec 29, 2025. Unlock Dataverse power in Power Automate! Learn to efficiently filter and retrieve related data using Expand Query and Lookup Columns. Optimize flows and boost performance.
• How LLMs Generate ResponsesDec 15, 2025. Learn how large language models generate responses step by step. Understand tokenization, embeddings, attention, and next-token prediction to see why LLMs sound confident, how they work internally, and why hallucinations occur.
• Reducing Deadlocks with Row-Versioning Isolation Levels | SQL ServerNov 27, 2025. Eliminate SQL Server deadlocks using row-versioning! This guide covers RCSI & SNAPSHOT isolation, enabling, testing, and real-world examples for smoother OLTP.
• Dynamic Row & Column Permission System (Field-Level Security Using a Rule Engine)Nov 19, 2025. Implement dynamic row and column-level security for enterprise apps. Centralize permissions, enforce rules at the API, and mask sensitive data. Enhance security and compliance.
• Dynamic Row & Column Permission System | Field-Level Security and Rule Engine for Angular + .NET ApplicationsNov 19, 2025. Implement dynamic row & column permissions in Angular & .NET apps. Secure sensitive data with field-level security, a rule engine, and metadata-driven access control.
• Implementing Row-Level Security (RLS) for Multi-Tenant Data (SQL Server + ASP.NET Core)Nov 17, 2025. Secure multi-tenant apps with SQL Server Row-Level Security (RLS). Implement robust tenant isolation using EF Core, session context, and security policies.
• SaccoShare Management System — Sample Project (ASP.NET Core 8)Nov 05, 2025. ASP.NET Core 8 Sacco Management System: A complete scaffold with MVC, EF Core, Identity, Docker & more. Kickstart your SaccoShare web app development!
• Build AI Agents with LangChainJS and Azure Model Catalog (MCP Agent Example)Oct 26, 2025. Learn how to create intelligent AI agents using LangChainJS and Azure’s Model Catalog with the MCP Agent sample. This detailed guide covers setup, architecture, and code examples for production-ready integrations.
• Prompt Engineering: Decoding Discipline - Sampling Policies and Sectioned Generation — Part 2Oct 16, 2025. Unlock predictably great AI outputs! This article dives into prompt engineering's decoding discipline, focusing on sampling policies and sectioned generation. Learn how to stabilize latency, lower costs, and boost first-pass success by mastering top-p, temperature, stop sequences, and strategic sectioning. Optimize your AI workflows without retraining models! Discover practical defaults and concrete presets for various content types.
• 🧩 Convert SQL Server DataTable Rows into Pivot Table (With Example)Oct 16, 2025. Learn how to convert SQL Server DataTable rows into a pivot table for enhanced data analysis and reporting. This guide provides a step-by-step example using the PIVOT operator, including dynamic SQL for automatically generating columns. Discover when to use pivot tables and explore alternative techniques like UNPIVOT and GROUP BY. Ideal for BI dashboards and Excel exports, this tutorial simplifies data visualization in SQL Server.
• Filtering Rows in a DataTable using DataView in C#Oct 13, 2025. Learn how to efficiently filter rows in a C# DataTable using DataView. This method allows dynamic data filtering without altering the original DataTable. Discover how to create DataViews, apply RowFilter with various conditions (text, numeric, date), and convert the filtered view back to a DataTable. Explore practical examples, best practices for avoiding errors, and a comparison with LINQ for data manipulation. Ideal for UI binding and data processing.
• How to Construct a Toeplitz Matrix from a Given Row and Column in PythonOct 07, 2025. This article provides a comprehensive guide on constructing Toeplitz matrices from a given row and column, highlighting their significance in signal processing, particularly in wireless communication systems like 5G. Learn how to leverage SciPy for efficient implementation, explore real-world applications, and optimize performance for faster computations. Discover how this matrix structure bridges abstract algebra and practical engineering for high-speed, low-latency connections.
• How to Find the Variance of Array Elements in PythonOct 03, 2025. Learn how to calculate variance in Python using the statistics module for financial risk assessment. This guide explains sample variance, its importance in banking for fraud detection and credit scoring, and provides a production-ready implementation with best practices. Discover how to analyze spending patterns and identify volatile behavior using variance, ensuring robust and reliable risk management.
• IndiaAI Pre-Summit Events 2025: How to Apply and Draft a Winning ProposalSep 14, 2025. Unlock opportunities at the IndiaAI Pre-Summit Events 2025! This guide provides essential information on how to apply, draft a winning proposal, and contribute to shaping India's AI strategy. Learn about eligibility, proposal requirements, evaluation criteria, and get a sample proposal to boost your chances of success in workshops, hackathons, and more.
• To Delete a Row from Table in SQL ServerAug 06, 2025. Learn how to delete a row from a table in SQL Server using the DELETE statement. This guide explains the syntax, provides examples of deleting rows by specific conditions, and highlights the difference between DELETE and TRUNCATE. Whether you are removing a single record or multiple rows, this article covers the essential steps and best practices for safe data deletion.
• ETL Design Pattern to Implement SCD Type 2 Using SQL, SSIS, or dbtJul 30, 2025. SCD Type 2 is widely used in data warehousing to preserve full history of dimensional changes. Implementing it correctly through your ETL process is crucial for accurate historical reporting.
• Publishing and Sharing Power BI Reports SecurelyJul 26, 2025. Learn how to securely publish and share Power BI reports by uploading them to the Power BI Service, setting access permissions, applying row-level security, and scheduling data refreshes—ensuring the right people see the right data at the right time.
• Hide Column Headers and Show Row Headers in C#Jul 08, 2025. Learn how to display DataGridView data horizontally in a WinForms application. This article shows you how to set up row headers, add columns, and rotate data display programmatically.
• From Packages to Projects: Leveraging the Power of the SSIS CatalogJun 27, 2025. This article is about Leveraging the Power of the SSIS Catalog from Packages to Project.
• 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.
• 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#.
• .NET Middleware with Practical Applications and Full Code SamplesMar 17, 2025. Middleware is an essential component of the ASP.NET request pipeline. It allows developers to run code during both the request and response lifecycle. This article, explains what middleware is, how it works, and provide real-world practical use cases with complete code examples.
• Automate Email Sending Using SSIS Script TaskFeb 28, 2025. This article is about Automate Email Sending Using SSIS Script Task
• Dockerize JavaScript Sample FileFeb 11, 2025. One of the simplest and most basic exercises in containerizing and getting familiar with Docker files is working with a simple JavaScript file. In this example, we will containerize a simple JavaScript file that doesn’t perform any specific function, or to put it more simply.
• Explain SSIS Designer for NewbiesFeb 07, 2025. Learn how to create and manage SSIS packages using SSIS Designer in SQL Server Data Tools (SSDT). Explore key components like Control Flow, Data Flow, Parameters, Event Handlers, Package Explorer, and Connection Managers.
• ETL Pipeline using Microsoft SQL Server Integration ServicesJan 31, 2025. This article is about building ETL (Extraction, Transformation and Loading) pipeline using SQL Server Integration Services (SSIS).
• Swap First and Last Rows in a Matrix Using Java with CodeJan 28, 2025. Learn how to interchange the first and last rows of a matrix in Java using simple loops or efficient methods like `System.arraycopy()`, complete with examples, explanations, and practical tips.
• How to Format List Views in SharePointDec 31, 2024. SharePoint list formatting enhances data presentation by customizing appearance, adding alternating row styles, and applying conditional formatting. It improves readability, highlights key data, and boosts user experience for efficient collaboration.
• Using Derived Column Task in SQL Server Integration ServicesDec 30, 2024. The Derived Column Task in SQL Server Integration Services (SSIS) allows you to transform or modify data within your ETL process. It enables the creation of new columns or updates to existing ones using SSIS expressions.
• Conditional Split in SQL Services Integration Services (SSIS)Dec 23, 2024. Conditional Split in SQL Server Integration Services (SSIS) allows you to route data based on specific conditions within a data flow. It is used to direct data into different paths, enabling dynamic data transformation and filtering.
• Create FTP Task in SQL Server Integration Services Dec 19, 2024. Learn how to create and configure an FTP Task in SQL Server Integration Services (SSIS). This task simplifies automated file transfers using the FTP protocol, making it essential for ETL processes.
• Automating Table Creation using SSISDec 10, 2024. In this article, we will see how to create a database table in SQL Server using the SSIS package. Learn how to create a database table in SQL Server using an SSIS package. Follow step-by-step instructions for automation.
• Rank Functions in SQL serverNov 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.
• How To Delete Duplicate Rows From A Table In SQL ServerOct 12, 2024. This guide explains how to delete duplicate rows from a table in SQL Server. Using common techniques like ROW_NUMBER() with PARTITION BY, you can identify and remove duplicate rows while keeping the original.
• Get First Row from Dataverse Table in Power AutomateSep 22, 2024. Learn how to retrieve the first row from a Dataverse table using Power Automate. This guide walks you through creating a flow, filtering contacts with emails, and using expressions to extract the first row's contact ID, full name, and email.
• SSRS (3) --- Report Build and Deploy as a VS ProjectAug 08, 2024. This article will make a sample of Report from Visual Studio Environment by using both the pre-setup SSIS, SSAS, Server and the SQL Server DAta Tools
• SSRS (1) --- Server Setup: SSIS, SSAS, and SSRSAug 04, 2024. This article is to discuss SSRS (1) --- Server Setup, SSIS, SSAS, and SSRS
• Populate Dropdown with All People from List for Easy SelectionJul 26, 2024. This is a complex situation where group of people are listed in drop down and depending upon drop down values all the people from list where drop down selected value.
• @@ROWCOUNT in SQL ServerJul 25, 2024. @@ROWCOUNT is a SQL Server function used to retrieve the number of rows affected by the last executed statement. It provides valuable insights for data manipulation and validation processes, helping to track changes and optimize performance in SQL queries and stored procedures.
• Difference Between DELETE and TRUNCATE in SQL ServerJul 23, 2024. In SQL Server, DELETE and TRUNCATE are used to remove data from tables, each with distinct characteristics. DELETE is a DML command that logs each row deletion, supports triggers, and respects foreign key constraints, making it slower but more flexible.
• Ranking Functions in SQL: RANK, DENSE_RANK, and ROW_NUMBERJul 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.
• Query to find Table Name, Row Count, Column Count and Data SizeJul 02, 2024. This guide covers techniques to query and display table names, row counts, column counts, and data sizes efficiently. Ideal for database administrators and developers seeking to optimize data management and performance analysis.
• Understanding RANK vs DENSE_RANK in SQLJun 14, 2024. Explore the nuances between RANK and DENSE_RANK in SQL with this comprehensive guide. Learn how these window functions order query results differently, impacting ranking assignment and handling of ties.
• How Does Avalanche Consensus Works?Jun 05, 2024. Discover how Avalanche Consensus revolutionizes blockchain with its speed, scalability, and energy efficiency, ensuring rapid and secure transaction processing.
• MongoDB Random VS Sample VS Sample Rate OperatorsJun 03, 2024. Explore MongoDB's random, sample, and sample rate operators for efficient data retrieval. Learn how to leverage these operators to retrieve subsets of data from your MongoDB databases, optimizing query performance and improving overall data analysis processes.
• Azure Bicep: Wrapping Up and Looking AheadMay 10, 2024. As we conclude with Azure Bicep, reflect on its benefits, lessons learned, and future enhancements. Prepare for continued adoption, explore learning resources, and anticipate its evolving role in Azure infrastructure management.
• Azure Bicep: Modules for Flexible Resource ManagementMay 10, 2024. This article is a comprehensive guide that takes you on a deep dive into Azure Bicep modules. It starts with logging into Azure, then moves on to explain the concept of modules in Azure Bicep, complete with code samples and explanations.
• Exploring Azure Bicep Outputs: Retrieving Resource PropertiesMay 09, 2024. This article is a comprehensive guide that takes you on a deep dive into Azure Bicep outputs. It starts with logging into Azure, then moves on to explain the concept of outputs in Azure Bicep, complete with code samples and explanations.
• Unraveling Azure Bicep ResourcesMay 07, 2024. This article is a comprehensive guide that takes you on a deep dive into Azure Bicep resources. It starts with logging into Azure, then moves on to explain the concept of resources in Azure Bicep, complete with code samples and explanations.
• Convert Rows to CSV & Eliminate Duplicates in SQL ServerMay 06, 2024. Using SQL Server's string aggregate function, efficiently transform row data into a comma-separated format, while simultaneously removing any duplicate entries, ensuring data integrity and optimization.
• How To Create A SSIS Packages?Apr 26, 2024. This comprehensive guide walks through leveraging SQL Server Integration Services (SSIS) to streamline data management for businesses. From installing tools to creating packages for migrating data, it's a detailed roadmap for efficient data handling.
• What Is There In SQL Server Integrated Services (SSIS) Toolbox?Apr 24, 2024. This comprehensive overview of SQL Server Integration Services (SSIS) delves into its toolbox, encompassing Control Flow, Data Flow, Variables and Parameters, Event Handlers, Package Explorer, and Connection Managers.
• What is SQL Server Integration Services?Apr 19, 2024. SQL Server Integration Services (SSIS) is a robust data integration platform within Microsoft SQL Server, enabling seamless data extraction, transformation, loading, and management tasks efficiently.
• 2D Array with Matrix Multiplication in C ProgrammingFeb 28, 2024. A double subscripted variable, also known as a two-dimensional array, is a variable that has two subscripts assigned to it in order to represent a list of items.
• CesiumJS Sample in WPF ApplicationFeb 06, 2024. This project streamlines CesiumJS integration into a WPF app, leveraging powerful geospatial visualization. Learn to inject KML files, define locations, create lines, and manage KML loading. Follow the steps to embed CesiumJS, set up HTML, and integrate with WPF using CefSharp.
• Identifying the Root Cause of SQL Server ProblemsJan 10, 2024. Finding issues in SQL Server involves troubleshooting and identifying the root cause of problems. Troubleshooting SQL Server issues involves comprehensive steps. Check error logs, use SQL Server Management Studio for queries and execution plans, employ Profiler Traces, analyze Dynamic Management Views, monitor disk space, and review application code for optimization.
• Row Constructors in PostgreSQLDec 13, 2023. Explore the power of row constructors in PostgreSQL, enabling efficient row-wise data manipulation. This guide covers syntax, applications in SELECT, INSERT, UPDATE, DELETE statements, and common use cases for optimization.
• Getting Started with SQL Server 2022 SSDT 17.8Dec 07, 2023. It breaks down complex concepts into easy-to-understand terms: SSDT, SSIS, SSAS, SSRS, ETL, SSOX, MDS, TDS and OLAP.
• How to Create Sample Maven Project by Adding TestNG Nov 28, 2023. Learn how to create a Maven project and add TestNG dependencies in Eclipse. Follow steps like configuring Maven settings, specifying project coordinates, and adding dependencies for efficient project development and execution.
• VSTACK Append in Excel with Total RowNov 24, 2023. In the article, Explore the power of Microsoft Excel with the LET, VSTACK, and HSTACK functions. This article guides you through creating complex formulas for dynamic data combination and summarization across multiple tables.
• How to Create Pyramid in C#?Oct 18, 2023. This article explains how to create a pyramid pattern using asterisks in the C# programming language. This pattern is created by printing rows of asterisks, with each row containing an increasing number of asterisks, creating the shape of a pyramid. It also explains the purpose of each line of code in the provided C# program.
• Windows Functions in SQL ServerOct 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.
• Kotlin Coroutines Sample Mobile App Code DemonstrationSep 06, 2023. Here's a simple Kotlin Android application code sample that demonstrates the use of Coroutines for asynchronous programming. This example fetches data from a fake API and updates the UI when the data is received using Coroutines.
• Add Row in Excel using Power AutomateAug 18, 2023. Streamline Excel Data Input: Automate with Power Automate and Microsoft Forms. Learn how to effortlessly add rows to Excel using these tools, enhancing data management and efficiency.
• Column And Row In Jetpack ComposeAug 07, 2023. In this article, We will learn about Row and Column in Jetpack Compose.
• LazyRow and LazyColumn In Jetpack ComposeAug 04, 2023. In this article, you will learn about how to use LazyRow and LazyColumn In Jetpack Compose.
• Power Pages - Custom "Select All - Unselect All" button in Lookup records dialogMay 11, 2023. In Power Pages (Earlier Power Apps Portal), OOB support for selecting / deselecting all grid rows in “Lookup records” dialog is not found. Hence, I have built one client-side custom generic feature using Jquery which will be reusable for all such “Lookup records” dialog.
• 💥Unlocking the Power of CSS: Best Practices and Sample Code for Stunning Web DesignMay 11, 2023. Best practices to follow while styling CSS
• What Is The Difference Between Relational And Non-Relational DatabaseMar 20, 2023. Relational databases and non-relational databases, also known as NoSQL databases, represent two fundamentally different approaches to storing and organizing data. Understanding the key differences between these two types of databases is essential for making informed decisions when choosing the most suitable database solution for specific use cases.
• Power Query Features Related to RowsMar 16, 2023. This article is about cleaning and transforming the data using Power BI query editor. Power Query has a large number of features that will help you clean and prepare your data for analysis. In this article, you will learn about the features related to rows.
• Create Custom Module Using Azure IoT Edge Sample CodeMar 10, 2023. In this article, you will learn how to create a custom Module using Azure IoT Edge Sample Code.
• RxJs Operators Debounce Vs Throttle Vs Audit Vs SampleFeb 27, 2023. In this article, you will learn about RxJs Operators Debounce Vs Throttle Vs Audit Vs Sample.
• Deactivate Child Records Using Plug-inDec 04, 2022. This article is about the sample plugin code which we can use to deactivate child records.
• How To Delete The Table Rows In The Dataverse Environment From PostmanDec 04, 2022. Step by step information about deleting the Dataverse row from a Table in an environment using Postman
• How To Update The Table Row Values In A Dataverse Environment From PostmanNov 30, 2022. Step by Step details to Update The Table Row Values In A Dataverse Environment From Postman
• React And .NET Core 6.0 Web API Sample Project with DockerNov 11, 2022. This article will explain the CRUD (Create, Read, Update and Delete) operations in ASP.NET Core 6.0 WEP API using Entity Framework Core Code First approach.
• What Is The Difference Between DBMS And RDBMS?Sep 13, 2022. DBMS (Database Management System) and RDBMS (Relational Database Management System) are both software systems used to manage and organize databases. The main difference between the two lies in the way they handle data and the relationships between data. A DBMS is a software application that allows users to interact with databases, providing an interface to create, retrieve, update, and delete data. RDBMS is a specific type of DBMS that manages databases based on the relational data model.
• Angular ngx-pagination Sample Implementation Step By Step GuideSep 02, 2022. In this example, I will show you how to implement ngx-pagination in your Angular Application.
• Fetch Previous Row Value With Lag Function And Without Lag FunctionJun 07, 2022. In this article, you will learn how to fetch previous row value with lag function and without lag function.
• How To Wrap Words In DataGridView CellApr 26, 2022. This article explains how to wrap words inside data grid view cell, and change cell height while typing in text.
• Functionality And Events Of Angular GridMar 29, 2022. In this article, you will learn about the functionality and events of Angular Grid.
• Design The Full Load And Delta Load Patterns In SSISFeb 14, 2022. Loading Data Design Patterns will provide you with two main recipes for SQL Server Integration Services (SSIS). Design patterns, the full load and the incremental load, to solve common problems encountered when staging data.
• SQL Security Tips - Implement Row Level Security QuicklyFeb 10, 2022. RLS (row-level security) is one of the important concepts we need to understand to secure data access at a different role.
• List Rows Based On Expand Query In Power AutomateJan 13, 2022. In order to get details of related entity for the selected entity without separate retrieve call we can leverage Expand Query .As a business scenario for the same vaccination use case extracting details of accounts that are present in list of contacts who took vaccination.
• List Contacts Based On FetchXMLQuery In Power AutomateJan 07, 2022. During certain scenarios we must work on List of records to perform certain operations like sending alerts to list of customers. In these scenarios it is critical to filter records to make sure actual requirement was met. In Power Automate, we can use FetchXMLQuery option under List Rows as an example we can see list of contacts in an environment.