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
Query Store has been around since SQL Server 2016, but its full potential often goes untapped. Some companies were initially wary of it after some edge case problems arose during its initial rollout. However, since its initial release, Query Store has undergone numerous enhancements and is rapidly establishing itself as one of the most significant…
Read more
If you’re responsible for a SQL Server environment, you already know the stakes: performance, availability, recoverability, and security. But what you don’t know—until something goes wrong—can cost you dearly. That’s why regular SQL Server Health Checks matter. Here are the most common problems we uncover—and why they need attention before they cause trouble. Top 10…
Read more
Banks and credit unions rely on SQL Server databases to power transactions, portals, reporting, fraud detection, and core systems. Despite this, many institutions end up undermanaging or even overlooking these critical systems. The result? Performance lags, security vulnerabilities, and unplanned downtime that can cost far more than most institutions realize. If you’re responsible for operational…
Read more
I read 50 to 60 books a year, a habit I’ve maintained for most of my life. Some of those are just-for-fun fiction books. Others are educational nonfiction books that give me glimpses into other disciplines or subjects. Still others, like the books I’ll share in this post, help me to improve in my various…
Read more
Need to build a SQL Server FCI in AWS but prefer not to use FSx for Windows File Server? Good news, you have other options. One option that more closely aligns with traditional FCIs that use shared disks is Multi-Attach EBS volumes. Multi-Attach EBS volumes in AWS enable organizations to use Windows Server Failover Clusters…
Read more
Whether in the cloud or a data center, the cost of maintaining a SQL Server estate can escalate quickly. Beyond the direct expenses, indirect costs can quietly unbalance and outpace your IT budget. Let’s look at 8 ways to reduce the costs of your SQL Server estate. Direct and Indirect Costs of a SQL Server…
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
Recent Comments