Category Archives: Database Administration

Introduction to SQL Server 2019

Introduction to SQL Server 2019 Microsoft has announced the first public community technology preview (CTP 2.0) of SQL Server 2019. It is powerful and enhanced version of SQL Server. This SQL Server 2019 has a lot of new features, enhanced … Continue reading

Rate this:

Posted in Database Administration, Microsoft News, Mirza Husain, Sql Server New Feature, T-SQL | 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

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 , , , , , , , , , , , , | 1 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