All about Databases
In this blog I am discussing the SQL Server Interview Questions answers on 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? […]
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? Availability […]
SQL Server Always On is one of the intersting feature introduced with SQL Server 2012 version. I am listed the Questions with answers which are asked on Always On Feature in the SQL Server DBA interviews. 1. What is Always on in SQL Server 2012? AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an […]
If you have enjoyed reading my First post about Questions about Cluster. Here is another post on SQL Server Cluster services and on its components and features. 1. What new functionality does failover clustering provide in Windows Server 2008? New validation feature. With this feature, you can check that your system, storage, and network configuration is […]
Today I am writing a Blog Series on one of my Favorite topic – SQL Server Cluster. This will include all the possible Questionnaire which are asked in the Interviews related to Cluster. 1) What is Windows Cluster? Clustering can be best described as a technology that automatically allows one physical server to take over the tasks […]
Continuing with my previous post of Interview Questions series on Database Mirroring, this is the second blog on Database Mirroring. 1) What is Database Snapshot? A database snapshot is a view of what the source database looked like at the time at which the snapshot was created. This means that all the objects will be […]
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 […]
Here I am posting fourth and last series of Backup/Restore interview questions. I am trying to cover most of the known errors and some concepts too. You may take a look at the other posts on Backup/Restore here. Database Backup and Restore – 1, Database Backup and Restore – 2 & Database Backup and Restore […]
Lets have some more questions on Backup and Restore. You may visit my other backup and restore related blogs here Database Backup and Restore – 1 and Database Backup and Restore – 2 1) What is the Backup strategy in your environment? It’s very open ended Question: As per my understanding, normally Organizations follow below […]
Continuing my Blog series on the SQL Server DBA Interview Questions on Database Backup Restores, I am posting another set of 31 questions which will help you to understand the SQL Server Database backups topic in more depth. 1) What are the Best Practices recommendations related to SQL Server Database backups? Backup is an important component […]
