Author: Soyeluddin Biswas
Extended Security Updates for SQL 2008
How to get SQL Extended Security Updates for SQL 2008/2008 R2 database…
Find cached execution plan
Find cached execution plan An execution plan, simply put, is the result of…
Find the SQL Server Cluster details
Scenario A cluster includes two or more physical servers, called nodes; identical configuration is…
Create login by CMD in SQL Server
Scenario You have got the SQL database engine installed but no SSMS…
Best Practices for SQL Database setting
1. Database Owner: ‘sa’ As per my understanding, the Database Owner always…
Find all the users for a particular database
Scenario How to find all the users present in a database. Solution…
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
Find IP and Port using SQL SSMS Find IP and Port of…
Find user activity without any Auditing
How to find out user activity on database without any particular Auditing…
Find SQL Server/Instance details using SQL query
Scenario Sometimes you need to gather the SQL instance details in a…
Login failed for user ‘XXXX’ (Microsoft SQL Server, Error: 18456)
Scenario You often get complained that user is not able to connect…
Unable to begin a Distributed Transaction
Problem When your application uses the distribution transaction then you may encounter…
Find the database file growth for all the databases in SQL Server
Introduction Find the database file growth for all the databases. It is…
How to get all statistics information for a database in SQL Server
Introduction: Sometimes your query gives you very bad performance because of statistics…
SQL Instance Last restart date and time in SQL Server
Introduction: When your SQL instance was last restarted? I understand it is…
Database restore history in SQL Server
Introduction This script will help you to get the restore history for…
Physical file location for all the databases in SQL Server
Introduction Very often DBAs need to find the location of the physical…
Set Auto growth for all the databases in SQL Server
Introduction Below script will give the command to execute to change the…