Cutting the cost of running SQL Server in the cloud: A guide

Who knew that there would be so many different ways that cloud service providers could charge for services? You were expecting to pay for compute and storage resources, sure. And it’s not really surprising that if you’re configuring your SQL Server infrastructure for high availability (HA) in the cloud you’re going to pay more for backup VMs and storage in remote sites. But added costs for Enterprise editions of software whose services you don’t otherwise really want or need? Added...

SQL Server high availability and disaster recovery for AWS, Azure and GCP: A guide

The public cloud offers a myriad of options for providing high availability and disaster recovery protections for SQL Server database applications. Conversely, some of the options available in a private cloud are not available in the public cloud. Given the many choices and limitations, the challenge faced by system and database administrators is determining the best available options for each application running in hybrid and purely public...

Time is running out for SQL Server 2008/R2 support – here’s what to do about it

Extended support for SQL Server 2008 and 2008 R2 will end in July 2019, giving database and system administrators precious little time to make some necessary changes. Upgrading the software to the latest version is always an option, of course, but for a variety of reasons, that may not be viable for some applications. So Microsoft is providing an alternative: Get three more years of free Extended Security Updates by migrating to the Azure...

How to make Amazon Web Services highly available for SQL Server

Mission-critical database applications are often the most complex use case in the public cloud for a variety of reasons. They need to keep running 24x7 under all possible failure scenarios. As a result, they require full redundancy, which involves provisioning standby server instances and continuously replicating the data. Configurations that work well in a private cloud may not be possible in the public cloud. And providing high availability can...