Resources  
  • 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
  • Benefits of Temporary Tables over Table Variables in SQL ServerMar 10, 2024. The article explores the advantages of utilizing temporary tables over table variables in SQL Server. It discusses how temporary tables offer better performance, scalability, and flexibility for handling large datasets and complex data manipulation tasks.
  • 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.
  • Understanding FORMATMESSAGE() Function in SQL ServerMar 06, 2024. In this article, we will discuss how to use FORMATMESSAGE() function in SQL Server, its advantages and usages with example.
  • SQL Tuning - Effective Strategies with Practical ExamplesMar 03, 2024. SQL Tuning — Effective Strategies with Practical Examples
  • Quick SQL Refresher Feb 28, 2024. The Quick SQL Refresher provides a concise cheat sheet for SQL, covering essential concepts, keys, commands (DDL, DML, DQL, DCL, TCL), constraints, clauses, T-SQL fundamentals, joins, functions, exception handling, indexes, views, stored procedures, transaction control, triggers, and cursors.
  • Analysis of T-SQL and PL/SQLFeb 12, 2024. This article delves into the distinctions between Transact-SQL (T-SQL) and PL/SQL, examining their origins, syntax, functionality, and optimization strategies. Explore their unique features for efficient database application development.
  • Local Temp Tables, Global Temp Tables, Table Variables, and CTEs ComparisonFeb 12, 2024. In SQL database management, optimizing data storage is vital for efficient query execution. Local and global temporary tables, table variables, and CTEs are versatile options for temporary data storage, each with distinct use cases.
  • New Modifications and Improvements to the Azure Stream Analytics No-Code Editor Feb 11, 2024. Explore real-time analytics with Azure Stream Analytics, a Microsoft Azure service for processing and analyzing streaming data. Learn about input sources, SQL-like query language, output destinations, and recent user experience enhancements for streamlined stream processing logic.
  • 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.
  • Mastering T-SQL Rank FunctionsFeb 06, 2024. SQL window functions like ROW_NUMBER, RANK, DENSE_RANK, and NTILE are vital for advanced data analysis. They organize, order, and rank data within result sets. ROW_NUMBER assigns unique sequential numbers, RANK assigns unique ranks allowing ties
  • Supported File Types for Data Ingestion into KQL Database in FabricFeb 06, 2024. This article is about Understanding the Supported File Types for Data Ingestion into the KQL Database in Fabric Real-time Analytics. Supported file types include JSON, CSV, XML, & Text. Note: XLSX is not supported. See how to ingest & transform data using Data Factory.
  • 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.
  • Optimize SQL Database PerformanceFeb 01, 2024. "Unlocking Database Efficiency: A Guide to Performance Optimization in SQL" is a concise and insightful resource that provides practical guidance on enhancing the efficiency of SQL databases. for optimize SQL database performance, ensuring faster queries, reduced resource consumption, and improved overall database responsiveness.
  • Securing Your .NET Applications With ExamplesJan 20, 2024. In the realm of software development, security remains a paramount concern. This is especially true for .NET applications, which often handle sensitive data and interact with critical systems. By adhering to security best practices, developers can create robust applications that safeguard user information and withstand potential attacks.
  • Create a Workspace in FabricJan 15, 2024. This article explains how to create workspaces in Microsoft Fabric. In workspaces, you create collections of items such as lakehouses, warehouses, and reports.
  • Understanding Collection Types in C#Jan 09, 2024. Delving into collection types like IEnumerable and IQueryable in C# unveils their impact on data querying efficiency. While IEnumerable offers simplicity for in-memory operations, it might load unnecessary data. IQueryable optimizes query execution by fetching only required data, which is beneficial, especially with extensive datasets or remote sources.
  • 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.
  • Query to Find and Drop User-Defined Stored ProcedureDec 20, 2023. In this article, we will learn about dangerous SQL scripts that iterate through user-defined stored procedures, views, functions, and user-defined types, dropping them one by one. Caution: Do not run in production environments; it poses serious risks.
  • 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.
  • Row Constructors in PostgreSQLDec 13, 2023. Explore the power of row constructors in PostgreSQL, enabling efficient row-wise data manipulation. This guide covers syntax, applications in SELECT, INSERT, UPDATE, DELETE statements, and common use cases for optimization.
  • 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.
  • Fabric Data Warehouse: Save as Table and Analyze Result FunctionalitiesNov 20, 2023. In this article, we'll delve into the Microsoft Fabric Data Warehouse features: Save as Table and Analyze Result. These functionalities offer users and analysts several advantages in terms of data management and visualization.
  • 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... "
  • Improving SQL Table Data PerformanceNov 01, 2023. This article discusses strategies and best practices for optimizing SQL table data performance. Topics covered include indexing, normalization, partitioning, data types, query design, monitoring, hardware, caching, sharding, and maintenance. These practices aim to improve database efficiency and, in turn, enhance application performance and user satisfaction. Regular maintenance is stressed for sustained success.
  • Optional Parameters in SQL ServerOct 26, 2023. Optional parameters in SQL Server refer to the capability of defining parameters within SQL queries that can be left unspecified or set to default values if not provided by the user. This feature enhances the flexibility of SQL statements by allowing developers to create dynamic queries that adapt to different scenarios. By specifying default values or leaving parameters unassigned, optional parameters provide a means to simplify queries while accommodating various filtering or search criteria. This is particularly useful when constructing stored procedures, user-defined functions, or queries in applications where certain parameters may or may not be needed, offering a more versatile and adaptable approach to database interactions in SQL Server.
  • How to Implement Continuous Querying with NCache?Oct 20, 2023. In this detailed article, let us discuss how we can implement continuous querying with NCache.
  • 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
  • Elements Of Responsive Web DesignOct 19, 2023. Responsive web design ensures that users can access a website effortlessly, whether they are using a desktop computer, laptop, tablet, or smartphone. By dynamically adjusting the layout and content presentation, responsive design enhances readability, navigation, and overall user satisfaction.
  • 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.
  • Delegation in Power BISep 18, 2023. Delegation in Power BI streamlines data processing by shifting tasks to the data source, enhancing efficiency and scalability, especially with large datasets. Learn key aspects of this essential concept.
  • GraphQL in Next.jsSep 15, 2023. Here we will give the description how to setup GraphQL with Next.js.
  • Stored Procedure in SQL ServerSep 12, 2023. A stored procedure is a reusable collection of SQL statements stored on the database server. It simplifies code maintenance and execution. Stored procedures can be invoked by triggers, other procedures, and various programming languages like Java, .Net, and Python, making them versatile.
  • Power BI Data Transformation Basics for InsightsSep 12, 2023. Power BI Power Query Basics Transforming Data for InsightsPower Query is a data transformation tool in Microsoft's Power BI suite. It connects, cleans, and shapes data from diverse sources, enabling insightful analysis. Learn its basics and key transformations with examples.
  • Power BI Interview Question and AnswerSep 08, 2023. Power BI components, differences between Power BI Desktop and Service, query optimization techniques, DAX functions, report creation steps, data model optimization, design best practices, security measures, dashboard tips, and embedding solutions.
  • Conditional INSERT, UPDATE, DELETE with MERGE QuerySep 04, 2023. The MERGE statement is a versatile SQL command used for conditional INSERT, UPDATE, or DELETE operations, streamlining database management tasks efficiently in a single query.
  • Optimizing API Performance in ASP.NET Core Web API with MiniProfiler and GlimpseSep 01, 2023. ASP.NET Core Web API's performance using tools like MiniProfiler and Glimpse. These tools are excellent for profiling and gaining insights into your application's performance, which can help you identify bottlenecks and areas for improvement. Here's a detailed guide:
  • Exploring Azure Cognitive Search's PowerAug 29, 2023. This article demonstrates the transformative prowess of Azure Cognitive Search, a technological marvel that is reshaping the way we interact with data in our data-driven world. With its advanced capabilities and features, Azure Cognitive Search is not just a search engine – it is a gateway to unlocking valuable insights from vast and diverse datasets. In this article, I will show you the features and customization of Azure Cognitive Search AI capabilities using a sample dataset of hotels.
  • Executing Dynamic SQL QueriesAug 25, 2023. Dynamic SQL: Defining and Executing Queries
  • Power BI Data Mart: Features, Limitations, and Best PracticesAug 22, 2023. Power BI Data Mart: Features, Limitations, and Best Practices
  • How to Get Query String in JavaScriptAug 22, 2023. This article will discuss using JavaScript to get Query String from a Web Page.
  • Exploring the Diverse Flavors of LINQ with ExamplesAug 22, 2023. LINQ is a powerful feature in modern programming languages like C# that allows developers to perform queries on different types of data sources using a consistent syntax. With LINQ, you can query and manipulate data without worrying about the underlying data source, whether it's an in-memory collection, a database, or XML
  • Azure Stream Analytics Queries for Processing JSON DataAug 21, 2023. Exploring Azure Stream Analytics Queries for Processing JSON Data
  • 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
  • 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.
  • How to Optimize SQL Server Query PerformanceAug 05, 2023. How to Optimize SQL Server Query Performance.
  • Recursive Queries in SQLJul 13, 2023. In this article we learn about recursive queries in sql.
  • EF Core in .NET 7 APIJul 13, 2023. Using EF Core in .NET 7 API
  • Rest Assured API Automation Testing ConceptsJun 28, 2023. This article provides an overview of various concepts related to API automation testing using the Rest Assured library. It covers topics such as sending query parameters and path parameters, handling authentication using different methods, setting request headers, logging request, and response details, and using RequestSpecBuilder and ResponseSpecBuilder for common headers and assertions.
  • How to use Between Operator in MySQLJun 21, 2023. The MySQL "BETWEEN" operator is used to filter and retrieve data within a specified range. It compares a value to the lower and upper bounds and includes entries that fall within the range. It can be used with numeric, date, or string values in SQL queries. Examples and syntax are provided in the article.
  • How to Use Group by in MySQLJun 21, 2023. Group by is a powerful feature in MySQL that allows you to group rows based on a specific column or set of columns. It is commonly used for generating summary reports and performing aggregations on large datasets. In this article, we will discuss how to use group by in MySQL with step-by-step examples.
  • 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.
  • Calling a Stored Procedure in ASP.NET CoreMay 22, 2023.
  • 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.
  • Connect SQL Server to Power BIMay 08, 2023. In this article, you will learn the steps to connect SQL server with Power BI
  • Advanced Query Tuning Techniques in SQL ServerApr 27, 2023. Advanced Query Tuning Techniques in SQL Server
  • Query Optimization Techniques in SQL ServerApr 25, 2023. Query Optimization Techniques in SQL Server
  • How to use MySQL DML commands in RustApr 18, 2023. In this article We learned how to Select, insert, update, and delete data in our database using rust.
  • Common Table Expression In SQL ServerMar 31, 2023. This article provides a practical guide to SQL CTE (Common Table Expressions), complete with examples that demonstrate how to use this powerful SQL feature to improve query performance and simplify complex queries. It covers the basics of CTE, including syntax and usage, and also delves into advanced topics such as recursive CTEs and using CTEs to implement complex calculations. Whether you're a beginner or an experienced SQL developer, this article is a valuable resource for mastering the use of CTEs in your SQL queries.
  • 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.
  • SQL Server Execution PlansMar 10, 2023. In this article, you will learn about SQL Server execution plans.
  • 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
  • Spark Logical And Physical PlansMar 03, 2023. In this article, you will learn about Spark Logical And Physical Plans.
  • 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.
  • 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.
  • Query Optimization In SQL ServerFeb 10, 2023. The way how can we optimize the Sql query and procedures
  • LINQ (Language Integrated Query) Jan 31, 2023. In this article, you will learn about LINQ (Language Integrated Query).
  • Using Power BI To Update DataJan 23, 2023. In this article, you will learn how to use Power BI to update data.
  • Elasticsearch Boolean QueriesJan 12, 2023. In this article, we will see how to write Boolean queries and how it is working in Elasticsearch.
  • SQL Server Useful QueriesJan 12, 2023. In this article, you will learn about SQL Server Useful Queries.
  • What is SQL Server Management Studio (SSMS)Jan 04, 2023. SQL Server Management Studio (SSMS) is a tool used to manage and develop Microsoft SQL Server databases. It provides a graphical interface for connecting to servers, creating and modifying database objects, importing and exporting data, and running queries.
  • What Is GraphQLDec 30, 2022. This would be a series of articles, in this article, we would talk about GraphQL, its comparison with REST and how does it work, why it is used and its operation types
  • SQL - Interesting Queries (2)Dec 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.
  • 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.
  • CRUP Operation with Dapper Using ASP.NET CoreOct 06, 2022. Using Dapper for CRUD operations in ASP.NET Core is straightforward and efficient. Dapper is a micro ORM that provides simple methods to execute SQL queries and map results to objects. Here's a basic example of how you can perform CRUD operations with Dapper in ASP.NET Core.
  • 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.
  • Call Rest APIs From Power BI / Power QueryJul 31, 2022. Sometimes, we encounter a requirement where we need to call some sort of Rest APIs from Power BI Desktop. In this article, I will teach you a step by step procedure for calling Rest APIs from Power BI.
  • Logical Query Processing In T-SQLJul 19, 2022. This article demonstrates the practical values of knowing Logical query execution in TSQL.
  • Query Processing In DBMSJul 14, 2022. Query Processing in DBMS is the approach of selecting the best strategy or plan which can be used to respond to a database request.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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. 
  • Query Apache Hive With C# And ODBCApr 26, 2022. This article introduces the combination of C# and ODBC to query data from Hive
  • Compare JSON In MySqlMar 16, 2022. In this article. you will learn how to compare 2 Json Records in MySql.
  • FetchXML Query In Microsoft Dynamics 365Mar 10, 2022. In this article, you will learn about the FetchXML queries in Microsoft Dynamics 365.
  • SQL Commands : DDL, DQL, DML, DCL, TCL with Examples Jan 27, 2022. Master the art of SQL DDL commands, DCL commands, DQL commands, DML commands, TCL commands for effective database management.
  • 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.
  • 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
  • Query Values From JSON Outputs In PowerAutomateJan 10, 2022. In this article, we will go through couple of ways to get the required values from the JSON output values that we got from Power Automate.

About j-query

NA

OUR TRAINING