Queries

Content
People

Sort By Search Results

Optimize MySQL Queries in Java for Better PerformanceDec 09, 2025. Learn how to optimize MySQL queries in Java applications using indexing, prepared statements, connection pooling, batch processing, and query tuning techniques. This guide explains everything in simple words with practical examples.
Optimizing Audit Queries by Time-Keyed ClusteringDec 02, 2025. Optimize audit queries with Time-Keyed Clustering! Learn how to improve performance, reduce I/O, and efficiently manage large audit datasets. Boost Angular app speed!
Refactoring N+1 Queries in Transactional SystemsNov 26, 2025. Eliminate N+1 query problems in transactional systems! Learn to detect, refactor, and prevent performance bottlenecks with SQL, ORM tuning, and architectural changes.
Beginner Guide to Writing SQL Queries for Full-Stack ProjectsNov 27, 2025. Master SQL for full-stack development! This guide covers essential SQL queries, database operations, joins, and best practices for building robust applications.
How to Optimize Slow SQL Queries | Beginner-Friendly Techniques with Practical Developer Case StudyNov 25, 2025. Boost SQL query speed! Learn indexing, filtering, and execution plan analysis. Fix slow queries with our beginner-friendly guide and developer case study.
How to Write SQL Queries Every Beginner Should KnowNov 24, 2025. Master SQL querying! Learn SELECT, JOIN, GROUP BY, and more with real-world examples. Perfect for beginners to build practical database skills and boost efficiency.
How ASP.NET Core MVC Performs CRUD Without SQL Queries | Beginner-Friendly EF Core Nov 22, 2025. Master ASP.NET Core MVC CRUD operations without writing SQL queries! Learn EF Core, DbContext, DbSet, and Models for efficient data management. Beginner-friendly tutorial.
Performance Tuning Case Study: Optimizing 10 Slow SQL Server Queries Step-by-StepNov 17, 2025. Boost SQL Server performance! This case study provides 10 step-by-step solutions to common slow query problems, complete with root causes and optimized code.
Optimizing EF Core Queries for Large Data Applications | ASP.NET CORENov 10, 2025. Boost ASP.NET Core performance! Master EF Core query optimization techniques for large data applications. Learn to handle millions of records efficiently and build scalable APIs.
Common Mistakes Developers Make in SQL Queries (and How to Fix Them)Oct 31, 2025. Master SQL! Avoid common mistakes like SELECT *, missing indexes, and subqueries. Learn to write efficient, safe, and accurate queries with these simple fixes.
Using CTEs and Recursive Queries for Complex Data Relationships (SQL Server)Oct 31, 2025. Master complex SQL Server data relationships with CTEs and recursive queries! Simplify hierarchies, improve readability, and boost performance. Learn how now! #SQL
Tell, Don't Ask: Write Code That Commands, Not Queries in C#Oct 26, 2025. Master the Tell, Don't Ask principle in C# for cleaner, more maintainable object-oriented code. Refactor from queries to commands for SOLID design!
🎯 Top SQL Server Queries Asked in Interviews (With Examples)Oct 25, 2025. Ace your SQL Server interview! Master 30 essential queries with examples, covering everything from basic SELECT statements to advanced window functions and optimization.
Understanding orientation in CSS Media Queries for Responsive DesignOct 24, 2025. Learn how to use CSS media queries to adapt your website's design based on device orientation (portrait or landscape). This guide covers the basics of the orientation media feature, provides practical examples for adjusting layouts and styles, and offers tips for creating a more responsive and user-friendly experience across various devices.
How LINQ Turns Your C# Code into SQL Queries (With Real Examples)Oct 21, 2025. Unlock the power of LINQ! This article provides a comprehensive guide on how LINQ translates your C# code into efficient SQL queries. Learn with practical examples demonstrating filtering, joining, ordering, and grouping. Understand deferred execution and the difference between LINQ to Entities and LINQ to Objects. Master LINQ and optimize your database interactions in .NET!
How to Optimize SQL Queries for Faster Execution in Large DatabasesSep 23, 2025. This article reveals practical techniques like indexing, efficient joins, and smart WHERE clauses to dramatically reduce execution time. Learn how to analyze execution plans, leverage partitioning and caching, and optimize subqueries for peak performance.
Find High-Usage Queries and Stored Procedures in SQL ServerSep 05, 2025. Identify the SQL statements and stored procedures that burn the most CPU, IO, and time using SQL Server DMVs—plus quick scripts, filters, and tips to fix them.
Basic SQL Queries for Database TestingJun 23, 2025. Learn essential SQL queries used in database testing. This guide covers SELECT, JOIN, WHERE, and more—ideal for QA testers and beginners ensuring data accuracy and integrity in applications.
Execution Process of SQL Queries vs Stored Procedures Apr 21, 2025. Dive deep into the internal execution process of SQL Server queries with this one-of-a-kind article comparing normal SQL queries and stored procedures.
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.
Simplify Your Queries With “AutoInclude” In EntityFramework CoreDec 30, 2024. In this article, we will discover how the "AutoInclude" feature in EntityFramework Core simplifies query writing by automatically including related navigation properties.
Recursive CTE: Simplifying Complex Queries with SQLAug 16, 2024. Recursive CTEs in SQL simplify querying hierarchical or recursive data by breaking down queries into anchor and recursive members. They are ideal for traversing structures like organizational charts or file directories, offering improved readability and performance.
Optimizing LINQ Performance with Compiled Queries in .NETJul 22, 2024. Compiled queries in LINQ (Language Integrated Query) are a powerful feature that can significantly improve the performance of your data access code, especially when dealing with repetitive queries.
Optimizing LINQ Queries in C# and .NET Core Web APIsJun 21, 2024. LINQ in C# optimizes data querying with readable syntax, but inefficient use can impact .NET Core Web API performance. Strategies like early filtering and selective projections enhance efficiency. Deferred execution via IQueryable delays query execution, optimizing database interactions.
Master GeoSpatial Queries in MongoDBMay 29, 2024. Mastering geospatial queries in MongoDB empowers efficient handling of location-based data. Leveraging features like GeoJSON, GeoNear, and GeoWithin, developers can perform precise searches, analyze spatial relationships, and optimize queries using indexes, facilitating robust geospatial data management and analysis.
SQL Joins: Optimizing SQL Queries for EfficiencyMay 06, 2024. Explore the art of optimizing SQL queries through effective join strategies. Learn essential techniques such as proper column selection, indexing, and join types, alongside real-time project examples. Delve into advanced concepts like self-joins and cross-joins for comprehensive understanding.
SQL Server Fundamentals: Design, Queries & OptimizationApr 29, 2024. This article serves as a comprehensive guide to SQL Server fundamentals, database design principles, querying with Transact-SQL, stored procedures, and optimization techniques. Through real-time examples and SQL query snippets, developers gain practical insights into building robust.
MySQL Queries Cheat SheetApr 18, 2024. In this article, we will learn about MySQL querying essentials, covering basic SQL commands, data manipulation functions, constraints, and frequently asked questions, providing valuable insights for both novice and experienced developers.
Enhance SQL Server Queries with OPTION(RECOMPILE) HintApr 11, 2024. This article provides an in-depth exploration of the OPTION(RECOMPILE) hint in SQL Server, offering developers and database administrators a thorough understanding of its functionality, practical applications, and best practices.
Leveraging Compiled Queries for Enhanced Performance in LINQMar 09, 2024. Compiled queries in LINQ allow developers to pre-compile LINQ queries into executable delegates, reducing the overhead of query compilation and optimization. By caching the compiled query execution plan, compiled queries improve the performance of frequently executed or complex queries in C# applications.
Azure Stream Analytics Queries for Processing JSON DataAug 21, 2023. Exploring Azure Stream Analytics Queries for Processing JSON Data
Handling Complex API Filter Queries in ASP.NET CoreAug 07, 2023. From this blog, you will learn how to integrate my composite filter solution into your ASP.NET Core web applications.
Recursive Queries in SQLJul 13, 2023. In this article we learn about recursive queries in sql.
Optimization Of Queries In SQL Server - HEAP TABLESMar 08, 2023. This article will help you to understand how to start to think on optimization of sql queries and why use indexes in tables
Optimizing Queries For Faster Performance In SQL Server - A Step-By-Step Guide With ExamplesFeb 14, 2023. In this article, you will learn about Query Optimization in SQL Server.
The Most Important SQL Queries For BeginnersNov 30, 2022. How do you get the data from the table? How do you create or drop the table? How do you display the different records? Do you want to? You can easily do all of this by writing a simple SQL query.
Handling SQL Queries Using XAMPP ServerJun 14, 2022. XAMPP is a Free full-fledged development environment that lets you install the Apache web server, MariaDB database, Perl, and PHP scripting languages in one installation. It is a free solution stack for website developers that includes a web server, database server, and scripting engines. production environments.
Database Backup Using SQL Queries And Its TypeMay 17, 2022. How to make a backup of database using SQL queries in compressed and uncompressed condition or restoring database from backup using SQL queries and Difference between Compressed and Uncompressed Backup.
Advanced Entity Framework Core - Output EF SQL Queries To The Console And Tips To Setup Dbcontext With The Development In MindJan 10, 2022. When you work with abstractions over SQL Database you may be wondering what does Entity Framework constructs from your Linq queries. To get a clue on it here are 3 options. Tips to setup DbContext with the development in mind for development purposes, you may sometimes decide to use an in-memory database for all environments including production, you may set up HealthChecks, below shows how to add health checks for the DbContext also for the development environment good to have set o.EnableDetailedErrors(); and o.EnableSensitiveDataLogging(); ?to manipulate with all these options you may consider adding configuration options
No Likes And Range Queries In CassandraDec 24, 2021. Cassandra's design philosophy emphasizes efficient distributed data storage and retrieval using partition keys and clustering columns. While it may not support arbitrary substring matching (No Likes queries) and requires careful consideration for efficient range queries, understanding and designing your data model accordingly can help you make the most of Cassandra's capabilities
Important Queries In MySQLSep 23, 2020. A list of Important Queries In MySQL. These queries are very useful whenever we face any difficulty in MySQL.
Optimizing LINQ Queries In C#.NET For MS SQL Server Aug 13, 2020. Learn how to optimize LINQ queries for SQL Server performance using Entity Framework. Understand the importance of generating efficient SQL queries and avoid common pitfalls. Explore techniques like JOIN and UNION for improving query efficiency. Utilize tools like SQL Complete for query history and formatting.
Delta Queries In Microsoft Graph API Using C#Aug 09, 2020. This article discusses Delta Queries in Microsoft Graph using C#.
Use Append Queries Feature In Power BIJul 31, 2020. In this article, you will learn how to use the append queries feature in Power BI.
Executing SQL Queries And SQL Stored Procedure With ODBCOct 04, 2019. In this article, you will learn how to execute SQL queries and SQL Stored procedure with ODBC.
Top 5 Tricky/Important SQL Queries And Their AnswersSep 05, 2019. In this article, you will learn about SQL Server Top 5 tricky/ important SQL Query with their answers.
Spatial Queries In Entity Framework CoreJun 03, 2019. In this article, you will learn about spatial queries in Entity Framework Core.
Top 30 Important SQL Queries For DevelopersApr 01, 2019. In this SQL article, I will introduce you to some important SQL queries and technical points. This article is a guide for you to learn the concepts related to SQL. It starts with the basic SQL queries and later, continues to the advanced ones.
Sub Queries In SQL ServerJan 23, 2019. In this write-up, we will learn about subqueries in SQL Server. Subqueries are also termed as Nested queries.
Most Asked SQL Queries In InterviewsSep 19, 2017. Do you wonder what the most frequently asked SQL queries are in interviews? Here is a list of most asked SQL queries interview questions.
Cross Database Queries In Azure SQLMay 06, 2017. In this article, you will learn about cross database queries in Azure SQL.
Accessing SQL From Entity Framework Core Queries In ASP.NET CoreFeb 03, 2017. In this article, you will learn how to access SQL from Entity Framework Core Queries in ASP.NET Core.
Compile Queries And Execute SQL Queries Using LINQ To SQLJan 08, 2017. In this article, you will learn how to compile queries and execute SQL queries, using LINQ to SQL.
How To View LINQ To SQL Generated SQL Queries And Using Stored Procedures With LINQ To SQL Jan 02, 2017. In this article, you will learn how to view LINQ to SQL generated SQL queries and use stored procedures with LINQ to SQL.
How To Run Interactive Spark SQL Queries On Apache Spark Hdinsight Linux ClusterDec 31, 2016. In this article, you will learn how to run Interactive Spark SQL queries on Apache Spark HDinsight Linux cluster.
SharePoint 2013 - Important SQL Queries On SharePoint Content Databases - Part TwoDec 12, 2016. This second part of this article presents you with some more of the important queries that you can use to query SharePoint content databases.
SharePoint 2013 - Important SQL Queries On SharePoint Content Databases - Part OneDec 08, 2016. This article presents you with some of the important queries that you can use to query SharePoint content databases.
Learn MySQL Queries With ExamplesJun 23, 2016. In this article, you will learn select, update and delete statements in MySQL queries with examples.
50 Important Queries in SQL ServerApr 23, 2016. In this article, you will learn about 50 Important Queries in SQL Server. EXEC sp_helpdb, exec sp_helptext, EXEC sp_updatestats, EXEC sp_MSforeachtable, SQL query for version name of SQL Server, Enable a SQL Trigger, Disable a SQL Trigger, EXEC sp_recompile, sql query for First Date of Current Month, Swap two column values in SQL, Remove all stored procedures, Remove all views from database, Drop all tables.
SharePoint 2013: Execute SharePoint Search Queries Using CSOMApr 13, 2016. In this article you will learn how to execute SharePoint Search Queries using CSOM in SharePoint 2013.
Useful SQL Queries For SharePoint PractitionersMar 11, 2016. In this article you will learn useful SQL Queries for SharePoint practitioners.
Detect Poor Performing Queries In Entity Framework 6.xFeb 23, 2016. In this article you will learn how to detect poor performing queries in Entity Framework 6.x.
Important Queries in SQLJun 07, 2015. In this article we learn some interesting and useful SQL queries.
Basic SQL Queries For BeginnersFeb 23, 2015. In this article you will learn Basic SQL Queries for Beginners.
Create Dynamic PIVOT Queries in SQL ServerMay 15, 2014. This article shows how to create a dynamic PIVOT query in SQL Server.
Some Practical Useful SQL Queries For SharePoint AdminstratorFeb 26, 2014. In this article, I will share some very practical and useful SQL queries that a SharePoint administrator will require.
Compiled Queries in LINQFeb 11, 2014. This article explains the use of compiled queries to improve performance when a query is fired many times.
Important SQL Queries Every Developer Should Know in SQL ServerJul 10, 2013. In this article i am sharing some sql queries that need to maintaining data in sql server for every developer.
Generate LINQ, SQL Queries With LINQPadJul 02, 2013. In this article I am sharing how to generate a LINQ query with a very facilitative tool, LINQPad.
Complex SQL Queries With Split() Function in SQLMay 23, 2013. In this article, you will learn about Complex SQL queries with the split() function in SQL.
Co-related Queries and Self Join Using LINQNov 17, 2012. Today, in this article let’s play around with one of the interesting and most useful concepts in LINQ.
Interrogating your Printer Queries with WMINov 08, 2012. In response to a newsgroup query here is the code needed to view the printer queues on your system. Once again this is achieved using Windows Management Instrumentation or WMI. Note this code will display all printer queues if there are documents waiting to be printed. To test this open up a printer queue and pause the printer then use notepad or word etc and print to the paused printer.
Perform queries using LINQ in VB.NETNov 08, 2012. In this article I will show you how to extract data from SQL Server using LINQ.
Normal LINQ Query to Compiled LINQ Query to Auto-Compiled LINQ Queries in Entity Framework 5Sep 26, 2012. In this article I'll be talking about query performances (EF1 to EF5) so that you can better understand the Entity Framework 5 query performance improvements.
Media Only Queries in CSS3Sep 11, 2012. CSS3 has added media queries functionality to media=screen that was added to CSS2. This article explores the media queries functionality.
Developing and Designing Queries Using Query Designer in SQL Server 2012Aug 16, 2012. Today, I have provided an article showing you how to develop and design queries using the Query Designer in SQL Server 2012.
Saving and Reusing Your Custom Queries as Template Using Template Explorer in SQL ServerApr 04, 2012. In this article, we are going to see how to save your custom queries as a template and reuse the queries instead of saving as a file.
Let's play around with LINQ Queries in C#.NETDec 08, 2011. Today, we will play around using LINQ Queries in C#.NET effectively. Let’s try to use some of the predefined methods of LINQ Queries and let’s dig out and find how to write LINQ rather than traditional way of using normal Classes.
Working with Queries in LightSwitch Beta 2Jun 21, 2011. Here we will see how to create a Query for Screens and Tables.
Linq queries for beginnersDec 02, 2010. Following are some of the basic Linq command/samples for those who just want to start learning Linq.
Weird Thing With Inner Queries in Sql Server Feb 24, 2009. This article helps you understand how inner queries work in relation to outer queries and what problems they can create if not used in a proper manner.
Building and consuming parameterized queries from ADO.Net to DLINQAug 29, 2008. In this article, I will represent different techniques to build and make use of parameterized queries. The first way is the classical one, and I mean by that the ADO.Net technique. Then I’ll expose the second one using the new technology, namely DLINQ.
Indexing JSON Data for Semi-Structured QueriesNov 27, 2025. Unlock peak performance for semi-structured data! Learn how to effectively index JSON columns in SQL Server, PostgreSQL, and MySQL for faster queries and reduced CPU usage.
LLMs + SQL: From Natural Language to Safe, Auditable QueriesNov 05, 2025. Safely use LLMs with SQL for self-serve analytics. Learn a production-ready architecture with validation, compilation, and auditing for reliable data access.
Mastering Complex SQL Server Queries: Turning Data Into InsightsOct 25, 2025. Unlock SQL Server's potential! Master complex queries with joins, subqueries, window functions, CTEs, and pivots. Turn raw data into actionable insights.
Choosing Between Subqueries and Joins in PostgreSQLSep 15, 2025. This article dives into the core differences, performance implications, and readability aspects of each method. Learn when to leverage JOINs for combining data from multiple tables and when subqueries excel at filtering and aggregation. Optimize your database queries for speed and clarity, ensuring efficient and maintainable code.
Order of Execution in LINQ QueriesApr 22, 2025. This article explains the difference between deferred and immediate execution, outlines the execution order, and shares best practices to write efficient and optimized LINQ queries for real-world applications.
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.
SQL Subqueries: Correlated, Scalar, and EXISTS/NOT EXISTSSep 04, 2024. Subqueries in SQL are powerful tools for complex queries. They include correlated subqueries, which depend on the outer query’s results, scalar subqueries that return single values, and EXISTS/NOT EXISTS subqueries used to check for record existence.
Explain Subqueries in PostgreSQLAug 16, 2024. Subqueries in PostgreSQL allow you to nest queries within other queries, enabling complex data retrieval. They can be used in various SQL clauses such as SELECT, FROM, WHERE, HAVING, and JOIN. Types include scalar, row, and table subqueries, with correlated subqueries providing powerful filtering capabilities.
Connection with SQL and queries.Jul 24, 2024. Explore the essentials of connecting to SQL databases and executing efficient queries. Learn about various SQL commands, database management techniques, query optimization strategies, and best practices for data retrieval.
SQL: Writing Efficient QueriesJul 10, 2024. Learn how to optimize SQL queries for better performance with our guide on "SQL: Writing Efficient Queries." Discover techniques for improving query speed, such as indexing strategies, query optimization tips, and best practices.
Using CTEs in PostgreSQL for Cleaner Efficient QueriesJun 12, 2024. In the realm of SQL databases, PostgreSQL stands out with its rich feature set, one of which is Common Table Expressions (CTEs). CTEs offer a powerful way to simplify and structure complex queries, making them more readable and maintainable.
Why GraphQL? The Future of API QueriesMay 24, 2024. Discover the revolutionary approach of GraphQL for API queries, reshaping the landscape of web development. With its single endpoint, typed schema, and client-driven querying, GraphQL offers unparalleled efficiency and flexibility, paving the way for real-time data delivery.
The Amazing Adventure of MongoDB QueriesFeb 09, 2024. This content provides an engaging analogy of MongoDB queries as an adventurous quest through a treasure-filled city. It introduces concepts like planning the query as preparing a treasure map, execution as detective work, utilizing the Aggregation Framework for complex queries.
SQL Joins for Efficient Database QueriesFeb 05, 2024. Explore SQL joins, including inner, natural, left outer, right outer, full outer, and cross joins. Learn their usage, syntax, and differences to master relational database querying for effective data retrieval.
Optimizing SQL Queries: CTE vs Temporary Tables for SpeedDec 17, 2023. In Microsoft SQL Server, there are different methods to enhance query performance: Common Table Expressions (CTE) and temporary tables.
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.
Exploring MongoDB: Applications and Essential QueriesNov 30, 2023. In this article, we will explore MongoDB and delve into its applications, accompanied by an in-depth look at some of the most commonly used MongoDB queries.
GraphQL in .NET: GraphQL queriesNov 22, 2023. Learn graphQL queries, resolvers, and annotation-based approach. This tutorial introduces GraphQL, emphasizing its benefits over REST, and explores querying in a C# ASP.NET Core environment using HotChocolate. It covers key concepts, operations, and practical implementation.

1 - 100 of 123

OUR TRAINING