Author: Soyeluddin Biswas

Soyeluddin Biswas, SQL Server DBA. Mostly involved in Data center migration. He has rich experience in SQL server design and database migration.
Posted in MS SQL

Extended Security Updates for SQL 2008

How to get SQL Extended Security Updates for SQL 2008/2008 R2 database…

Posted in MS SQL

Find cached execution plan

Find cached execution plan An execution plan, simply put, is the result of…

Posted in MS SQL

Find the SQL Server Cluster details

Scenario A cluster includes two or more physical servers, called nodes; identical configuration is…

Posted in MS SQL

Create login by CMD in SQL Server

Scenario You have got the SQL database engine installed but no SSMS…

Posted in MS SQL

Best Practices for SQL Database setting

1. Database Owner: ‘sa’ As per my understanding, the Database Owner always…

Posted in MS SQL

Find all the users for a particular database

Scenario How to find all the users present in a database. Solution…

Posted in MS SQL

How to run a SQL query using command prompt without SQL SSMS

Introduction How to run a SQL query using command prompt without SQL…

Find IP and Port using SQL SSMS
Posted in MS SQL

Find IP and Port using SQL SSMS

Find IP and Port using SQL SSMS Find IP and Port of…

How to find out user activity on database without any particular Auditing
Posted in MS SQL

Find user activity without any Auditing

How to find out user activity on database without any particular Auditing…

Posted in MS SQL

Find SQL Server/Instance details using SQL query

Scenario Sometimes you need to gather the SQL instance details in a…

Posted in MS SQL

Login failed for user ‘XXXX’ (Microsoft SQL Server, Error: 18456)

Scenario You often get complained that user is not able to connect…

Posted in MS SQL

Unable to begin a Distributed Transaction

Problem When your application uses the distribution transaction then you may encounter…

Posted in MS SQL

Find the database file growth for all the databases in SQL Server

Introduction Find the database file growth for all the databases. It is…

Posted in MS SQL

How to get all statistics information for a database in SQL Server

Introduction: Sometimes your query gives you very bad performance because of statistics…

Posted in MS SQL

SQL Instance Last restart date and time in SQL Server

Introduction: When your SQL instance was last restarted? I understand it is…

Posted in MS SQL

Database restore history in SQL Server

Introduction This script will help you to get the restore history for…

Posted in MS SQL

Physical file location for all the databases in SQL Server

Introduction Very often DBAs need to find the location of the physical…

Posted in MS SQL

Set Auto growth for all the databases in SQL Server

Introduction Below script will give the command to execute to change the…