Category: SQL Server

core banking system SQL Server

When “We Just Don’t Know” Costs You: The Hidden Risk of SQL Server Outages for Banks and Financial Institutions

I recently spoke with a senior IT leader at a respected financial institution about their Microsoft SQL Server environment. Like many banks, they rely on their core banking system provider to build and maintain their SQL Server infrastructure. But a recent experience undermined their confidence in that approach. Their core banking system SQL Server went…
Read more

SQL Server Health Check

SQL Server Health Checks: 10 Issues That Show Up Again and Again

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

SQL Server Database Mail Troubleshooting

How to Troubleshoot SQL Server Database Mail Issues Using Built-In View

Sending emails from a SQL Server via sp_send_dbmail is common, but troubleshooting problems can be frustrating. Fortunately, SQL Server logs every email attempt, making it easier to find and fix issues. View All Messages Processed By Database Mail The sysmail_allitems view shows every email that Database Mail has tried to process, whether it was successful…
Read more

Tail-Log Backup SQL Server

Why Tail-Log Backups Matter for SQL Server Recovery and Migration

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

Undermanaged SQL Servers can lead to frustration for both your customers and your team.

The Costs of Undermanaged SQL Servers for Financial Institutions

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

SQL Server Compression

Should You Use SQL Server Compression to Optimize Storage and Performance?

If you’ve worked around database systems for long, you’ve no doubt encountered the issue of ensuring efficient storage. As your databases grow, so do your storage sizes (and costs!). Thankfully, SQL Server provides a powerful feature that can help alleviate this problem: compression. Compression in SQL Server is a feature that helps to reduce the…
Read more

SQL Server Downtime Prevent

The Impact of SQL Server Downtime (and How to Prevent It)

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

Clustered vs. Non-Clustered Indexes

Clustered vs. Non-Clustered Indexes: How to Optimize SQL Server Performance

Indexes are an essential part of any SQL Server database. One of the keys to improving performance is understanding how indexes work. Indexes help speed up data retrieval, optimize query performance, and improve the overall efficiency of your database. SQL Server offers several index types, but clustered and non-clustered indexes are the most important. Understanding…
Read more

SQL Server piecemeal restores

SQL Server Piecemeal Restores: Minimize Downtime & Speed Up Recovery

Restoring large databases can be time-consuming, but online piecemeal restores in SQL Server Enterprise offer quicker access to data. This method allows partial restoration while keeping the primary filegroup online, minimizing downtime. Requirements include using the Enterprise edition, multiple filegroups, a full recovery model, and available log backups. Best practices enhance efficiency.

SQL Server high memory usage

Understanding SQL Server’s High Memory Usage: What You Need to Know

“Why is SQL Server memory usage high?” If you haven’t been asked this question, you haven’t supported SQL Server long enough. I’ve encountered managers, systems administrators, and developers who’ve wondered this. Simply put, data reads are much faster in RAM than from disks. RAM latency is typically measured in nanoseconds. By contrast, disk latency is…
Read more