Category Archives: Q & A

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 , , , , , , , , , , , , , , , | Leave a comment

Comparison – SQL Database & SQL Server in Virtual Machine in Azure

Comparison – SQL Database & SQL Server in Virtual Machine in Azure Summary: This blog is based on the comparison of SQL database feature with SQL server installed in virtual machine in Azure. Which option is good or which one … Continue reading

Rate this:

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

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

Trace Flags in SQL Server

Trace Flags in SQL Server Trace flags plays an important role in database administration. These are frequently used to diagnose performance issues or to debug stored procedures. For example trace flag 1222 is to detect the deadlock and returns the … Continue reading

Rate this:

Posted in Database Administration, Q & A, Sql Server | Tagged , , , , , , , , , , , | Leave a comment

DBA Daily Tasks

This blog is especially for those people who are preparing to be a Database Administrators or who have just started their career in the database administration field. As a production DBA, we are supposed to perform several tasks on the … Continue reading

Rate this:

Posted in Database Administration, Q & A, Sql Server | Tagged , , , , , , , , , | Leave a comment

Shift Handover importance in a DBA job- DBA Interview Question

One of my blog readers asked me about shift Handover in a DBA job and how to prepare it. What is the importance of it for a DBA? I am trying to reply and the best possible points to ponder. … Continue reading

Rate this:

Posted in Database Administration, Other, Q & A | Tagged , , , , , , , , , | 1 Comment

Interview Questions

Basic interview questions and answers for my fresher technical friends: Q & A Which TCP/IP port does SQL Server run on? How can it be changed? SQL Server runs on port 1433. It can be changed from the Network Utility … Continue reading

Rate this:

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