Category Archives: Database Administration

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

SQL Server High Availability and Database Recovery Model Relationship

There are four types of high availability options available in Microsoft SQL server. All the options are different from each other. For example, Log shipping, Mirroring and Always On works on database level while Replication works on database objects level. … Continue reading

Rate this:

Posted in Always on, Database Administration, Replication, Sql Server, T-SQL | 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