Database Solutions

5 Most Important Points for SQL Server Backup

Organizations need to make sure their backup process for SQL Server databases are as through as possible. In this article we offer you a checklist that will go a long way in making your backups effective. We cannot stress enough on the importance of backups in SQL Server. For the backup process, it is not only important to do them, but also to do them right, to store them right, and to use them right. Backups in SQL Server might seem like just another important, regular process, but it is...

Read more »

How Always On Availability Groups Make DBAs Take A Close Look At System Admin Functions

In this article, we take a look at how Always On Availability group has changed the priority for DBAs and have induced them to keep an eye on System Admin functions With the coming of Always On Availability Groups in the 2012 edition of SQL Server, the System Administrator roles were bound to change, and this made all the DBAs a lot more concerned about their existing sys admin roles. The AlwaysOn Availability Groups feature is a feature that provides disaster recovery option, along with...

Read more »

How to Use SQL Server High Availability with Amazon Web Services

In this article, we look at how we can get AlwaysOn features in SQL Server to work with Amazon AWS Many organizations using SQL Server, make use of cloud services for not only storing active data but also backups. The most preferred options of cloud storage by such organizations are Azure Cloud and Amazon Web Services (AWS). Although, Azure cloud is specifically tailored for SQL Server users, and is a product of Microsoft, AWS has no such specifications. Still, both of these cloud storage...

Read more »