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

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

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

Database Online training offers – Udemy $14.99 sale

In today's unpredictable IT world, learning is not only a straightforward thing to do — it is key to the survival in the competition. Particularly in the recession time, it is...

APLICATIONS

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