Wednesday, February 20, 2019

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 Mirroring – 1

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

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

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

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

APLICATIONS

Udemy Online courses – Sale is on now all courses ($19)

In today's challenging and competitive IT world, learning is not only a straightforward thing to do — it is key to the survival in...