Last Saturday, I woke up before dawn to a quiet house. My family was still asleep, as I’m the only morning person in our household. The Christmas tree lights cast a warm glow across the room, and I was alone with my thoughts and a hot cup of coffee. No urgent emails, no fire drills,…
Read more
Updated: November 3, 2025: Missed the live event? You can now watch the full recording on our YouTube channel. Why SQL Server Maturity Matters In banking, SQL Server isn’t just a technology platform—it’s the backbone of customer trust, regulatory compliance, and operational resilience. But many institutions operate in reactive, risk-heavy environments that lead to outages,…
Read more
If you’re a new CIO at a bank or financial institution, chances are your organization relies heavily on Microsoft SQL Server. From core banking systems to regulatory data, SQL Server often holds your most critical and most targeted information. However, over time, many SQL Server environments quietly drift out of alignment with security best practices.…
Read more
In previous posts, we’ve covered the more routine types of backups available within SQL Server — full, differential, and transaction log backups. While you may not use them as often, you should also be aware of tail-log backups when managing SQL Server. Tail-log backups can help in two scenarios. What is a tail-log backup? Tail-log…
Read more
If you’re attending the GBA Operations and Technology Conference, we’d love to meet you! This event is Georgia’s leading conference for bank operations and technology professionals, covering key topics like cybersecurity, payments, fintech partnerships, and vendor management. It’s a great opportunity to network, learn from industry experts, and explore new solutions to today’s banking challenges.…
Read more
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
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
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
The SERO Group will be at the IT Symposium in Louisville on August 21st! I’m looking forward to connecting with industry leaders, sharing insights, and discussing the latest trends and innovations. The event will be at the Louisville Marriott East from 8:30 a.m. to 3:15 p.m. If you’re in the area, stop by our table…
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
Recent Comments