Post
Ask Question
Related resources for Query
  • Difference between SQL and T-SQL5/9/2024 10:35:19 AM. In the realm of relational database management systems (RDBMS), SQL (Structured Query Language) and T-SQL (Transact-SQL) are often used interchangeably. In this article, we'll delve into the key d
  • Comma Separated Value (CSV) in MVC Using Ajax5/8/2024 9:48:29 AM. Learn how to implement CSV (Comma Separated Value) data handling in an MVC (Model-View-Controller) architecture using Ajax. Explore techniques for exporting data asynchronously, leveraging JavaScript
  • Unlocking Performance: Exploring PLINQ in .NET C#5/8/2024 8:40:53 AM. In today's computing landscape, where multi-core processors are ubiquitous, optimizing the performance of your applications often involves leveraging parallelism. One powerful tool in the .NET dev
  • Various Types of Hidden Fields in .NET5/7/2024 11:25:41 AM. Explore the diverse methods of managing hidden data in .NET applications. Learn about ViewState, Control State, Session State, HiddenField Control, Cookies, QueryString, Application State, Cache, and
  • Ckeditor4 Integration with MathType and ChemType using jQuery5/6/2024 11:58:44 AM. CKEditor is a WYSIWYG rich text editor which enables writing content directly inside of web pages or online applications. Its core code is written in JavaScript and it is developed by CKSource. CKEdit
  • Connecting Grafana to Data Sources5/6/2024 5:19:15 AM. Connect Grafana to databases, APIs, and more for powerful data visualization. Link MySQL, PostgreSQL, or InfluxDB seamlessly and extend with plugins for MongoDB, Kafka, REST APIs, and cloud platforms
  • SQL Indexing: Boosting SQL Query Performance5/6/2024 4:11:19 AM. Unlock the power of SQL indexing to supercharge your database queries with our comprehensive guide. Learn how indexing works, explore real-world examples, and discover essential tips for optimizing qu
  • JQuery Multiple File Upload and Remove5/3/2024 4:25:22 AM. This code segment utilizes jQuery to handle file upload and removal events in a dynamic UI environment. It captures file details upon selection, facilitates removal with associated buttons, and update
  • Multiple Ways To Bind Data To Kendo Grid In MVC5/2/2024 9:49:15 AM. Discover various methods to bind data to Kendo Grid in MVC. From server-side binding with IQueryable to client-side binding via AJAX and JSON, explore options like DataSource, ViewData, or ViewModel f
  • ASP.NET MVC jQuery Server Side Datatable Example4/30/2024 7:18:36 AM. This article is demonstrating the implementation of jQuery server side Datatable in MVC appplication with server side filter, sorting and Pagination.
  • SQL Server Fundamentals: Design, Queries & Optimization4/29/2024 10:52:37 AM. 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 examp
  • Pass Multiple Parameters in URL in Web API4/29/2024 10:02:24 AM. Learn how to efficiently pass multiple parameters in URLs when developing ASP.NET Web API applications. Explore techniques such as using query parameters, route parameters, and model binding to handle
  • Learn about jQuery Ajax in ASP.Net4/29/2024 10:00:43 AM. Learn how to utilize jQuery Ajax in ASP.Net for efficient client-server communication. Explore sending asynchronous HTTP requests, handling responses, and updating web content dynamically without full
  • Create Fixed Size Cropper Using ASP.Net and jQuery4/26/2024 12:16:16 PM. Create a fixed-size cropper using ASP.NET and jQuery to enable users to precisely crop images. This frontend UI component allows selecting and manipulating image regions within predefined dimensions,
  • Getting Started with Ignite UI igGrid4/25/2024 11:28:41 AM. Explore Infragistics Ultimate for intuitive UI tools like igGrid. Use JavaScript/HTML5 with CSS for grid layout customization. Incorporate jQuery libraries for enhanced functionality. Initialize and b
  • Delete Duplicate Rows In SQL Server From A Table4/25/2024 8:49:52 AM. In SQL Server, delete duplicate rows from a table efficiently using techniques like DISTINCT, GROUP BY, or ROW_NUMBER(). Ensure data integrity by considering primary keys or unique constraints.
  • Creating a Basic Overlay Effect in jQuery4/24/2024 2:07:41 PM. Learn to create a basic overlay effect using jQuery, enhancing web interactivity by overlaying content on existing pages, ideal for modal dialogs, lightboxes, or interactive pop-ups.
  • Get Client Side and Server Side Data in Grid View Using jQuery and Ajax4/24/2024 1:18:02 PM. Learn how to efficiently manage data in a grid view by combining client-side and server-side approaches using jQuery and Ajax. This tutorial guides you through the process of retrieving data from both
  • Django Bootcamp - FrontEnd (Bootstrap, Javascript, DOM, jQuery)4/24/2024 7:32:39 AM. Dive into the Django Bootcamp focusing on FrontEnd development, covering Bootstrap, JavaScript, DOM manipulation, and jQuery. Master essential skills to enhance user interfaces, create dynamic web pag
  • Integrating Datatables JQuery Plugin in ASP.NET Webforms4/23/2024 8:57:18 AM. Learn how to seamlessly integrate the DataTables jQuery plugin with ASP.NET WebForms for efficient server-side processing. This tutorial delves into harnessing the power of DataTables for dynamic data
  • How to Get External Drives and Peripherals Using WMI Query4/22/2024 9:26:33 AM. Learn how to efficiently retrieve information about external drives and peripherals on Windows using WMI queries. Explore the power of WMI (Windows Management Instrumentation) for detecting and managi
  • Zero To Hero In MS SQL Server - Part One4/19/2024 10:51:18 AM. This is part one of Zero To Hero Series in MS SQL Server. This is mainly focused for beginners who are into MS SQL Server and also for experienced who want to fresh up for interviews and daily technic
  • Mastering SQL Server Common Table Expressions (CTEs)4/19/2024 10:50:28 AM. Mastering SQL Server Common Table Expressions (CTEs) empowers users to create complex queries efficiently. Learn recursive and non-recursive CTEs, optimize queries, and enhance database management ski
  • Zero To Hero In MS SQL Server - Part Five4/19/2024 10:32:41 AM. Embark on a journey from novice to expert in MS SQL Server with Part Five of our comprehensive series. Explore advanced topics including query optimization, stored procedures, indexing strategies, and
  • Zero To Hero In MS SQL Server - Part Four4/19/2024 10:31:37 AM. In this article, Part Four of 'Zero To Hero In MS SQL Server' delves into advanced topics like query optimization, stored procedures, and indexing strategies. Master database management, T-SQL
  • Select Query With Logical Operator in a Mongo Database Using C# Driver4/18/2024 1:28:05 PM. Learn how to perform select queries in MongoDB using C# driver. Explore JSON-style object representation, conditional operators, insertion, and retrieval of data. Connect to MongoDB, serialize and des
  • Select Data Using Complied Query4/18/2024 11:13:18 AM. Learn how to optimize data retrieval in your application by utilizing compiled queries. This technique, often employed in Entity Framework and LINQ, enhances performance by pre-compiling queries, resu
  • Select Stored Proc With Raw SQL Query Via EDF Framework4/18/2024 10:43:47 AM. Utilize Entity Data Framework (EDF) for selecting stored procedures with raw SQL queries. Enhance data access in your application by leveraging the power of SQL alongside EDF's object-relational m
  • Using Table Valued Function for Data Selection - EDF Framework 5.04/18/2024 10:27:02 AM. Learn efficient data retrieval techniques using Table Valued Functions (TVF) through Data Entity Model in EDF Framework 5.0. Enhance database operations by leveraging TVFs within Entity Framework, sim
  • Mastering SQL Joins with the WITH(INDEX(Index_Name)) Clause4/18/2024 9:09:24 AM. Explore how the WITH(INDEX(Index_Name)) clause in SQL can turbocharge query performance by providing hints to the query optimizer regarding index selection, particularly when used in joins. Learn the
  • Create Enterprise Search Center Site Collection in SharePoint4/18/2024 8:25:23 AM. Empower your organization with an Enterprise Search Center Site Collection in SharePoint 2013 Online. Enhance content discovery, refine queries, and customize results for efficient information retriev
  • How To Create A Partitioned View In SQL Server4/15/2024 11:05:27 AM. Learn about creating and utilizing partitioned views in SQL Server for efficient data retrieval and performance optimization. Understand the concept, steps for implementation, check constraint usage,
  • ASP.Net Form Validation Using jQuery4/11/2024 10:52:32 AM. Learn how to perform form validation in ASP.Net using jQuery, enhancing user experience by validating form data on the client-side before submission. This tutorial covers setting up jQuery functions,
  • GET, SET The Value From HTML Table In ASP.NET MVC jQuery4/11/2024 10:25:17 AM. Learn how to utilize jQuery in ASP.NET MVC to efficiently GET and SET values from HTML tables. Enhance user interaction and streamline data handling between front-end and back-end components.
  • Enhance SQL Server Queries with OPTION(RECOMPILE) Hint4/11/2024 6:56:49 AM. 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 appl
  • Calling Web Service in HTML Page 4/11/2024 6:10:41 AM. Calling a web service in an HTML page involves using client-side technologies like AJAX and JavaScript to asynchronously communicate with a server. This allows for dynamic data exchange without reload
  • Using jQuery DataTable With ASP.NET MVC Client Side4/9/2024 11:46:04 AM. Utilize jQuery DataTable in ASP.NET MVC for dynamic client-side rendering of tabular data. Enhance user experience with features like pagination, sorting, and filtering, seamlessly integrating with se
  • Soft Delete in Entity Framework Core4/8/2024 7:15:23 AM. Soft delete in Entity Framework Core allows for logically marking records as deleted without physically removing them from the database. This technique involves setting a flag, often "IsDeleted,&
  • Becoming Proficient in C# and ASP.NET: A Roadmap to Mastery4/8/2024 4:59:04 AM. From traditional ASP.NET Web Forms to the sleek ASP.NET MVC, and from robust backend solutions using ADO.NET and SQL Server to dynamic front-end interactions with jQuery, AJAX, and more, developers ha
  • Employee Salary Updates Using SQL Update with Inner Join Query4/5/2024 9:16:51 AM. Explore how to update employee salaries while ensuring that each employee has only one salary per job. We'll accomplish this task using the UPDATE statement with INNER JOIN in SQL. Let's dive
  • jQuery Filters: Selecting, Manipulating, and Filtering DOM Elements4/5/2024 5:28:35 AM. jQuery Filters" refer to powerful methods in jQuery for selectively targeting elements within the DOM based on specific criteria. These filters allow developers to efficiently manipulate and inte
  • Power of Filtered Indexes in SQL Server4/5/2024 4:28:34 AM. Discover the power of filtered indexes in SQL Server with our concise guide. Explore practical applications and key benefits, empowering you to harness the full potential of SQL Server for enhanced da
  • How To Change Data Source Of Existing Report In Power BI4/4/2024 9:12:57 AM. To change the data source of an existing report in Power BI, access the report and navigate to "Edit Queries." Then, update the data source connection by modifying the query or connection se
  • Learn About Power BI Data Source Options And SQL Database Connection - Part One4/4/2024 7:25:57 AM. Explore Power BI's diverse data source options and its seamless connection to SQL databases in this informative series. Learn about querying, data integration, visualization, and more in Part One,
  • How To Query Dataverse In Microsoft SQL Server Management Studio (SSMS)?4/3/2024 10:45:55 AM. Querying Dataverse in Microsoft SQL Server Management Studio (SSMS) involves using Transact-SQL (T-SQL) to interact with tables, views, indexes, and stored procedures. Understanding entity relationshi
  • Tools in SQL Server Management Studio4/3/2024 10:42:11 AM. Learn to utilize essential tools like Object Explorer, Query Editor, and TSQL in SQL Server Management Studio. Navigate objects, execute commands, and manage databases efficiently. Explore more tech a
  • Difference Between Union & Union All In SQL Server 20174/3/2024 9:56:30 AM. In this article, you will learn the nuances between UNION and UNION ALL in SQL Server 2017. While both combine results from multiple queries, UNION removes duplicates, whereas UNION ALL retains them.
  • Comparing Execution Plans In SQL Server 4/3/2024 9:52:56 AM. SQL Server Management Studio (SSMS) allows easy comparison of execution plans, aiding in identifying performance discrepancies. Users can compare .sqlplan files, highlighting differences in query oper
  • Temporary Tables and Table Variables in SQL Server4/3/2024 5:59:21 AM. In this article we will explore the temporary tables and table variables in SQL Server. From understanding their differences to exploring practical use cases and examples. Whether you're storing i
  • Database Optimization Technique4/3/2024 5:40:07 AM. Database optimization ensures efficient and performant systems. Techniques like indexing, normalization, and query optimization enhance query performance and overall efficiency.
  • GET and POST Calls to Controller's Method in MVC4/2/2024 9:16:30 AM. In this article I am going to cover some really interesting material that is very useful today in web application development. You will learn how to make jQuery Ajax GET and POST calls to controller m
  • Difference between IEnumerable vs IQuerable4/1/2024 6:34:21 AM. Understand the difference between IEnumerable and IQueryable in .NET collections. While IEnumerable is suitable for in-memory collections, IQueryable allows for optimized queries, especially in scenar
  • Temporary Tables vs Common Table Expressions in SQL Server3/29/2024 11:07:01 AM. In this article, we will learn what is Differences Between Temporary Tables and Common Table Expressions in SQL Server. Temporary tables and Common Table Expressions (CTEs) are SQL Server tools for da
  • What is Language Integrated Query in C#?3/29/2024 9:08:50 AM. Know about LINQ (Language Integrated Query) in C# and their benefits. In this article, we have explained LINQ with an example.
  • What Is Automatic Tuning In Azure SQL Database3/28/2024 6:37:39 AM. Microsoft has long given us DBA tools and suggestions to help tune databases, to fix queries with indexes, and many times they were of questionable merit. We have all seen the dreaded dta_index names
  • What Is Date Correlation Optimization?3/28/2024 6:27:07 AM. OK So, I am doing some digging and peaking around again in SQL Server and came across a database option called Date Correlation Optimization Enabled = False. Honestly, I had no clue what it did, so I
  • Deletion of Record using Power Shell Script with FetchXML Query in D3653/23/2024 4:14:02 PM. Deletion of Contact Record using Power Shell Script with FetchXML Query in D365
  • Why GraphQL Is An Alternative Over React API3/21/2024 6:26:24 AM. GraphQL offers a more flexible and efficient approach compared to traditional REST APIs, especially when integrated with React. With GraphQL, frontend developers can request only the data they need, r
  • Querying Azure SQL Databases In Databricks Spark Cluster3/13/2024 8:44:48 AM. We will see the entire steps for creating an Azure Databricks Spark Cluster and querying data from Azure SQL DB using JDBC driver. Later we will save one table data from SQL to a CSV file.
  • Benefits of Temporary Tables over Table Variables in SQL Server3/10/2024 8:15:37 AM. 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 handl
  • Leveraging Compiled Queries for Enhanced Performance in LINQ3/9/2024 9:17:22 AM. 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 pl
  • Entity Framework Core 5.0 - An Introduction To What's New 3/7/2024 11:26:50 AM. Discover the latest features in Entity Framework Core 5.0, including improved performance, enhanced LINQ capabilities, migration enhancements, and streamlined database schema management.
  • New Features Of Entity Framework Core 2.03/7/2024 8:53:53 AM. Entity Framework Core is a lightweight and extensible version of Entity Framework. It is based on an ORM (Object-Relational Mapper) which enables us to work with databases using .NET objects. This art
  • Shadow Properties In Entity Framework Core3/7/2024 8:52:35 AM. In this article, you will learn Entity Framework Core's shadow properties, and hidden fields in the model that aren't mapped to the database schema directly. Learn how to leverage them for met
  • ASP.NET MVC Tooltip with Web API, Bootstrap Popover, jQuery UI Dialog3/7/2024 8:41:29 AM. This article provides a detailed guide on dynamically adding help/tooltip icons to form elements using jQuery UI modal or Bootstrap popover. The tooltips are fetched from a centralized location via We
  • Practical Introduction To Entity Framework: Day 33/6/2024 10:32:09 AM. Day 3 of this practical Entity Framework introduction delves into database transactions, query optimization, and advanced EF features. Learn to manage relationships, optimize data models, and fine-tun
  • Understanding FORMATMESSAGE() Function in SQL Server3/6/2024 4:58:24 AM. In this article, we will discuss how to use FORMATMESSAGE() function in SQL Server, its advantages and usages with example.
  • SharePoint 2010 Search Alerts3/5/2024 10:24:14 AM. This article explores the Search Alerts feature of SharePoint, which allows users to save queries and receive notifications via email or RSS feed when content matching the query is found. It discusses
  • SQL CTE to Rank Sales by Products using Fabric Data Warehouse3/5/2024 5:03:37 AM. This video shows how to author Common Table Expressions in Fabric Data Warehouse to Rank Sales by Products.
  • Improving SQL Performance Using Covering Indexes3/4/2024 11:29:49 AM. In this article we will try to understand what a covering index is, how to avoid the expensive key lookup operations, and how it can improve our T-SQL performance multi fold times.
  • SQL Tuning - Effective Strategies with Practical Examples3/3/2024 5:01:15 AM. SQL Tuning — Effective Strategies with Practical Examples
  • Effortless Pagination with jQuery DataTables and Bootstrap2/28/2024 9:02:53 AM. Effortless pagination with jQuery DataTables and Bootstrap offers seamless integration, providing a plug-and-play solution for front-end development. It enhances the user interface with responsive des
  • Quick SQL Refresher 2/28/2024 4:39:54 AM. 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, excep
  • ASP.NET State Management2/18/2024 5:38:25 AM. State management in ASP.NET is vital for maintaining application state across requests. It's a common topic in interviews, catering to both novices and seasoned developers. ASP.NET offers various
  • Local Temp Tables, Global Temp Tables, Table Variables, and CTEs Comparison2/12/2024 9:53:11 AM. 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 storag
  • Analysis of T-SQL and PL/SQL2/12/2024 4:03:24 AM. 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 effici
  • New Modifications and Improvements to the Azure Stream Analytics No-Code Editor 2/11/2024 8:22:36 AM. 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,
  • The Amazing Adventure of MongoDB Queries2/9/2024 9:21:46 AM. 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, executi
  • Getting Started With ASP.NET Core And jQuery CRUD Using WEB API2/9/2024 7:23:23 AM. A lab exercise for you to demonstrate what have you learned from this training material to create your own Todo CRUD operation using TodoRepository included in this training material.
  • Supported File Types for Data Ingestion into KQL Database in Fabric2/6/2024 10:04:20 AM. 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
  • Mastering T-SQL Rank Functions2/6/2024 9:28:41 AM. 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 nu
  • Clean and Transform Data using M Code Stored in Text File2/5/2024 8:32:26 AM. In this video, I showed how to clean and transform data using M code stored in Text file in excel
  • Optimize SQL Database Performance2/1/2024 8:40:21 AM. "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
  • Create a Workspace in Fabric1/15/2024 5:12:14 AM. 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#1/9/2024 4:35:29 AM. 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 unnece
  • Query to Find and Drop User-Defined Stored Procedure1/3/2024 9:53:53 AM. 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
  • Creating Dynamic PIVOT Query in SQL Server12/23/2023 11:50:26 AM. In this article, we are going to learn how to create dynamic PIVOT Query in SQL Server with some examples.
  • Inner Join SQL Query in Fabric Notebook using PySpark12/22/2023 5:15:40 AM. This video shows how to write inner join SQL Query in Microsoft Fabric Notebook using Spark.
  • Exploring Kusto Query Language (KQL): Uses, Queries, and Unique Features12/1/2023 5:09:29 AM. 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 querie
  • New DAX Query View in Power BI Desktop11/28/2023 4:15:58 AM. This video showcases the new DAX query view in Power BI Desktop November 2023 updates.
  • Display Loading or Processing Message Inside DataTable11/27/2023 6:52:34 AM. displays a loading screen while data is being loaded into a DataTable using JavaScript, you can use a combination of HTML, CSS, and JavaScript. Below is a simple example demonstrating how you can achi
  • GraphQL in .NET: GraphQL queries11/22/2023 7:02:01 AM. 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 HotC
  • Fabric Data Warehouse: Save as Table and Analyze Result Functionalities11/22/2023 3:53:08 AM. 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
  • Analyzing Sales Data with a Comprehensive SQL Query in Microsoft Fabric Data Warehouse11/18/2023 4:28:22 AM. 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
  • How To Use Query Parameters In Angular11/15/2023 11:26:44 AM. In this tutorial, we'll be looking at Query Parameters feature in Angular which lets you pass data from one route to another.
  • Cascading Dropdown List Of Country, State And City Using MVC, Web API And jQuery11/15/2023 9:09:46 AM. Today, in this article, I will explain how to create a Cascading dropdown list using MVC, Web API and jQuery.
  • Learn to Avoid Query Governor Cost Limit Error in SQL Server11/13/2023 7:08:56 AM. Learn to solve "The query has been canceled because the estimated cost of this query... "
  • Get IBM and Microsoft Daily and Weekly Historical Stocks Data from API11/10/2023 6:43:11 AM. Get IBM and Microsoft Daily and Weekly Historical Stocks Data from API.
  • Fetch Data from Azure Data Explorer of the Kusto Microsoft Fabric Database in Excel11/7/2023 5:19:43 AM. In this video, I demo how to fetch data from azure data explorer of the kusto Microsoft Fabric database in Excel.
  • What is SQL Server Management Studio (SSMS)11/7/2023 4:14:32 AM. 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 ob