Resources   No resource found

• Benchmarking PostgreSQL 19 Beta Planner Changes with EF CoreAug 17, 2026. Benchmark PostgreSQL 19 Beta query planner changes with EF Core using realistic workloads, execution plans, query latency, throughput, and database performance metrics.
• Benchmarking EF Core Compiled Queries on Large Production-Style DatasetsAug 17, 2026. Benchmark EF Core compiled queries on large production-style datasets to measure query execution time, allocations, throughput, and performance improvements under realistic workloads.
• PostgreSQL 19 JSONB Query Performance: What Changed?Aug 17, 2026. Explore PostgreSQL 19 JSONB query performance changes by benchmarking JSONB workloads, query execution, indexing behavior, latency, and optimization opportunities for applications.
• Benchmarking PostgreSQL 18 vs 19 Beta for Write-Heavy .NET APIsAug 17, 2026. Compare PostgreSQL 18 and PostgreSQL 19 Beta for write-heavy .NET APIs using transaction throughput, query latency, EF Core workloads, resource usage, and performance benchmarks.
• Benchmarking Local Speech-to-Text with Foundry Local and C#Aug 14, 2026. Benchmark local speech-to-text with Microsoft Foundry Local and C#, comparing transcription latency, CPU usage, memory consumption, accuracy, and offline performance.
• Testing PostgreSQL 19 Beta Against Production-Like .NET QueriesAug 14, 2026. Test PostgreSQL 19 Beta with production-like .NET queries to evaluate query performance, execution plans, compatibility, concurrency, and database behavior under realistic workloads.
• Building Data Lineage Pipelines for PostgreSQL AI WorkloadsAug 14, 2026. Build data lineage pipelines for PostgreSQL AI workloads to track data movement, transformations, dependencies, and provenance for better governance and AI observability.
• High-Performance Architecture and Full-Stack Delivery with OutSystemsAug 13, 2026. In an era where digital transformation dictates business survival, enterprise IT departments face a persistent challenge: demand for custom, mission-critical software far outpaces the capacity of traditional engineering teams. While hand-coding using frameworks like React, Angular, or .NET microservices provides granular control, it often comes at the cost of prolonged development cycles, integration friction, and accumulating technical debt.
• Largest Odd-Sized Square with At Most K OnesAug 11, 2026. Efficiently find the largest odd-sized square with at most k ones in a binary matrix using 2D prefix sums and binary search.
• Benchmarking JSON Union Serialization in .NET 11Aug 11, 2026. Benchmark C# 15 union types with .NET 11 System.Text.Json for API contracts. Measure serialization, deserialization, payload size, and compatibility.
• EF Core 11 Query Translation Changes Under Real WorkloadsAug 11, 2026. Evaluate EF Core 11 query translation changes with real workloads. Learn to benchmark, inspect SQL, and analyze execution plans for optimal performance.
• Benchmarking JSON Lines Serialization in .NET 11Aug 10, 2026. Explore .NET 11's native JSON Lines support for efficient record-oriented data processing. Benchmark performance, memory, and streaming for large datasets.
• Full Outer Joins in LINQ: Performance and SQL TranslationAug 10, 2026. Explore .NET 11's FullJoin in LINQ for explicit full outer joins. Optimize database queries with EF Core translation and understand performance implications.
• SQL Server Vector Search: Benchmarking EF Core WorkloadsAug 10, 2026. Benchmark SQL Server vector search with EF Core. Explore exact vs. approximate search, performance factors, and best practices for RAG.
• Zero-Impact Data Tracking: How SQL Server Change Data Capture Works at the Log LevelAug 05, 2026. SQL Server CDC tracks row changes asynchronously via the transaction log, offering zero-impact auditing, event streaming, and synchronization.
• How Enterprise Applications Leverage SQL Server Temporal Tables for Time-Travel Auditing and ComplianceAug 05, 2026. SQL Server Temporal Tables offer built-in time-travel auditing & compliance for enterprises, simplifying data history management.
• Building an Azure SQL to Dataverse Migration Solution with the New Dataverse SDK for PythonAug 06, 2026. Build an Azure SQL to Dataverse migration solution using the new Dataverse SDK for Python. Integrate enterprise data seamlessly.
• Designing Tenant-Isolated Vector Search for SaaS ApplicationsAug 06, 2026. Design secure, tenant-isolated vector search for SaaS. Learn architectures, retrieval patterns, and best practices for AI applications.
• How to Resolve SQL Server Error 40 ("Could Not Open a Connection to SQL Server")Aug 04, 2026. Resolve SQL Server Error 40 in ASP.NET Core. Troubleshoot connection issues with Entity Framework Core, connection strings, and configuration.
• Benchmarking Embedding Models for Enterprise Semantic Search ApplicationsAug 04, 2026. Benchmark embedding models for enterprise semantic search & RAG. Optimize accuracy, latency, and cost with a .NET framework.
• Comparing GraphRAG and Traditional RAG for Enterprise Knowledge RetrievalAug 04, 2026. GraphRAG enhances enterprise knowledge retrieval by combining vector search with knowledge graphs for complex, multi-hop queries.
• Production Caching Strategies for Vector Search ApplicationsAug 04, 2026. Optimize vector search apps with multi-tier Redis caching. Slash latency to <10ms & cut API costs by up to 60%.
• Cost Benchmarking Vector Databases for Enterprise RAG WorkloadsAug 03, 2026. Benchmark vector databases for enterprise RAG workloads. Optimize costs by evaluating storage, query performance, and operational overhead.
• Generative Engine Optimization (GEO) Strategies for AI Search VisibilityAug 03, 2026. Master Generative Engine Optimization (GEO) to boost AI search visibility. Learn strategies for trustworthy content selection in AI-generated answers.
• Dissect a cluster index in the SQL serverAug 01, 2026. Understand SQL Server's Clustered Index: how it physically orders data, its properties, and the performance boost it offers over heaps.
• SQL Server Indexing Strategies for Large OLTP SystemsJul 31, 2026. Master SQL Server indexing for large OLTP systems. Optimize queries, reduce scans, and boost performance with practical strategies.
• Benchmarking JSON Serialization Options in .NET 11Jul 31, 2026. Compare .NET JSON serializers: System.Text.Json, Source Generation, and Newtonsoft.Json. Benchmark for optimal performance.
• SQL Server Performance Troubleshooting: 10 Queries Every Developer Should KnowJul 29, 2026. Master SQL Server performance with 10 essential queries for developers. Troubleshoot bottlenecks, optimize queries, and ensure application responsiveness.
• 10 Common SQL Interview Questions Every Developer Should KnowJul 29, 2026. Master SQL interviews with 10 essential questions on DELETE, WHERE, JOINs, UNION, keys, CHAR/VARCHAR, indexes, COUNT, stored procedures & normalization.
• Construct a Full Binary Tree from Preorder and Mirror Preorder Traversal Jul 27, 2026. Construct a full binary tree from preorder and mirror preorder traversals. Learn the unique reconstruction method for full binary trees.
• Vector Databases with .NET: PostgreSQL pgvector vs Azure AI Search vs QdrantJul 24, 2026. Compare PostgreSQL pgvector, Azure AI Search, and Qdrant for .NET AI apps. Choose the best vector database for RAG, semantic search, and more.
• Building RAG Applications in C# with Semantic Kernel and Azure AI SearchJul 24, 2026. Build C# RAG apps with Semantic Kernel & Azure AI Search. Ground LLMs in your data for accurate, context-aware responses.
• Understanding EXPLAIN FORMATTED in Databricks SQLJul 23, 2026. Master Databricks SQL query optimization with EXPLAIN FORMATTED. Uncover Spark's execution plans, identify bottlenecks, and tune performance.
• Check if an Array Can Represent Preorder Traversal of a BSTJul 23, 2026. Learn how to validate if an array represents a BST's preorder traversal using a stack and lower bound logic. Efficient O(n) solution.
• Entity Framework Core Performance Anti-Patterns in ProductionJul 23, 2026. Master EF Core performance! Avoid common anti-patterns like N+1 queries, over-fetching, and client-side evaluation for faster, scalable .NET apps.
• SQL Server Query Performance Troubleshooting Guide for .NET DevelopersJul 23, 2026. Master SQL Server query performance for .NET apps. Learn to troubleshoot, optimize indexes, and write efficient queries for faster responsiveness.
• Minimum Deletions to Make Sorted (Java)Jul 22, 2026. Find the minimum deletions to make an array strictly increasing by calculating the Longest Increasing Subsequence (LIS) efficiently.
• SQL Server Temporal Tables ExplainedJul 22, 2026. Master SQL Server Temporal Tables for automatic data history tracking, point-in-time recovery, and simplified auditing. Learn creation, querying, and best practices.
• Understanding SHOWPLAN_ALL in SQL Server and Microsoft FabricJul 21, 2026. In this article, you'll learn hoe to master SQL Server's SHOWPLAN_ALL for query optimization. Understand execution plans, avoid pitfalls, and tune for peak performance.
• Building AI-Powered Search with SQL Server and Vector IndexesJul 21, 2026. Unlock AI-powered search in SQL Server 2026 with vector indexes. Discover semantic search, natural language queries, and enhanced relevance for modern applications.
• SQL Server Query Store: Monitoring and Fixing Slow QueriesJul 21, 2026. SQL Server Query Store: Monitor, diagnose, and fix slow queries with historical data, execution plans, and performance metrics.
• Building Semantic Search Applications with PostgreSQL pgvector and ASP.NET CoreJul 20, 2026. Build intelligent search apps with PostgreSQL pgvector & ASP.NET Core. Understand meaning, not just keywords, for better user experiences.
• SQL Server Query Performance Tuning Using Execution PlansJul 20, 2026. Master SQL Server query performance tuning with execution plans. Identify bottlenecks, optimize indexes, and improve database speed.
• Blazor Web Apps in .NET 11: What's New for Full-Stack DevelopmentJul 20, 2026. Explore Blazor Web Apps in .NET 11: new features for faster performance, enhanced developer productivity, and seamless full-stack C# development.
• JWT Session 11: Replace Hardcoded Login with EF Core Database Authentication in ASP.NET Core Web APIJul 19, 2026. Replace hardcoded login with EF Core database authentication in ASP.NET Core Web API for secure user management and JWT generation.
• Cut Matrix: A Deep Dive into the DP + Binary Search SolutionJul 18, 2026. Master the Cut Matrix problem with DP + Binary Search. Learn to slice grids into k valid pieces efficiently, optimizing cuts for speed.
• Vector Databases Explained: How Semantic Search Works in Modern ApplicationsJul 16, 2026. Unlock semantic search with vector databases. Understand how embeddings power AI apps, from RAG to recommendations, for context-aware results.
• Vector Databases vs Traditional Databases: Choosing the Right Storage for AI ApplicationsJul 16, 2026. Explore vector vs. traditional databases for AI. Learn their strengths, use cases, and how to choose the right storage for your intelligent applications.
• Part 2: Knowledge Representation and Reasoning in AIJul 15, 2026. A practical explanation of classical AI foundations, including search algorithms, knowledge graphs, ontologies, rule-based systems, and why explicit programming falls short.
• Apache DataFusion Tutorial: Building High-Performance Query Engines in RustJul 16, 2026. Learn Apache DataFusion fundamentals, architecture, and query execution. Build high-performance analytical applications and custom query engines in Rust.
• SurrealDB Tutorial: Combining Relational, Document, and Graph DatabasesJul 16, 2026. Learn how SurrealDB combines relational, document, graph, and real-time database capabilities into a single platform for modern application development.
• DuckDB Tutorial: Building Analytics Applications Without a Data WarehouseJul 15, 2026. Learn how DuckDB enables fast analytics without a traditional data warehouse. Explore architecture, use cases, benefits, and implementation tips.
• OpenSearch vs Elasticsearch: Which Search Platform Should You Choose?Jul 15, 2026. Compare OpenSearch and Elasticsearch to understand architecture, features, licensing, scalability, and use cases for modern search and analytics applications.
• Building Production-Ready RAG Applications with Azure AI Search and .NETJul 14, 2026. Build production-ready RAG apps with Azure AI Search & .NET. Enhance LLMs with your data for accurate, context-aware responses.
• Building a Memory Layer for AI Agents Using PostgreSQL and Semantic SearchJul 14, 2026. Build AI agent memory with PostgreSQL & semantic search. Enhance context, personalization, and recall for smarter AI applications.
• Building an AI-Powered Knowledge Base Using Vector Databases and C#Jul 14, 2026. Build AI-powered knowledge bases with C# & vector databases for semantic search, understanding user intent & delivering accurate, context-aware answers.
• Full-Stack AI Applications with Next.js, ASP.NET Core, and OpenAIJul 14, 2026. Build full-stack AI apps with Next.js, ASP.NET Core, and OpenAI. Learn architecture, integration, and best practices for scalable, secure AI solutions.
• Qdrant Tutorial: Building High-Performance Semantic Search ApplicationsJul 13, 2026. Learn Qdrant for high-performance semantic search. Understand embeddings, build RAG apps, and unlock intelligent search beyond keywords.
• Building Production-Ready RAG Pipelines with Azure AI Search and .NETJul 13, 2026. Build production-ready RAG pipelines with Azure AI Search and .NET for accurate, context-aware AI responses using your own data.
• Building Search Applications with Qdrant Vector Database and .NETJul 10, 2026. Build intelligent search apps with Qdrant vector database and .NET. Learn semantic search, RAG, and AI-powered retrieval for faster, relevant results.
• Building Enterprise Knowledge Assistants with Azure AI SearchJul 10, 2026. Build enterprise knowledge assistants with Azure AI Search for faster, accurate answers. Leverage RAG and LLMs for intelligent, secure information retrieval.
• SurrealDB Explained: Combining SQL, Graph, and Document DatabasesJul 09, 2026. SurrealDB unifies SQL, graph, and document databases for modern apps. Simplify architecture with a single, multi-model solution.
• HTTP QUERY Method: Why It Finally Fixes Search APIsJul 07, 2026. Introducing the HTTP QUERY method: a revolutionary fix for search APIs, combining GET's safety with POST's body capabilities for efficient, reliable data retrieval.
• Meilisearch vs Elasticsearch: Which Search Engine Is Right for Your Application?Jul 08, 2026. Meilisearch vs. Elasticsearch: Compare features, architecture, and use cases to choose the right search engine for your application's needs.
• Understanding Vector Embeddings: The Foundation of Modern AI SearchJul 08, 2026. Unlock the power of modern AI search with vector embeddings. Understand how they represent meaning, enable semantic search, and drive RAG applications.
• Building Full-Stack Applications with Hono and Cloudflare EcosystemJul 07, 2026. Build fast, scalable full-stack apps with Hono & Cloudflare. Leverage edge computing, serverless databases, and global infrastructure.
• DuckDB Tutorial: Getting Started with the Fastest Analytics DatabaseJul 06, 2026. Master DuckDB! Learn to install and use this lightning-fast, serverless analytics database for efficient data analysis and reporting.
• OpenSearch vs Elasticsearch: Key Differences, Performance, and CostsJul 06, 2026. OpenSearch vs Elasticsearch: Explore key differences in licensing, features, performance, and costs to choose the right search & analytics platform.
• How Vector Search Powers Modern AI Applications and RAG SystemsJul 06, 2026. Unlock AI's potential with vector search! Discover how it powers modern applications, RAG, and semantic understanding beyond keywords.
• HTTP QUERY: The New HTTP Method That Makes Complex Searches CleanerJul 04, 2026. HTTP QUERY is a new method for cleaner, complex searches, combining POST's body flexibility with GET's safety and cacheability.
• HTTP QUERY: The Missing Piece Between GET and POST, 16 Years in the MakingJul 05, 2026. Introducing HTTP QUERY: the new standard method solving API search limitations. It combines GET's safety with POST's payload capacity, fixing a 16-year-old design gap.
• Building a Search Platform Using OpenSearch and .NETJul 03, 2026. Build powerful search platforms with OpenSearch and .NET. Learn about its architecture, indexing, querying, and advanced features for scalable, relevant search.
• Graph Databases vs Relational Databases: Choosing the Right ModelJul 03, 2026. Graph vs. Relational Databases: Understand strengths, weaknesses, and use cases to choose the right data model for your application.
• PostgreSQL vs SQL Server for Modern .NET ApplicationsJul 02, 2026. Compare PostgreSQL vs SQL Server for .NET apps. Explore licensing, performance, cloud, JSON, and scalability to choose the best fit.
• How to Convert Text into Currency ($) Format in Power AppsJul 01, 2026. Learn to format numbers as currency in Power Apps using the Text() function for professional and readable financial data display.
• Building AI-Powered Database Query Optimization Tools with SQL Server and .NETJun 30, 2026. Build AI-powered SQL Server query optimization tools with .NET. Automate performance analysis, detect bottlenecks, and get intelligent recommendations.
• Building Intelligent API Discovery Portals with ASP.NET Core and Vector SearchJun 30, 2026. Build intelligent API discovery portals with ASP.NET Core and vector search. Enhance developer productivity by enabling semantic API search.
• Creating an AI-Powered API Documentation Assistant with ASP.NET Core and Vector SearchJun 30, 2026. Build an AI-powered API documentation assistant using ASP.NET Core and vector search for faster, contextual answers.
• Building an AI-Driven Database Query Performance Analyzer with .NET and SQL ServerJun 30, 2026. Build an AI-driven .NET and SQL Server analyzer to boost database query performance, reduce troubleshooting time, and enhance application responsiveness.
• Implementing an AI-Powered Knowledge Base Search System with ASP.NET Core and Azure AI SearchJun 30, 2026. Build an AI-powered knowledge base search with ASP.NET Core & Azure AI Search. Enhance productivity with semantic search & RAG.
• Microsoft Fabric Update: You Can Now Adjust Column Width in the SQL Analytics Endpoint User InterfaceJun 26, 2026. This article is about the new feature in Microsoft Fabric that allows you to adjust column width
• Intelligent Database Index Optimization Using AI and SQL ServerJun 26, 2026. Leverage AI and SQL Server DMVs with .NET to build intelligent index optimization, boosting performance and reducing manual tuning.
• Building AI-Powered SQL Query Performance Advisors with Entity Framework CoreJun 26, 2026. Build AI-powered SQL query advisors with Entity Framework Core to automatically detect bottlenecks, optimize performance, and boost application responsiveness.
• Role of Hilbert Curve in LLMs: What It Is and How It Improves Data Organization and RetrievalJun 24, 2026. Learn what the Hilbert Curve is and how it helps Large Language Models (LLMs) organize, store, retrieve, and process high-dimensional data more efficiently. Explore its role in vector databases, embeddings, retrieval systems, and AI infrastructure.
• Why Every Databricks Data Engineer Should Audit Their Query HistoryJun 24, 2026. Audit Databricks query history to identify and optimize costly, long-running queries, ensuring financial governance and platform performance.
• How to Build AI-Powered Engineering Knowledge Assistants with BlazorJun 24, 2026. Build AI-powered engineering knowledge assistants with Blazor & ASP.NET Core for faster access to crucial information.
• Maximum Number of People DefeatedJun 23, 2026. Find the max people defeated by strength p. Uses sum of squares formula & binary search for efficient O(log n) solution.
• Building AI-Powered Enterprise Search Validation PipelinesJun 23, 2026. Build AI-powered enterprise search validation pipelines in ASP.NET Core to ensure accurate, trustworthy, and actionable information delivery.
• Designing AI-Aware Database Architectures for Enterprise ApplicationsJun 22, 2026. Design AI-aware database architectures for enterprise apps. Explore .NET strategies for semantic search, vector storage, and knowledge management.
• Hybrid Retrieval (BM25 + Vector + Reranking) with LangGraphJun 18, 2026. Build a Hybrid RAG pipeline with LangGraph: BM25 + Vector Search + Reranking for efficient, parallel retrieval.
• Building an Inventory & Order Management System in ASP.NET Core (Setup & Core Features) Part 1Jun 19, 2026. Build an ASP.NET Core Inventory & Order Management System. Part 1 covers project setup, core features like Product, Category, Supplier, and Customer CRUD.
• 📖 Building a Web-Based Timesheet Management System in ASP.NET CoreJun 19, 2026. Build a robust ASP.NET Core MVC timesheet system with SQL Server. Features include entry, allocation, approvals, auth, reporting & deployment.
• Building Internal AI Knowledge Hubs for Development TeamsJun 17, 2026. Build internal AI knowledge hubs for dev teams to boost productivity. Centralize docs, code, and tickets for instant, natural language answers.
• Building AI-Powered SQL Assistants with Semantic Kernel and .NETJun 16, 2026. Build AI-powered SQL assistants with Semantic Kernel and .NET to unlock data insights. Empower users with natural language queries and secure data access.
• Hybrid Retrieval in Azure AI Search: Combining Vector, Keyword, and Semantic RankingJun 16, 2026. Boost RAG accuracy with Azure AI Search's hybrid retrieval: combining vector, keyword, and semantic ranking for superior AI responses.
• How to Build an Internal Knowledge Assistant Using Azure AI Search and BlazorJun 16, 2026. Build an internal knowledge assistant with Azure AI Search & Blazor for efficient, AI-powered information retrieval and conversational access.
• Building AI-Powered API Documentation Assistants with .NETJun 16, 2026. Build AI-powered API documentation assistants with .NET, Azure AI Search, and Azure OpenAI for enhanced developer productivity and accessibility.
• How to Design AI-Friendly Database Schemas for Knowledge Retrieval SystemsJun 16, 2026. Optimize AI knowledge retrieval by designing AI-friendly database schemas. Learn best practices for chunking, metadata, embeddings, and security.
• Building AI-Powered Engineering Portals with ASP.NET Core and BlazorJun 16, 2026. Build AI-powered engineering portals with ASP.NET Core & Blazor. Centralize knowledge, boost productivity, and accelerate software delivery.
• From Search Results to Business Insights: Building AI Analytics AssistantsJun 16, 2026. Transform data into actionable insights with AI Analytics Assistants. Build them using .NET, Azure AI Search, and Azure OpenAI.