Solutions

How to Choose the Appropriate SQL Server Backup Option for Your Case

In this article we look at choosing the apt backup option depending on our specific needs. Backing up data in SQL Server is an important and a challenging exercise. Like many other SQL Server processes, backup also involves a lot of factors that should be kept in mind. While backing up your data it is not only important to ensure the preservation of your data, it is also necessary for maintaining business continuity. There are different types of backups that you can use to back up your SQL...

Read more »

Understand SQL Server Clustering in Context of AlwaysOn Availability Groups

In this article, we look at Clustering in SQL Server in context of AlwaysOn Availability Groups and how both of them play together. Clustering in SQL Server refers to installing multiple instances of SQL Server in Windows Server Failover Cluster. Windows Server Failover Cluster often makes use of shared storage mainly in the form of SAN. If the cluster contains a SQL Server instance, then the user databases and the systems will also have to be on the shared storage. This will enable the...

Read more »

5 Most Important Improvements of AlwaysOn Feature in SQL Server 2016

In this article,we discuss the improvements introduced in SQL Server 2016 edition with respect to AlwaysOn Availability groups. The AlwaysOn Availability Groups or the Availability Groups feature was launched first in the 2012 edition of SQL Server. This feature is mainly used to increase the availability of a database and efficiently work towards disaster recovery. Since the launch of this feature it has continued to receive constant updates every year. This feature was launched to tackle...

Read more »