SQL SERVER – 2005 – Last Ran Query – Recently Ran Query

How many times we have wondered what were the last few queries ran on SQL Server? Following quick script demonstrates last ran query along with the time it was executed on SQL Server 2005. SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query] FROM sys.dm_exec_query_stats AS deqs CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest…
Read More
All Articles openrowset-490x400

SQL SERVER – Fix : Error 15281 SQL Server blocked access to STATEMENT OpenRowset/OpenDatasource of

Error 15281
Msg 15281, Level 16, State 1, Line 3
SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’ of component ‘Ad Hoc Distributed Queries’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Ad Hoc Distributed Queries’ by using sp_configure. For more information about enabling ‘Ad Hoc Distributed Queries’, see “Surface Area Configuration” in SQL Server Books Online.

Read More
All Articles quality-600x599

SQL SERVER – Difference Between Quality Assurance and Quality Control – QA vs QC

Regular readers of this blog are aware of my current outsourcing assignment. I am managing very large outsourcing project in India. One thing is very special in all Indian offices are “Tea Time.” Everybody wants to attend Tea Time not only for tea or coffee but for the interesting discussion occurs at that time. This is the time when all the department employees are together and discussing whatever they wish.Today there was an interesting discussion about Quality Assurance (QA) and Quality Control (QC).

Read More
All Articles practiceguide

SQLAuthority News – Book Review – A Practitioner’s Guide to Software Test Design

A Practitioner’s Guide to Software Test Design is one book containing all the important latest test design approaches. This book makes life of software tester very easy. Software tester can find all the information in this book instead of searching through hundreds of books, periodicals and websites.

Read More