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

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

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-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 Perform database restore with Database Encryption

Database encryption is the process of changing the information inside database into some ciphertext using encryption keys and appropriate algorithm. This process makes sure even if the hackers get through the...

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

Performance Counters Data collection using TypePerf utility

SQL Server performance tuning and Optimizing SQL Server is part of the day to day job of a Database administrator. One of the key aspects of Performance tuning is to gather...

APLICATIONS

Cloud Computing and top service providers

Technologically the IT industry has evolved at a rapid rate with new and innovative ideas entered into the industry. The amount of data that...