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
SQL Server Availability Groups can present challenges after a failover, such as missing logins, outdated passwords, or absent SQL Server Agent jobs. Some clients address these issues by requiring the primary replica to remain on the same instance. If a failover occurs due to an outage or patching, they generally request to revert the AG…
Read more
SQL Server is designed to efficiently manage memory on its own. It requests memory when it’s needed and releases memory back to the system when it’s not. However, the default settings may not be ideal for your situation. An experienced database administrator will usually fine-tune these settings to optimize performance and server stability. Minimum server…
Read more
Some companies take virtual machine snapshots of their web servers, their file servers, and their Citrix servers. They regularly snapshot before software patching, before server upgrades, and before other configuration changes. Snapshotting a good way to ensure they can recover the VM if something goes wrong. So, that begs the question: should you use VM…
Read more
The SQL Server community is vibrant, caring, and close-knit. Now, with recent news about the future of SQLSaturday, we can add resilient to that list. The gift of SQLSaturday If you’ve been around SQL Server very long, you know just how wonderful the SQL Server community is. People around the world regularly and selflessly share…
Read more
Do All SQL Servers Need to Be Upgraded? Running production systems on a platform that is no longer supported by the vendor is worrisome. If something goes wrong, you’ll no longer be able to call the vendor and receive technical support. But worse, you’ll no longer release updates, fixes, security patches, etc, for the out…
Read more
I’ve been pondering a question recently. “Has PASS outlived its purpose?” To help answer that question, I went to the PASS website to look for its mission statement. I couldn’t find it in the dropdown menus. I searched the site. No results found. That’s disappointing. And perhaps it explains why the organization is struggling as…
Read more
“The human brain starts working the moment you are born and never stops until you stand up to speak in public.” observed Academy Award winning movie producer George Jessel. I think there is some truth to that for many of us. As a regular speaker at conferences, SQLSaturdays, and other organizations, I’m often asked about…
Read more
Recent Comments