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
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.
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
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
“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
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
As 2025 kicks off, organizations are eagerly setting new goals. For DBAs, a top priority might be preparing thoroughly for the next IT audit. Whether planned or unplanned, an audit can significantly impact how others perceive your IT department’s reliability. A seamless audit highlights strong governance and dependable systems, while missteps can reveal vulnerabilities and…
Read more
As the year comes to an end, all of us at The SERO Group want to extend our warmest wishes to you. We hope that 2024 has been fulfilling and joyful and that you’ve had the opportunity to celebrate with your family and friends. The holiday season is a time for reflection and connection, and…
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
So, your Microsoft SQL Server is showing its age, and you need to upgrade it. What’s the best approach—an in-place upgrade or a side-by-side upgrade? For many businesses, especially those in industries like healthcare or banking, where reliability, security, and performance are non-negotiable, a side-by-side SQL Server upgrade is often the smarter choice. But first,…
Read more
Recent Comments