Here with we are presenting a list of interview Q&A for SQL Server developers, SQL DBA’s, SQL Server Database architects, MSSQL Business intelligence developers.
I have prepared this list of questions and answers, this information I have documented from my professional experience, various articles, blogs and other sources from internet.
Tags: SQL Server Interview Questions and Answers, SQL Server interview questions with answers, SQL Server interview, Interview Questions and Answers, SQL Server developer Interview questions and answers, SQL Server developer Interview questions with answers, SQL DBA Interview questions and answers, SQL DBA Interview questions with answers, BI developer Interview Questions and Answers, BI Developer Interview Questions with Answers, SQL Server Interview questions and answers, SQL Server Architecture Interview Questions and Answers
Uday it’s very useful for all New and experience.. Very good technical stuff you have and u share for us also thank you very much… I am waiting for HA real-time issue
We have been preparing questions and answers on HA & DR. the actual process is:
We do conduct a survey for collecting interview questions
Once we receive survey forms, we will categories the questions
We will remove the duplicates
Will prepare answers
Publish Answers
Due to this lengthy process it might take some time to get back to you
thank you..very much informative.
kindly post some more articles ,suggest best books for DBA. i want to start my career as a DBA.
but there are no recruitment s for freshers.need your guidance please.
Thanks for your help to the Dba’s world,If you publish Replication,Mirroring,Log shipping, Clustering also we will appreciate.People are waiting for your Posting on this topics
Due to busy schedules we are not able to finish those articles on (Replication, Log Shipping, Clustering and Mirroring) but we’ll surely come-up with those at our earliest.
Hi There, I love all the posts, I really enjoyed. I would like more information about this, because it is very nice., Thanks for sharing. I reviewed few articles on improving group by performance by adding indexes for columns in group by clause for single table. Please advise how to improve performance in following scenario where I have to join multiple tables. Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition… Read more »
We published an article called “Top 50 DBMS Interview Questions & Answers”. The article talks about the most common DBMS interview questions and answers along with some information about how to prepare for the interview. I have attached the URL below. https://www.edvicer.com/articles/top-50-dbms-interview-questions-answers
Thank You
Anshuman Sonowal
Team Edvicer
really very interesting notes and interview questions. if i read all these note and questions properly , no need of teacher. really I like it at all!!!
Satheesh Duggina
2 years ago
This is a great book.Keep it up
Deepak Kumar
2 years ago
Hello Uday
In your book you have mentioned “Freezing the service group” in chapter SQL Server Failover Clustering. e.g., Que 55 on page 195.
What do you mean with this freezing? Could you please explain. Because I did not find any clue or such terminology in Wsfc.
Uday it’s very useful for all New and experience.. Very good technical stuff you have and u share for us also thank you very much… I am waiting for HA real-time issue
Hari, Thanks for your kind words.
We have been preparing questions and answers on HA & DR. the actual process is:
We do conduct a survey for collecting interview questions
Once we receive survey forms, we will categories the questions
We will remove the duplicates
Will prepare answers
Publish Answers
Due to this lengthy process it might take some time to get back to you
Happy Reading
The Team SQL
http://www.udayarumilli.com
thank you..very much informative.
kindly post some more articles ,suggest best books for DBA. i want to start my career as a DBA.
but there are no recruitment s for freshers.need your guidance please.
Apologizing for the delayed response.
Still there are firms taking freshers for DBA role. You can find fresher openings here “https://www.facebook.com/ujoboffers”
Happy Reading
The Team SQL
http://www.udayarumilli.com
Hi Uday,
Thanks for your help to the Dba’s world,If you publish Replication,Mirroring,Log shipping, Clustering also we will appreciate.People are waiting for your Posting on this topics
Bharath,
Due to busy schedules we are not able to finish those articles on (Replication, Log Shipping, Clustering and Mirroring) but we’ll surely come-up with those at our earliest.
Happy Reading
The Team SQL
http://www.udayarumilli.com
[…] Feature image source – udayarumilli.com […]
Hi There, I love all the posts, I really enjoyed. I would like more information about this, because it is very nice., Thanks for sharing. I reviewed few articles on improving group by performance by adding indexes for columns in group by clause for single table. Please advise how to improve performance in following scenario where I have to join multiple tables. Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition… Read more »
[…] Interview Q&A […]
Hi, that’s a great article. I can also recommend a book by Matthew Urban “TOP 30 SQL Interview Coding Tasks”, from https://www.amazon.com/TOP-SQL-Interview-Coding-Tasks-ebook/dp/B07GC5RS3K.
didn’t have to look around for more concise and detailed websites etc. Really recommend.
Ben, thanks for sharing, this is awesome book. Was using it before my interview. Great content. https://www.net-boss.org/shop/top-30-sql-interview-coding-tasks-by-matthew-urban
HI there, really good book. Thanks for the recommendation.
Thanks for the feedback 🙂
Uday Arumilli
Hi guys, very good book. helped on a few occasions. Very well written, easy and to the point. Recommending also.
Gary,
Thank you so much for the feedback 🙂
Thanks
UDay Arumilli
This is one of the best books in coding, by Matthew Urban: Top 30 JAVA Interview Coding Tasks (https://www.net-boss.org/shop/top-30-java-interview-coding-tasks-by-matthew-urban) and Top 30 SQL Interview Coding Tasks (https://www.net-boss.org/shop/top-30-sql-interview-coding-tasks-by-matthew-urban).
Easy read, great tips, well explained.
We published an article called “Top 50 DBMS Interview Questions & Answers”. The article talks about the most common DBMS interview questions and answers along with some information about how to prepare for the interview. I have attached the URL below.
https://www.edvicer.com/articles/top-50-dbms-interview-questions-answers
Thank You
Anshuman Sonowal
Team Edvicer
really very interesting notes and interview questions. if i read all these note and questions properly , no need of teacher. really I like it at all!!!
This is a great book.Keep it up
Hello Uday
In your book you have mentioned “Freezing the service group” in chapter SQL Server Failover Clustering. e.g., Que 55 on page 195.
What do you mean with this freezing? Could you please explain. Because I did not find any clue or such terminology in Wsfc.