SQL Server Management Studio(SSMS)

How to Repair MS SQL Database from Suspect Mode

Mar 18, 20243 min read

This article focuses on getting the Displays Estimated and Actual number of Rows from the SQL Server Execution Plan. Read More

Feb 16, 20221 min read

Jan 19, 20221 min read

How to take SQL SERVER backup to Azure Blob Storage. This is a guide for SQL Server DBA to store SQL SERVER backup in Azure.

Jan 8, 20221 min read

A friend recently asked me how to change the authentication mode of SQL instances. This blog gives steps to change SQL Server authentication

Jan 8, 20221 min read

Do you want to modify the default Select Top 1000 Rows and Edit Top 200 Rows configuration in SQL Server Management Studio? Read more

Jan 6, 20221 min read

Suppose you created a new table in SQL Server or Azure SQL Database, and the query editor shows you the error message "Invalid Object Name"

Jan 4, 20221 min read

This article guides you to stop logging successful backup messages in SQL Server Error Logs.

Jan 4, 20222 min read

Dec 28, 20211 min read

Do you have a long list of servers appearing in the drop-down of SSMS connection window. If yes, follow the steps in this article to...

Dec 28, 20211 min read

I recently faced an issue where my query returns only five, whereas the table contains 542 records. The select statement does not have a...

Dec 26, 20211 min read

Dec 26, 20211 min read