-
March towards SQL Server : Day 22 – SQL DBA Interview Questions Answers – REPLICATION Part II
Readers, Replication is a vast topic and there are many questions and scenario based issues which a DBA can face. So, today’s series of Interview Questions on Replication presents 31 more questions to make you a highly knowledgeable professional on replication. You can refer to Part I of Interview Questions series on Replication here. Happy learning! 1) Is it…
-
March towards SQL Server : Day 21 – SQL DBA Interview Questions Answers – REPLICATION
Dear Readers, Now as we have already crossed two third of the month and covered a lot of topics till date, Now lets get a deep insight about another very interesting feature of SQL Server, The Replication. It is simple, It is bit tough and It is complex at the same time depending on the…
-
March towards SQL Server : Day 20 – SQL DBA Interview Questions Answers – Always ON – 2
I hope you enjoyed my last post on Always On. Here goes the final post on Always On feature. What is availability group wizard? Availability Group Wizard is a GUI using SQL Server Management Studio to create and configure an AlwaysOn availability group in SQL Server 2012. What are the Restrictions on Availability Groups?…
-
March towards SQL Server : Day 19 – SQL DBA Interview Questions Answers – Always ON
After completing successful 18 Day – here comes the most awaiting and demanding series of interview questions and answers on Always On Feature. 1. What is Always on in SQL Server 2012? AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012,…
-
March towards SQL Server : Day 15 – SQL DBA Interview Questions Answers – Database Mirroring – 1
Next topic to High availability Questions Answers series is about Database Mirroring. This is very interesting topic and consists of very wide range of terminologies and scope. I will cover this topic in two blogs so that I can touch base all the possible Questions from Database Mirroring. 1. What is Database Mirroring? Database mirroring was…
-
March towards SQL Server : Day 14 – SQL DBA Interview Questions Answers – Log Shipping
This blog is about one of the High Availability feature supported by Microsoft SQL Server- Log Shipping. What is High Availability in SQL Server? A high availability solution masks the effects of a hardware or software failure and maintains the availability of applications so that the perceived downtime for users is minimized.SQL Server high-availability solutions…