About data
Data is collection of row material which is collection of records and distinct pieces of information usually formatted in a special way. All software is divided into two general categories: data and programs. Programs are collections of instructions for manipulating Data. Data can exist in a variety of forms as numbers or text on pieces of paper, as bits and bytes stored in electronic memory, or as facts stored in a person's mind. Strictly speaking, data is the plural of datum, a single piece of information. In practice, however, people use data as both the singular and plural form of the word. The term Data is often used to distinguish binary machine-readable information from textual human-readable information. For example, some applications make a distinction between data files and text files. In database management systems, data files are the files that store the database information, whereas other files, such as index files and data dictionaries, store administrative information, known as metadata.
Related resources for data
  • Azure Data Factory Lakehouse Connector to Read and Write Data11/21/2024 5:24:15 AM. In this new video, I covered how to use the new Lakehouse Connector in Azure Data Factory to read data from ADLS Gen2 to Fabric Lakehouse as a delta table and also to write data from the Lakehouse to
  • Events: Love Triangle in Integration Testing11/20/2024 6:30:48 AM. This video will delve into the main problems of not creating integration tests that check whether the application works fine, showing different alternatives with their pros and cons.
  • Apache Kafka with Dapr Bindings in .NET11/20/2024 4:30:36 AM. This content provides an in-depth overview of integrating Apache Kafka with Dapr Bindings for building distributed event-driven applications. It explains the key concepts of Apache Kafka, Dapr, and Da
  • Temporary Tables vs Table Variables in SQL Server Explained11/19/2024 10:49:20 AM. This article explores their key distinctions, advantages, and ideal applications, helping users understand when to use each for better query performance and resource optimization.
  • Save List Data to Another List as an Attachment Using Power Automate11/19/2024 10:42:33 AM. This step-by-step guide covers creating workflows to transfer and attach data from one SharePoint list to another, automating data management, and improving efficiency in your SharePoint environment.
  • Change Data Capture Automated Incremental Data Loading in Azure Data Factory11/19/2024 5:56:36 AM. In this new video, I demonstrated how to implement automated incremental data loading using Change Data Capture technique in Azure Data Factory.
  • Use of ItemsControl in WPF C# for Flexible UI Design11/19/2024 4:38:09 AM. This guide explores data binding, templates, and customization techniques for crafting sophisticated layouts. Enhance your WPF skills and unlock the full potential of ItemsControl for efficient UI dev
  • Unlocking the Power of the SELECT Feature in SQL Server11/18/2024 12:04:57 PM. This article explores the basics of the SQL Server SELECT statement, demonstrating how to query data from tables using practical examples. Learn how to fetch specific columns, improve query performanc
  • How to Install Ubuntu Server on VMware ESXi Using VMware Client Browser11/18/2024 11:07:48 AM. This guide explains how to install Ubuntu Server on VMware ESXi using the web client. It covers steps like creating a virtual machine, selecting storage, uploading the Ubuntu ISO, configuring network
  • Delta Tables in Microsoft Fabric🔼11/18/2024 7:51:14 AM. Delta tables in Microsoft Fabric offer a powerful way to manage large-scale data efficiently. Built on open-source Delta Lake, they enable ACID transactions, versioning, and real-time data streaming.
  • Exploring the Seven Experiences in Microsoft Fabric11/18/2024 4:47:32 AM. In this article we will dive deeper into each of the seven Fabric experiences, focusing on their objectives, the resources they provide, similar Azure services, and the key personas they serve.
  • Retrieve API Data and Store in SharePoint with Power Automate11/18/2024 4:42:57 AM. In this article, we will learn how to use Power Automate to retrieve data from an external API and automatically store it in a SharePoint list, streamlining your workflow and data management.
  • How to Create Lakehouse in Microsoft Fabric11/18/2024 4:27:25 AM. In this article, we will create a lakehouse in Microsoft Fabric. Discover Lakehouse architecture, a modern approach combining data lakes and warehouses. Learn how to build a Lakehouse in Microsoft Fab
  • Enhance SQL Server Stored Procedure Performance – Tuning Tips11/18/2024 3:51:42 AM. Covering indexes and filtered indexes in SQL optimize database performance by efficiently retrieving data for queries. Covering indexes include all needed columns, while filtered indexes target specif
  • Data Professionals to LLM/GPT Prompting for Everyday Tasks11/17/2024 10:52:39 AM. A guide for data professionals on leveraging Microsoft OpenAI with Python for efficient workflows and enhanced data analysis. Focuses on prompt design, including clear instructions, context, and tempe
  • How to Read and Write JSON Files in C#11/17/2024 10:49:03 AM. JSON is a common data format used in APIs, configuration files, and data exchange. Learn to handle JSON in C# using `System.Text.Json`. This article covers creating data models, writing to and readin
  • Repository Pattern in .NET Core for Clean Data Access11/15/2024 11:24:56 AM. Learn how to separate business logic from data logic, enhance testability, and reduce code duplication. By following these best practices, you’ll achieve modular, scalable applications in .NET Core.
  • Amazon OpenSearch Service Setup with Kibana11/15/2024 9:48:13 AM. Amazon OpenSearch Service enables real-time search, monitoring, and analysis of business data. It integrates with AWS services like CloudWatch Logs and Lambda for log aggregation, with Kibana for data
  • Migrate Grafana dashboard Dev to UAT Environment11/15/2024 5:16:37 AM. Learn how to migrate Grafana dashboards from Dev to UAT environments seamlessly. This guide covers export, configuration, and deployment steps to ensure smooth transitions and effective testing in UAT
  • Data Quality, Security, and Building Trust in AI11/15/2024 5:14:14 AM. As AI adoption grows, data quality, security, privacy, and trust are becoming critical. Organizations must prioritize data cleansing, validation, encryption, and access controls to ensure reliable AI
  • Azure Data Factory PRESERVE HIERARCHY Copy Behaviour11/14/2024 9:41:42 AM. In this video, I covered how to use the Preserve Hierarchy in Azure Data Factory Copy Behaviour.
  • Loading Nested JSON File Data in Dropdown ASP.NET11/14/2024 6:58:43 AM. Learn how to load and bind nested JSON data to a dropdown in ASP.NET, covering both client-side and server-side techniques for dynamic data binding and efficient JSON parsing in web applications.
  • How to Create a ListView Command Set Extension11/12/2024 11:13:01 AM. A ListView Command Set extension in SharePoint customizes the command bar or context menu of lists/libraries. It allows adding buttons that trigger custom actions, such as displaying alerts, showing s
  • Creating Views for Lists or Libraries in SharePoint Online11/12/2024 6:02:41 AM. Creating custom views in SharePoint Online allows users to tailor how lists and libraries display data. With options for filtering, sorting, grouping, and different layouts like calendar and gallery v
  • RxJS Operator Essentials: Map, Tap, Filter, and More11/12/2024 5:15:13 AM. This article explores key RxJS operators in Angular, like map, tap, filter, take, and takeLast. You'll learn how each operator manipulates data streams to handle emitted values, log information, a
  • An Introduction to Microsoft Fabric Fundamentals11/12/2024 5:13:49 AM. Learn the core concepts, including Fabric architecture, data lake integration, and analytics capabilities, designed to streamline data management and empower insights across organizations.
  • SSRS (4) --- SQL Server Database Project in Visual Studio11/11/2024 8:37:33 PM. This article is to discuss: SQL Server Database Project in Visual Studio
  • Database Dictionary (1) --- Schema11/11/2024 8:15:04 PM. This article will discuss the database schema.
  • Difference Between Large Language Model & Small Language Model11/11/2024 6:01:01 AM. Large and small language models differ primarily in scale, resources, and use cases. Large models, with billions of parameters, excel in generalization and diverse tasks but require significant comput
  • Read Multiple CSV Files from GitHub Repository to Databricks Notebook11/11/2024 5:52:15 AM. In this Data engineering episode, I covered how to read multiple CSV files from GitHub Repository to Databricks Notebook for analysis.
  • Managing User Sessions in React11/11/2024 5:36:17 AM. Session management is a fundamental aspect of web applications that allows developers to track user activity, maintain login states, and manage temporary data throughout a user's interaction with
  • Glimpse of Apache Flink11/11/2024 5:10:48 AM. Apache Flink is an open-source framework designed for real-time and batch data processing. It enables scalable, high-performance analytics, ideal for complex event-driven applications.
  • How to perform CRUD Operations in Power Apps11/10/2024 7:03:28 AM. Create a student management app in Power Apps with CRUD functionality—Create, Read, Update, and Delete—for efficient data handling. This app connects to a SharePoint list, allowing users to add, view,
  • Creating Interactive Charts with Chart.js and TypeScript11/10/2024 6:08:34 AM. To create a responsive chart in a TypeScript application, use Chart.js—a popular library for data visualization. Set up your TypeScript project, install Chart.js and its types, and configure Webpack f
  • Everything you need to know about QuickGrid in Blazor11/9/2024 6:21:07 AM. This guide covers the basics of setting up QuickGrid, customizing columns, and optimizing performance in Blazor projects. Perfect for developers seeking a simple, powerful grid component for their Bla
  • Weather App to fetch/display weather data using API11/8/2024 11:39:42 AM. Building a weather app that fetches and displays weather data using an API is a practical project for developers looking to enhance their skills in JavaScript and API integration. This application all
  • Hacking MySQL for Big Data11/8/2024 11:14:47 AM. In this video, we will go through the things that make MySQL & its counterparts capable of performing well on bigger data sets.
  • Overview of Essential Networking Devices11/8/2024 5:01:07 AM. Networking devices enable data flow and secure communication within networks, connecting computers, servers, and other devices. Examples include routers, switches, modems, access points, and firewalls
  • Integrate MySQL and Snowflake for Real-Time Insights11/8/2024 4:38:58 AM. This guide covers migrating data from MySQL to Snowflake, highlighting two methods: using Estuary Flow for real-time data sync with minimal setup, and a manual CSV export/import for smaller datasets o
  • Fetch Document Versions in SharePoint using PowerShell11/8/2024 4:24:10 AM. This PowerShell script connects to a SharePoint site to retrieve document versions from a specified library. It gathers metadata, including version numbers, last modified dates, and user details, then
  • Mirror Azure Databricks Unity Catalog in Microsoft Fabric11/7/2024 4:43:27 AM. In this video, I covered how to mirror Azure Databricks Unity Catalog in Microsoft Fabric for downstream analysis in Power BI Service.
  • Data Fetching Unleashed: Next.js, React Query and their BFF11/6/2024 11:37:01 AM. This video explores the intersection of Next.js, React Query, and the Backend for Frontend (BFF) design pattern, three vital elements pieces that help solve the puzzle of performant and scalable data
  • 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,
  • Fededim.Extensions: ASP.NET Data Protection Integration11/5/2024 9:59:16 AM. Fededim.Extensions.Configuration.Protected.DataProtectionAPI enables seamless integration between ASP.NET Configuration and the Data Protection API, providing enhanced security for sensitive data in a
  • Data Engineering in Microsoft Fabric11/5/2024 8:27:55 AM. Learn how to design, build, and maintain robust infrastructures and systems that enable your organization to collect, store, process, and analyze vast volumes of data efficiently.
  • Managing User Data in Azure AD with Microsoft Graph API11/5/2024 5:47:57 AM. Microsoft Graph API is a RESTful web API that provides access to Microsoft 365 services, enabling developers to manage user data in Azure Active Directory. It allows operations such as retrieving, cre
  • Understanding TreeView in .NET Core11/4/2024 5:58:45 AM. The TreeView component in .NET Core is a powerful UI element that displays hierarchical data in a tree-like structure, allowing users to navigate through items easily.
  • 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
  • Create Premium Databricks Workspace on Azure in 5 mins10/31/2024 4:45:34 AM. This video shows how to create Databricks workspace on Azure.
  • Paging Microsoft Graph data in SPFx10/31/2024 4:29:31 AM. Microsoft Graph return multiple pages of data either due to server-side paging or client-side paging. Paging data helps improve the performance of your app and the response time of Microsoft Graph.
  • Understanding Dataverse Text Fields10/30/2024 6:51:35 AM. Understand how to integrate text fields into your applications, validate user input, and retrieve data seamlessly. Enhance your knowledge of database design and modeling within Microsoft Dataverse.
  • Top AI Tools for Testers10/30/2024 6:04:42 AM. Artificial Intelligence (AI) revolutionizes software testing by automating repetitive tasks, enhancing accuracy, and expediting the testing process. It enables testers to generate test cases, detect d
  • Securing Remote Access to SQL Server10/30/2024 5:39:48 AM. Securing remote access to SQL Server is paramount for data protection and compliance. Explore methods like VPNs, firewalls, encryption, and multi-factor authentication for enhanced security and protec
  • 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
  • Windowing Enhancements New T-SQL Enhancement in SQL Server10/29/2024 6:29:27 AM. SQL Server 2022 introduces advanced T-SQL features, enhancing window functions, aggregations, and NULL handling. New options like the WINDOW clause and IGNORE NULLS optimize complex data queries, redu
  • Data Reliability and Availability with Microsoft Fabric Mirroring10/29/2024 4:05:52 AM. Mirroring in Microsoft Fabric enhances data reliability and availability by creating redundant copies of data across multiple locations. This ensures high availability, fault tolerance, and rapid disa
  • Data Loss Prevention in Microsoft Fabric Internals10/28/2024 9:20:50 AM. Microsoft Fabric’s Data Loss Prevention (DLP) feature protects sensitive data across services like SharePoint, Teams, and Exchange by enabling policy creation, scanning, and enforcement through Micros
  • How to Store Temporary Information in Table Like Format in C#?10/28/2024 8:56:49 AM. In this article, we will learn how to manipulate and manage in-memory data effectively, allowing for quick access and modifications while maintaining a structured format for your applications.
  • 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
  • SharePoint Online - Add/Update Taxonomy Field Using Graph API 10/25/2024 10:31:41 AM. This guide covers step-by-step instructions for integrating taxonomy fields, managing metadata, and customizing fields in SharePoint lists and document libraries. Enhance your SharePoint solutions wit
  • SQL Data Analysis in Databricks Notebook10/25/2024 6:09:40 AM. This video dives into performing SQL Data Analysis in Databricks Notebook.
  • GENERATE_SERIES Function New T-SQL Enhancements in SQL Server10/25/2024 6:06:40 AM. The GENERATE_SERIES function in SQL Server 2022 creates sequences of numbers or dates between specified start and end values, with an optional step. It's beneficial for reporting, filling data gap
  • How to Download Data as CSV in C# Blazor App10/25/2024 5:46:03 AM. In this article, we will explore the process of downloading data as a CSV (Comma-Separated Values) file in C#. CSV files are widely used for data interchange due to their simplicity and ease of use.
  • Generative AI in Copilot Studio 10/25/2024 4:29:43 AM. This guide explains how to control Generative AI responses in Copilot by managing data sources and system settings. You can choose to generate answers from your private knowledge base or public AI kno
  • Create a Data Visualization Adaptive Card Extension10/24/2024 7:03:25 AM. Creating a Data Visualization Adaptive Card Extension (ACE) for SharePoint Online using the SharePoint Framework (SPFx) involves building a custom ACE component to display visual data in the form of c
  • Quality AI Requires Quality Data10/23/2024 8:23:48 AM. This video dives into data quality, with a strong focus on how data is maintained as it moves from transactional to analytic workloads.
  • 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.
  • Array to Text File: Detailed Overview of ArrayIOExtensionsLib Class10/22/2024 10:04:42 AM. This article provides a comprehensive overview of the ArrayIOExtensionsLib class, detailing its functionality for converting arrays to text files in C#. We explore its key features, methods, and pract
  • Introduction to Power BI: A Beginner's Guide10/22/2024 9:31:36 AM. Power BI is a powerful business analytics tool from Microsoft designed for data visualization and sharing insights across organizations. This beginner-friendly guide covers its key components, includi
  • Best Practices for Microsoft 365 Admins when User Offboarding10/22/2024 8:39:45 AM. Learn how to effectively manage user accounts, ensure data security, and maintain compliance while revoking access. Implementing structured workflows and documentation will streamline the process, min
  • Learn SharedPreferences in Android10/22/2024 7:19:52 AM. SharedPreferences is an Android feature used to store small amounts of data in key-value pairs. It allows apps to save user preferences, settings, and simple data across sessions.
  • Encapsulation vs Abstraction in C#10/21/2024 9:52:41 AM. Encapsulation and abstraction are fundamental concepts in C# and object-oriented programming. Encapsulation refers to the bundling of data and methods that operate on that data within a class, promoti
  • Read/Write From Fabric Lakehouse to Databricks Notebook using ABFSS Protocol10/21/2024 8:15:07 AM. In this episode, I covered how to Read/Write From Fabric Lakehouse to Databricks Notebook using ABFSS Protocol.
  • Dependency Properties in WPF: Benefits, Usage, and Examples in C#10/21/2024 6:14:51 AM. A Dependency Property in WPF is a specialized property supported by the WPF property system. It enables data binding, styling, animation, and value inheritance. This system improves memory efficiency
  • Using Attributes and Metadata in C# 1210/21/2024 5:38:45 AM. Ziggy Rafiq demonstrates how to use attributes and metadata in C# 12 including improvements in parameter types, reflection capabilities, and best practices for maintaining self-documenting code.
  • 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 Adaptive Cards with Copilot10/16/2024 10:36:25 AM. This article explores the use of Adaptive Cards in Microsoft Copilot, covering their purpose, integration strategies, and practical examples that developers can use to build custom experiences for use
  • Check Constraint in SQL Server 201210/16/2024 9:55:46 AM. A Check Constraint in SQL Server enforces Domain Integrity by ensuring valid values for specific table columns. It restricts invalid data entries, rejects values that don't meet set conditions, an
  • 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
  • Gitea - an Open Source, Self Hosted GitHub Alternative10/16/2024 4:51:49 AM. Gitea is a lightweight, self-hosted Git server that offers features similar to GitHub, including issue tracking, pull requests, and a web-based interface. It's ideal for organizations needing data
  • How to Make Serial Chart With JSON Data Using amChart10/15/2024 11:48:32 AM. This article demonstrates how to use amCharts to display JSON data in a serial layout. It walks through the steps of adding an HTML container, referencing JavaScript libraries, creating a JSON data fi
  • 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.
  • Introduction to SharePoint and Steps Creating Lists 10/15/2024 11:12:19 AM. Learn how to create and manage lists effectively, enhancing your team's collaboration and productivity. With step-by-step instructions and best practices, this resource is perfect for beginners a
  • Understanding List Column Data Types in SharePoint 10/15/2024 11:08:42 AM. SharePoint allows users to create and manage lists with various column types, such as text, number, date, and lookup fields. These columns help organize and store data effectively, ensuring better rep
  • Implementing an LRU Cache in C#10/15/2024 8:37:55 AM. This article explores the concept of caching, outlines the algorithm's mechanics, and provides step-by-step guidance on building an efficient LRU Cache using C# collections.
  • 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.
  • How To Delete Duplicate Rows From A Table In SQL Server10/12/2024 5:29:23 AM. 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 o
  • The OSI Model: Exploring the Seven Layers of Networking10/12/2024 5:19:26 AM. The OSI model is a framework that standardizes network communication into seven layers, facilitating interoperability, troubleshooting, and consistent practices across different networks and protocols
  • Implementing Azure Databricks AutoLoader (Incremental Data Loading)10/11/2024 4:25:22 AM. In this end to end video, I walked you through how to implement Azure Databricks Autoloader which allows incremental loading of new files from Azure Data Lake Storage Gen2.
  • 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
  • Understanding Infix, Postfix, and Prefix Expressions/Notations in DSA10/10/2024 3:36:19 AM. Infix, prefix, and postfix expressions are three notations for representing mathematical expressions in data structures and algorithms. Infix notation, where operators are between operands (e.g., A +
  • Power Platform for Admins Connector in PowerApps10/9/2024 6:38:19 AM. PowerApps allows users to integrate the "Power Platform for Admins" connector to manage environments efficiently. By using functions like GetAdminEnvironment(), users can retrieve and pagina
  • Create Fiscal Year and Aggregate using Power Query M Code10/9/2024 6:28:23 AM. In this Power Query video, I covered how to create fiscal Year and perform aggregation using Power Query M Code.
  • Mastering SQL Query Generation with Azure OpenAI10/9/2024 6:07:40 AM. Leverage Azure OpenAI to transform natural language into SQL queries seamlessly. By integrating Azure OpenAI and Azure SQL Database, you can simplify data querying and enhance accessibility. Learn how