Friday, November 15, 2019

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

I am writing this blog based upon the Experience and knowledge which I gained after reading lot of Articles, Blogs, and Microsoft Documentation on SQL Server Architecture. Though it takes lot...

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 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 – Always ON – 1

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

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

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

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

APLICATIONS

Windows Powershell

Introduction to PowerShell Windows PowerShell is a Windows commandline shell scriptining mechanism particularly designed for System Admins. Windows PowerShell providex an inteactive command prompt and...