Database Solutions

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 »

3 Quick Tips to Optimize Your SQL Server Backup Process

In this article we share some handy tips to help you optimize your backup and recovery process Often while backing up your SQL Server database, you might face problems which are complex in nature. As important is the process of backing up SQL Server data, equally important is the need to optimize the backup processes. If the process is not done right, without proper optimization, you might not be able to completely restore the backed up data or the whole process may end up consuming a lot of...

Read more »