Tag: SQL Server Consultant

SQL core banking upgrade

Choosing the Right SQL Server Partner for Your Core Banking Upgrade

Upgrading your core banking system that supports the core banking system is a major initiative that demands meticulous planning, cross-team coordination, and deep technical know-how. For banks and financial institutions, SQL Server is often the backbone of these systems. That’s why the role of a SQL Server partner during a core banking upgrade is critical.…
Read more

SQL Server database migration

How We Migrated 1,200+ SQL Server Databases in Under 3 Hours (While Cutting Storage Costs by 84%)

Editor’s Note: This is part one of a two-part series. In next week’s follow-up, we’ll cover the project management and coordination strategies that helped make this migration a success. What if you could retire two aging SQL Server 2016 failover clustered instances, migrate 1,200+ databases to SQL Server 2022, and slash storage spend by 84%—all…
Read more

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

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

Reduce the Cost of a SQL Server Estate

8 Ways to Reduce the Cost of a SQL Server Estate

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

Prevent SQL Server Outages by Monitoring Transaction Log Growth

Prevent SQL Server Outages by Monitoring Transaction Log Growth

I’ve lost count of the times I’ve been called after hours due to a drive filling up. The usual culprit? Transaction file log growth. Monitoring the growth of your SQL Server transaction log files is crucial for maintaining database performance and ensuring system reliability. Unchecked transaction log growth can lead to disk space issues and…
Read more

Reducing Business Risks for a SQL Server Estate

Reducing Business Risks for a SQL Server Estate

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

Conference hall, IT Symposium

Join Us: 8/21 IT Symposium in Louisville

The SERO Group will be at the IT Symposium in Louisville on August 21st! I’m looking forward to connecting with industry leaders, sharing insights, and discussing the latest trends and innovations. The event will be at the Louisville Marriott East from 8:30 a.m. to 3:15 p.m. If you’re in the area, stop by our table…
Read more

Check your SQL Server's code compatibility with Azure so you don't step in it.

Is your SQL Server Code Ready for Azure?

I recently had a discussion with a client that turned to the question of SQL Server code compatibility with Azure SQL Database. We were designing a new pipeline for their on-premises SQL environment, and they mentioned their abandoned cloud migration effort from a few years earlier. The business ended up pausing this effort because of…
Read more

High availability options--which one should you choose?

Availability Groups: What’s Right for Your Business?

I’ve had several companies inquire about SQL Server’s built-in high availability options over the years. This conversation usually indicates a need to ensure that their database systems remain operational and accessible with minimal downtime. But why now? They’ve been in business for years and are just now interested in HA/DR. What changed? Reasons vary, but…
Read more