SQL Server 2016 SP1 Release – A bold move by Microsoft

A bold move by Microsoft, Is not it? With the emergence of cloud technology, there is a huge competition in the market and everyday software Companies are coming up with lucrative deals...

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

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

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 – SQL Server Cluster 2

If you have enjoyed reading my First post about Questions about Cluster. Here is another post on SQL Server Cluster services and on its components and features. 1. What new functionality does...

SQL Server DBA Interview Questions and Answers – SQL Server Cluster 1

Today I am writing a Blog Series on one of my Favorite topic – SQL Server Cluster.  This will include all the possible Questionnaire which are asked in the Interviews related to...

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 – Log Shipping

This blog is about one of the High Availability feature supported by Microsoft SQL Server- Log Shipping. What is High Availability in SQL Server? A high availability solution masks the effects of...

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

APLICATIONS

How to create Drop and Recreate Script of all Indexes in...

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