Monday, December 10, 2018

SQL Server DBA Interview Questions and Answers-Data File and Transaction Log File Architecture

This Blog illustrates about the most frequent questions which are asked about the Data file and Transaction Log file architecture. Intentionally I did not add any troubleshooting questionnaire in this blog...

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 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 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 Database backups: Third party backup tools

While discussing about the roles and responsibilities of DBAs, backup and restore is counted as on the important activity of a Database Administrator as a day to day task. Though most...

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

All about SQL Server Error logs

SQL Server error logs are one of the important stuff to check whenever DBA face issues in the SQL Server instance. It contains lot of information about the Issues, Errors, Backup...

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

APLICATIONS

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