Resources   No resource found

• 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!
• What Is TypeScript Interface vs Type Alias and When to Use Which?Apr 03, 2026. Unlock the power of TypeScript! Learn the difference between Interface and Type Alias with clear examples. Choose the right tool for object shapes, unions, and more!
• 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.
• Why Reports Change After Deployment – Data Consistency ExplainedFeb 02, 2026. Reports changing post-deployment? This article explains why, covering code, data pipelines, caching, and more. Maintain trust with clear communication & definitions!
• 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 Role Definition IDs in SharePointJan 02, 2026. Unlock SharePoint permissions! Learn about Role Definition IDs: the numeric keys (like 1073741829 for Full Control) that Power Automate & APIs use to manage access effectively.
• Exploring nameof Support for Unbound Generic Types in C# 14 (.NET 10)Dec 29, 2025. Unlock compile-time safety with C# 14's nameof operator for unbound generic types! Simplify logging, DI, and validation. Boost code maintainability in .NET 10.
• 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.
• 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.
• Python - Importance of Function and OperationsNov 04, 2025. Explore Python functions: syntax, parameters, variable arguments, and return statements. Learn to build practical tools like temperature converters and password checkers.
• 🧩 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.
• AI vs. ML: Untangling the ConfusionOct 04, 2025. This article clarifies the crucial differences between Artificial Intelligence and Machine Learning, two often-confused terms. Understand how ML, a subset of AI, empowers systems to learn from data without explicit programming. Explore their definitions, key characteristics, and dispel common misconceptions to gain a clear understanding of their roles in intelligent systems and real-world applications.
• What is GEO (Generative Engine Optimization)?Aug 31, 2025. Generative Engine Optimization (GEO) is SEO for AI answers. Learn the definition of GEO, how it works, and why it matters in the era of ChatGPT, Gemini, and Perplexity.
• What is Generative Engine Optimization (GEO)?Aug 31, 2025. Generative Engine Optimization (GEO) is the practice of optimizing your content so AI systems like ChatGPT, Google Gemini, and Perplexity cite your brand directly inside their answers. Learn the definition, origins, and why GEO is the future of SEO.
• Automating SharePoint Permissions with PnPjsAug 14, 2025. Learn how to create custom role definitions, assign dynamic item-level permissions, and audit SharePoint security using PnPjs in SPFx. Step-by-step guide with best practices.
• Custom Role Definitions & Dynamic Permission Management in SharePoint with PnPjs (SPFx Guide)Aug 11, 2025. This script uses PnP.js to create a custom SharePoint role named "Custom Reviewer" with permissions to view and add comments but without editing core data, defining it via sp.web.roleDefinitions.add().
• 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.
• Manage SharePoint Permissions with PnPjs in SPFxAug 06, 2025. Manage SharePoint permissions in SPFx using PnPjs. Learn how to get user roles, break inheritance, assign or remove access, and check effective permissions with efficient and production-ready code examples.
• What is artificial intelligence (AI)?Aug 06, 2025. Discover what Artificial Intelligence (AI) really is! Understand its definition, types, real-world applications, and practical C# code examples that introduce AI concepts to developers.
• 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.
• 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.
• What is a CTE, and How Do You Write a CTE in SQL Server?Nov 29, 2024. A Common Table Expression (CTE) in SQL Server is a temporary result set that can be referred to within a SELECT, INSERT, UPDATE, or DELETE query. CTEs simplify complex queries by breaking them into manageable parts.
• 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.
• What is a Sitemap and How to Use It?Aug 09, 2024. A sitemap is a crucial tool for website optimization, aiding search engines in indexing your site efficiently. This guide explores the definition, types, and benefits of sitemaps, including XML and HTML formats.
• Detailed explanation of SQL Server Triggers and its AdvantagesAug 06, 2024. SQL Server triggers are automated stored procedures that execute in response to specific database events such as INSERT, UPDATE, or DELETE (DML) and CREATE, ALTER, or DROP (DDL). They enforce business rules, maintain referential integrity, and log changes, ensuring data consistency and centralized logic.
• Investigating and Fixing Swagger Error- Failed to Load API DefinitionJul 29, 2024. Swagger is a widely used and powerful API development toolset that offers a framework for designing, building, documenting, and consuming RESTful web services. This article explains what Swagger is and how to fix the "Failed to load API definition" error in Swagger.
• 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.
• 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.
• 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.
• Trunk-based or Feature-based Development (1) - DefinitionDec 29, 2023. This article will discuss the Trunk-based and Feature-based Development. On a journey into software development strategy, delving into Version Control Tools and branching strategies. This series explores Trunk-based and Gitflow workflows, defining, comparing, and understanding their evolution, application, and implications.
• 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.
• 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.
• 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.
• C# Abstract Classes: Definition, Usage With ExampleAug 07, 2023. Learn all about C# Intermediate Abstract Classes in this comprehensive guide. Understand the concepts, usage, and benefits. A must-read for C# developers aiming to enhance their skills. Click to become a C# Abstract Classes expert!
• 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.
• How To Solve Failed to load API definition Response Status 500 in ASP .NET?Jun 22, 2023. ASP.NET is a popular web development framework used to build dynamic web applications. While working with ASP.NET. Developers may encounter the "Failed to load API definition". Response status is 500 error message. This error occurs when the API definition file fails to load due to an internal server error. In this article, we will discuss the possible causes of this error and how to solve it easily and in a simple way.
• 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.
• DDL Triggers in SQL ServerMay 01, 2023. DDL triggers are a type of trigger that gets fired and executed when DDL events occurs on database schema. DDL events include Create, Alter, Drop, Grant, Deny, Revoke statements.
• 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.
• 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
• Generate Step Definition File In Cucumber BDD FrameworkOct 06, 2022. In this article, you will learn how to generate step definition file in cucumber bdd framework.
• 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.
• 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.
• 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.
• Different Ways To Find And Delete Duplicate Rows From A Table In SQL ServerJan 04, 2022. In this article, we will learn how to find and delete duplicate values from a table in SQL Server.
• Add Temporary Row Into Table Using JQuery Panel Slider Dec 31, 2021. Add Temporary Row Into Table Using JQuery Panel Slider.
• Get Lookup Field Text In Power AutomateDec 24, 2021. In Power Automate one of the common scenarios was to extract Look up Field Text which will be a nightmare for the people who are new to Power Automate about how to extract details of lookup field. As an example, on update of Contact Table, Account Details will be extracted.
• Working With List Rows Present In Excel Table OneDrive In Power AutomateDec 23, 2021. In Power Automate, during certain scenarios we must traverse all the records in excel file table and based on few conditions content in excel to be updated. List Rows action present under Excel Online(Business) Connector in power automate can be used. As an example scenario of updating eligibility of Employees based on Age explained here.
• Update A Row In An Excel Table Onedrive In Power AutomateDec 16, 2021. Most of the common usage of storing data in Excel Spread sheets and a common scenario was to update data in Spread Sheet. We can use an action Update a row into a Table in Power Automate under connector Excel Online (Business). As an example, Employee details will be updated in existing Spread sheet post sending emails in a new column Date when emails were sent through Power Automate.
• Filter Real-Time Error Rows From CSV To SQL Database Table In Azure Data Factory - Part TwoDec 09, 2021. In this article, you will learn about Filter Real-Time Error Rows from CSV to SQL Database Table in Azure Data Factory.
• Filter Realtime Error Rows From CSV To SQL Database Table In Azure Data Factory - Part OneDec 09, 2021. In this article, you will learn about Filter Realtime Error Rows from CSV to SQL Database Table in Azure Data Factory.
• Add A Row Into An Excel Table Onedrive In Power AutomateDec 04, 2021. Most of the common usage of storing data in Excel Spread sheets and a common scenario was to add data into Spread Sheet. We can use an action Add A row into a Table in Power Automate under connector Excel Online (Business). As an example, Employee details will be passed to Spread sheet through Power Automate.
• Azure Data Factory - Implement UpSert Using Dataflow Alter Row TransformationJun 18, 2021. In this article, we will learn how to implement UpSert using Dataflow Alter Row Transformation.
• Multiple Expand And Collapse Rows In A Power Apps Canvas App GalleryJun 03, 2021. In this article, you will learn how to expand and collapse multiple rows using PowerApps nested Gallery.
• How To Set Background Color Of A Selected Row Based On Checking/Unchecking Checkbox In Angular 10Feb 23, 2021. In this article, you will learn how to set the background color of a selected row based on checking or unchecking a checkbox in Angular 10.
• Component Wise vs. Functionality Wise - Team BreakupDec 30, 2020. Agile methodology advocates for smaller teams like frontend, backend, and data engineering for enhanced productivity. Component-oriented and feature-oriented teams streamline development, but communication and dependencies pose challenges. Scalable Agile Framework emphasizes system layers and integration tests.
• Delete Duplicate Rows In SQL Server From A TableDec 21, 2020. In SQL Server, delete duplicate rows from a table efficiently using techniques like DISTINCT, GROUP BY, or ROW_NUMBER(). Ensure data integrity by considering primary keys or unique constraints.
• How To Create A Function In RDec 04, 2020. Learn how to create and use functions in R with this comprehensive guide. Understand the syntax for defining functions, specifying arguments, and defining default values. Explore examples demonstrating function calls, handling return values, and utilizing return functions.
• Azure Data Explorer - Kusto Query - Transform Rows To ColumnsOct 26, 2020. In Azure Data Explorer using Kusto Query Language, transform rows to columns using operators like Pivot or Transpose. Aggregate and reshape data with Summarize and Project, facilitating efficient analysis and visualization of tabular data.
• Operations On Dataframe - Part OneSep 28, 2020. In this article, we would learn about various dataframe operations like Binary operations (Addition, Subtraction, Multiplication, etc.) Inspection Functions, Iteration Functions, and How to retrieve Head and Tail rows.
• The serve command requires to be run in an Angular project, but a project definition could not be foundSep 26, 2020. How to fix error The serve command requires to be run in an Angular project, but a project definition could not be found
• Add, Assign, And Modify Values In DataFrameSep 21, 2020. In this article, we will learn how to add or assign values in the dataframe. Also, we will learn to modify existing values in the dataframe.
• Get SharePoint Role Definition ID'sAug 06, 2020. Retrieve SharePoint Role Definition IDs to manage access levels efficiently. Use SharePoint APIs or PowerShell to access, view, and modify permission settings for users and groups within your SharePoint environment.
• Removing Unnecessary Rows Using Power Query In Power BIJul 19, 2020. In this article, you will learn how to remove Unnecessary Rows using Power Query in Power BI.
• Retrieve More Than The Default Number Of Rows Of Data From Excel Using Power AutomateJul 08, 2020. In this article you will learn how to retrieve more than default number of rows of data from excel using power automate.
• Row Layout Option Missing In Multiline FieldJul 05, 2020. This article is about fixing an error in a multiline field.
• jQuery Datatable Single And Multi-Row SelectionJun 08, 2020. This article gives an overview of how to use jQuery datatable in MVC to implement single and multiple row selection, in jQuery Ajax. I will use jQuery datatable plugin in this demo application and explain how to apply single and multiple row selection
• Deleting Multiple Rows With Checkboxes In Angular 9 With Web API And SQLMay 26, 2020. In this article, I'm going to perform Deleting multiple rows with check boxes in Angular 9 using Web API And SQL with the help of an example.
• Datatable To CSV File Using UiPath StudioMay 21, 2020. Reading this article, you can learn How to create a Datatable and store the data in to Datatable and retrieve the data from datatable and write the data in to CSV file with Assign, Do While, Add Data Row and Write CSV activities using UiPath Studio Pro Community.
• How To Highlight Selected Row In ngFor In Angular 9May 14, 2020. In this article, you will learn how to highlight selected row in ngfor in angular 9.
• Selecting Table Rows with CheckboxesApr 09, 2020. In this article, you will learn how to select Tables Rows with Checkboxes using tabulator.js.
• Row Virtualization In Kendo Grid With Remote Data BindingFeb 24, 2020. From this article you will learn how to implement row virtualization in kendo grid with remote data binding