Learn it from developers who built it.
Tutorials, how-tos and deep dives on AI, .NET, C#, cloud and developer tools, written by the community.
In this article, you will learn about STUFF() and REPLACE().

In this article, you will learn how to install microsoft SQL server management studio (SSMS)?

In this article, I am going to demonstrate how to find the employee who is getting highest salary. I am going to explain different ways of writing sql queries to find nth highest salary and department wise highest salary.

In this article, you will learn how to import excel data into SQL Server 2019.

Learn how to install and configure SQL Server Reporting Services (SSRS), including the service account, report server database, web service URL, and web portal URL.

In this article, we are going to configure Microsoft SQL Server on windows machine to listen on specific TCP port.

This tutorial will show you, how to prevent tables from being created, dropped, or altered in SQL Server.

In this article, you will learn about Table Scan, Index Scan, and Index Seek.

In this article, I have described various ways to handle NULL in SQL Server.

In this article I'll discuss how to put a SQL database into a Recovery Pending state.

In this blog we will learn how to take backup of database in SQL Server Express edition.

Get Table All Columns Schema Information in One Click In this article, I will show how we can get table columns information like ColumnName, DataType, DataType Length, is mandatory, and column brief description

Here is a list of the most popular MSSQL interview questions and answers explained. These SQL interview questions are for both beginners and professional MSSQL developers.

This tutorial will show you various methods to generate scripts for database objects in SQL Server 2019.

If you’re a developer, irrespective of the platform, you would have to work with Databases. Creating SQL statements for tables is quite often a monotonous job and it gets hectic especially with dealing gigantic tables that have hundreds of columns.

In this article we will explore the usage of Exists and Not Exists in SQL Server

In this article, we will see how to create a SQL Server Database backup. Database backup using SQL Server Management Studio, SQL Server provides a large number of options to create backups. We will discuss here FULL BACKUP and DIFFERENTIAL BACKUP.

In this article, you will learn how to convert the UTC Datetime to any timezone using SQL.

This tutorial will show you the difference between delete, truncate and drop statements in SQL Server.

This article describes how to import BACPAC file using SQL Server Manage Studio

This article describes what are the options for Database restore and create and how to export BACPAC file in SQL Server

In this article, you will learn about SQL Server Backup And Restore Planning.

How Change Data Capture (CDC) can be used to track and capture the changes performed by DML operations on an SQL Server table

Transact-SQL (T-SQL) is an extension to SQL developed by Microsoft and Sybase used to administer SQL Server.

In this article, you will learn about SQL Server 2019.

This article describes what is Linked servers and how to link MS SQL Server to Oracle from SSMS

In this article, you will learn how to install SQL Server 2019.

In this article, you will learn about SQL Index Creation Using DROP EXISTING ON.

This article describes how to configure SQL server reporting services and setup the environment in detail.
Everything on SQL Server, not only its articles: the SQL Server page →
DevSocialUpcoming · 3rd editionAI Agents ConferenceNov 23–27, 2026Live onlineMembers only16days leftRegisterMembers onlyWrite an article and earn +1,000 SHARP when it is approved.
Write an article