Resources   No resource found

• CodeQL GitHub Actions Queries: Building a Workflow Injection Security Test SuiteAug 27, 2026. Learn how to use CodeQL with GitHub Actions to detect workflow injection vulnerabilities, unsafe expressions, untrusted inputs, and CI/CD security risks before production.
• PostgreSQL 19 SQL/PGQ: Building Property Graph Queries with .NETAug 27, 2026. Learn how PostgreSQL 19 SQL/PGQ enables property graph queries and explore how .NET applications can model relationships, traverse graphs, and query connected data.
• PostgreSQL 19 Beta 3: Testing Temporal Table Queries with EF CoreAug 26, 2026. Explore PostgreSQL 19 temporal table capabilities with EF Core and test temporal queries, historical data access, performance, and .NET integration.
• PostgreSQL 19 Beta 3: Detecting JSON Query Plan Regressions in Production-Like WorkloadsAug 26, 2026. Learn how to detect JSON query plan regressions in PostgreSQL 19 Beta 3 using production-like workloads, execution plans, performance metrics, and benchmarks.
• Benchmarking AI-Generated SQL: Correctness, Query Plans, and Database CostAug 26, 2026. Benchmark AI-generated SQL for correctness, query plans, execution time, resource usage, and database cost across real-world database workloads.
• PostgreSQL 19 Beta 3: Testing Temporal Tables with EF CoreAug 25, 2026. Learn how to test PostgreSQL 19 Beta 3 temporal tables with EF Core, including temporal queries, compatibility testing, and potential query behavior changes.
• Azure SQL Free Tier vs SQL Server Express: Benchmarking .NET ApplicationsAug 25, 2026. Compare Azure SQL Free Tier and SQL Server Express for .NET applications using performance, latency, storage, connections, resource limits, and cost considerations.
• CodeQL 2.26.3: Testing GitHub Actions Workflow Security DetectionAug 25, 2026. Explore CodeQL 2.26.3 security detection for GitHub Actions workflows and learn how to test CI/CD pipelines for workflow-related security vulnerabilities.
• Azure SQL Developer Container: Building Offline .NET Development EnvironmentsAug 25, 2026. Learn how to use the Azure SQL Developer container to build local and offline .NET development environments with consistent database behavior for development and CI/CD.
• SQL Server Express to Azure SQL: Benchmarking Migration Without Code ChangesAug 25, 2026. Benchmark migration from SQL Server Express to Azure SQL and explore compatibility, performance, configuration, and application changes when moving .NET workloads.
• Benchmarking AI-Generated SQL Against Expert Queries on Real DatasetsAug 25, 2026. Benchmark AI-generated SQL against expert-written queries using real datasets and measure correctness, performance, execution cost, and maintainability across database workloads.
• .NET 8 to .NET 10 Migration: Finding Breaking Changes Before November 2026Aug 24, 2026. Explore Azure Cosmos DB AI tools and learn how to test agent-generated queries for accuracy, performance, security, and request unit costs.
• .NET Aspire 13.5 Azure Resources: Managing Cross-Tenant Infrastructure ReferencesAug 24, 2026. Learn how to test PostgreSQL 19 Beta 3 with EF Core applications and detect query plan regressions before upgrading production workloads.
• PostgreSQL 19 Beta 3: Detecting Query Regressions in EF Core ApplicationsAug 24, 2026. Benchmark PostgreSQL 19 Beta 3 JSONB workloads with GIN indexes and compare query performance, indexing behavior, and resource usage against PostgreSQL 18.
• Azure Cosmos DB AI Query Assistance: Measuring Accuracy and RU EfficiencyAug 24, 2026. Learn how to evaluate Azure Cosmos DB AI query assistance by measuring generated query accuracy, performance, request units, and cost efficiency.
• GitHub Actions Security: Testing CodeQL Detection for Workflow InjectionAug 24, 2026. Learn how to use CodeQL to test GitHub Actions workflows for injection vulnerabilities and strengthen CI/CD security against malicious workflow inputs.
• Building Cost Controls for AI Agents Querying Azure Cosmos DBAug 24, 2026. Learn how to control AI agent costs when querying Azure Cosmos DB by monitoring request units, limiting expensive operations, and setting usage safeguards.
• Benchmarking AI-Generated Database Queries Against Expert-Written SQLAug 24, 2026. Learn how to benchmark AI-generated database queries against expert-written SQL by comparing correctness, performance, cost, maintainability, and execution efficiency.
• Azure Cosmos DB AI Query Assistance: Measuring Accuracy and RU EfficiencyAug 24, 2026. Learn how to evaluate Azure Cosmos DB AI query assistance by measuring generated query accuracy, performance, request units, and cost efficiency.
• CodeQL 2.26.3: Testing GitHub Actions Security Detection in CI/CDAug 24, 2026. Learn how to test CodeQL 2.26.3 security detection for GitHub Actions workflows and improve vulnerability detection in CI/CD pipelines.
• OneLake ≠ Lakehouse: Understanding the Foundation of Microsoft FabricAug 21, 2026. Understand the difference between Microsoft Fabric OneLake and Lakehouse, including how they work together for unified storage, data engineering, Delta tables, Spark, SQL, and analytics.
• PostgreSQL 19 Beta: Detecting EF Core Query Plan RegressionsAug 21, 2026. Learn how to test PostgreSQL 19 Beta with EF Core and detect query plan regressions, performance changes, compatibility issues, and production migration risks.
• PostgreSQL 19 Beta: Benchmarking JSONB Workloads from .NET APIsAug 21, 2026. Benchmark PostgreSQL 19 Beta JSONB workloads from .NET APIs and evaluate query performance, indexing strategies, EF Core behavior, and database scalability.
• DATABRICKS.SQL and DATABRICKS.TABLE Functions Debuts in Microsoft ExcelAug 18, 2026. Discover how Excel’s DATABRICKS.SQL and DATABRICKS.TABLE functions connect spreadsheets directly to Databricks, enabling live SQL queries, enterprise data analysis, and real-time insights.
• Mastering "Triplets with Sum in Range": An Efficient Java ApproachAug 19, 2026. Learn how to solve the "Triplets with Sum in Range" problem in Java with an optimal $O(n^2)$ time complexity and $O(1)$ auxiliary space using sorting and the two-pointer technique.
• PostgreSQL 19 Beta: Benchmarking JSONB Indexes with EF CoreAug 19, 2026. Benchmark PostgreSQL 19 Beta JSONB indexes with EF Core by measuring query performance, indexing strategies, execution plans, storage, and application response times.
• PostgreSQL 19 Beta Migration: Detecting Query Plan Regressions in .NETAug 19, 2026. Learn how to test PostgreSQL 19 Beta migrations for .NET applications and detect query plan regressions, performance issues, compatibility problems, and database risks.
• HCL .NET Full Stack Developer – Technical Round 1 Interview Questions Aug 19, 2026. This can help .NET Full Stack developers understand the interview pattern and prepare for similar technical rounds.
• Switching Query Results in Fabric WarehouseAug 17, 2026. Learn how to run multiple SELECT statements in a Microsoft Fabric Warehouse and easily switch between their individual result sets. Using practical examples with Region, Product, and Orders tables, this article shows how multiple queries can simplify data exploration, validation, troubleshooting, and everyday SQL development in Fabric.
• Benchmarking PostgreSQL 19 Beta with JSONB-Heavy EF Core WorkloadsAug 18, 2026. Benchmark PostgreSQL 19 Beta with JSONB-heavy EF Core workloads by measuring query performance, indexing efficiency, transaction throughput, latency, resource usage, and database scalability.
• Testing PostgreSQL 19 Upgrade Compatibility for .NET ApplicationsAug 18, 2026. Test PostgreSQL 19 upgrade compatibility for .NET applications by validating EF Core workloads, queries, extensions, drivers, migrations, application behavior, and potential compatibility issues.
• 5 Ways to Improve ASP.NET Core Web API Performance with a Real-World ExampleAug 18, 2026. Learn five practical ways to improve ASP.NET Core Web API performance using optimized database queries, pagination, async/await, AsNoTracking, and caching for scalable applications.
• The Silent Performance Killer: Understanding the N+1 Query Problem in EF CoreAug 18, 2026. Learn how to identify and fix the N+1 query problem in Entity Framework Core using Include, projection, relationship queries, and efficient LINQ patterns to improve database performance.
• 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.
• 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.
• Deep Dive into EF Core Query Performance: Default Tracking vs. AsNoTrackingAug 12, 2026. In Entity Framework Core (EF Core), query performance and memory management are heavily governed by one underlying mechanism: Change Tracking. While EF Core's default tracking behavior makes data mutations seamless, applying it blindly across read-only queries can introduce significant memory and CPU overhead. Understanding how the ChangeTracker operates under the hood—and knowing when to bypass it using AsNoTracking() or AsNoTrackingWithIdentityResolution()
• PostgreSQL 19 Beta: Testing Planner Changes Before ProductionAug 12, 2026. Test PostgreSQL 19 Beta's query planner changes before production. Optimize performance by comparing execution plans and identifying regressions.
• Calculate the Number of Days Between Order Date and Ship Date in Fabric Dataflow Gen2Aug 11, 2026. Learn to calculate shipping days in Fabric Dataflow Gen2 using Power Query. Handle date types, missing values, and invalid dates for robust data transformation.
• 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.
• PostgreSQL 18 Skip Scans: When Multicolumn Indexes WinAug 11, 2026. PostgreSQL 18's skip scan enhances multicolumn indexes for queries filtering on later columns. Learn when it's beneficial and how to benchmark.
• 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.
• The Five Graph Query Patterns That Power Interconnected Cash RiskAug 09, 2026. Unlock interconnected cash risk with 5 graph query patterns for liquidity, regulation, and policy compliance. Powering proactive treasury intelligence.
• 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.
• 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.
• Optimizing Entity Framework Core Performance with Compiled Queries and AsNoTrackingAug 03, 2026. Boost EF Core read performance! Learn to use AsNoTracking and Compiled Queries to slash overhead, reduce GC pressure, and speed up repetitive database calls.
• 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.
• Building a CQRS Architecture with MediatR in ASP.NET Core 11Jul 31, 2026. Master CQRS with MediatR in ASP.NET Core 11. Separate reads/writes, simplify logic, and build scalable, maintainable apps.
• EF Core Performance Benchmarks: 12 Mistakes That Hurt Query SpeedJul 29, 2026. Unlock EF Core performance! Discover 12 common mistakes hurting query speed and learn production-ready solutions for faster applications.
• 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.
• EF Core 10 Performance Tuning: Tracking, Query Filters, Compiled Queries, and Bulk OperationsJul 28, 2026. Boost EF Core 10 performance with AsNoTracking, query filters, compiled queries, and bulk operations. Optimize your data access layer.
• 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.
• 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.
• EF Core Performance Tips for Faster QueriesJul 22, 2026. Boost EF Core performance with essential tips: select only needed columns, use AsNoTracking, filter at DB, avoid N+1, and monitor SQL.
• 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.
• PostgreSQL JSONB Performance Tips for High-Traffic ApplicationsJul 21, 2026. Optimize PostgreSQL JSONB performance for high-traffic apps. Learn indexing, query tips, and best practices for scalable, fast data handling.
• 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.
• CSS Container Queries: Building Truly Responsive Web ComponentsJul 21, 2026. Unlock truly responsive web components with CSS Container Queries. Adapt layouts to parent container size, not just viewport.
• 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.
• 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.
• CQRS Pattern Explained: Building Scalable and Maintainable ApplicationsJul 16, 2026. CQRS separates read/write operations for scalable, maintainable apps. Learn its architecture, benefits, and best practices.
• 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.
• Apache Iceberg Explained: Modern Data Lake Architecture for DevelopersJul 15, 2026. Learn Apache Iceberg architecture, ACID transactions, schema evolution, time travel, and query optimization for building scalable modern data lakes.
• Apache Pinot Tutorial: Building Real-Time Analytics Applications at ScaleJul 15, 2026. Learn Apache Pinot with practical examples. Build real-time analytics applications using streaming data, low-latency queries, indexing, and scalable OLAP architecture.
• Apache DataFusion Explained: The Next Generation Query EngineJul 09, 2026. Apache DataFusion: A Rust-based, embeddable query engine for high-performance SQL on structured/semi-structured data, ideal for modern data platforms.
• 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.
• MongoDB Aggregation Pipeline Explained with Practical ExamplesJul 07, 2026. Unlock MongoDB's power with aggregation pipelines. Learn to filter, group, sort, and transform data efficiently with practical examples.
• 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.
• 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.
• 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.
• Optimizing Entity Framework Core Queries for Large-Scale ApplicationsJul 02, 2026. Optimize EF Core queries for large-scale apps. Learn techniques like projection, AsNoTracking, pagination, and indexing for peak performance.
• 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.
• 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 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.
• Building AI-Powered Database Query Optimization Advisors with ASP.NET CoreJun 29, 2026. Build an AI-powered database query optimization advisor with ASP.NET Core, EF Core, and Azure OpenAI for faster queries, reduced costs, and improved scalability.
• 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
• Building Flexible EF Core Queries with Query ObjectsJun 27, 2026. Master EF Core query flexibility with Query Objects. Build reusable, composable queries for maintainable, efficient data retrieval.
• 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.
• 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.
• 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.
• How to Implement AI-Assisted Database Query Optimization in ASP.NET CoreJun 17, 2026. Boost ASP.NET Core app performance with AI-assisted database query optimization. Learn to identify bottlenecks, get recommendations, and improve productivity.
• Construct List Using XOR Queries – Efficient Reverse Processing ApproachJun 16, 2026. Efficiently construct a list using XOR queries by processing in reverse. Avoids costly array updates with bit manipulation.
• 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.