Resources   No resource found

• 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.
• Updating an Object in the Local Database in MAUI .NET 9 [GamesCatalog] - Part 11Apr 03, 2025. Learn how to retrieve and update game statuses in a local database using MAUI .NET 9. Implement async functions in GameRepo and GameService, manage game status, and enhance UI interactions efficiently.
• 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.
• 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.
• Adding Objects to a Local Database in MAUI .NET 9 [GamesCatalog] - Part 10Apr 02, 2025. Learn how to store game reviews in a local SQLite database using MAUI .NET 9. This guide covers setting up repositories, handling images, adding games, and implementing dependency injection for seamless functionality.
• 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.
• 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.
• Setting Up and Using a Local SQLite Database in MAUI .NET 9 [GamesCatalog] - Part 9Mar 31, 2025. This article covers database integration, CRUD operations, and best practices for storing data locally in a cross-platform mobile application. Follow along to enhance your MAUI app with efficient data management.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• Understanding Numeric Functions in SQLMar 27, 2025. SQL numeric functions simplify mathematical operations like rounding, power calculations, and random value generation. Functions like ABS(), CEILING(), FLOOR(), ROUND(), SQRT(), MOD(), and LOG() help with financial calculations, data analysis, and scientific computing.
• Understanding Conversion Functions in SQLMar 27, 2025. SQL conversion functions like CAST(), CONVERT(), TRY_CAST(), TRY_CONVERT(), and FORMAT() help change data types, format values, and handle errors efficiently.
• Explanation of Date and Time Functions in SQLMar 26, 2025. SQL date and time functions help efficiently manipulate and retrieve date-related information. Common functions include GETDATE() for the current timestamp, DATEADD() for adding time intervals, DATEDIFF() for date differences, FORMAT() for formatting, and EOMONTH() for month-end dates.
• 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.
• 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).
• 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.
• 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.
• 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.
• 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.
• How to Become Data ScientistMar 21, 2025. This article explores the path to becoming a Data Scientist, covering essential skills like Python, Machine Learning, Data Analysis, and AI/ML Engineering.
• 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.
• 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.
• 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 SQL Execution PlansMar 20, 2025. An SQL execution plan outlines how a database executes a query, detailing operations like table scans, index seeks, and joins. Analyzing these plans is essential for optimizing query performance.
• 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.
• Explicit Loading in ASP.NET Core Web APIMar 18, 2025. Explicit Loading in ASP.NET Core Web API is a technique used to manually retrieve related data from the database when needed, using LoadAsync() on navigation properties. Unlike eager loading (Include()) or lazy loading, explicit loading provides better control over database queries, improving performance and efficiency. It is useful when related data is conditionally required.
• 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.
• Dynamic Database Web API in .NET 9: Clean Architecture & MediatR for FlexibilityMar 17, 2025. A Web API should support multiple database options such as SQL Server, PostgreSQL, MySQL, and SQLite without major code changes. In this article, we will build a .NET 9 Web API using Clean Architecture, Domain-Driven Design (DDD), and MediatR, while implementing dynamic database selection using Entity Framework Core (EF Core).
• 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.
• 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.
• 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.
• 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.
• Setting Up Microsoft Entra Service Principal for Azure RBAC and Connecting to Fabric SQL DatabaseMar 03, 2025. This article explains creating a Service Principal, assigning role-based access, and securely authenticating to the database, ensuring seamless integration and enhanced security in your Azure environment.
• 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.
• Understanding Azure CosmosDB Failures and How to Fix ThemFeb 24, 2025. Azure CosmosDB failures can impact application performance. Learn how to identify, debug, and resolve common issues like duplicate keys (11000) and shard key violations (16500) for optimal database performance and reliability.
• 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.
• How to Encrypt the SQLite DB File using AES Feb 17, 2025. using the AES Algorithm to encrypt the SQLite DB file. Learn how to encrypt an SQLite database file in .NET C# using AES encryption. This guide covers key generation, IV usage, hashing with SHA256, and secure file encryption using CryptoStream and FileStream.
• 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.
• Power of Dapper in .Net Core Feb 16, 2025. Dapper is a high-performance micro ORM for .NET Core, known for its speed and efficiency in database access. It simplifies SQL execution, object mapping, and data retrieval while maintaining flexibility.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• Most common GlideRecord objects in ServiceNowFeb 04, 2025. This article provides an overview of common GlideRecord methods in ServiceNow, which are essential for interacting with the platform's database. It covers key methods like querying, inserting, updating, deleting records, and managing permissions.
• Be Careful Using Distinct and OrderBy in EF Core QueriesFeb 03, 2025. Combining Distinct() and OrderBy() in EF Core queries can lead to performance issues. This article explains why and offers solutions for efficient data retrieval.
• 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.
• 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.
• 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.
• 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.
• How to Fix Recovery Pending State in MS SQL Server DatabaseJan 24, 2025. Learn about the causes of SQL Server's "Recovery Pending" state, methods to resolve it, and preventive measures. Explore manual fixes, recovery tools, and best practices to ensure database integrity.
• 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.
• 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.
• 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.
• 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.
• 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.
• How to Create A Pivot Table in PostgreSQLJan 22, 2025. This article covers using crosstab functions, grouping, and SQL queries to pivot rows into columns, making it easier to analyze complex datasets. Perfect for data analysis and reporting tasks in PostgreSQL.
• 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.
• 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.
• 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.
• How to Create and Attach an Amazon EBS Volume to an EC2 InstanceJan 22, 2025. Amazon Elastic Block Store (EBS) provides scalable, high-performance block storage for EC2 instances in AWS. EBS volumes offer reliable, fault-tolerant, and persistent storage for data, databases, and applications.
• Learn Quantifier Operations in LINQ Jan 21, 2025. Quantifier operations in LINQ simplify logical evaluations of collections using methods like `Any`, `All`, and `Contains`. They enhance readability, reduce boilerplate, and support efficient data validation and filtering.
• Introduction to Azure DevOpsJan 21, 2025. Azure DevOps is a SaaS platform from Microsoft offering tools for managing DevOps workflows. It integrates with popular tools, supporting CI/CD, version control, testing, and collaboration, available as a cloud-based or on-premises solution.
• Download and Installing Veeam Backup & ReplicationJan 20, 2025. Veeam Backup & Replication is a program that helps you save and recover data from computers, servers, and the cloud. It lets you set up automatic backups, store the data safely, and restore it if something goes wrong. It is easy to install and set up, making sure your important data is always protected.
• Error handling in AngularJan 19, 2025. Error handling in Angular ensures smooth user experiences and easier debugging. Techniques include HTTP errors, global handlers, interceptors, RxJS operators, guards for routes, user-friendly messages, retries, and external logging.
• Entity Framework (5-1), With .Net Core MVC, Database-First --- Scaffold-DbContextJan 18, 2025. This article is to discuss the reverse engineering command Scaffold-DbContext by AI.
• How to use SharePoint List Input Tool in AlteryxJan 16, 2025. Use Alteryx Designer to connect to SharePoint lists across versions (2007 to SPO). Configure the SharePoint Site URL, and credentials, and select the desired list and view. Filter data, limit records, and export to Excel using the output tool.
• SQL Server – Query Performance – Database Maintenance can HelpJan 14, 2025. To improve query performance in an ASP.NET MVC application using SQL Server, periodic database maintenance steps like updating statistics and defragmenting indexes are essential. This includes manual or automatic execution for optimal results.
• How to Configure Security Groups in AWS VPCJan 14, 2025. A Security Group in AWS is a virtual firewall controlling inbound/outbound traffic for resources like EC2 and RDS. It defines rules for IPs, ports, and protocols, ensuring secure access within your Virtual Private Cloud (VPC).
• Transaction in SQL ServerJan 13, 2025. This article covers the basics of SQL transactions, including BEGIN, COMMIT, and ROLLBACK commands, ACID properties, isolation levels, and error-handling techniques for effective database management.