Tag Archives: SQL Server database administration

SQL DBA Interview Q & A on Stretch Database

Introduction to Stretch Database in Azure There are different databases and services are available in Microsoft Azure.  Here, I am going to focus on stretch database/feature which is available from SQL Server 2016 onward. Different types of databases & services … Continue reading

Rate this:

Posted in Azure, Database Administration, Q & A, Sql Server New Feature, windows azure | Tagged , , , , , , , , , | Leave a comment

DBA- Interview Questions & Answers

Hi Friends, This blog is based on the interview based questions.  I have collected, summarized & prepared the answers and presenting in front of you. These questions are based on Page & Extents in SQL Server. What is the fundamental … Continue reading

Rate this:

Posted in Database Administration, Q & A, Sql Server, T-SQL | Tagged , , , , , , , , , , , , , , , | 2 Comments

DBA Interview Question# Can we create a snapshot for MSDB system database?

DBA Interview Question# Can we create a snapshot for MSDB system database? Recently I have been approached for one of my technical friend regarding the snapshot for system databases i.e. Master, Model. MSDB & TempDB whether possible or not. As … Continue reading

Rate this:

Posted in Database Administration, Q & A, System databases | Tagged , , , , , , , | Leave a comment