All items that have the "Cash on Delivery Available" icon are valid for order by Cash on Delivery.
Add the item(s) to your cart and proceed to checkout. When prompted to choose a payment option, select "Pay By Cash on Delivery". Enter the CAPTCHA text as shown, for validation.
Once verified and confirmed, your order will be processed for shipment in the time specified, from the date of confirmation. You will be required to make a cash-only payment to our courier partner at the time of delivery of your order to complete the payment.
Terms & Conditions:
|30 days from delivery||Damaged, Defective, Item not as described||Replacement|
|30 days from delivery||Exchange for colors and size, Does not fit||Exchange|
|10 days from delivery||Damaged, Item not as described||Replacement|
But there's a second stronger reason for writing this book which stands taller than the readers demand and that is SQL Server itself. Almost 90 per cent projects in software industry need databases or persistent data in some or other form. When it comes to .NET persisting data SQL Server is the most preferred database to do it. There are projects which use Oracle, DB2 and other database product, but SQL Server still has the major market chunk when language is .NET and especially operating system is windows. I treat this great relationship between .NET, SQL Server and Windows OS as a family relationship. In my previous book we had only one chapter which was dedicated to SQL Server which is complete injustice to this beautiful product.
So why an interview question book on SQL Server? If you look at any .NET interview conducted in your premises both parties (Employer and Candidate) pay no attention to SQL Server even though when it is such an important part of development project. They will go talking about stars (OOP, AOP, Design patterns, MVC patterns, Microsoft Application blocks, Project Management etc.). I am not saying these things are not important but if you see in development or maintenance majority time you will be either in your IDE or in SQL Server. Secondly many candidates go really as heroes when answering questions of OOP, AOP, Design patterns, architecture, removing and others but when it comes to simple basic question on SQL Server like SQL, indexes (Forget DBA level questions) they are completely out of track. Third very important thing IT is changing people expect more out of less.
That means they expect a programmer should be architect, coder, tester and yes and yes a DBA also. There were times and it will still exist for mission critical data that there will be separate positions for DBA's. But now many interviewers expect programmers to also do a job of DBA, Data warehousing etc. This is the major place where developers lack during facing these kinds of interview. So this book will make you walk through those surprising questions which can sprang from SQL Server aspect. I have tried to not go too deep as that will defeat the complete purpose of an "Interview Question" book. I think that an interview book should make you run through those surprising question and make you prepare in a small duration (probably with a night or so).
I hope this book really point pitfalls which can come during SQL Server Interview's. I hope this book takes you to a better height and gives you extra confidence boost during Interviews. SQL Server is the database flagship of Microsoft. It's probably the only best database product when doing projects with windows and its rule the windows family like a king. "SQL Server 2005", its recent release is packed with probably the best features like .NET integration, Data warehousing and mining concept which makes it one of the best product for both DBA's and programmers. This book goes how to tackle interview questions related to this product and get you in to a decent position.
Table of Contents
1. Database Concepts
3. .Net Integration
5. Notification services
6. Service Broker
7. XML Integration
8. Data warehousing/ Data Mining
9. Integration services/DTS
11. Reporting Services
12. Database Optimization
13. Transaction and locks
|Number of Pages||250 Pages|
I just bought this book. Extremely impressive , great diagrams , short answers and not to forget the awesome videos with the dvd just add more color.
The SSIS , SSRS and SSAS section is too good.
There are some english mistakes but i have written it off looking at the technical quality.
if u r fan of dot net interview book by Koirala Shivprasad..plzz don't buy this book..nothing good in this book..
for sql buy this "Beginning Microsoft Sql Server 2008 Programming" or go to sql authority website..i cnt expect such kind of book by Shivprasad
Stunning book. Awesome videos and awesome notes. I like how the author in the start of every chapter walked through the cycle of questions. The videos are so practical and to the point they just add more value to the book.
Added i loved the salary calculator.
Great if publisher can improve the quality of the paper.
Awesome book. Got a job a SQL Server DBA. Shivprasad koirala means interview questions and interview questions means Shivprasad Koirala.
Would suggest to add more questions around SQL Server 2012 only 30 question was too short.
Thanks Shiv from me and my Family.