Loading
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.
We will cover all the new features which SQL came up within 2019 version
In this article you will learn about the difference Between Inner join and Left join In SQL Server.
This article presents stepwise instructions on how to pivot tables and create user reports.
In this article, you will learn how to find the Nth Highest Salary in SQL Server 2017.
In this article, we are going to learn about the Stored Procedure and the difference between Stored Procedures and Functions.
A SQL Operator is used for arithmetic, logical, and bitwise operations. This SQL Operators tutorial explains SQL Arithmetic Operators, SQL Assignment Operator, SQL Bitwise Operator, and SQL Logical Operator with examples.
In this article, I am going to explain different types of SQL commands which are DDL, DML, DQL, DCL, and TCL.
In this article, you will learn about Azure SQL Database Serverless.
Learn how to copy a SQL Server backup into a Docker container and restore it with T-SQL on SQL Server for Linux.
In this article, you will learn what is Batch Mode on Rowstore in SQL Server.
Explains SQL Server XML support, including SQLXML, XPath queries, XML schema mapping, FOR XML AUTO and EXPLICIT modes, and reading XML with XmlReader.
In this article you will learn about Quickly Blocking Inbound Connections to SQL Server.
Learn how to deploy an SSIS project to SQL Server Integration Services Catalog and schedule SSIS packages with SQL Server Agent.
In this article, you will learn about running SQL Server on my Mac with Docker.
We have compiled a list of top 10 most popular SQL Server articles.
In this article, you will learn about SQL Query optimization tools and techniques.
In this article you will learn about SQL query execution plan operations.
Learn how SQL Server execution plans work, including estimated, actual, and cached plans, SSMS display options, and STATISTICS IO, TIME, XML, and PROFILE output.
In this article you will learn how to solve bulk load error while using SQL Server Authentication in our Windows Application.
In this article, you will learn about Azure SQL Database - Great Choice for Modern Cloud Applications.
In this article, you will learn about exception handling in SQL Server.
Learn how SQL Server ROW_NUMBER() assigns sequential row numbers using ORDER BY and how PARTITION BY restarts numbering within groups.
In this article, you will learn about triggers.
In this article, you will learn about how to display information about events.
Learn how to repair corrupted SQL Server databases and MDF files using Stellar Repair for MS SQL, including scanning, previewing, and recovering database objects.
In this article, you will learn about being a woman in the sql community.
In this article, you will learn about String Function in SQL Server.
In this article, you will learn about Error 927: database can't be opened , it is middle of the restoration. it comes when we click on start mirroring. Actually this is not an error, this msg tell us that the database, for which you want to configure the mirror, is not fully restored. First Solution: For this we need to restore the latest transaction log backup on mirror server/ mirror node. Then click on start mirroring again at principal node, it will work. Second Solution: If we have restored the full backup and latest log backup as well and still we are getting error 927. then we need to execute below mentioned command as directed: On Mirror Server run this: ALTER DATABASE <Database_Name> SET PARTNER = ‘TCP://<Principal Server>:5022’ On Principal Server run this: ALTER DATABASE <Database_Name> SET PARTNER = ‘TCP://<Mirror Server>:5022’
Everything on SQL Server, not only its articles: the SQL Server page →
Mahesh Chand9 videos · 23 news posts+5.3Kpoints2
Aarav Patel21 articles · 1 day visited+2.1Kpoints3
Ananya Desai21 articles · 1 reaction received+2.1Kpoints4
Riya Patel20 articles · 1 reaction received+2Kpoints5
Bhavya Singh20 articles+2KpointsFull leaderboard →
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
