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.
As an effective DBA, it is critical to keep updated on the various server side databases. Recently, I encountered a Developer who was saying that the “sys” schema objects were no longer in the MASTER database. Interestingly, what is the use of RESOURCE Database inside SQL Server? Tell us one change in RESOURCE Database inside SQL Server 2008 R2 edition. Also, how can we find the properties of the RESOURCE database, like what its version is, etc.?
RESOURCE databases are special databases. And these were created separately for a specific reason. Can you also tell how we can find the details of a RESOURCE database version, and other description of this database? In addition, in your plan to backup the system databases, are you also planning to take the backup of the RESOURCE database? Answering these questions can lead you to the right answer to the SQL Quiz question mentioned earlier. Tell me your views.
Today, instead of hint and sound bytes, let me give a question back at you. How many system databases are there in SQL Server? I often end up receiving the answer “FOUR”.
I think that during the course of SQL Server evolution, DBAs and developers frequently miss their respective rhythm to keep updated. I often say that there’s no empty knowledge; we can find small knowledge from everything. At one place, I have seen a developer deleting a resource database, then SQL Server began to face issues when it was attempting to start. This experience tells us that resources database is very important and it has a specific and crucial use. Honestly, every single system database is very significant, and one should know more about them and keep their knowledge updated.
SQL Server Interview Questions and Answers ISBN: 1466405643 Page#104
Resource Database ID – 32767
Location of Resource Database in SQL Server Editions
mssqlsystemresource – Resource Database
Importance of Master Database for SQL Server Start-up
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)