Resources  
  • Handling JSON in C#Mar 16, 2024. C# provides seamless JSON handling with System.Text.Json. Easily parse JSON strings into C# objects and vice versa for efficient data manipulation.
  • 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.
  • Reverse String Filter in Vue.js Mar 06, 2024. To reverse a string in Vue.js, create a custom filter that reverses the characters. Define the filter, register it globally, and apply it in Vue component templates for efficient string reversal.
  • How to Extract Initials from a String in Vue.jsMar 06, 2024. To extract initials from a string in Vue.js, you can create a custom filter or method. Define a filter or method to process the string and return the initials, providing flexibility in implementation.
  • 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.
  • Template Literals In JavaScriptFeb 24, 2024. JavaScript template literals are an effective tool for working with and creating strings. They were first included in ECMAScript 6 (ES6).
  • String.IsNullOrEmpty() vs String.IsNullOrWhiteSpace()Feb 13, 2024. Learn when to use String.IsNullOrEmpty() and String.IsNullOrWhiteSpace() in C#. Understand their differences for effective null and whitespace checks, enhancing data validation and code reliability.
  • 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.
  • 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.
  • 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.
  • Lazy Loading In ASP.NET Core 7 Web APIJan 22, 2024. ASP.NET Core 7 Web API. Lazy loading is a technique where related data is only loaded from the database when it is explicitly requested. In Entity Framework Core, lazy loading can be achieved by marking navigation properties as virtual.
  • 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.
  • Concatenate Two Strings in C# Jan 17, 2024. In C#, string concatenation can be achieved using the + operator, String.Concat method, String.Join method, or string interpolation. Choose the method that suits your coding style and project requirements.
  • 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.
  • Sending SMS Notifications with Azure Communication Services in .NETJan 07, 2024. Learn to send SMS notifications with Azure Communication Service using .NET. Follow simple steps like installing the SDK, importing libraries, setting up connection strings, and sending SMS messages with ease.
  • Common Mistakes and How to Avoid Them in C# Jan 05, 2024. In this article, we will learn how to avoid common mistakes in C# programming. From efficient null checking and using tuples instead of classes to optimizing string concatenation and evaluating default values correctly.
  • JavaScript Replace SpacesDec 27, 2023. Learn how to use the JavaScript replace() method to remove spaces from a string and replace them with another character. The JavaScript replace() method is mostly used to replace the spaces in this article. So here is a quick introduction to the replace() method.
  • API Development Using Dapper and Microsoft Asp.NET Core Web API Dec 24, 2023. ASP.NET Core is a powerful framework for building web applications, and "Dapper" is a popular micro ORM (Object-Relational Mapping) that works well with ASP.NET Core for database operations. Dapper provides a simple way to interact with databases using raw SQL queries while mapping the results to objects.
  • 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.
  • Reverse String Pipe in AngularDec 14, 2023. Learn how to create a custom pipe in Angular to reverse a string. Follow the steps to generate a pipe, implement the logic, and use it in your Angular application.
  • 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.
  • How to Extract Initials from a String in AngularDec 13, 2023. In this article, we will learn how to extract initials from a string.
  • 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.
  • String Constants in PostgreSQLDec 01, 2023. Delve into PostgreSQL's handling of string constants, which is essential for managing text data. Explore their syntax, handling of special characters, and their versatile use in variable assignment, function arguments, comparisons, and more. Examples demonstrate their significance in tasks like substring replacement, regular expression matching, and date conversion. Elevate your PostgreSQL proficiency in manipulating and storing text data with these insights.
  • Dealing with Date and Time in Humanizer in C#Dec 01, 2023. Learn how to handle date and time in a user-friendly way in C# projects using Humanizer. Covering DateTime and TimeSpan humanization with customization options and real-world use cases for improved user experience.
  • 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.
  • Getting Started with Humanizer in C#Nov 27, 2023. In this article, we'll explore how to install and use Humanizer in C#, unveiling both its basic and advanced capabilities. By the end, you'll be equipped to elevate the user experience in your C# applications with Humanizer.
  • 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... "
  • Data Types In JavaScript Nov 10, 2023. Data types is most important concept in javascript and very useful logic in programming.Best concepts for fresher interview questions.
  • How to use Power Automate to split a string into an arrayNov 06, 2023. This article explains how to turn a string into an array using the Power Automate split function.
  • Java 21: New Features and ExamplesNov 02, 2023. Java 21 is a major release that includes a number of new features and improvements that make Java more concise, expressive, safe, and performant. Some of the most significant new features include record classes, sealed classes, pattern matching for instanceof, virtual threads, and sequenced collections.In short, Java 21 is a must-have update for any Java developer. It includes a number of new features that can help you to write better code, faster.
  • 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.
  • Convert String to JSON using Power Automate Microsoft Flow Oct 18, 2023. Learn to convert a string to JSON in Power Apps. Explore two methods: the JSON expression and the Parse JSON Data Operation, followed by reading the JSON data for effective data manipulation.
  • 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.
  • Securing .NET/ASP.NET Core Apps with Azure Key Vault Middleware Sep 08, 2023. Securing secrets in a .NET/ASP.NET Core application using Azure Key Vault is crucial for protecting sensitive information like API keys, connection strings, and other configurations. In this example, we'll walk through creating an ASP.NET Core application that leverages Azure Key Vault to store and retrieve secrets. We'll also implement a custom middleware for secure secret retrieval in real-time.
  • 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
  • String Methods in JavaScriptAug 22, 2023. Explore essential JavaScript string methods in this guide. Learn to manipulate, extract, and transform strings using functions like charAt, concat, includes, indexOf, and more. Start mastering JavaScript string manipulation today!
  • Convert String into Array in JavaScriptAug 21, 2023. Efficiently transform strings into arrays in JavaScript. Explore split() method, custom delimiters, and JSON conversion.
  • Azure Stream Analytics Queries for Processing JSON DataAug 21, 2023. Exploring Azure Stream Analytics Queries for Processing JSON Data
  • Constant Interpolated Strings in C# Aug 18, 2023. Explore interpolated strings in C#, a powerful feature for expressive string formatting. Learn about constant interpolated strings introduced in C# 10, enhancing readability and performance. Understand benefits, use cases, and considerations for improved code quality and maintainability.
  • 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.
  • Converting Strings to Numbers in C#Aug 04, 2023. In this article we learn about how to convert string to numbers in c#
  • Converting Strings in C#: JSON, Base64, XML, CSV and ReverseJul 19, 2023. Article on converting String to JSON, Base64, XML and CSV and Reverse using C#
  • 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
  • How to work with the MongoDB in VS-Code? Jul 07, 2023. How to work with the MongoDB in VS-Code
  • 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.
  • Parse JSON String in C#Jun 07, 2023. Code example of how to parse a JSON string in C#
  • Convert string to JSON in C#Jun 06, 2023. Code example of how to convert string to JSON in C#
  • Convert a JSON object into a string in C#Jun 03, 2023. Code example of how to convert an object into a JSON string in C#.
  • How to Create A JSON String In C#?Jun 01, 2023. How to create JSON object in C#
  • 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
  • String Operations in Rust: A Beginner's GuideMay 08, 2023. In this article we learn about how to perform string operations in Rust, including reading, manipulating, and transforming strings, through a variety of examples
  • How to Initialize String Array With Default Values In C#May 04, 2023. In this article, you will learn about How to initialize string array with default values in C#
  • Globalizing Strings in Microsoft .NET with the Multilingual App ToolkitMay 02, 2023. In this article, I will demonstrate how to do this and introduce you to the Multilingual App Toolkit, which makes string translation fast and cost-effective. It was so simple that I only needed a few hours (including my learning curve) to convert the Spargine Dev Tool to Danish, Hindi, and Spanish.
  • Advanced Query Tuning Techniques in SQL ServerApr 27, 2023. Advanced Query Tuning Techniques in SQL Server
  • Strings In RustApr 27, 2023. In this article, we discuss what is a string in Rust, the type of string in Rust, and how to use them.
  • Query Optimization Techniques in SQL ServerApr 25, 2023. Query Optimization Techniques in SQL Server
  • Using C# 12's Interpolated Strings For More Concise And Readable CodeApr 19, 2023. Using C# 12's Interpolated Strings for More Concise and Readable Code
  • 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.
  • How to Use GUIDs in C#?Apr 14, 2023. we are looking at GUIDs (Globally Unique Identifiers), which are widely used in C# for generating unique identifiers for objects, entities, and resources in a system. In this post, we'll explore the basics of GUIDs in C#, their advantages, and how to convert strings to GUIDs
  • How to remove duplicate words from string in C#Apr 14, 2023. This article covers all possible methods of removing duplicate words from string in C# with code examples and explanations.

About Query-String

NA

OUR TRAINING