Post
Ask Question
Related resources for SQL
  • Entity Framework In MVC - Part Three9/12/2024 12:12:57 PM. This article explains the Code First approach in MVC using Entity Framework. It covers creating a new database from domain classes, reverse engineering an existing database to generate POCO classes, a
  • Entity Framework Core Feature - Global Query Filters9/12/2024 5:59:39 AM. Learn how to implement Global Query Filters in Entity Framework to apply automatic filters at the model level. This feature is commonly used for scenarios like soft delete and multi-tenancy, ensuring
  • Configure SQL Server Session State In ASP.NET Core9/12/2024 5:49:48 AM. This guide covers setting up SQL Server as a session storage provider, configuring the connection string, enabling session middleware, and ensuring session persistence for scalable web applications.
  • CRUD Operation Using Repository Unit Of Work Pattern9/12/2024 5:44:14 AM. Create an ASP.NET MVC project in Visual Studio 2013, add a class library, and set up a SQL Server database. Implement Entity Framework with an EDMX model, then use the Repository pattern for CRUD oper
  • Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise Mode9/12/2024 5:10:58 AM. This article explains how to configure a Data Gateway for an On-Premise SQL Server Database using Power BI's Recommended Mode. It covers the installation steps, including downloading and setting u
  • SQL Vs DAX: Calculating Total Sales & COGS using SQL and DAX9/11/2024 8:13:50 AM. This videos show how to use SQL and DAX languages to compute Total Sales and Total Cost achieving the same result in Fabric Warehouse and Power BI.
  • Database Mail Configuration in SQL Server 20089/10/2024 10:16:49 AM. Learn how to configure Database Mail in SQL Server 2008 with this guide. Discover step-by-step instructions for setting up email profiles, configuring SMTP settings, and managing mail settings using S
  • Real Time Use Of Context Menu Strip In Windows Form Application9/9/2024 11:35:42 AM. Learn how to use ContextMenuStrip in a Windows Forms application to delete records from a DataGridView. This tutorial covers setting up a context menu, handling right-click events, and executing a del
  • Relations between Dataset in DBMS9/6/2024 12:45:34 PM. A relationship in DBMS links two or more data sets. This article explores types of relationships: one-to-one, one-to-many, and many-to-many, and their implementations in databases.
  • SQL Data Analysis Using Azure Synapse Built-in Serverless Pool9/6/2024 6:06:58 AM. In this video, I demonstrated how to perform SQL Data Analysis in Azure Synapse Analytics using built-in serverless pool.
  • SQL: Not Using Aggregate Function in WHERE Clause, instead, Using HAVING Clause9/5/2024 12:51:37 PM. This article will discuss the issue that SQL: Not Using Aggregate Function in WHERE Clause, instead, Using HAVING Clause
  • Export Data Table To Excel in ASP.Net MVC 49/5/2024 11:09:19 AM. This article demonstrates exporting a Data Table to Excel in ASP.NET MVC. It covers creating a new project, adding a ClosedXML reference, and setting up models and controllers. It details fetching dat
  • Export Data From Database Table to Excel File in ASP.Net MVC9/5/2024 10:55:56 AM. Exporting data from a database to Excel in ASP.NET MVC involves creating a database, setting up a model, and designing a view. Use SqlConnection and SqlDataAdapter to fetch data and Microsoft.Office.I
  • How To Implement CKEditor In ASP.NET MVC9/5/2024 10:45:12 AM. CKEditor is a powerful, browser-based WYSIWYG editor that simplifies HTML content creation. It integrates seamlessly with ASP.NET MVC, allowing users to easily create and manage rich text content.
  • Temporary Tables vs Table Variable in SQL Server9/5/2024 7:20:02 AM. In this article you will learn about Temporary Tables and Table Variables in SQL Server 2008. Temporary tables come in two types: Local (prefixed with "#", accessible only to the current con
  • What are Temporary Tables in SQL Server?9/5/2024 7:19:46 AM. Temporary tables in SQL Server, stored in tempdb, assist with short-term data management. They come in Local (scope limited to current connection, prefixed with "#") and Global (accessible t
  • SQL Subqueries: Correlated, Scalar, and EXISTS/NOT EXISTS9/4/2024 9:30:54 AM. 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 EXI
  • Database Mail in SQL Server 2008R29/4/2024 8:38:30 AM. Database Mail in SQL Server 2008 R2 enables sending emails directly from SQL Server using SMTP. It supports job alerts, query results, and file attachments, ensuring consistent, scalable, and secure e
  • GridView Paging Sample in ASP.NET9/4/2024 8:21:34 AM. Learn how to implement various paging styles in ASP.NET GridView using C#. This guide covers binding SQL Server data to a GridView, enabling paging, and customizing pager settings like Numeric, NextPr
  • Configure SQL Server Database Mail for Sending Emails9/4/2024 7:01:19 AM. This guide covers the step-by-step process for setting up Database Mail, including creating and managing mail accounts, profiles, and ensuring your SQL Server can successfully send email notifications
  • Learn Common Table Expressions (CTE) in SQL9/4/2024 6:25:07 AM. Common Table Expressions (CTEs) in SQL are a powerful tool for simplifying complex queries. They allow you to create temporary result sets that can be referenced within a SELECT, INSERT, UPDATE, or DE
  • Advance Chat Application with .NET and SignalR9/2/2024 8:30:14 PM. Build an advanced real-time chat app with .NET 8, SignalR, and MS-SQL. This guide covers creating a chat app with one-to-one and group messaging, utilizing ASP.NET Identity for user roles and permissi
  • Introduction to SQL Server & Its History9/2/2024 7:10:06 AM. Learn how to create, manage, and query databases using SQL Server, with a focus on essential concepts like database design, data storage, and SQL queries. Perfect for beginners aiming to build a stron
  • ADF: Provision Snowflake Database Table in Azure SQL DB and Create Power BI Report9/2/2024 7:08:05 AM. In this data engineering and data analysis episode, I covered how to provision single snowflake database table in azure sql database and then use Power BI desktop to connect to the data to create Powe
  • Learn Database Mail in SQL Server8/29/2024 10:53:40 AM. Database Mail in SQL Server is a robust feature that enables sending emails via an SMTP server without relying on MAPI clients like Outlook. It offers secure SSL encryption, asynchronous processing, e
  • SSRS (4) --- SQL Server Database Project in Visual Studio8/29/2024 2:28:31 AM. This article is to discuss: SQL Server Database Project in Visual Studio
  • Understanding SQL Triggers: A Practical Guide with a New Example8/28/2024 8:38:05 AM. Discover how triggers can automate tasks, enforce business rules, and maintain data integrity in your database. Perfect for both beginners and experienced developers looking to deepen their SQL skills
  • Mastering Pivot Tables in SQL8/28/2024 6:59:59 AM. Learn to efficiently aggregate, summarize, and transform data using advanced SQL queries. Discover techniques for data analysis, reporting, and visualization to enhance your analytical skills.
  • Inner Join vs Cross Apply and Left Outer Join vs Outer Apply8/28/2024 5:32:30 AM. In SQL, INNER JOIN and CROSS APPLY differ in functionality; INNER JOIN merges rows based on a condition, while CROSS APPLY uses a table-valued function for dynamic row operations. LEFT OUTER JOIN incl
  • SQL Data Analysis using Azure Synapse Built in Serverless Pool8/28/2024 4:28:22 AM. In this Azure Data Engineering episode, I discussed how to perform SQL Data Analysis using Azure Synapse Built in Serverless Pool
  • Unit Test (2) --- TSQLT8/27/2024 1:49:06 PM. This article will discuss TSQLT Unit Test.
  • Implementation Ajax Calls in ASP.NET Core MVC 8/27/2024 7:03:37 AM. Learn how to build a dynamic fleet management system using AJAX in ASP.NET MVC with SQLite as the database provider. This tutorial guides you through creating, managing, and displaying vehicle data in
  • New in Fabric Warehouse SQL: TRUNCATE8/27/2024 6:07:38 AM. The SQL TRUNCATE command, newly introduced in Fabric Warehouse, offers an efficient way to delete all rows from a table without logging individual row deletions.
  • Learn about Different Type of Triggers in Oracle8/23/2024 8:02:40 AM. In this article, you will learn about different type of triggers in Oracle.
  • Understanding IN vs EXISTS in SQL8/22/2024 5:29:41 AM. Explore the differences between the IN and EXISTS operators in SQL. Learn how each operator affects query performance, and understand their use cases in filtering and retrieving data. This guide provi
  • Real-Time Pageview Tracking With .NET Core8/21/2024 5:28:26 AM. Learn how to implement real-time pageview tracking in your .NET Core application. This guide covers setting up live monitoring of website traffic, capturing pageview metrics, and integrating real-time
  • Read Parquet Data to Fabric Warehouse using COPY INTO & INSERT INTO SQL Statements8/21/2024 4:49:45 AM. In this new episode, I demonstrated how to Read Parquet Data to Fabric Warehouse using COPY INTO & INSERT INTO SQL Statements.
  • Why You Should Learn Azure Cosmos DB?8/20/2024 12:26:01 PM. Discover why learning Azure Cosmos DB is essential for modern data management. With its global distribution, scalability, and multi-model capabilities, Cosmos DB offers unmatched performance and high
  • Learn to Shrink a Microsoft SQL Server Database Programatically 8/20/2024 4:59:45 AM. Shrinking a SQL Server database reduces file size by reclaiming unused space in data and log files. This can optimize disk usage, especially in storage-constrained environments. However, it can cause
  • Explain Subqueries in PostgreSQL8/16/2024 7:21:21 AM. 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 i
  • Recursive CTE: Simplifying Complex Queries with SQL8/16/2024 7:14:44 AM. 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 o
  • How to Retrieve and Display Database Records in Java Using JTable8/13/2024 5:22:08 AM. Learn how to retrieve and display database records in Java using JTable with this step-by-step guide. Explore Java Swing for creating a graphical user interface, JDBC for database connectivity, and SQ
  • SQL Server on Azure VMs vs Managed Instance vs SQL Database8/12/2024 11:18:45 AM. Based on the type of the cloud service each Relational azure service use and different aspects formulated the differences and uses cases when to use each database solution.
  • Difference Between Primary Key and Unique Key in SQL8/12/2024 9:38:24 AM. Primary Key and Unique Key are essential in relational databases for data integrity. A Primary Key uniquely identifies each row and cannot be NULL, while a Unique Key ensures column values are unique
  • Azure Databricks: Group By All Clause8/12/2024 5:25:13 AM. In this Azure Databricks episode, I covered how to use the Group By All clause to efficiently query data in the SQL editor.
  • Validating User Input Using Regular Expression With C#8/9/2024 9:46:52 AM. In software development, validating user input is crucial to prevent errors and security issues. Regular expressions (regex) are used to validate fields such as email, zip codes, and phone numbers. Th
  • How Do We Create Custom APIs with Next.js?8/8/2024 5:25:24 AM. Next.js allows you to create custom APIs with API routes defined in the pages/api directory. You can handle various HTTP methods (GET, POST, PUT, DELETE), use query parameters, connect to databases (e
  • Azure Data Factory: Clean and Transform Multiple Data using Dataflow8/8/2024 4:14:34 AM. In this Data Engineering episode, I covered how to use Azure Data Factory Dataflow to read, appends multiple CSV files from ADLS Gen2, clean and transform the data and sink to the Azure SQL Database f
  • Login And Registration Process In WPF application8/7/2024 10:30:02 AM. This WPF application in Visual Studio 2010 features a simple login and registration system with two forms: Registration and Login. Users register on the Registration form, and upon successful registra
  • Understanding the NTILE Window Function in SQL8/7/2024 4:10:20 AM. Understanding the NTILE Window Function in SQL" delves into the NTILE function, a powerful SQL tool used to divide result sets into a specified number of roughly equal groups.
  • How to Upload a File to Amazon S3 with NodeJS8/6/2024 6:16:29 AM. Implementing pagination and filtering in an ASP.NET Core 8.0 API with Entity Framework Core (EF Core) is crucial for efficiently managing large datasets. This guide covers setting up the project, crea
  • Detailed explanation of SQL Server Triggers and its Advantages8/6/2024 5:27:50 AM. SQL Server triggers are automated stored procedures that execute in response to specific database events such as INSERT, UPDATE, or DELETE (DML) and CREATE, ALTER, or DROP (DDL). They enforce business
  • VIEW in SQL with example8/6/2024 4:57:26 AM. SQL Views act as virtual tables based on predefined queries, streamlining data access and management. They eliminate the need to rewrite complex joins or aggregations in your applications. Views enhan
  • Implement CI/CD for SQL Server with Visual Studio and Azure DevOps8/2/2024 8:44:29 AM. Implementing Continuous Integration and Continuous Deployment (CI/CD) for SQL Server databases ensures that database changes are automatically built, tested, and deployed to various environments.
  • T-SQL Script for Purging Tables with Foreign Key References8/2/2024 8:42:15 AM. This article provides a comprehensive T-SQL script for purging tables in SQL Server, including those with foreign key references, ensuring data integrity and correct order of operations. Ideal for SQL
  • What are Azure Resources and Resource Groups8/2/2024 6:21:11 AM. Azure Resources are individual cloud services like virtual machines, app services, and storage accounts. Each resource serves a specific purpose, such as data storage or application hosting. Azure Res
  • Basics of Working With Windows Azure Table Storage8/2/2024 5:08:21 AM. Learn how to efficiently store and manage large datasets in the cloud, explore key features, and get practical tips for data organization, querying, and performance optimization in Azure Table Storage
  • Understanding ROW_NUMBER() in SQL Window Functions8/2/2024 4:46:39 AM. ROW_NUMBER() is a window function in SQL that assigns a unique number to each row within a partition of a result set. It’s useful for ranking, removing duplicates, pagination, and selecting the top N
  • Table(s): Temp Table, Table Variable and CTE (Common Table Expression)8/1/2024 6:37:16 PM. This article will discuss SQL Table like items, including temp table, table variable, CTE, Table-valued Parameters.
  • Count(*) vs Count(1) in SQL8/1/2024 4:11:33 AM. When counting rows in SQL databases, both `COUNT(*)` and `COUNT(1)` are used, but there is no performance difference between them. Modern databases optimize both functions similarly. Prioritize code r
  • Create XML in .NET Core API and Send to Stored Procedure Using Dapper7/30/2024 10:43:10 AM. Learn how to create and send XML data to a stored procedure in a .NET Core Web API. This guide covers setting up a .NET Core Web API project, generating XML from data models, using Dapper for database
  • How To Connect On-Premise SQL Server From Microsoft Flow Using Azure On-Premise Data Gateway7/30/2024 4:34:24 AM. This guide covers step-by-step instructions to set up the gateway, configure data connections, and integrate your SQL Server with Flow for seamless automation and data management.
  • EF Core Query Tags: What They Are and How to Use Them7/29/2024 11:25:31 AM. Discover the power of EF Core Query Tags in optimizing and debugging your database queries. This guide explains what query tags are, their benefits, and how to implement them in your Entity Framework
  • Training a Small Language Model AI Using Text Files, C#, and SQL Database7/29/2024 10:57:22 AM. This article guides you through training a small language model AI using text files, C#, and an SQL database. It covers preparing text data, setting up an SQL database, tokenizing data with C#, and q
  • @@ROWCOUNT in SQL Server7/29/2024 9:28:40 AM. @@ROWCOUNT is a SQL Server function used to retrieve the number of rows affected by the last executed statement. It provides valuable insights for data manipulation and validation processes, helping t
  • Blazor Web Assembly 3.2 Add/Edit/Delete Fully Functional Application - Part One7/29/2024 8:37:43 AM. This article guides you through creating a Blazor web assembly app with .NET Core hosting. It covers setting up .NET Core APIs, Entity Framework Core for SQL Server data access, and implementing CRUD
  • Programming in Practice - LINQ to SQL - Explained7/29/2024 6:31:06 AM. Discover the power of LINQ to SQL in this comprehensive guide. Learn how to seamlessly integrate LINQ queries with SQL databases using the .NET framework. From setting up your environment to executing
  • BigQuery to Azure SQL Database using Azure Synapse Analytics7/26/2024 5:29:48 AM. In this video, I covered how to use Azure Synapse Analytics to integrate data from Google Big Query to Azure SQL Database.
  • SQL Essentials: GROUP BY vs. PARTITION BY Explained7/26/2024 4:08:59 AM. Discover how GROUP BY aggregates data into summary rows, while PARTITION BY divides data into partitions for window functions. Master these techniques to enhance your SQL querying skills.
  • SQL Performance (2), Optimized SELECT Query (B)7/25/2024 5:41:20 PM. This article discuss SQL performance on optimizing SELECT Query, Second Part.
  • Creating Maintaining Utilizing Transactions in SQL Server7/25/2024 5:25:28 AM. A transaction in SQL Server is a sequence of operations performed as a single logical unit of work. A transaction has four main properties, often referred to by the acronym ACID: Atomicity, Consistenc
  • UNION vs UNION ALL in SQL Server7/24/2024 9:28:49 AM. The SQL UNION operator combines the results of two or more SELECT statements, removing duplicate rows. In contrast, UNION ALL combines results while retaining all duplicates. UNION may impact performa
  • Connection with SQL and queries.7/24/2024 8:08:46 AM. 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 practic
  • Understanding Table Partitioning in SQL7/24/2024 6:07:08 AM. Table partitioning is a technique in database design that divides large tables into smaller, manageable pieces called partitions. This approach improves query performance, enhances manageability, and
  • Understanding Normalization in SQL7/24/2024 4:47:41 AM. Normalization is a database design process that reduces redundancy and improves data integrity by organizing data into tables and defining relationships. It involves applying normal forms (1NF, 2NF, 3
  • Creating Triggers in SQL Server7/24/2024 4:44:18 AM. SQL Server triggers are automated procedures that execute in response to specific events, enhancing data integrity and enforcing business rules. They include DML triggers (AFTER, INSTEAD OF) for data
  • Real-World ADO.NET Use Cases: Case Studies and Best Practices7/24/2024 4:41:43 AM. ADO.NET remains a robust data access technology within the .NET framework, even as newer technologies emerge. Its ability to manage data interactions efficiently makes it suitable for a variety of rea
  • Performance Optimization in ADO.NET: Tips and Techniques7/23/2024 9:19:54 AM. Optimize ADO.NET performance by leveraging connection pooling to reduce overhead, using efficient command execution strategies such as stored procedures and batch processing, and retrieving data effec
  • Difference Between DELETE and TRUNCATE in SQL Server7/23/2024 9:18:59 AM. In SQL Server, DELETE and TRUNCATE are used to remove data from tables, each with distinct characteristics. DELETE is a DML command that logs each row deletion, supports triggers, and respects foreign
  • Efficient Data Retrieval with ADO.NET SqlDataReader 7/23/2024 6:15:48 AM. SqlDataReader in ADO.NET provides fast, forward-only data retrieval from SQL Server databases. It reads data as a stream, minimizing memory usage, and making it ideal for large datasets. Unlike SqlDat
  • Advanced ADO.NET Features for Complex Data and Async Operations7/23/2024 4:39:40 AM. ADO.NET remains essential for database interactions in . NET. Advanced features include handling complex types with SQL Server's UDTs and XML data, managing binary data with VarBinary, and leverag
  • Security Best Practices in ADO.NET7/23/2024 3:51:46 AM. ADO.NET is a powerful data access technology in the .NET framework, enabling developers to interact with databases. This article explores best practices for protecting sensitive data, preventing SQL i
  • Executing Commands with ADO.NET7/22/2024 10:02:34 AM. Explore how to use ADO.NET’s SqlCommand class for executing SQL queries and stored procedures in .NET applications. This guide covers setting up SqlConnection, using methods like ExecuteNonQuery, Exec
  • Connecting to a MySQL Database Over LAN Using SQL Workbench7/22/2024 8:18:50 AM. Learn how to connect to a MySQL database over a local area network (LAN) using SQL Workbench. This guide covers finding the IP address of the MySQL server, configuring it for remote access, setting up
  • Setting Up Your First ADO.NET Project7/22/2024 7:29:17 AM. ADO.NET is a set of classes that expose data access services for .NET Framework programmers. It provides a rich set of components for creating distributed, data-sharing applications. This guide will w
  • Detailed Explanation of Procedure and Function in SQL Server7/22/2024 6:22:57 AM. Stored procedures are precompiled sets of one or more SQL statements that can be executed together. Functions in SQL Server are essential database objects that contain a series of SQL statements and p
  • Working with Stored Procedures in ADO.NET7/22/2024 6:17:00 AM. Stored procedures are a powerful feature in database management systems that allow you to encapsulate complex logic and operations on the server side. When using ADO.NET in a .NET application, stored
  • Working with Connection Objects in ADO.NET7/22/2024 6:14:31 AM. ADO.NET is a set of classes that expose data access services for .NET Framework programmers. A primary feature of ADO.NET is the ability to work with disconnected data. However, working directly with
  • ASP.NET C# Display Bootstrap Bar Chart from Database Values7/22/2024 5:58:27 AM. Create a stored procedure in SQL to fetch monthly audit data and display it in an ASP.NET application. Use Visual Studio to create a master page with jQuery and Flot libraries. Serialize the data to J
  • Understanding the SQL Query Execution Order7/22/2024 4:41:19 AM. SQL (Structured Query Language) is essential for interacting with relational databases, and mastering its intricacies can significantly enhance your data querying skills. One of the fundamental aspect
  • Breaking Down SQL Complexity7/21/2024 4:03:03 AM. Choosing between Common Table Expressions (CTEs) and subqueries in SQL Server depends on readability, maintainability, and performance. Subqueries are ideal for simpler, single-use cases, while CTEs e
  • Interesting Query (2) --- Whtch Manager has no Employee with7/19/2024 10:12:18 PM. This article will discuss interesting queries, more.
  • Interesting Query (1) --- Find Second Highest Salary7/19/2024 10:11:51 PM. This article will discuss several most popular, complex, and interesting SQL queries and their solutions.
  • Interesting Query (3) --- Get Rolling Average7/19/2024 10:09:29 PM. This article will discuss Interesting Query (3) --- Get Rolling Average
  • SQL- Self Join And Group By7/19/2024 9:00:50 PM. This article will discuss SQL: Self Join and Group by.
  • How to Create Server-Side Pagination, Searching, and Sorting Stored Procedure7/19/2024 1:36:54 PM. This article demonstrates how to create a SQL Server stored procedure for server-side pagination, searching, and sorting. The procedure efficiently handles large datasets by dynamically calculating to
  • Dynamically Creating a Table in SQL Server from Information Schema7/19/2024 11:01:55 AM. This SQL script dynamically creates a table in SQL Server by utilizing INFORMATION_SCHEMA and system views. It constructs the table definition, including columns, data types, constraints, and default
  • Hosting ASP.NET Website7/18/2024 3:13:24 PM. To host your ASP.NET website, register a domain name and log in to your hosting account. Upload your website files to the httpdocs directory. Create a database via phpMyAdmin, then link it to your sit
  • Implementing a Audit Trail in ASP.NET Core Web API7/17/2024 12:18:56 PM. Learn how to implement a robust audit trail in an ASP.NET Core Web API using Entity Framework Core and SQL Server. This comprehensive guide covers setting up the project, defining data models like Pro
  • SQL Server Collations: Case Sensitivity and Insensitivity7/17/2024 6:03:08 AM. This article explains SQL Server collations, which dictate data sorting and comparison rules. It highlights case-sensitive (CS) and case-insensitive (CI) collations with practical SQL query examples.