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 w will learn how to retrieve number of days per month and per year b/w two dates.

This Blog explains how to generate numbers that are leading with 0

In this article you will learn Return Comma Separated column value in SQL Server.

In this blog you will see OUTPUT clause information from, or expressions based on, each row affected by an INSERT, UPDATE, DELETE statement.

This blog will explain how to retrieve information about all hard drives and free space of hard drives on SQL Server.

This blog explains how to disable and enable a particular trigger, all triggers of a table and all triggers for a database.

In this blog you will learn how to count the number of occurrences of a character or word in a string in SQL Server .

In this blog you will learn how to Know Primary Key Constraint And Foreign Key Constraint in SQL Server.

In this blog you will learn how to get first and last date with week name and total days in current month

In this article we will list the basic differences between Len() and DataLength() function in SQL.

In this blog I will show you how to how to find the current financial year using SQL Query.

In this article I am going to show how we can update our existing column value with serial number without using loop. Below is my problem.

In this article we will see how to assign shortcuts for SQL Queries in SQL Server.

In this blog you will learn about Performance tuning of Stored Procedure.

In this blog you will learn about SQL Server Profiler solution for slow running queries, problems of query and other database engine errors.

In this blog, I am going to show how we can count the total number of rows in every SQL Server table.

In this blog you will learn how to get data from SQL Server and bind GridView using jQuery, JSON and Ajax.

In this blog you will learn about a SQL server business problem.

In this article you will learn how to resolve Terminating Abnormally Error while restoring database.

In this blog you will learn how to resolve issues to Restore CDC Enabled Databases.

In this blog, we are going to learn how to delete duplicate rows from a table in SQL Server.

In this blog we will learn how to import data from Excel to SQL Server Data table.

In this blog you will learn Localdb instance version naming changed for SQL Server 2014.

In this blog explains Ways to prevent Saving changes is not permitted in SQL Server.

In this blog, I will explain the steps to be followed for resolving the issue tthat logs MERGE statement as DELETE followed by INSERT instead of UPDATE on a CDC enabled table.
Everything on SQL Server, not only its blogs: the SQL Server page →
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