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.
Domain-Independent Windows Failover Cluster for SQL Server AlwaysOn Availability Group
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..
SQLBits 2022 session - Field Testing Ola Hallengren’s Maintenance Solution
As far as maintenance solutions for SQL Server instances are concerned, those based on Ola Hallengren's scripts work beautifully out of the box. They have also transformed many a SQL Server and boast an impressive track record. Nevertheless, a critical question arises: How do you get the best out..
Windows Active Directory Detached Cluster with SQL Server Basic Availability Group
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.
SQL Server 2012 End of Life: What does the Microsoft Product Lifecycle mean to me?
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..
Does SQL Server Get An Extra Hour In Bed?
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..
Database in restoring state and single user mode? See why and how to resolve
Background...
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..
Podcast: Managed Services for Data Platforms (with Kieran Sutherland)
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,..
Concurrency with Azure Backup for SQL Server
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..
