Tag: SQL Server

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

TBA Strategic Tech Summit

Join Us: Tennessee Bankers Association Innovation and Strategic Tech Summits

The SERO Group is excited to participate in the 2025 TBA Innovation and Strategic Tech Summits on April 10th and 11th in Franklin, TN. This event brings together banking professionals, technology leaders, and industry experts to discuss the future of banking and explore innovative solutions for financial institutions. With a rapidly changing landscape, banks need…
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

Replacement FFIEC CAT

Farewell, CAT: FFIEC Cybersecurity Tool Will Sunset This August

Banks’ Replacement Options for the FFIEC CAT Since 2015, the FFIEC CAT has helped financial institutions assess cybersecurity risks and maturity levels. However, the FFIEC recently announced that the CAT will sunset on August 31, 2025. Now, banks must determine the best alternative to ensure continued compliance and security. The FDIC’s official announcement encourages institutions…
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

Database downtime cost

The True Costs of Database Downtime—and Why Modernization Can’t Wait

How to Build a Business Case for Modernization In today’s always-on business environment, database downtime isn’t just an inconvenience—it’s a direct hit to revenue, productivity, and customer trust. Despite this, many organizations delay modernization efforts due to perceived costs and complexity. However, the real question is: can your business afford not to modernize? Read on…
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.

Database Design SQL Server

How Proper Database Design Improves SQL Server Performance and Scalability

When a SQL Server database is the backbone of your application, its design will have a huge impact on the application’s performance. While many developers just view the database as a container for storing data, the truth is that a well-designed database is critical to your application’s speed, reliability, and ability to scale with your…
Read more

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

Best business books

The Best Business Books I Read in 2024

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