Friday, November 15, 2019

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

How to move Indexes (Cluster and Non Cluster) from Primary File group to New...

As a DBA, many times there are requirements to segregate data in a Database into multiple file groups. There can be many reasons like below: Performance issues (Disk IO) Disk space...

How to use Microsoft Virtual Labs for Practical implementation

One of the important questions often asked by my fellow mates is how we can implement practical scenarios without configuring anything on Desktop or Laptop. This is a common problem for...

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

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

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

APLICATIONS

10 reasons why LinkedIn profile is important for professionals

LinkedIn was counted amongst the other social media networks but over time, it has become the most important to professionals in all fields. Since...