Category Archives: Sql Server

Restore SQL Server Database from Multiple Backup Files: Learn the Best Practices

SQL Server can come across errors at any time. To tackle any severe situation, it is always standard practice to backup SQL database. The backup of primary and secondary database files, as well as Transaction log files, are saved as … Continue reading

Rate this:

Posted in Sql Server, T-SQL | Leave a comment

Check Out How to Open LDF File in SQL Server

The data of SQL database can be broadly categorized into two primary file types. One of MDF file and another is LDF file. MDF file is the master database file that contains the basic data and LDF file (log database … Continue reading

Rate this:

Posted in Sql Server | Leave a comment

Top Free SQL Server Tools & Performance Tuning options from Microsoft

Top Free SQL Server Tools & Performance Tuning options from Microsoft (A Benefit to the company) I am writing this blog to share the importance of the tools provided by Microsoft along with SQL Server to use to monitor the … Continue reading

Rate this:

Posted in Database Administration, Other, Sql Server | Tagged , , , , , , , , , , , | Leave a comment

Let’s Discuss the Importance of Backup in SQL Server

There should be proper planning done to create backup of SQL Server Database. As all the data saved within the database is prone to get corrupt in several ways such as any human error, network intrusions, natural catastrophes, poor power … Continue reading

Rate this:

Posted in Sql Server | Leave a comment

SQL Warning Fatal Error 605 occurred? Here is A Complete Profound

If you are getting SQL error 605 while working with SQL Server then, this troubleshooting guide will help you resolve this issue. User Scenarios: Query-1 “I am acquiring following error while running queries from one of my tables: In order … Continue reading

Rate this:

Posted in Sql Server | 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