Resources   No resource found

• 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 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.
• 🧩 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.
• 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.
• 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.
• Working with Dataset Data in ASP.NET GridViewMar 08, 2025. This article covers data binding, displaying records, sorting, paging, and editing in GridView. Understand how to fetch data from a database, manipulate it using DataTables, and present it efficiently using ASP.NET GridView for a seamless user experience.
• 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.
• 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.
• 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 to Remove Extra Column from DataGrid WPF ControlMay 31, 2024. The WPF DataGrid often displays an extra column due to default behavior. This issue arises when the source data contains fewer columns than displayed. By adjusting the XAML code and setting the ColumnWidth attribute to "*", the extra column can be removed, ensuring proper alignment of data in the DataGrid.
• 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.
• Utilization of DataGrid VS ListBox in WPF C#Apr 22, 2024. In WPF (Windows Presentation Foundation), the DataGrid and ListBox are two powerful controls that serve different purposes and are suitable for different scenarios
• Bulk Data Import in Blazor Server with Radzen DatagridApr 19, 2024. In this article, we'll explore how to implement a robust bulk data upload feature in a Blazor Server application using the Radzen Datagrid component for rendering the bulk imported data.
• 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.
• 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.
• ASP.NET (2) - ASP.NET ControlsSep 06, 2023. This series of articles on ASP.NET, originally from legacy OneNote notes, covers fundamental concepts. It offers valuable insights into current programming involving similar technologies like Angular and React.
• Creating a Dynamic DataGrid Sourced from Tree Component in BlazorAug 25, 2023. Creating a DataGrid component that receives data from Tree component. This combination of components can be super useful in scenarios like product catalogs, file explorers, and organizational charts etc.
• 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.
• 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
• 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.
• Navigation In WPF And MVVM Using Tab controlsJun 14, 2022. To manage the content of the graphical region in WPF, there is some tools (like PRIM) that allows to have a main region which doesn't change during the navigation, and a dynamic one that will hold the content of the controls. In some simple cases, we want to perform it in a simple way without using any tool. Fortunately, the Wpf Material design Toolkit http://materialdesigninxaml.net/ is providing great items that can be used as navigation menus. In this article I'm going to show you how to create an application and navigate between views using The tab control of the Material design toolkit in WPF
• 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.
• 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.
• 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.
• 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.
• 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.
• Xamarin.Forms - DataGridMay 15, 2020. The DataGrid is format or architecture to show a set of data in the user interface. In Xamarin Forms there is no default DataGrid control, so we need to install “Xamarin.Forms.DataGrid” dependency.
• 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
• How To Insert CheckBoxList Values Into a Single Column and Retrieve It From A Database When User Selects A Gridview RowFeb 23, 2020. In this article, I will explain how to insert CheckBoxList Values into a single column and retrieve it from a database when a user selects a GridView Row.
• How to Save Images in Row Format/Bytes Into a Database and Fetch Them in a C# Windows Desktop ApplicationsFeb 18, 2020. In this article, you will learn how to save images in row format/bytes into a database and fetch from the database in a C# windows desktop application.
• Adding Ag-Grid and Enable Sorting and FilteringOct 30, 2019. Ag-Grid is feature rich datagrid designed for major frameworks such as Angular, Vue, React and etc.
• Create Dynamic Row With Custom MultiSelect Dropdowns In Angular 8Oct 10, 2019. In this article, you will learn how to create dynamic Row with Custom MultiSelect Dropdowns in Angular 8.
• Access Data From DataFrame In PythonSep 04, 2019. In this article, I am going to explain how you can access value, rows, and columns of a DataFrame in Python.
• Add Custom Row Actions In SharePoint List Items With Column FormattingAug 06, 2019. In this article, you will learn how to add custom row actions in SharePoint list items with column formatting.
• R Data Frame Operations - Adding Observations / Rows And Variable / Column To A Data Frame In RJul 19, 2019. In this article, we shall learn about adding observations/rows and variables/column to a Data Frame in R in different ways.
• Dynamically Add And Remove Rows In Angular 7May 31, 2019. Here, we will learn about how we can dynamically add/remove rows of the grid using Angular 7.
• Dynamically Add And Remove Row In AngularJS With ASP.NET MVCMay 29, 2019. In this article, we will learn how to add and remove rows dynamically using Angular.js with MVC application.
• Dynamic Row With Controls On Button Click - Add - RemoveMar 25, 2019. Dynamic row with controls is useful when you have to add multiple data for multiple items of the same type. In this article, we will see how to play around with it.
• Expand/Collapse Table Rows With jQuery Jan 24, 2019. In this article, we will explore two ways to expand/collapse HTML table rows.
• ASP.NET MVC 5 - Matchheight.js📦 - Create Equal Height Of Columns In Row Using jQueryJan 16, 2019. Here, we are going to learn how to match the height of the tallest of each row by the column height and why should learn this.
• Passing Value Of Grid Row From Data Grid To Webpages Using Hyperlink In ASP.NETNov 06, 2018. In this article i am going to explain how to pass value of grid row from data grid to one page to another webpage using hyperlink in Asp.net using C# and VB.Net.