At Coeo we make heavy use of Ola Hallengren’s Maintenance Solution for configuring database backup, integrity check and index optimisation jobs. We use it because it’s great, and we presented on it at SQLBits last year.
This blog is part of Advanced Failover Cluster options series, which demonstrates and provides information for deploying ‘Domain-independent Windows Failover Cluster for SQL Server AlwaysOn Availability Group’. You will find commonalities between the deployment of ‘Active Directory-Detached..
This series will cover the following three Advanced Windows Failover Cluster Options with SQL Server AlwaysOn availability group configuration to demonstrate how they differentiate from one another and how they work.
Welcome to Chez SQL. I will be your SQL server (ha ha)!
SQL Server 2012 is fast approaching its Extended Support end date of 12th July 2022. After this date regular security updates will no longer be provided, exposing your data to significant security and compliance risks. In addition to this, support for Windows Server 2012 and 2012 R2 will end in..
Many countries follow the standard of Daylight Saving Time (DST), where twice each year, the clocks will move either forward or backwards by one hour to maximise the evening daylight in the spring, summer, and autumn months. For countries that follow this, there is a specific side-effect of this..
We recently came across an interesting issue when performing some planned work for a client. In order to move the databases' data files to a different disk, we had to temporarily remove the databases from the availability group (AG) but had an issue when trying to join the secondary..
Discover why migrating to a cloud platform comes with its own set of challenges and the considerations that companies need to make when selecting a managed services provider.Kieran Sutherland - Commercial Lead for Coeo's Dedicated Support Service - talks about the myths around cloud migration,..
For SQL Server IaaS VMs, Microsoft provides Azure Backup for SQL Server – a PaaS service allowing you to leverage the Azure Backup service to back up SQL Server databases easily and in a centralised manner.
In this post, we’ll discuss a recent pitfall we came across with backup concurrency, and how..