Wednesday, August 12, 2020

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 – SQL Server Services

This blog is all about the SQL Server Services which are required for the functionality of SQL Server components. It also contains Questions answers about the important parameters and SQL Server...

SQL Server DBA Interview Questions and Answers-Installation

I have been thinking since long time to pen down a comprehensive series on most commonly asked DBA Interview questions. I have planned to segregate the entire questions series, topic wise...

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 – 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...

SQL DBA Interview Questions and Answers – Security Permissions

1) What is Authentication and Authorization? What is the difference between both? Authentication is the process of verifying who you are. Logging on to a PC with a username and password is...

How to create Drop and Recreate Script of all Indexes in a database?

It’s a general requirement in the DBA job to scripts out the database objects and deployment the scripts in the new environment. Microsoft SQL Server provides us an option to script...

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...

How to capture SQL Server blocking information

Many a times Application team report SQL Server Blocking issues. In this article I will explain about Blocking and Its cause. Due to this blocking issue Application team asks the DBA...

SQL DBA Interview Questions and Answers-Database Architecture and Database Properties

This article comprises of SQL Server Questions and answers series on Database Architecture and various Database Properties. Intentionally I skipped Database Recovery Models, Backups, Restore, Data File and Transaction Log Architecture...

APLICATIONS

Database Online training offers – Udemy $14.99 sale

In today's unpredictable IT world, learning is not only a straightforward thing to do — it is key to the survival in the competition....
Skip to toolbar