SQL Server DBA Interview Questions and Answers – SQL Server Cluster 1
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...
SQL Server DBA Interview Questions and Answers – Database Mirroring – 2
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...
SQL Server DBA Interview Questions and 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...
SQL Server DBA Interview Questions and Answers – Database Backups and Restore-4
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...
SQL Server DBA Interview Questions and Answers – Database Backups and Restore-3
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...
SQL Server DBA Interview Questions and Answers – Database Backups and Restore-2
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...
SQL Server DBA Interview Questions and Answers – Database Backups and Restore-1
This blog contains series of most commonly asked SQL Server DBA Interview Questions regarding one of the important DBA tasks- Database Backups and Restore. Since this is very wide topic, I will try...
SQL Server DBA Interview Questions and Answers – SQL Server System Databases and Recovery...
System databases are very important part of the Database Management system. It plays a vital role in Database Administration as SQL Server functionality is based on the system database. This blog...
SQL Server DBA Interview Questions and Answers – SQL Server DBA Tools and Executables
Every DBA uses multiple tools to perform the day to day Database Administration tasks to make hisher life easy. In this blog I am writing all about the SQL Server related...
SQL Server DBA Interview Questions and Answers – SQL Server Agent and Its Components
This blog contains Question answers about the most frequently used tool by a Database Administrator i.e. SQL Server Agent. I tried to cover all the questions related to each and every...
APLICATIONS
How to move Indexes (Cluster and Non Cluster) from Primary File...
As a DBA, many times there are requirements to segregate data in a Database into multiple file groups. There can be many reasons like...
