Category Archives: SQL Server

Surface area configuration is a security measure that involves stopping or disabling unused components. Surface area configuration helps to improve security by providing fewer avenues for potential attacks on a system. Surface Area Configuration too is introduced in SQL Server 2005 & Direct access of Surface Area Configuration tool has been removed from SQL server 2008 onwards. … Continue reading →

Today, A weird though come into mind to check the different way to connect to SQL Server instance. Diffrent strings, I can pass in Server Name in SSMS to connect. I am surprised but I got 21 different way to connect & may be there are many more ways. I am connecting to the default … Continue reading →

1) We can get queries execution plan from below query SELECT –st.text, qs.EXECUTION_COUNT qs.*, cp.* FROM sys.dm_exec_query_stats AS qs CROSS APPLY sys.dm_exec_sql_text(sql_handle)AS st CROSS APPLY sys.dm_exec_query_plan(plan_handle) AS cp 2) Column query_plan is having execution plan in XML form 3) When we click hyperlink in query_plan column, in SQL 2005,2008 & 2008 R2 it open as … Continue reading →

A Contained Database is a database which contains all the necessary settings and metadata, making database easily portable to another server. This database will contain all the necessary details and will not have to depend on any server where it is installed for anything. You can take this database and move it to another server … Continue reading →

DBA or Developers both are habitual of using multiple SQL server remotely from one server. But the normal issue of running commands on wrong servers due to less of attention on server name displaying in SSMS query windows pane. We can give different color codes to different server to make them more identifiable in single … Continue reading →