TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
About Sql Server
Share
facebook
twitter
linkedIn
Reddit
Topics
No topic found
Content Filter
Articles
Videos
Blogs
News
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Naveen Kumar (9)
Aradhana Tripathi (7)
Amit Mohanty (4)
Ajay Kumar (4)
Pankaj Kumar Choudhary (3)
Rohatash Kumar (3)
Ijas Ahamed (3)
Nitesh Jha (2)
Jaydeep Patil (2)
Alpesh Maniya (2)
Nandan Hegde (2)
Manikandan Murugesan (2)
Anandu G Nath (2)
Sivaruban Narayanapillai (2)
Satyaprakash Samantaray (2)
Jefferson S. Motta (2)
Abiola David (2)
Yogi S (2)
Mohammad Hussain (2)
Shaily Dubey (1)
Rohini Parade (1)
Sai Sherlekar (1)
Nisarg Upadhyay (1)
Raj Kumar (1)
Rohit Kainth (1)
Ravi Patel (1)
Mithilesh Tata (1)
Ankit Sharma (1)
Anupam Maiti (1)
Lakshmi V (1)
Bala S (1)
Pratik Somaiya (1)
Nitin Pandit (1)
Sharad Gupta (1)
Jitendra Maurya (1)
Ankit Sahu (1)
Najath Risni (1)
Harpreet Singh (1)
Shirsendu Nandi (1)
Jayraj Chhaya (1)
Yash Rajora (1)
Subarta Ray (1)
Rafnas T P (1)
Muzaffar Ur Rahman (1)
Deepak Tewatia (1)
George (1)
Onkar Sharma (1)
Staff Writer (1)
Simran Verma (1)
Ishika Tiwari (1)
Yuvapriya P (1)
Afzaal Ahmad Zeeshan (1)
Krishna Rajput Singh (1)
Akkiraju Ivaturi (1)
Hardik Sheth (1)
Ashish Shukla (1)
Rajeev Kumar (1)
Sardar Mudassar Ali Khan (1)
Durgaprasad Yadav (1)
Uday Dodiya (1)
Joshy George (1)
Senthilkumar (1)
Related resources for Sql Server
No resource found
How to Fetch Daily, Weekly, Monthly, and Yearly based Data in SQL
3/12/2024 10:59:03 AM.
In SQL, fetching data based on specific time intervals like day, week, month, and year is essential for meaningful analysis.
Benefits of Temporary Tables over Table Variables in SQL Server
3/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
How To Secure PII Data In SQL Server Using .NET Assembly
3/6/2024 10:46:18 AM.
In this article, we will learn PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number, etc. When you are working with financial
How To Secure PII Data In SQL Server Using CLE (Column Level Encryption)
3/6/2024 10:45:53 AM.
PII (personally identifiable information) which is used to identify individual identity such as SSN, DOB, Bank Account Number etc. When you are working with financial application you face the scenario
Practical Introduction To Entity Framework: Day 2
3/6/2024 10:30:54 AM.
This article provides a comprehensive guide on executing stored procedures using Entity Framework. It covers creating stored procedures in SQL Server, adding entity models to projects, and calling aut
Renaming the Column in SQL Server
3/6/2024 10:28:46 AM.
Renaming columns in SQL Server is a fundamental task in database management. This comprehensive guide provides step-by-step instructions, syntax examples, and best practices to effectively rename colu
Understanding FORMATMESSAGE() Function in SQL Server
3/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.
How to Enable Remote Connections in SQL Server 2005
3/5/2024 10:39:30 AM.
This article provides guidance on enabling remote connections in SQL Server 2005, addressing the common error message encountered when attempting a remote connection. It outlines the security precauti
Covering Indexes And Filtered Indexes In SQL
3/5/2024 10:36:56 AM.
Hello Learners. I hope you all are doing great. This article describes the Covering Indexes and Filtered Indexes. I would like to tell you that these type of Indexes can only be created as NONCLUSTERE
SQL Server Error Logging From A Stored Procedure
3/5/2024 10:28:44 AM.
In this article, we will learn effective error handling in SQL Server stored procedures. Utilize RAISERROR to log errors, manage exceptions, and maintain robust error reporting mechanisms for enhanced
Securing Remote Access to SQL Server
3/5/2024 4:16:02 AM.
Securing remote access to SQL Server is paramount for data protection and compliance. Explore methods like VPNs, firewalls, encryption, and multi-factor authentication for enhanced security and protec
SQL Server Performance Tuning: Data Compression
3/4/2024 11:30:53 AM.
In this article, you will learn about Data Compression in SQL Server. Learn SQL Server Performance Tuning, Types of Data Compression like Row Compression, Page Compression, Dictionary Compression.
SQL Tuning - Effective Strategies with Practical Examples
3/3/2024 5:01:15 AM.
SQL Tuning — Effective Strategies with Practical Examples
Product Management Application using .NET Core and React JS with CRUD Operations
3/2/2024 9:31:29 AM.
In this article, learn to create a product management web API with CRUD operations using .NET Core 6 and React JS. Utilize SQL Server for the backend and Axios for API consumption.
How to Open, Read or View MS SQL Error Log File
2/29/2024 10:47:38 AM.
Explore methods to open, read, or view SQL Server Error Log File. Get the best solution to open or view the SQL Server Log File of MS SQL Server in easy steps.
SQL Server Data Types for Performance, Memory Efficiency
2/28/2024 6:49:09 AM.
"Embark on a journey to unlock SQL Server's full potential through savvy data type selection. Enhance performance and streamline operations with optimal choices.
ASP.NET Core - Expense Manager Using EF Core And Highcharts
2/20/2024 7:31:47 AM.
We will create a personal expense manager using Asp.NET Core 2.1 and Entity Framework core Code first approach with the help of Highcharts to show the expense summary chart and a modal dialog to handl
SQL Server Migration Strategy into Azure SQL PaaS Database
2/16/2024 3:47:43 AM.
This article outlines a strategic approach to migrating SQL database workloads from on-premises to Azure cloud services. It covers the high-level migration roadmap, choosing the right migration path,
Difference Between UNION and UNION All (SQL Server)?
2/12/2024 11:55:50 AM.
UNION merges and filters out duplicates from various SELECT queries, whereas UNION ALL combines them without eliminating duplicates, providing quicker results but retaining all rows, including duplica
How to Find Blocked Deadlocks in SQL?
2/9/2024 8:42:19 AM.
The SQL query utilizes dynamic management views (DMVs) like sys.dm_exec_requests, sys.dm_exec_sessions, sys.dm_exec_connections, and sys.dm_exec_sql_text to monitor and manage active sessions, connect
Difference Between Raw SQL and Dapper
2/8/2024 8:55:42 AM.
Explore the trade-offs between using raw SQL queries and leveraging Dapper, a micro-ORM for database access in C# development. Delve into performance, code maintainability, and efficiency to make info
Mastering T-SQL Rank Functions
2/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
Top 10 Most Used SQL Queries
2/6/2024 6:39:43 AM.
In this article you will learn about the top 10 most used SQL Queries. SQL Server is an interface which helps to communicate with the system’s database using queries.
Requirements to Install SQL Server 2014
2/6/2024 6:28:59 AM.
In this article I explain what are requirements to install SQL Server 2014
DATEPART Function in SQL Server
2/6/2024 6:26:51 AM.
This SQL Server tutorial explores the Datepart function, a built-in function for extracting portions of a DateTime field, demonstrated through practical examples for various date and time components.
Automated Deployment of SQL Server Database through Azure Devops
2/6/2024 4:04:30 AM.
Explore an automated deployment solution for SQL Server databases using Azure DevOps. This guide details the setup of a self-hosted agent, granting necessary server access, and configuring a release p
Implement CRUD Operations in .NET Core 8 with Dockerized MSSQL Server
1/25/2024 5:31:16 AM.
In this article, I'm going to implement the basic CRUD Operations using .Net Core Web API & the Dockerized MSSQL Server. This article guides you through implementing CRUD operations in ASP.NET
Run MS SQL Server on Docker 📦
1/24/2024 6:27:51 AM.
In this article, I'm going to show how to install Docker on Windows 11 and run the MS SQL server on it.
OPENJSON in SQL Server
1/15/2024 5:50:12 AM.
SQL Server's OPENJSON function is a powerful tool for working with JSON data in relational database systems. It allows users to parse and transform JSON-formatted strings into tabular data, making
Union and Union All
1/10/2024 6:55:52 AM.
This article will tell you the use of union and union all and difference between them and some key points that are important to follow in union and union all syntax.
SQL Functions and Examples.
1/10/2024 6:08:41 AM.
This article provides you with many built-in SQL functions including aggregate functions, date functions, string functions, control flow functions, window functions, and math functions.
Identifying the Root Cause of SQL Server Problems
1/10/2024 5:17:17 AM.
Finding issues in SQL Server involves troubleshooting and identifying the root cause of problems. Troubleshooting SQL Server issues involves comprehensive steps. Check error logs, use SQL Server Manag
Deleting Duplicate Records Using CTE
1/9/2024 7:00:44 AM.
In this article we will understand how to delete duplicate rows and records from table using Common Table Expression (CTE) in SQL Server.
Safely Changing the Instance Name of SQL Server
1/4/2024 5:24:47 AM.
Changing the instance name of a SQL Server involves several steps and should be done with caution. Secure process for changing the instance name of SQL Server. This guide ensures a smooth transition,
Truncate All Table Data in MSSQL
1/2/2024 10:49:45 AM.
In this article we will learn about how to truncate all tables in a SQL Server database using dynamic SQL. Exercise caution, as this operation deletes all data without the possibility of rollback. Lea
Creating Dynamic PIVOT Query in SQL Server
12/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.
Implement Entity Framework A Code First Approach in .Net 8 API
12/18/2023 11:14:53 AM.
In this article, we are going to discuss. How to implement Entity Framework a code first approach in .Net 8 API. In this approach, model classes and their relation are created first using the ORM des
Optimizing SQL Queries: CTE vs Temporary Tables for Speed
12/17/2023 7:22:44 AM.
In Microsoft SQL Server, there are different methods to enhance query performance: Common Table Expressions (CTE) and temporary tables.
Bind Data In WebGrid Control Using Stored Procedure In ASP.NET MVC 4.0 And SQL Server
12/7/2023 9:19:11 AM.
In this article, you will learn how to bind the data in WebGrid control, using stored procedure in ASP.NET MVC 4.0 & SQL Server 2012.
How Configure User’s Profile in Server 2019
12/7/2023 6:22:57 AM.
This article guides you through configuring user profiles on Windows Server 2019 for effective access control and privilege enforcement. Learn step-by-step procedures, including logon hours, log-on to
Getting Started with SQL Server 2022 SSDT 17.8
12/7/2023 6:12:21 AM.
It breaks down complex concepts into easy-to-understand terms: SSDT, SSIS, SSAS, SSRS, ETL, SSOX, MDS, TDS and OLAP.
Stored Procedures In SQL Server
12/6/2023 9:44:18 AM.
This tutorial explains everything about SQL Server Stored Procedures including creating a stored procedure, updating a stored procedure, deleting a stored procedure, and executing a stored procedure i
Generate Database Script with Table Data From SQL Server
12/6/2023 9:21:33 AM.
In this article, I will describe how to generate a database script for a table with all it's data, views, stored procedures, constraints, and login credentials.
Ingest Excel Data to Azure SQL Database using SSMS GUI
12/6/2023 5:30:32 AM.
This video shows how to easily ingest Excel data to the Azure SQL Database using the SQL Server Management Studio Graphical User Interface
Join vs. Except and Intersect in SQL
12/6/2023 4:57:35 AM.
SQL Improvement Performance Tips & Tricks. Explore SQL data retrieval methods with JOIN, EXCEPT, and INTERSECT keywords. JOIN combines rows from multiple tables based on a related column, while EX
PIVOT AND UNPIVOT Operators in SQL Server
12/5/2023 8:25:24 AM.
In this article, we are going to learn PIVOT and UNPIVOT Operators in SQL Server with some examples.
Efficient Data Fetching Techniques in SQL Server
12/5/2023 5:24:30 AM.
This article combines theory and hands-on SQL examples to showcase efficient data retrieval techniques in SQL Server. From indexing strategies to query optimization, it offers actionable insights for
Time Series Databases: Understanding, Using, and Implementing
11/28/2023 9:56:25 AM.
In our era of data dominance, managing and analyzing time-sensitive information is pivotal, especially in finance, IoT, and healthcare. Traditional databases grapple with time-stamped data, paving the
Ranking Function in SQL Server
11/23/2023 4:52:58 AM.
This SQL Server tutorial explores ranking functions, including RANK(), ROW_NUMBER(), DENSE_RANK(), and NTILE(). With detailed examples, learn how these functions assign ranks, sequential row numbers,
RANK, DENSE_RANK And ROW_NUMBER Functions In SQL Server
11/22/2023 6:20:33 AM.
Learn RANK, DENSE_RANK And ROW_NUMBER Functions In SQL Server.
Inserting 1 Million Dummy Product Data into SQL Server Using Bogus Package
11/17/2023 7:36:39 AM.
When working with databases, populating them with substantial amounts of data for testing or demonstration purposes is crucial. The Bogus package in C# provides a convenient way to generate fake data,
MAXRECURSION Option In CTE
11/15/2023 9:28:03 AM.
In this article, you will learn about MAXRECURSION option in CTE.
Basic Authentication with ASP.Net Core Web API Using MySQL Server
11/15/2023 6:06:58 AM.
This article provides a comprehensive guide for implementing Basic HTTP authentication in a .NET 3.1 API with C#. The step-by-step instructions, code snippets, and explanations seem well-organized.
Learn to Avoid Query Governor Cost Limit Error in SQL Server
11/13/2023 7:08:56 AM.
Learn to solve "The query has been canceled because the estimated cost of this query... "
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
Recover Deleted Table Data "without Backup" in SQL Server
10/31/2023 4:42:47 AM.
This article will discuss Recover Deleted Table Data "without Backup" in SQL Server.
SQL UPDATE with JOIN
10/30/2023 8:24:41 AM.
This tutorial will show you the concept of SQL UPDATE With JOIN.
Resolve Error 40: Could Not Open a Connection to SQL Server
10/27/2023 7:14:46 AM.
In this article we will discuss about various reasons and solutions to resolve error : 40 related to SQL Server connection.
Optional Parameters in SQL Server
10/26/2023 12:57:13 PM.
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 enha
SQL Server Connection Error: Network Issue
10/25/2023 7:13:36 AM.
a network-related or instance-specific error occurred while establishing a connection to sql server. the server was not found or was not accessible. verify that the instance name is correct and that s
ASP.NET Core MVC CRUD Application with Dapper
10/24/2023 10:40:36 AM.
Learn how to build a robust CRUD application in ASP.NET MVC with Dapper, a lightweight and efficient ORM library.
Event Trigger Data Sync from SQL Server to Synapse via Azure Data Factory / Synapse Pipeline
10/23/2023 7:51:04 AM.
Event Trigger Data Sync from SQL Server to Synapse via Azure Data Factory / Synapse Pipeline
Dynamic Data Masking in SQL Server
10/23/2023 6:06:08 AM.
In this article, we will discuss about Dynamic Data Masking (DDM. Dynamic Data Masking (DDM)) in SQL Server is a security feature designed to protect sensitive data in real-time by obfuscating it from
Connect to Data Warehouse in Microsoft Fabric from SQL Server Management Studio
10/20/2023 9:16:19 AM.
This video shows how implement connection to Data Warehouse in Microsoft Fabric from SQL Server Management Studio
What is Lead and Lag in SQL Server?
10/20/2023 5:55:35 AM.
SQL Server offers the LEAD and LAG functions for accessing data from subsequent and previous rows in a result set. These functions are instrumental in data analysis and complex query development, enha
How To Install And Configure Microsoft SQL Server Management Studio (SSMS)
10/18/2023 10:04:05 AM.
Learn how to install and configure Microsoft SQL Server Management Studio (SSMS), a vital tool for managing SQL Server instances, with step-by-step guidance and helpful screenshots.
Dynamically Bind HTML Template to JSON Data Without using Loop in SQL
10/17/2023 9:46:41 AM.
How we can dynamically bind html template to json data without using looping sql server
What are Temporal Tables in SQL Server?
10/16/2023 3:56:01 PM.
A temporal table, also known as a system-versioned temporal table, is a type of database table designed to track changes to data over time automatically. It accomplishes this without the need for comp
Know The History Of Your SQL Server Database
10/16/2023 9:00:14 AM.
Understand your SQL Server database history for effective management. Learn to identify the internal version number using SQL Server Management Studio and various T-SQL statements, ensuring accurate d
User Defined Table Types And Table Valued Parameters
10/13/2023 8:36:41 AM.
In this article you will learn about User Defined Table Types and Table-Valued Parameters. The concepts of User-Defined Table Types (UDTTs) and Table-Valued Parameters (TVPs) were introduced in SQL Se
SQL Server Database Connection In C# Using ADO.NET
10/12/2023 9:44:57 AM.
ADO.NET provides classes to connect to databases in .NET using C#. This article describes how to create a connection in .NET and use SqlConnection in C#.
Search Functionality in SQL Server
10/12/2023 5:01:38 AM.
In SQL Server, searching for specific patterns in columns is achieved using the LIKE operator. It employs wildcards such as '%' for multiple characters (e.g., 'Acc%') and '_' f
Solution: Login failed for user 'sa'. Microsoft SQL Server, Error 18456
10/11/2023 9:38:58 AM.
Login failed for user 'sa'. (Microsoft SQL Server, Error 18456)" is the most common error in SQL server login. There are multiple reasons for this error. One potential reason is you are t
How To Restore Northwind Database In SQL Server In One Minute
10/11/2023 8:49:39 AM.
To use Northwind database in your SQL Server, you need to restore it. In this tutorial, I will explain all the restore database steps through the images.
Solution: Mail not queued. Database Mail is stopped
10/11/2023 8:31:38 AM.
Database Mail is a feature in SQL Server that allows you to send email messages from the SQL Server database engine. It can be a crucial tool for alerting and notifications within a database system. H
5 Quick Ways To Delete Duplicate Records From Database Which Every Developer Must Know
10/11/2023 4:51:49 AM.
In this tutorial, I explain the 5 quick ways to delete duplicate records from any database table. These ways must be known to every developer.
How To Create Login Page In ASP.NET Web Application Using C# And SQL Server
10/10/2023 10:06:02 AM.
How to create login page In ASP.NET Web Application using C# and SQL Server.
Pagination In SQL Server
10/9/2023 8:51:10 AM.
Pagination in SQL Server refers to the practice of dividing a large set of query results into smaller, manageable subsets, or "pages," to improve performance and user experience. This techni
Pagination in SQL Server
10/9/2023 7:17:18 AM.
Pagination is the process of dividing large data into smaller data sets in discrete pages. It is widely used in web applications.
Dynamic Sorting in SQL Server
10/9/2023 4:55:05 AM.
Dynamic sorting in SQL Server allows you to sort the result set of a query based on one or more columns in a dynamic and flexible way.
Update Statistics in SQL Server
10/7/2023 6:00:46 AM.
In this article, we will discuss how to update statistics in SQL Server to ensure that the query optimizer has the most up-to-date information to make accurate estimates.
Step By Step Installation Of Microsoft SQL Server On Windows System
10/5/2023 10:37:38 AM.
In this article, we are going install Microsoft SQL Server on windows machine step by step. In this tutorial, we are going to use SQL Server 2019 Developer edition and Windows Server 2019.
Upload Single And Multiple Files Using The .NET Core 6 Web API
10/5/2023 6:23:59 AM.
In this article, you willl learn how to upload single and multiple files using the .NET Core 6 Web API.
Mastering the Art of Convert DateTime Formats In SQL Server with Over 30 Code Examples
10/4/2023 7:00:55 AM.
Learn how to convert datetime values to different formats in SQL Server with this comprehensive guide. Explore various date conversion functions and formats, including examples and code snippets, to e
Registered Servers in SQL Server Management Studio (SSMS)
9/27/2023 8:17:36 AM.
Registered Servers in SQL Server Management Studio (SSMS) is a feature that allows database administrators and developers to conveniently manage and access multiple SQL Server instances and other data
CRUD operations using Powershell and SQL Server
9/22/2023 3:40:43 AM.
PowerShell is very useful for automating various day to day tasks
ACID Properties in SQL Server
9/18/2023 5:27:47 AM.
ACID Properties in SQL Server ensure Data Integrity during a transaction.
Passing Table to a Store Procedure in SQL Server
9/15/2023 9:32:59 AM.
In this article, I described how to pass a table to a Stored Procedure parameter in SQL Server.
Azure Function Data Migration with ASP.NET Core Web API
9/15/2023 7:36:25 AM.
Creating an Azure Function for data migration from one database to another using an ASP.NET Core Web API involves several steps. In this example, I'll provide a high-level overview and code snippe
SQL Server Trigger
9/14/2023 11:34:03 AM.
This article explains triggers in SQL Server. A trigger in SQL is a special kind of Stored Procedure or stored program that is automatically fired or executed when some event (insert, delete and updat
DATEADD Function in SQL Server
9/14/2023 6:07:54 AM.
In this article, I would like to show the Dateadd Function in SQL Server.
Exception Handling in SQL Server
9/14/2023 4:36:29 AM.
This article explores SQL Server's TRY...CATCH statement for exception handling. It delves into its syntax, functions like ERROR_NUMBER and ERROR_MESSAGE, and demonstrates its use through examples
DateTime in SQL Server
9/13/2023 11:44:45 AM.
In this article we will learn about DateTime in SQL Server
Stored Procedure in SQL Server
9/12/2023 7:29:06 AM.
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 procedure
Automatic SQL Server Backup Utility using Sqlserver Agent
9/8/2023 10:36:46 AM.
It is a sample C# (VS2005) application for Automatic Sql server Backup Utility using sqlserveragent. I have used SQL-DMO dll. This article will show you how to create a automatic backup in Sql server
Good Practices to Write Stored Procedures in SQL Server
9/8/2023 9:35:57 AM.
This explains the good practices for writing stored procedures in SQL Server and the advantages of writing stored procedures.
SQL Commands
9/8/2023 6:12:46 AM.
In SQL Server, various types of SQL commands are essential for managing and querying databases. These include Data Query Language (DQL) for retrieving data, Data Definition Language (DDL) for defining
SQL SHA Algorithm Benefits
9/6/2023 8:31:22 AM.
SQL SHA Algorithm and Benefits of Using SHA Algorithm
SQL Server ACID Properties
9/4/2023 6:18:50 AM.
Understanding SQL Server ACID(Atomicity, Consistency, Isolation, Durability) Properties.
Call Web API in .NET and Filter Data using Bootstrap Filters with Less Code
8/27/2023 12:14:42 PM.
We can filter records for each columns in table with single textbox or search. With less code and few mins, We can implement that feature to work on complex data.