SQL Server Database Recovery

Working with a Scenario Where One Has to Initiate a Manual Force Failover

In this article we explain the Forced manual failover, when you should do it, and key points to remember. The Availability groups in MS SQL Server work as magic when it comes to failovers for securing data. In terms of availability groups, there are three different kinds of failovers that you can perform. These include an Automatic failover, which does not involve any data loss, a planned manual failover, this also does not involve any kind of data loss, and then comes the forced manual...

Read more »

4 Key Tips to Avoid Deadlocks in SQL Server

The article suggests important tips to avoid Deadlocks in SQL Servers Although SQL Server has witnessed huge evolution in past couple of years, users still regularly face the situation of deadlocks. Ideally, a database server should be able to retrieve multiple requests but it often results in blocks. The conflicts where one process awaits the release of another resource are called blocks. And then there are Deadlocks. Imagine a situation where one person is asking the second to release a...

Read more »

A Detailed Overview of Data Compression Features in SQL Server and Its Benefits

The article gives an overview of Data Compression features in SQL services Data management isn’t an easy process and server like SQL also might face difficulties if the Data grows exponentially, which it does and then there are backups. Is there any way which could simplify the process and consume comparatively less disk space? This is where Compression feature of SQL server fits it. This article will stress more on… Data Compression SQL Server allows its DBAs to use the option of Data...

Read more »