Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective.
Beyond Relational has come up with a very interesting concept – they have converted a few of the questions from my book into the SQL Quiz. The quiz is indeed focused on my two goals. In addition, it’s going to put the learning of the book to a higher stage. Looking at this novel concept, Vinod Kumar (Co-author) and I have decided to help every participant and reader by giving a few hints and suggestions to solve the quiz.
From Perfmon to SQL Profiler to other third Party tools, there are a good number of performance troubleshooting tools which a DBA can use inside SQL Server. One of the hidden features of most troubleshooting tools is the Data Collector inside SQL Server. What is a Data Collector, anyway? What are the predefined collectors inside SQL Server which can be used?
Notes of Vinod Kumar
Data Collector is truly a hidden gem in SQL Server. Data Collector is a great tool to track what is happening inside the SQL Server. Are you using the Data Collector? Have you extended it by any chance? Let us hear your stories and how would you have implemented the same in SQL Server 2005 versions?
Notes of Pinal Dave
Data Collection is our old habit. Isn’t that the very reason why we have reached this far? I think we might have started to count because we wanted to remember how much inventory we have (may be not – but you got the point). Now, collection of the data is not really helpful unless they are arranged, filtered, cleaned up and put together in a nice algorithm. These can make data start talking and reveal its various intelligence. Data Collector is a very important subject, but I often see it not getting the proper exposure as it deserves.
SQL Server Interview Questions and Answers ISBN: 1466405643 Page#144
Note: SQL Quiz, winners and prizes are administrated by Beyond Relational. The goal of this blog post is to provide additional learning pointers only.
Reference: Pinal Dave (http://blog.sqlauthority.com)