Category Archives: Database Administration

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

SQL Database as a Service in Azure

Introduction –SQL Database as a Service in Azure Summary: This blog is based on a feature in Azure that is SQL Database which is used as a service. It is a good service for the management of SQL Database from … Continue reading

Rate this:

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

Microsoft under the Sea (A journey from Cloud to Sea)

Microsoft under the Sea (A journey from Cloud to Sea) This blog is based on the current news from Microsoft which is related to the milestone project Natick. I am sharing a brief summary and few important highlights however at … Continue reading

Rate this:

Posted in Azure, Database Administration, Microsoft News, Other, Sql Server, T-SQL, windows azure | 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

How to learn Microsoft Cloud- Azure

As we know that technology has changed and Cloud Computing has come into picture. This technology provides easy access with lot of functionalities and is good from the point view of cost. Therefore companies have started to move to cloud … Continue reading

Rate this:

Posted in Azure, Database Administration, 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