SQL Server has had a number of really wonderful new features over the last several releases. One of those features is Accelerated Database Recovery. This enhancement has received some coverage in the community and I want to make my own contribution to promoting this feature. What is Accelerated Database Recovery? Accelerated Database Recovery (ADR) came…
Read more
Low disk space alerts are a common occurrence in I.T. For SQL Server consultants, there could be a few causes: This last scenario related to volume shadow service is what I want to talk about today. This one can be a little confusing at first because your organization may get a low disk space alert…
Read more
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
When I talk with companies, whether they be community banks or healthcare companies, about their SQL Server environments, I find that most aren’t intentionally and proactively managing their SQL Server environment–they’re reacting to it. Things run fine until they don’t. Then, suddenly, IT teams are dealing with performance issues, failed backups, or questions from auditors…
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
For many businesses, the availability and performance of SQL Server databases are paramount. Unplanned downtime can lead to significant financial losses, tarnished reputations, and regulatory repercussions. Understanding the costs associated with SQL Server downtime and exploring strategies to mitigate these risks is essential for those aiming to maintain operational resilience in 2025. Read on for…
Read more
Since Microsoft SQL Server databases are critical for many organizations, protecting SQL Server from disasters such as security breaches and data loss isn’t optional—it’s essential. This is especially true for sectors like healthcare, banking, and FinTech. I’ve suffered a great many catastrophes in my life. Most of them never happened. -Mark Twain Mark Twain’s quip…
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
Recent Comments