Extended Security Updates for SQL 2008
How to get SQL Extended Security Updates for SQL 2008/2008 R2 database instance. The End of Support date for SQL Server 2008 and 2008 R2 is July 9, 2019 Extended…
Read FullAuthor: Soyeluddin Biswas
Find cached execution plan
An execution plan, simply put, is the result of the query optimizer's attempt to calculate the most efficient way to implement the request represented by the T-SQL query you submitted. Execution plans can tell you how a query will…
Read FullFind the SQL Server Cluster details
Scenario A cluster includes two or more physical servers, called nodes; identical configuration is recommended. One is identified as the active node, on which a SQL Server instance is running the production workload, and…
Read FullCreate login by CMD in SQL Server
Scenario You have got the SQL database engine installed but no SSMS installed on it. In this scenario how you will connect to the target database engine and create a…
Read FullBest Practices for SQL Database setting
1. Database Owner: 'sa' As per my understanding, the Database Owner always should be 'sa'. We can change 'sa' login name as per our organization standard login available in SQL…
Read Full
Find all the users for a particular database
Introduction In SQL Server, managing user access and permissions is crucial for maintaining the security and integrity of a database. Often, there is a need to retrieve a list of…
Read FullHow to run a SQL query using command prompt without SQL SSMS
Introduction How to run a SQL query using command prompt without SQL SSMS Open CMD from Run and run the below command (CMD) to connect with Database engine. sqlcmd -S…
Read FullFind IP and Port using SQL SSMS
Find IP and Port using SQL SSMS Find IP and Port of a SQL Server from a client machine. The script will not provide all the information if you are…
Read FullFind user activity without any Auditing
How to find out user activity on database without any particular Auditing Sometime you may need to find out who ran some script or who is accessing the database or…
Read FullFind SQL Server/Instance details using SQL query
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…
Read Full