Queries

Content
People

Sort By Search Results

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.
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.
Executing Dynamic SQL QueriesAug 25, 2023. Dynamic SQL: Defining and Executing Queries
SQL Server Useful QueriesJan 12, 2023. In this article, you will learn about SQL Server Useful Queries.
Elasticsearch Boolean QueriesJan 12, 2023. In this article, we will see how to write Boolean queries and how it is working in Elasticsearch.
T-SQL Subqueries In PracticeJul 21, 2022. This article will demonstrate the two types of subqueries and their practical usage.
Using For XML Clause In SQL QueriesMay 05, 2022. For XML clause is used to convert the SQL result set into XML format. It is a very much helpful clause when we need XML data from the SQL result set. The FOR XML clause can be used in top-level queries and in subqueries. The top-level FOR XML clause can be used only in the SELECT statement. In sub queries, FOR XML can be used in the INSERT, UPDATE, and DELETE statements. 
Advanced Entity Framework Core Tips In Practice: Context pooling, Lazy vs Eager loading, Single vs. Split Queries, Tracking vs. No-Tracking QueriesSep 22, 2021. Advanced Entity Framework Core Tips In Practice: Context pooling, Lazy vs Eager loading, Single vs. Split Queries, Tracking vs. No-Tracking Queries
LINQ QueriesSep 02, 2020. In this article, you will learn about LINQ Queries.
MongoDB Tutorial - Queries: Part TwoJun 07, 2016. In this article, we will see some MongoDB specific queries.
How To Optimize SQL QueriesApr 24, 2016. In this article, you will learn how to optimize SQL Query.
Top 10 Most Used SQL QueriesFeb 25, 2016. In this article you will learn about the top 10 most used SQL Queries. SQL Server is an interface which helps to communicate with the system’s database using queries.
Useful SQL QueriesFeb 21, 2016. In this article, we'll learn some basic but useful SQL queries.
Find Datatype Of Each Measure In SSAS MDX QueriesFeb 18, 2016. In this post we will see how we can get the datatype of each measure we use in our SSAS MDX Queries.
Responsive Website Design Using Media QueriesDec 14, 2015. Create responsive website designs with media queries, adapting layouts and styles based on device characteristics like screen size and orientation. Optimize user experience across various devices through targeted CSS adjustments, ensuring seamless interaction and readability.
SQL Basic QueriesSep 17, 2015. In this article I will explain some basic SQL queries.
Filters in MDX QueriesJul 08, 2015. This article, explains the power of MDX queries with precise filtering! This guide dives into filtering techniques to control the data you see in your multidimensional analyses.
Various Ways To Write LINQ QueriesFeb 13, 2015. In this article we will learn various ways to write LINQ queries.
Building a Responsive Website Template: HTML5 & CSS3 Media QueriesSep 30, 2013. In this article, I'll explain the nuts and bolts of responsive web designing and media queries. What? When? Why? I'll explain these questions in this article.
Introduction to Sub-Queries in SQL ServerDec 26, 2012. In this article i have explained detailed about the Sub-Queries in sql Server
Subqueries in MySQLNov 29, 2011. In this article we discuss how to use Subqueries in MySQL.
Use CompiledQuery.Compile method to build parameterized DLINQ queriesAug 29, 2008. In this article, I will make use of the CompiledQuery.Compile generated method which receives a Lambda expression as parameter, and then it generates a delegate that returns a generic IQueryable object that one can enumerate it through a foreach loop.
XML Pathfinder - Sample C# Utility to Study XML Paths and XPath QueriesFeb 05, 2008. This article discusses the construction of a simple utility that may be used to locate and evaluate paths within an XML document, and to test queries against those paths.
Real Life SQL and .NET : SQL Subqueries: Part VIIJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
Data Access through Web Services, Stored Procedures and SQL QueriesFeb 12, 2002. Web Services has been the most revolutionary aspect of the .NET framework developed by Microsoft. This article presents the three different modes through which data can be accessed viz. through Web services, stored procedures and SQL query using the power of ADO.NET and XML.

OUR TRAINING