SQL Server

Dealing with database performance issues has to be a priority, regardless of the scope or scale of your server infrastructure. Of course, if you don’t know what to look for, …

There is no question that monitoring the performance of your SQL Server deployment is an important part of any DBA’s maintenance and troubleshooting responsibilities. However, the integrated tool provided by …

Today, I am going to describe how to generate random value for DATETIME field within a given range. This is very useful specially for generating test data. For this, we …

This article shares the importance of indexes in a SQL database. Also, it provides a brief overview of the clustered and nonclustered indexes. Further, the article discusses reasons for SQL …

Last week one of my colleagues requested me to help him write a query to fill in missing dates in query output. I came across couple of solutions, neither seemed …

I got ” Cannot shrink ‘read only’ database ” error during Shrink Transaction Log While Using AlwaysOn Availability Group.

Finally, I got my certification Azure Database administrator Associate for Exam (DP-300) after two times failure, during the journey of study I watched many courses, videos, and articles, and this post of …

JSON (JavaScript Object Notation) is very popular standard for exchanging data specially in REST API. Almost all modern websites, android or iOS app use this for exchanging data with server. …

SQL CASE statement is very powerful and versatile. It can be used in SELECT, UPDATE and INSERT statement. Even it can be used in ORDER BY and GROUP BY clause. …

I am going to share my experience about how I was able to recover my SQL database from SUSPECT mode. Problem at hand About a week ago, I was inserting …