Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
SQL Server Interview Questions and Answers: For All Database Developers and Developers Administrators Paperback – October 11, 2011
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Customers who bought this item also bought
What other items do customers buy after viewing this item?
Top customer reviews
Regardless of how much you work with SQL Server there are numerous little details that either get forgotten or may not have been acquired in the first place. Pinal and Vimod address a pretty comprehensive list of questions with brief yet thoroughly accurate responses that will increase a candidate's confidence when it comes to the in-depth challenges of a technical interview. In my case, for instance, being able to say that a TRUNCATE command is "minimally logged" as opposed to "unlogged" (a common misconception) separated me from the pack - a detail that was clarified directly from the book.
This book won't make up for any lack of whiteboard skills (such as writing out queries or designing schemas). You still will have to show your stuff on your own there. I was amazed, however, at the sheer number of questions that came directly out of the book. I knew the gist of the answers for the most part on my own, but Pinal and Vimod helped form my responses in a coherent, confident way. If you are serious about preparation for a career in SQL Server, this book should be an arrow in your quiver.
demonstrate some deeper understanding of each topic. An interviewer is also likely to be aware of this book and
would dig deeper to test the understanding.
What I enjoyed was: each topic ended with a url for more details on Pinal's blog. This is awesome.
What I didn't dig as much: where a bit more depth was required, they referred the reader to the Joes 2 Pros book.
So I'd recommend to get the Joes2Pros book, or another book.
However there were continual references of "If you wish to learn more, read Joes 2 Pros", so the book came across as more of an advertisement.
Then that turned into simply copy & pastes of his Blog that you can read for free.
I am highly doubtful anyone would be asked these questions during an interview.
I'd have rated it 2 out of 5 if it was not so cheap.