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 Full
153 views 19:53 0 Comments

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 Full
190 views 19:04 0 Comments

Find 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 Full
1568 views 19:47 0 Comments

Create 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 Full
754 views 19:20 4 Comments

Best 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
214 views 18:52 0 Comments

Find 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 Full
553 views 20:39 2 Comments

Find 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 Full
770 views 20:31 0 Comments