Loading
DevSocial Blogs · SQL Server blogs
Quick takes from developers at work.
Tips, fixes and short write-ups on what developers ran into this week, in their own words.
- Blogs
- 18,829
- Reads
- 471.6M
- Bloggers
- 3,370
Latest · 1,284 blogs
Quick takes from developers at work.
Tips, fixes and short write-ups on what developers ran into this week, in their own words.
In this blog, we will learn how to calculate the distance between two points on the Earth's surface.
In this blog, you will learn about table variable in SQL Server.
In this blog, we learn how to get collation name of a particular database and columns of a table.
In this blog, you will learn about OFFSET-FETCH clause in SQL Server 2012.
In this blog you will see the difference between Stored Procedure and Functions in SQLServer.
In this blog you will learn about Auto Increment ID Column using nvarchar DataType in SQL Server.
In this blog, you will learn how to resolve the 100 percent CPU usage problem in SQL Server.
In this blog, you will learn how to backup and replace text in all search string matching stored procedure(s).
In this blog, I will show you how to calculate working & non-working days of resources.
In this blog, you will learn how to recover the deleted data on SQL Server.
In this blog, you will learn about the Nth highest or lowest record in SQL.
I have noticed that after doing a Windows Update in Windows 10 , it sometimes disables SQL Server instances. I have provided a fix for it.
In this blog, we will learn about the Cycle Clipboard Ring feature of SQL Server Management Studio.
In this blog, you will learn how to download all report files or single (RDL) from ReportServer.
In this blog, we shall see how to use pivot tables in SQL Server.
In this blog, we will learn how to get the header information of a table.
In this blog, you will learn commonly used mathematical functions in SQL Server.
In this blog, you will learn how to alter a constraint in SQL Server.
This blog is intended to show the cumulative sum of hierarchical data, using SQL server. You will get the sum of node and the children's sum on the individual node.
This blog talks about various SQL methods to fetch disk usage details and the use of T-SQL in conjunction with invoking OLE automation procedures and WMI class libraries, using the SQL Windows Shell interface.
In this blog, you will learn about the details of the Application of JSON data and the use new SQL 2016 constructs that enables an integration of JSON data to a relational schema.
This blog details the use of "Execute AT LinkedServer" clause. It's best in some ways when you are trying to run dynamic complex queries across heterogeneous data source.
This blog shows you different manual tricks to resolve master database corruption in SQL Server.
In this blog, you will learn about the Collation Error in SQL Sever.
In this blog, you will learn about getting Stored Procedure Execution Statistics.
Everything on SQL Server, not only its blogs: the SQL Server page →
Mahesh Chand9 videos · 23 news posts+5.3Kpoints2
Aarav Patel21 articles · 1 reaction received+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 a blog post and earn +250 SHARP when it is approved.
Write a blog
