Month: September 2024

Basic Availability Groups: Affordable High Availability with Key Limitations

Basic Availability Groups: Affordable High Availability with Key Limitations

In SQL Server 2022, Basic Availability Groups provide a limited, cost-effective solution for high availability and disaster recovery in the Standard Edition. However, they have several limitations when compared to a standard Availability Group in the Enterprise Edition. Although Basic AGs were introduced before SQL Server 2022, we’ll focus strictly on the latest version. Let’s…
Read more

Audit-Ready SQL Servers: The Game Plan

Audit-Ready SQL Servers: The Complete Game Plan

As an IT leader in a heavily regulated sector such as finance or healthcare, you’re no stranger to audits. They’re a critical part of ensuring compliance with regulations like the Sarbanes-Oxley Act (SOX), the Gramm-Leach-Bliley Act (GLBA), the PCS Security Standards Council (PCI DSS), and the Health Insurance Portability and Accountability Act (HIPAA). Still, audits…
Read more

Reducing Business Risks for a SQL Server Estate

Reducing Business Risks for a SQL Server Estate

Your SQL Servers are the backbone of your company’s data operations. They power critical applications and store valuable information. They enable financial decisions, undergird operational activities, and support your sales processes. But what happens if there’s a problem? What happens when data is lost or corrupted? Or if one of your key systems is down…
Read more