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.
• 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.
• 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.
• 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.
• 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.
• 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 Parameter Sniffing in SQL ServerMar 24, 2025. In SQL Server and other relational database systems, query execution performance is critical for handling large datasets efficiently. One common yet sometimes problematic optimization technique is Parameter Sniffing. While it can improve query performance.
• 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.
• SQL Tag Library in Java Server PageMar 21, 2025. JSTL SQL tags are used to access databases and are designed for low-volume Web-based applications.? JSTL SQL tags facilitate database interactions in JSP pages, enabling data source setup, query execution, updates, and transactions through tags like <sql:setDataSource>, <sql:query>, <sql:update>, and <sql: transaction>
• 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.
• 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.
• 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.
• Understanding Expressions in C#: Dynamic Code and Query GenerationMar 19, 2025. Expressions in C# allow dynamic query generation, runtime compilation, and code transformation using Expression Trees. They are widely used in LINQ, ORM frameworks like Entity Framework, and reflection to optimize performance and enable flexible, data-driven logic.
• Understanding SQL CTE (Common Table Expression)Mar 19, 2025. A Common Table Expression (CTE) in SQL is a temporary result set that improves query readability and performance. CTEs simplify complex queries, support recursive operations, and help with aggregation and multi-step calculations.
• 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.
• Running Azure Resource Graph Queries in an Azure Logic AppMar 12, 2025. Learn how to run Azure Resource Graph queries within an Azure Logic App to automate resource management and gain insights into your Azure environment.
• 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
• 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.
• 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.
• Most Used GlideRecord Methods in ServiceNowFeb 27, 2025. GlideRecord is a powerful ServiceNow API used to interact with database tables. This article explores the most commonly used GlideRecord methods, helping developers query, retrieve, update, and manipulate records efficiently.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• Let's Play with ServiceNow Table API Using PostmanJan 10, 2025. Learn how to create and test a POST Table API in ServiceNow using Postman. Step-by-step guide covers API setup, JSON payload, authentication, headers, and testing, ensuring secure and efficient data handling with best practices.
• Python Data Analysis Package ExampleJan 09, 2025. Learn how to perform data analysis in Python using powerful packages like Pandas, NumPy, and Matplotlib. This example-driven guide demonstrates key steps, including data loading, cleaning, processing, and visualization.
• Implementing Azure Private Link for Microsoft FabricJan 09, 2025. Azure Private Link integrates with Microsoft Fabric to secure data by enabling private access within Azure’s network. It ensures compliance, prevents data leaks, supports services like Power BI, and boosts performance for organizations.
• How to Enable Cross-Region Replication in Amazon S3Jan 08, 2025. Learn how to enable Cross-Region Replication (CRR) in Amazon S3 to automatically replicate your data across AWS regions for better availability, disaster recovery, and compliance.
• Understand the Concept of Shallow Copy and Deep Copy in C#Jan 06, 2025. Learn the difference between shallow and deep copying in C#. Explore their behavior, implementation, and use cases with practical code examples, helping you make informed decisions for object duplication scenarios.
• Understanding Connected Disconnected Scenarios in EF Core MVCJan 06, 2025. This article explains the connected and disconnected scenarios in Entity Framework Core for ASP.NET Core MVC applications. It covers how EF Core handles data in these scenarios, including change tracking, entity states, and managing database contexts.
• SharePoint Data from Azure Function using Self Signed CertificateJan 04, 2025. This article covers configuring Azure Functions, setting up certificate-based authentication, and connecting to SharePoint Online, enabling secure integration for seamless data access.
• Blockchain Applications with Advanced Cybersecurity StrategiesJan 03, 2025. Blockchain security faces evolving cyber threats like phishing, smart contract vulnerabilities, and 51% attacks. Advanced strategies, including encryption, multi-signature wallets, and real-time monitoring, are essential to mitigate risks and ensure network resilience.
• How to Set Up DynamoDB in AWS?Jan 02, 2025. Amazon DynamoDB is a fully managed, serverless NoSQL database service offering fast performance, scalability, and flexibility. It supports key-value and document data models, with global availability and seamless integration with AWS services.
• Apply UI to Enhance Choice Fields with Conditional FormattingJan 02, 2025. Enhance SharePoint lists with UI Conditional Formatting. Use JSON to customize Choice Fields, changing colors, icons, and text dynamically based on values like "Done" or "In progress" for better data visualization.
• How to Add and Manage connections in Power Automate Jan 01, 2025. Learn how to add, manage, and secure connections in Power Automate. Integrate 500+ services like SharePoint, Excel, and Office 365 for seamless workflows, time-saving automation, and centralized management.