Soyeluddin Biswas

Scenario Sometimes you need to gather the SQL instance details in a proper format such as Server Name, Instance, Service account name. Today I am sharing a script that will…

Scenario You often get complained that user is not able to connect to SQL server or Application is not able to connect to SQL for some reason. There might be…

Problem When your application uses the distribution transaction then you may encounter below error. Error: The operation could not be performed because OLE DB provider “SQLNCLI11” for linked server “Linked_Server_Name”…

Introduction Find the database file growth for all the databases. It is not a good practice to keep your database file growth limited. In that case, you may get an…

Introduction: Sometimes your query gives you very bad performance because of statistics as SQL database engine Query optimizer uses statistics to create query plans. Updated statistics will give you good…

Introduction: When your SQL instance was last restarted? I understand it is very simple script but we often forget  simple scripts. Hence I thought to write this simple script and…

Introduction This script will help you to get the restore history for all the databases. If you need to know the restore history only for a single database then please…

Introduction Very often DBAs need to find the location of the physical file (MDF, LDF & NDF) of a database. Simply we can obtain the output by executing the below…

Introduction Managing the growth of database files is an essential aspect of maintaining a healthy SQL Server environment. As databases grow over time, it becomes crucial to configure appropriate growth…