Query

Resources

SQL Join Optimization: Improve Query Performance on Large TablesJun 03, 2026. Learn SQL Join Optimization techniques to improve query performance on large tables using indexes, execution plans, filtering, and SQL Server best practices.
What is Query Execution Plan in SQL Server and How to Analyze It?May 04, 2026. Unlock SQL Server query performance! Learn to analyze execution plans, identify bottlenecks like table scans, and optimize queries with indexes for faster, scalable databases.
How to implement API versioning using URL, header, and query string in ASP.NET Core?Apr 22, 2026. Master API versioning in ASP.NET Core! Learn to implement URL, query string, and header versioning for backward compatibility and seamless API evolution. Keep your apps stable!
How to Store and Query Embeddings Using Vector DatabasesApr 15, 2026. Learn how to use vector databases to store and query embeddings for AI applications. Unlock semantic search and RAG pipelines for intelligent systems.
What is Database Indexing and How Does It Improve Query Performance?Apr 13, 2026. Boost database speed! Learn database indexing: types, benefits, and best practices for faster queries in MySQL, SQL Server, and PostgreSQL. Optimize your database now!
How to Fix the EF Core N+1 Query ProblemMar 26, 2026. Boost EF Core performance! Learn to identify and fix the N+1 query problem with eager loading, projection, and more. Optimize your database calls now!
What are Indexes in SQL and How Do They Improve Query Performance?Mar 25, 2026. Unlock faster SQL queries! Learn how indexes dramatically improve database performance by creating efficient data retrieval paths. Boost your application speed now!
Simplifying Multi-Tenancy in EF Core: A Beginner’s Guide to Global Query FiltersMar 10, 2026. Implement multi-tenancy in EF Core with Global Query Filters! Secure your data by automatically filtering queries based on TenantId. Prevent data leaks and simplify code.
What role does data indexing play in improving query performance?Mar 11, 2026. Unlock faster query speeds! Learn how data indexing optimizes database performance, reduces I/O, and enhances user experience. Master primary, secondary, & composite indexes.
GraphQL with .NET & React | Part 2: Query (Arguments, Aliases & Fragments)Feb 19, 2026. Master GraphQL queries in .NET & React! Learn arguments, aliases, fragments, directives, and HotChocolate filtering for efficient data fetching. Build dynamic UIs!
Extracting Data From PDFs in Power Query of Power BIFeb 15, 2026. In this article, I’ll walk you through this feature in a very practical, real-world way. Not just the steps, but also the thinking behind it, the common pitfalls, and how you can use it effectively in real enterprise scenarios.
MongoDB Query Optimization TechniquesFeb 05, 2026. Boost MongoDB performance! Learn query optimization techniques: indexing, efficient filters, limiting data, and monitoring. Build high-performance applications.
MongoDB Indexes Explained: How to Improve Query PerformanceJan 30, 2026. Unlock MongoDB's power! Learn how indexes boost query performance, reduce full collection scans, and optimize your database for speed and scalability. A must-read!
How Query Folding Impacts Power BI PerformanceJan 20, 2026. Unlock peak Power BI performance! Learn how query folding optimizes data processing, prevents bottlenecks, and ensures lightning-fast refreshes, especially with large datasets.
How Can I Optimize a Slow MySQL Query with Multiple Joins?Jan 14, 2026. Optimize slow MySQL queries with multiple joins! Learn indexing, EXPLAIN, filtering, and join strategies for faster performance. Boost database efficiency now!
DAX Query View in Power BI Desktop: Why It Matters and How It Elevates Your Data ModelingJan 05, 2026. In this article, I talked about unlocking Power BI's potential with DAX Query View! Explore, debug, and optimize DAX queries directly in Desktop. Elevate data modeling and build reliable reports. I also covered how to evaluate and create a new DAX measures from the DAX query view
Understanding Filter rows and Expand Query in Dataverse (Power Automate)Dec 29, 2025. Unlock Dataverse power in Power Automate! Learn to efficiently filter and retrieve related data using Expand Query and Lookup Columns. Optimize flows and boost performance.
Token-Efficient RAG: Using Query Intent to Reduce Cost Without Losing AccuracyDec 29, 2025. Optimize RAG by tailoring retrieved document count to query intent (Generic, Contextual, Specific). Reduce token usage, maintain accuracy, and cut costs.
Avoid EF Core Query Pitfalls That Slow Down AppsDec 18, 2025. Learn how common Entity Framework Core query mistakes slow down enterprise applications and how to fix them using simple patterns, better queries, and performance-focused practices.
How to Improve Entity Framework Core Query Performance?Dec 05, 2025. Boost EF Core query performance! Learn practical tips like AsNoTracking, pagination, projections, and indexing to optimize your .NET applications. Make your apps faster!
Using AI to Optimize SQL Server Query Performance in Angular ApplicationsDec 03, 2025. Boost Angular app speed! This guide uses AI to optimize SQL Server queries, reducing latency and enhancing scalability. Perfect for all developer levels.
Profiling Query Regression After ReleaseDec 02, 2025. Master query regression profiling! Detect, diagnose, and resolve performance issues post-release with database, backend, and Angular techniques. Prevent slowdowns!
SQL Server Query Rewrite Using EXISTS Instead Of INDec 01, 2025. Boost SQL Server query performance! Learn how to rewrite IN clauses with EXISTS for faster execution, reduced resource usage, and improved scalability. Practical examples included.
Improving Query Plan Stability with OPTIMIZE FOR in SQL ServerDec 02, 2025. Achieve stable SQL Server query performance using OPTIMIZE FOR! This guide covers syntax, ASP.NET Core integration, and best practices to combat parameter sniffing.
Efficient Soft-Delete Models Without Query Degradation in SQL Server | A Practical Guide for High-Volume OLTP SystemsDec 01, 2025. Optimize SQL Server soft-delete models for high-volume OLTP systems. Learn strategies to avoid query degradation using filtered indexes, views, and archiving for peak performance.
Workload Analyzer — Predict SQL Query Performance Using ML ModelsNov 24, 2025. Predict SQL query performance with ML! Prevent slow queries, reduce database incidents, and guide efficient SQL development. Integrate into CI/CD pipelines.
Workload Analyzer: Predict SQL Query Performance Using ML ModelsNov 25, 2025. Proactively optimize SQL performance with a self-learning Workload Analyzer! Predict query cost, suggest indexing, and prevent regressions using ML models.
SQL Server Advanced Concepts: Views, Triggers, Functions, and Query Optimization Explained with Practical ExamplesNov 24, 2025. Master SQL Server: Views, Triggers, Functions, and Query Optimization. Build robust, high-performance databases. Practical examples included for real-world applications.
Hybrid Query Engine: SQL + JSONB + XML within the Same Data ModelNov 20, 2025. Unify SQL, JSONB, and XML in a single data model with a Hybrid Query Engine! Query across formats with consistent performance and governance. Ideal for modern apps.
SQL Server Data Federation (Split Big Tables Across Databases but Query as One)Nov 21, 2025. Scale SQL Server databases by splitting large tables across multiple physical databases while querying them as one. Improve performance, isolation, and flexibility.
Intelligent Query Router: Routing Reads to Replicas and Writes to Primary for High-Performance SystemsNov 19, 2025. Intelligent Query Routers boost system performance by routing reads to replicas and writes to the primary database. Achieve scalability and high availability.
Implementing AI Document Query (“ask your PDF”) in ASP.NET CoreNov 18, 2025. Build an "ask your PDF" feature in ASP.NET Core! This guide covers PDF extraction, chunking, embeddings, Pinecone integration, RAG, and production concerns.
SQL Server Indexing Strategies for Faster Query ExecutionOct 31, 2025. Boost SQL Server query speed! Master indexing: clustered, non-clustered, composite, filtered, columnstore. Optimize performance & avoid common pitfalls. A must-read!
Automating SQL Query Generation Using LlamaIndex and SnowflakeOct 21, 2025. Learn how to use LlamaIndex with Snowflake to automatically convert natural language prompts into SQL queries. Includes setup, architecture, and example workflows.
Command Query Responsibility SegregationSep 24, 2025. Command Query Responsibility Segregation (CQRS) separates read and write operations into distinct models, enhancing scalability and performance. Ideal for complex, read-heavy applications and event-driven microservices, CQRS offers optimized read models and better separation of concerns. However, it introduces complexity, eventual consistency challenges, and infrastructure overhead, making it unsuitable for simple CRUD applications. Weigh the pros and cons carefully before implementation.
Google Cloud Web3 Without a Credit Card: Query Ethereum in BigQuery SandboxAug 28, 2025. Unlock Web3 analytics for free! Query Ethereum & Solana on-chain data in Google Cloud BigQuery Sandbox without a credit card. Learn SQL, visualize insights, and save costs.
Smart Query Caching in C#: Auto-Invalidate on Database ChangesAug 20, 2025. Learn how to keep your cache fresh using SqlDependency, version-stamps, event-driven invalidation, and Redis Pub/Sub in C#, ensuring high performance, consistency, and scalability across applications.
Monitor Performance by Using the Query StoreAug 04, 2025. Query Store in SQL Server helps monitor query performance over time by storing execution plans, runtime stats, and wait times. It enables troubleshooting, plan forcing, and tracking regressions effectively.
How to Use PnPjs in SPFx to Query SharePoint List ColumnsJul 11, 2025. Learn how to configure PnPjs in your SharePoint Framework (SPFx) project and query all common SharePoint column types including Lookup, Person, Choice, and more.
MongoDB Filter Query Cheat SheetJun 04, 2025. This article explains how to use filters in MongoDB GUI tools (like MongoDBCompress or Compass) using simple query examples. You’ll learn how to search for records, use conditions, sort results, and filter by dates or partial matches, all without writing any code!
EJB QUERY LANGUAGE (EJB QL)May 30, 2025. EJB QL is a query language used to query enterprise beans and their relationships, supporting string and arithmetic functions, with syntax defined using Backus-Naur Form (BNF) for structured query creation.
How to Clean Data in Pivot Query in ExcelMay 16, 2025. In this article, we will learn how to clean and prepare your data directly within Pivot Queries in Excel.
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.
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.
Mastering SQL Query Generation with Azure OpenAIOct 09, 2024. Leverage Azure OpenAI to transform natural language into SQL queries seamlessly. By integrating Azure OpenAI and Azure SQL Database, you can simplify data querying and enhance accessibility. Learn how to set up the environment, construct prompts, and generate SQL queries using powerful AI models.
EF Core Query Tags: What They Are and How to Use ThemJul 29, 2024. Discover the power of EF Core Query Tags in optimizing and debugging your database queries. This guide explains what query tags are, their benefits, and how to implement them in your Entity Framework Core projects.
Amazon Bedrock Knowledge Base Query in .NET Console AppJul 25, 2024. Learn to create a .NET console application using Visual Studio 2022 to query an Amazon Bedrock knowledge base. This guide demonstrates querying an Amazon S3 bucket for data, handling responses, and managing errors. Prerequisites include AWS CLI setup, .NET 8.0 SDK, and necessary IAM permissions.
Understanding the SQL Query Execution OrderJul 22, 2024. SQL (Structured Query Language) is essential for interacting with relational databases, and mastering its intricacies can significantly enhance your data querying skills. One of the fundamental aspects to understand is the order of execution of SQL query clauses.
Interesting Query (3) --- Get Rolling AverageJul 19, 2024. This article will discuss Interesting Query (3) --- Get Rolling Average
Inner Workings of a Query ProcessorJul 18, 2024. The query processor in a DBMS is pivotal, handling DML and DDL queries through stages like compilation, linking, and optimization. It ensures efficient execution, supporting operations like SELECT, INSERT, UPDATE, and DELETE while maintaining database integrity and performance.
SQL Query Execution Understanding Process and PerformanceJun 11, 2024. Understanding the SQL query execution order—from FROM and JOIN to WHERE, GROUP BY, HAVING, SELECT, ORDER BY, and LIMIT/OFFSET—is crucial for optimizing queries. Key techniques include indexing, optimizing joins, early filtering, avoiding SELECT *, and using subqueries, CTEs, caching, and materialized views to enhance performance.
Reduce Query Time-Out Issues with GraphQL and Hasura for EnterprisesJun 11, 2024. Explore how GraphQL and Hasura can significantly reduce query time-out issues in enterprise applications. By optimizing data fetching and improving API performance, these technologies enhance backend efficiency and scalability.
Query Folding in Fabric Dataflow Gen2 (Power Query Online)May 30, 2024. Understanding Query Folding in Fabric Dataflow Gen2 (Power Query Online)" explores the concept of query folding within Microsoft's advanced data integration tool. Learn how query folding optimizes data transformation processes, enhances performance, and streamlines ETL tasks in Power Query Online.
LINQ Query Syntax vs Method Syntax in Entity FrameworkMay 29, 2024. Choosing between LINQ Query Syntax and Method Syntax in Entity Framework depends on various factors. Query Syntax often resembles SQL, making it more intuitive for those with SQL background, while Method Syntax offers more flexibility with lambda expressions and method chaining.
An In-depth Look at Kusto Query Language (KQL)May 28, 2024. Delve into Kusto Query Language (KQL), the powerful syntax behind Azure Data Explorer. From data querying to advanced analytics, KQL facilitates efficient data analysis, aggregation, and visualization, empowering users with comprehensive insights and querying capabilities.
Command Query Responsibility Segregation and its EvolutionMay 14, 2024. Command Query Responsibility Segregation (CQRS) separates read and write operations in system architecture, enhancing scalability and performance. This article explores its need, evolution, and implementation in .NET Web API Core with sample code.
SQL Indexing: Boosting SQL Query PerformanceMay 06, 2024. Unlock the power of SQL indexing to supercharge your database queries with our comprehensive guide. Learn how indexing works, explore real-world examples, and discover essential tips for optimizing query performance. Dive into the world of database optimization and take your SQL skills to the next level.
What is Language Integrated Query in C#?Mar 29, 2024. Know about LINQ (Language Integrated Query) in C# and their benefits. In this article, we have explained LINQ with an example.
Deletion of Record using Power Shell Script with FetchXML Query in D365Mar 23, 2024. Deletion of Contact Record using Power Shell Script with FetchXML Query in D365
Creating Dynamic PIVOT Query in SQL ServerDec 23, 2023. In this article, we are going to learn how to create dynamic PIVOT Query in SQL Server with some examples.
Exploring Kusto Query Language (KQL): Uses, Queries, and Unique FeaturesDec 01, 2023. Kusto Query Language (KQL) is a potent tool developed by Microsoft for diverse data analytics needs. Uncover its applications across industries, from log analytics to IoT, and explore essential queries, distinguishing KQL from other database query languages with its specialized focus on log analytics, time-series analysis, and data exploration efficiency. Enhance your understanding of KQL's rich functionalities and its seamless integration with Azure Data Explorer, making it a standout choice for efficient and specialized data querying.
Analyzing Sales Data with a Comprehensive SQL Query in Microsoft Fabric Data WarehouseNov 18, 2023. This SQL query is a powerful tool for in-depth sales analysis, utilizing joins and aggregations to break down sales data by account manager, payment type, and region in Microsoft Fabric Data Warehouse.
Learn to Avoid Query Governor Cost Limit Error in SQL ServerNov 13, 2023. Learn to solve "The query has been canceled because the estimated cost of this query... "
Creating a Calendar Table in Excel Power Query and its BenefitsOct 20, 2023. This blog is based on Creating a Calendar Table in Excel Power Query
Understanding LINQ in C#: Query Syntax and Method SyntaxOct 03, 2023. This article is an informative and in-depth exploration of LINQ (Language Integrated Query) within the context of C#, a widely used programming language in the software development industry. The guide delves into both the query syntax and method syntax aspects of LINQ, providing readers with a thorough understanding of how to effectively use LINQ to query and manipulate data in C# applications.
Kusto Query Language (KQL) for Azure IoTSep 25, 2023. Kusto Query Language (KQL) empowers Azure IoT projects with real-time data analysis, flexible exploration, aggregation, and seamless Azure service integration. It's pivotal in extracting insights from IoT data streams.
Power BI Query Folding Sep 22, 2023. Query Folding in Power BI is a performance-enhancing feature that optimizes data analysis. It pushes data transformations to the source, improving data refresh and incremental processes. Learn how it works, its benefits, and its limitations, and see practical examples of efficient data handling in Power BI.
How to Get Query String in JavaScriptAug 22, 2023. This article will discuss using JavaScript to get Query String from a Web Page.
Set Status Bar Color for SQL Server Query EditorAug 18, 2023. This article will discuss how to set status bar color for a SQL Server Query Editor
How to Optimize SQL Server Query PerformanceAug 05, 2023. How to Optimize SQL Server Query Performance.
Filtering Data with Global Query Filters in Entity FrameworkMay 24, 2023. In certain cases, you may need to apply filtering conditions to all queries involving specific entities. This can be useful when you want to exclude soft-deleted items, filter data based on certain criteria, or ensure data integrity. With Entity Framework's global query filters, you can easily achieve this during the model creation process.
Using Langchain and OpenAI APIs in Python to Query Your DocsMay 09, 2023. Using the APIs from OpenAI and the langchain project, it is quite easy to implement a bot that is fed with your documentation and other product information. The answers of the bot are then specific for the trained knowledge domain. Background on the used techniques can be found here, this article describes the required Python code.
Advanced Query Tuning Techniques in SQL ServerApr 27, 2023. Advanced Query Tuning Techniques in SQL Server
Power Query Features Related to RowsMar 16, 2023. This article is about cleaning and transforming the data using Power BI query editor. Power Query has a large number of features that will help you clean and prepare your data for analysis. In this article, you will learn about the features related to rows.
Did You Hear About Query Filters In Entity Framework Core?Feb 20, 2023. In this article, we can learn about Global Query Filters in Entity Framework Core in .NET is a feature that allows us to apply filters to all queries of a specific entity type.
Interesting Query (2) --- Whtch Manager has no Employee withDec 23, 2022. This article will discuss interesting queries, more.
Structured Query Language (SQL)Dec 19, 2022. Structured Query Language (SQL) is a standardized programming language that is used to manage relational databases and perform various operations on the data in them.
Powerful Query By Ant Design Blazor And EF CoreSep 20, 2022. In this article, you will learn about powerful query by ant design blazor and efcore.
Logical Query Processing In T-SQLJul 19, 2022. This article demonstrates the practical values of knowing Logical query execution in TSQL.
How To Query Parquet File Stored In S3 Using S3 SelectMay 26, 2022. In this article, you will learn how to query parquet file stored in s3 using s3 select.
How To Query JSON File Stored In S3 Using S3 SelectMay 26, 2022. In this article, you will learn how to query JSON file stored in s3 using s3 select.
Retrieve Related Entities Data Using Expand Query With Webresource In Dynamics CRMMay 05, 2022. In Dynamics 365 CRM, for certain requirements data needs to be retrieved from related entities. Expand query in XRM Web API. As an example, selected contact record guid was passed to fetch details of account that is related to the given contact.
FetchXML Query In Microsoft Dynamics 365Mar 10, 2022. In this article, you will learn about the FetchXML queries in Microsoft Dynamics 365.
Azure Synapse Analytics - Exploring Query EditorJan 27, 2022. In this article, we'll learn the features provided in the query editor in Azure Synapse Analytics.
List Rows Based On Expand Query In Power AutomateJan 13, 2022. In order to get details of related entity for the selected entity without separate retrieve call we can leverage Expand Query .As a business scenario for the same vaccination use case extracting details of accounts that are present in list of contacts who took vaccination.
Azure Synapse Analytics - Connect, Query And Delete Data Warehouse SQL PoolJan 10, 2022. In this article, we'll learn to connect, query and delete data warehouse using SQL Pool and Azure Data Studio.
Azure Data Studio - Create, Query And Delete In SQL ServerDec 22, 2021. This article dives in creating tables, working with queries and delete the data in SQL Server from Azure Data Studio.
Azure Data Studio - Create, Query And Delete In Azure SQL Database Dec 16, 2021. This article dives in creating tables, working with queries and delete the data in Azure SQL Database from Azure Data Studio
Read Text File And Move Files To Another Folder Using SQL Server Query Instead Of ETLDec 09, 2021. In this article, you will learn how to read text file and move files to another folder using sql server query instead of etl.
How To Query Dataverse In Microsoft SQL Server Management Studio (SSMS)?Dec 08, 2021. Querying Dataverse in Microsoft SQL Server Management Studio (SSMS) involves using Transact-SQL (T-SQL) to interact with tables, views, indexes, and stored procedures. Understanding entity relationships and data types is crucial for accurate retrieval and manipulation of data within Dataverse.
Query CSV File Saved In ADLS Through SQL Query - Azure Synapse AnalyticsNov 22, 2021. In this article, you will learn how to query CSV File saved in ADLS through SQL Query - Azure Synapse Analytics.
How To Query Data In Dynamics 365 CRM Online Using XrmToolBoxNov 07, 2021. In this article, you will learn how to query data in Dynamics 365 CRM Online using XrmToolBox.
How To Create, Query And Delete Database In Azure SQLOct 14, 2021. In this article, we’ll learn to create a database in Azure SQL, experiment with some Query and then when one is done with using the resources, learn to delete it.
Advanced Entity Framework Core Tips In Practice: Concurrency, Query filters and SaveChanges Method Abilities💪Sep 20, 2021. I am describing the practical aspects of working with Entity Framework Core. In this article I am touching Concurrency token and RowVersion, on save changes interceptor with a bunch of useful logic like tracking who and when did the change, versions, validations and domain events sending.
Interesting Query (1) --- Find Second Highest SalaryJun 01, 2021. This article will discuss several most popular, complex, and interesting SQL queries and their solutions.
SQL Performance (1), Optimized SELECT Query (A)May 17, 2021. This article discusses SQL performance on optimizing SELECT Query.
SQL Performance (2), Optimized SELECT Query (B)May 17, 2021. This article discuss SQL performance on optimizing SELECT Query, Second Part.
Get Items From Multiple Line Of Text Column Using CAML Query With SharePoint Rest API - Life SaverApr 27, 2021. When I was stuck up at getting items from Multiple line of text column CAML query saved my time, as the blog title says ;)
Azure Data Lake Storage Gen2 Query AccelerationApr 24, 2021. In this article, you will learn about Azure Data Lake Storage Gen2 Query Acceleration.
Salesforce SOAP API: POST Request With SOQL Query Envelope [Custom SObjects]Apr 23, 2021. In this article, we will discuss the detailed steps on executing SOQL queries for Custom Salesforce SObjects using SOAP API. In this demo, we will look into how to query fields with lookup relationships. This article holds good both for Custom and Standard SObjects.

Tags