Resources   No resource found

• Artificial Intelligence and Private Tailored Small Language Model (PT-SLM) Solutions for Education AdministrationMay 01, 2025. Private Tailored Small Language Models (PT-SLMs) bring secure, efficient, and context-aware AI to educational administration, enabling automation, improved decision-making, and enhanced stakeholder experiences.
• Advanced C# Techniques: Multipart Uploads with AWS S3Apr 30, 2025. Learn how to efficiently upload large files to Amazon S3 using Multipart Upload in .NET (C#). Explore automation with TransferUtility, manual control, best practices, retries, and production integration tips.
• Binary Search Tree (BST) Node Deleteion Algorythm in C#Apr 30, 2025. Learning BST: How to implement Binary Search Tree (BST) deletion algorithm in C#, with unit testing using xUnit and FluentAssertions. This guide covers deletion cases, real-world relevance.
• How to Load Data in ExcelApr 29, 2025. Learn how to import, clean, and manage multiple tables in Excel using Power Query. This step-by-step guide covers importing data from Excel workbooks, transforming data, using "Create Connection" for multiple tables, and loading them into Excel or the data model for further analysis.
• How to Seamlessly Integrate Microsoft Dataverse with Fabric Using Fabric LinkApr 28, 2025. Learn how to easily connect Microsoft Dataverse to Microsoft Fabric using Fabric Link. Step-by-step guide covering prerequisites, setup, Lakehouse validation, and understanding how Dataverse syncs with Fabric.
• Differences Between Layer 2 Switches, Layer 3 Switches & RoutersApr 28, 2025. A Layer 2 switch moves data using device MAC addresses in the same network, a Layer 3 switch can also move data between networks using IP addresses, and a router connects different networks and sends data to the right place.
• How to Convert a DataTable to a List of Objects in C#Apr 27, 2025. Learn how to convert a DataTable to a List<T> in C#. Explore manual, reflection-based, and LINQ methods for better performance, type safety, and cleaner code. Improve maintainability in modern C# applications.
• AI-Driven Banking Automation: Code Generation and Secure Data Integration Apr 24, 2025. In today’s competitive financial landscape, banks are driven by a dual imperative: deliver superior customer service and comply with stringent regulatory standards.
• How to Convert a List of Objects to a DataTable in C#Apr 23, 2025. In real-world C# applications, especially when working with data layers or exporting data (e.g., to Excel, reports, or grids), you may often need to convert a generic list of objects (List<T>) to a DataTable.This article shows you how to do that in a clean, reusable way using reflection.
• 🏔️AlpineGate AI: Redefining Data Privacy in Healthcare AI by John GodelApr 23, 2025. The healthcare industry stands at a crossroads — one path driven by rapid AI innovation, the other governed by the ethical imperatives of privacy, trust, and patient safety.
• Understanding Change Data Capture (CDC) and Its TypesApr 23, 2025. In this article we are going to learn about the CDC and types of CDC approaches. It helps keep data in sync without causing a heavy load on the database.
• Splitting Of Datasets in Machine LearningApr 23, 2025. Splitting datasets is vital in machine learning to test model accuracy on unseen data. Common methods include train-test split, k-fold cross-validation, stratified k-fold, and time series split.
• Sharing Session and Application dataApr 21, 2025. The request scope makes data available to multiple pages processing the same request. But in many cases, data must be shared over multiple requests.
• Encoding of Variable in Machine LearningApr 18, 2025. How to transform categorical values into continuous form, and what is encoding? Encoding categorical data is vital for machine learning. Techniques like Label Encoding and OneHotEncoder convert non-numeric values into numerical form.
• How to Detect Outlier and Remove in Machine LearningApr 18, 2025. This article explores techniques to detect and remove outliers using statistical methods like Z-score, IQR, and tools like Python, Pandas, and Scikit-learn to improve data quality and model performance.
• How to Impute Missing Value in Machine LearningApr 17, 2025. This article explains the importance of data and various imputation techniques in machine learning to handle missing values, ensuring cleaner datasets and improving model accuracy and performance.
• Modern Data Wrangling with Polars and Delta Lake in Microsoft FabricApr 17, 2025. Learn how to efficiently clean, transform, and manage large datasets with high-performance tools. Discover scalable, fast, and flexible data workflows designed for today’s data engineering needs.
• Create Graph Windows Form - WInForm using .Net 8Apr 16, 2025. Learn how to create a bar chart in a Windows Forms App (.NET) using the Chart control. This step-by-step guide covers project setup, adding the chart control, configuring the chart area, and adding data points for visualization.
• Django Web framework Google Chart ExampleApr 14, 2025. Django, a Python web framework using the MVT pattern, simplifies web development with built-in admin, structured views, and templates—demonstrated using a Google Charts example for dynamic data visualization.
• The Future of Web3: How Decentralized Applications Are Changing the InternetApr 15, 2025. Explore the transformative world of Web3, where decentralization empowers user control, enhances data integrity, and fuels digital innovation. Discover top DApps, business benefits, and how to start your journey in the future of a decentralized internet.
• Overview of RadioButtonList ControlApr 15, 2025. Learn how to use RadioButtonList in ASP.NET WebForms, including its layout types (Horizontal, Vertical, Flow, Table), binding data from C# List, database tables, and manually added items. Also, discover JavaScript integration and best practices.
• Asynchronously Grouping Totals in MAUI [GamesCatalog] - Part 13Apr 14, 2025. Learn how to implement dynamic game status cards in MAUI using MVVM, data binding, and async methods. This covers creating UI components, grouping data by game status, and displaying totals on the main screen.
• React Tutorial For Beginners - Pass Data between Components (Parent to Child and Child to Parent)Apr 14, 2025. The user interface of every React application we develop, gets broken down into Components. Each React application we develop will be comprising of multiple components.
• Explaining Tanspose DataTable Data in C# Apr 09, 2025. Learn how to create and transpose a DataTable in ASP.NET Web Forms using C#. This guide covers table creation, manual data entry, HTML rendering, and dynamic data transposition using StringBuilder.
• Bring Your Data From Azure Data Lake Storage Gen2 to Power BIApr 09, 2025. Learn how to connect Azure Data Lake Storage Gen2 with Power BI to unlock powerful data visualization and insights. This guide helps you seamlessly import, transform, and analyze big data for smarter business decisions using Microsoft tools.
• Create an Amazon Bedrock Knowledge Base with Microsoft Teams DataApr 07, 2025. In this article, you will learn how to create and configure Amazon Bedrock Knowledge Base to connect to Microsoft Teams data.
• Transforming Data Insights with Snowflake's LLM Functions– Part 1Apr 07, 2025. In this article, I will cover the capabilities of Snowflake Cortex’s Large Language Model (LLM) function which can be utilize for variety of task such as sentiment analysis, text completion and language translation.
• AI in the Office of the CFOApr 06, 2025. CFOs must lead AI-driven transformation using LLMs and PT-SLMs for smarter finance, risk control, and ROI. Embrace AI as a strategic asset with strong governance, cross-functional alignment, and long-term value.
• Building Your First API with FlaskApr 02, 2025. Learn how to build a simple student management API using Flask in Python. This guide covers CRUD operations (GET, POST, PUT, DELETE), API endpoints, JSON responses, and testing with Postman for a hands-on learning experience.
• Responsible AI in Practice: From Ethics to ImplementationApr 02, 2025. In this article, I explore the practical implementation of responsible AI by moving beyond ethical theory and focusing on actionable strategies that organizations can adopt.
• Viewing the Content of Spark DataFrames in Fabric NotebookApr 02, 2025. Discover techniques to preview, filter, and analyze large datasets using Apache Spark. Whether you're working with PySpark or big data processing, enhance your workflow with efficient DataFrame visualization.
• The Role of Data in Artificial IntelligenceApr 01, 2025. Artificial Intelligence (AI) thrives on data. Without quality data, even the most sophisticated AI algorithms can't deliver accurate results.
• Big Data and AI: Advanced Analytics and InsightsApr 01, 2025. The fusion of big data and artificial intelligence (AI) is revolutionizing industries by providing organizations with profound insights, enabling them to predict future trends and automate complex decision-making processes. As data continues to grow exponentially.
• Implementing Data Protection and Encryption with System.Security.CryptographyMar 30, 2025. Learn how to implement data protection and encryption in C# using the System.Security.Cryptography namespace.
• Best Practices for Azure Table StorageMar 30, 2025. Learn the best practices for optimizing Azure Table Storage, from partitioning strategies to query performance enhancements, ensuring scalable and cost-effective data management in the cloud.
• Exploring PLINQ (Parallel LINQ) for Parallel ProcessingMar 29, 2025. PLINQ (Parallel LINQ) is a powerful feature in .NET that enables parallel processing of queries to improve performance on multi-core processors.
• Creating DataFrames in PySpark Using Fabric NotebookMar 27, 2025. This article walks through defining schemas, specifying column names, and using SQL-like DDL in a Fabric Notebook. Explore StructType, StructField, and various ways to display and verify DataFrame content efficiently.
• Enhancing SharePoint: New Features in Microsoft Lists FormsMar 27, 2025. This article covers new features such as conditional branching, logo addition, support for additional field types, and more. Learn how these updates can streamline your workflow and improve the user experience.
• Introduction to Managing Connections and Gateways in Power BIMar 27, 2025. Learn how to efficiently manage connections and gateways in Power BI, including on-premises and virtual network data gateways.
• Prevent Accidental Data Deletion with Two Simple StrategiesMar 25, 2025. Recently, I came across several discussions on Communities where users shared their experiences with accidental data deletion.
• Understanding System-Versioned Tables in SQLMar 25, 2025. System-versioned tables in SQL automatically track data changes, maintaining historical records for auditing and recovery. They consist of a main table (current data) and a history table (past records).
• Configure Retention Policies for Microsoft TeamsMar 25, 2025. This article gives a simple guide on how to plan and set up retention policies in Microsoft Teams. You will learn how to manage what content to keep, apply policies to specific areas, and make sure you follow the rules while getting rid of old data.
• Trigger Fabric Data Pipeline from ADF/Synapse via Managed IdentityMar 24, 2025. Learn how to trigger a Fabric Data Pipeline from Azure Data Factory or Synapse Pipeline using Managed Identity for secure authentication.
• Automating SCD Type 4 in Azure SQL Database with Azure Data FactoryMar 24, 2025. Learn how to automate Slowly Changing Dimension (SCD) Type 4 implementation in Azure SQL Database using Azure Data Factory.
• Understanding the Difference Between Encryption and Data MaskingMar 24, 2025. In today’s digital landscape, protecting sensitive information is a top priority for organizations. Two widely used techniques for securing data are Encryption and Data Masking. This article explores the key differences between encryption and data masking, their use cases, and their advantages.
• Evolution of Web Scraping: Insights from John Godel on the Enhanced HtmlFetcher ClassMar 24, 2025. In the ever-evolving landscape of web development, efficiently retrieving and parsing web data has become crucial. Recently, I had the opportunity to delve into a sophisticated yet efficient C# class that achieves this goal: the HtmlFetcher class.
• How to Use the Sort Function in Power Apps with Dynamic Column Values from a SharePoint ListMar 22, 2025. This article covers features, advantages, disadvantages, and step-by-step instructions to enhance your data management and user experience.
• Efficiently Splitting SharePoint Column Values Using Power Apps Split FunctionMar 20, 2025. This article explores how to use the Split function in Power Apps to dynamically extract and display the first and last names from a full name stored in a SharePoint list's people picker column.
• How to Become a Data ScientistMar 21, 2025. This article explores the path to becoming a data scientist, covering what essential skills are required, like Python, Machine Learning, Data Analysis, and AI/ML Engineering.
• ASP.NET Session State: Storing Data Beyond IIS RestartsMar 20, 2025. ?To maintain ASP.NET sessions after an IIS restart, configure the session state to use SQL Server, State Server, or a distributed cache like Redis instead of the default in-memory storage.
• Understanding HashSet in C#Mar 20, 2025. A HashSet<T> in C# is a collection that stores unique elements with fast lookups. It supports set operations like union, intersection, and difference while offering better performance than List<T> for searches.
• Databricks Genie: Unlocking AI-Powered Data Insights with OpenAIMar 20, 2025. Databricks Genie is a conversational AI assistant powered by Azure OpenAI to enable self-service analytics, and conduct data exploration using natural language questions to produce data-driven insights.
• Handling Slowly Changing Dimensions (SCD) in Azure Data WarehouseMar 17, 2025. This article explains how to handle Slowly Changing Dimensions (SCD). Type 1, Type 2, Type 3, Type 4, and Type 6—explaining how data looks before and after each type is applied.
• Implementing SCD Type 4 in Azure SQL Database: A Step-by-Step GuideMar 16, 2025. Learn how to implement SCD Type 4 in Azure SQL Database using a structured approach with staging, dimension, and history tables. This guide covers real-world use cases, SQL implementation, and execution scenarios for efficient historical data management.
• Using Spark to Read and Write Data in Microsoft Fabric Data WarehouseMar 10, 2025. Using the Spark Connector for Microsoft Fabric Data Warehouse to enable data engineers to directly read and write data in Fabric Data Wareousing using Spark notebooks. This eliminates the need for complex ETL processes or intermediary storage.
• Protecting Sensitive Data in ASP.NET Core 9 with Azure Key VaultMar 10, 2025. This article describes what is Azure key vault and manage the secrets using it. Additionally, it demonstrates how to implement it in ASP.NET Core 9 application.
• Keyset Pagination in Entity Framework Core for Efficient Data RetrievalMar 10, 2025. In this article, I will provide a comprehensive overview of Keyset Pagination in Entity Framework Core, highlighting its benefits, implementation strategies, and a performance comparison with traditional pagination methods
• Arrow-Optimized Python UDFs in PySpark: Boosting PerformanceMar 09, 2025. Apache Arrow’s in-memory columnar format to speed up data transfer between Python and the JVM, reducing serialization/deserialization overhead.
• 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.
• Secure AI Model Deployment with Azure Confidential ComputingFeb 27, 2025. Azure Confidential Computing provides a secure environment for AI model deployment by leveraging hardware-based Trusted Execution Environments (TEEs) like Intel SGX and AMD SEV.
• Azure SQL Database: Scalable & Secure Cloud SolutionFeb 26, 2025. Azure SQL Database is a fully managed cloud database service by Microsoft, offering high availability, scalability, security, AI-driven performance tuning, automated backups, threat protection, and seamless integration with Azure services.
• Data Consistency in ASP.NET Core Microservices with LocksFeb 24, 2025. This article explores how to use distributed locks to manage concurrent operations, prevent race conditions, and maintain data integrity across microservices efficiently.
• Web Scraping Using PythonFeb 21, 2025. Learn how to scrape book details like titles, prices, and ratings from 'Books to Scrape' using Python. This guide covers web scraping basics, data extraction, and enhancements for efficient data handling.
• Create Schema Zip Using CDS Configuration Migration Tool for D365Feb 20, 2025. Create Schema zip file using Common Data Service Configuration Migration tool for D365 to imported the record using tool
• Feature-Rich User Management System in AngularFeb 18, 2025. Build a modern User Management System using Angular with advanced features like theme switching, undo/redo functionality, CRUD operations, data export, form validation, and responsive design for an enhanced user experience.
• Synthetic Data Generation for AI Model Training on AzureFeb 18, 2025. Synthetic data generation is essential for AI model training, especially on Azure. It helps create diverse, high-quality datasets while preserving privacy and overcoming data limitations.
• Create Storage Account and Move Files Using ADF ActivityFeb 17, 2025. Learn how to create an Azure Storage Account, set up Azure Data Factory (ADF), and efficiently move files between folders using ADF activities.
• Data Science Applications: Powering Business Intelligence & Driving InnovationFeb 17, 2025. Data science applications are transforming businesses by turning raw data into strategic insights that drive growth and innovation.
• Security Best Practices in ASP.NET CoreFeb 14, 2025. Secure your ASP.NET Core app with HTTPS, JWT, OAuth2, and API keys. Prevent SQL injection, XSS, and CSRF attacks. Use encryption, logging, monitoring, and secure file uploads. Keep dependencies updated for continuous security.
• Error Handling in Python: Try, Except, and BeyondFeb 14, 2025. Error handling in Python is crucial for building robust applications. This article explores the try, except, else, and finally blocks to effectively manage exceptions and improve code reliability.
• Explaining Aggregate Functions in SQLFeb 14, 2025. Learn about SQL Aggregate Functions like SUM, COUNT, AVG, MIN, and MAX. These functions help perform calculations on grouped data, such as finding totals, averages, and minimum or maximum values, making data analysis more efficient.
• Creating a ListView MAUI MVVM .NET 9 [GamesCatalog] - Part 2Feb 14, 2025. Create a MAUI .NET 9 project that displays game information using a ListView. Bind a ViewModel with an ObservableCollection of UIIGDBGame items, and design a clean UI using XAML, Grid, and custom styling for a game catalog.
• A C# 13 Tip for building Data Transfer Objects (DTOs) Using RecordsFeb 12, 2025. C# records, introduced in C# 9 and improved in C# 13, offer immutable data models ideal for DTOs. They provide value semantics, concise syntax, automatic method generation, and enhanced data integrity for clean, maintainable code.
• Introduction to Azure AI FoundryFeb 11, 2025. Azure AI Foundry is a powerful platform by Microsoft that simplifies AI development, offering pre-built models, seamless Azure integration, custom model support, and enterprise scalability for industries like healthcare, finance, retail, and manufacturing.
• Getting Started with dbt (Data Build Tool) in Microsoft FabricFeb 10, 2025. In this article, we will learn how to get started with DBT (Data Build Tool) in Microsoft Fabric for efficient data transformation and modeling.
• Databricks Unity Catalog: Mastering Metastore and NamespaceFeb 10, 2025. Databricks Unity Catalog provides a unified governance layer with a three-level namespace (Catalog, Schema, Table) for efficient data organization, access control, and sharing across workspaces, improving security and collaboration.
• Data Maturity Assessment: Where Does Your Company Stand?Feb 09, 2025. A Data Maturity Assessment helps organizations evaluate their data management capabilities, identify gaps, and improve decision-making. Advancing through maturity levels ensures better governance, analytics, AI adoption, and business success.
• List Azure Backup Jobs Using C# Async MethodFeb 08, 2025. Azure Backup is a secure, scalable service for protecting VMs, databases, and on-premises data. It automates backups, ensures compliance, supports Geo-Redundant Storage (GRS), and enables recovery via the Azure SDK for .NET or PowerShell.
• Reduce NULL Storage in SQL Server with Sparse ColumnsFeb 05, 2025. SQL Server Sparse Columns optimize storage by not allocating space for NULL values, improving efficiency. They support filtered indexes and column sets for dynamic queries but add a 4-byte overhead for non-NULL values, requiring careful use.
• What Is a Data Strategy and Why Does It Matter?Feb 05, 2025. A data strategy is a comprehensive plan for managing and utilizing data to drive business decisions. It includes data collection, storage, analysis, and governance.
• Privacy-Preserving AI with Differential Privacy in Azure Machine LearningFeb 05, 2025. This aticle explores Azure Machine Learning’s privacy-preserving techniques, including noise addition, private model training, and compliance with GDPR and HIPAA regulations.
• Mitigate OWASP A02 2021-Cryptographic Failures Web Security TipsFeb 04, 2025. ADO.NET offers low-level access to databases using SQL commands, while EF is an Object-Relational Mapping (ORM) tool that simplifies database operations by mapping objects to database tables, offering higher-level abstractions.
• Set up dbt for Fabric SQL DatabaseFeb 04, 2025. Learn how to set up and use the dbt-sqlserver adapter for Microsoft Fabric SQL Database to transform data, run models, and validate results using dbt’s SQL-based transformation framework.
• ADO.NET vs Entity Framework: Understanding the DifferencesFeb 03, 2025. This article compares ADO.NET and Entity Framework (EF), two popular data access technologies in .NET. It explores their differences in performance, data manipulation, and development approaches like code-first vs database-first, helping developers choose the right tool for their application needs.
• Unlocking the Power of SQL for ETL Feb 03, 2025. SQL is crucial in ETL processes, enabling data extraction, transformation, and loading into databases, data warehouses, or lakes. It helps in real-time analytics, reporting, and machine learning, making it essential for data engineers.
• Data Build Tool (DBT) - KickstartFeb 03, 2025. dbt (Data Build Tool) transforms raw data in warehouses using SQL, automating workflows in ELT pipelines. It supports models, tests, snapshots, documentation, incremental processing, and version control, ensuring efficient data engineering.
• Installing and Using GitHub Copilot in Azure Data StudioJan 31, 2025. Azure Data Studio helps manage databases and write SQL queries. With GitHub Copilot, it auto-suggests code completions, making complex SQL tasks easier, including writing queries, using JOINs, and generating reports efficiently.
• Understanding of Data Models with APIs in CosmosDB Using C# Jan 30, 2025. Azure Cosmos DB supported multiple data models and APIs. Cosmos DB provides a variety of data models, APIs, tools and flexibility needed to deliver robust, scalable solutions.
• Exploring Snowflake SQL New Capabilities Using SELECT StatementJan 29, 2025. Learn how to leverage new features for efficient data querying, optimization, and advanced analytics in Snowflake’s cloud data platform. Perfect for data professionals.
• Enhancing Blazor Virtualization for Large Data Sets in .NET 9Jan 29, 2025. Explore how virtualization in Blazor enhances performance for large data sets in .NET 9. Learn techniques to optimize rendering, improve scalability, and build high-performance web apps with Blazor's powerful features.
• JSON Data with Python in SQLite DatabaseJan 29, 2025. This article explores handling JSON data in an SQLite database using Python. It covers reading, inserting, and creating tables while leveraging Python’s standard `json` and `sqlite3` libraries for seamless integration.
• The Cybersecurity Frontier - Securing the Fifth Domain of WarfareJan 27, 2025. Cybersecurity has emerged as the fifth domain of warfare, impacting global security. It involves protecting critical infrastructure, countering cyberattacks, and leveraging AI, blockchain, and zero-trust models to enhance defense strategies.
• Understanding Precision in SQL Server CalculationsJan 24, 2025. Learn why SQL Server calculations can produce different results depending on the approach used. Discover how single-step and multiple-step calculations handle precision and rounding, and how to achieve consistent outcomes with explicit rounding.
• Real-Time Data and NCache: Keeping Your Data Fast and FreshJan 23, 2025. Learn what is real-time data and what are its characteristics. Learn how modern distributed caching solutions such as NCache can help us in building and managing modern real-time applications.
• How to Concatenate Dynamic Column Values in Power AppsJan 23, 2025. Learn to use the Concatenate function in Power Apps to combine dynamic column values in a gallery. Simplify data presentation, reduce redundancy, and enhance user experience with this versatile tool for custom business applications.
• How to Implement Search Function in PowerAppsJan 22, 2025. Learn how to implement a dynamic search function in Power Apps to filter data from sources like SharePoint. This article covers step-by-step instructions for adding search features, improving usability, and boosting app performance.
• Differences Between TRUNCATE and DELETE in SQL ServerJan 22, 2025. Learn the key differences between TRUNCATE and DELETE in SQL Server, two commands used to remove data from tables. Understand their syntax, performance impact, transaction logging, and use cases.
• Modern ADO .Net with SQLite in VB and C#Jan 22, 2025. This article demonstrates how to connect SQLite with ADO .NET in C# and VB, showcasing database operations such as creating tables, inserting records, and reading data. It uses the Microsoft.Data.Sqlite package in .NET Core environments.
• Mastering UseSeeding and UseAsyncSeeding in EF Core 9Jan 22, 2025. Explore the UseSeeding and UseAsyncSeeding methods in Entity Framework Core 9. Learn what they are, why they matter, when and where to use them, and how to implement them effectively with real-world examples.
• How to Encrypt Data in Amazon S3 Using Server-Side EncryptionJan 22, 2025. This article walks you through accessing your S3 bucket, enabling SSE-S3 encryption, uploading files, and verifying encryption. Protect sensitive information easily with default encryption settings in AWS.