Other than core level interview question, dba topics like database optimization and locking are also addressed.
Replication section where most of the developer stumbles, a full chapter is dedicated to replication so that during the interview you really look a champ.
Every answer is precise and to the point rather than hitting around the bush. Some questions are answered to greater detail with practical implementation in mind.
Shivprasad koirala s sql server: interview questions presents a solution for those programmers who want to get a job in software industry. It is a known fact that a major amount of software projects require databases or persistent data in some form. And sql server is the most preferred database for . Net. Various projects make use of db2 and oracle as well but . Net language majorly involves use of sql server, more so with windows operating system. The author has ensured to provide a book that helps candidate be prepared for those unexpected and surprising questions that can spring in any interview from an aspect of sql server. The book does not go deep into the subject but it provides a chance to go through these questions and get ready for the interview in a short span of time. Sql server: interview questions begins with an introduction to sql server and informs the reader as how to read the book. It informs the reader about the software company hierarchy. Moreover, a different section has been devoted to resume preparation guidelines and finally lists points to remember. The main sections include database concepts, . Net integration, sql, transaction and locks, service broker, notification services, ado. Net, reporting services, xml integration, replication, data warehousing/data mining, database optimization, and integration services/dts.