In banking, SQL Server isn’t just a piece of technology humming quietly in the background. It’s the backbone of customer trust, regulatory compliance, and day-to-day operations. Without it, transactions stall, reports can’t run, and auditors start asking uncomfortable questions. Yet in my conversations with CIOs and IT leaders, a common theme keeps coming up: many…
Read more
Last weekend, I hit the trails for a mountain bike ride. As I was packing my gear, it struck me how my pre-ride preparation is similar to managing our banking clients’ SQL Server environment. Both require the right tools, proper planning, and backup systems when things go wrong. The Essential Backpack: Your SQL Server Toolkit…
Read more
SQL Server is mission-critical to your business. However, maintaining performance, reliability, security, and compliance demands ongoing attention and specialized expertise. SQL Server managed services can provide valuable support in these areas. Still, even if your technical team sees the need, it can be tough to make the business case to your CFO. Since managed services…
Read more
If disaster struck your data center right now, how quickly—and how cleanly—could your SQL Server environment recover? It’s a question too many teams avoid until it’s too late. But between rising cybersecurity threats, growing compliance expectations, and increasing reliance on real-time data, a solid SQL Server disaster recovery (DR) plan is no longer optional. Here’s…
Read more
“We’re upgrading Windows and SQL Server. Why can’t we just install the new version on top of the existing one? Why do we have to provision a new virtual machine and go through all that effort?” Whether you’re modernizing your SQL stack to meet compliance requirements, to maintain supportability, or because you want new features…
Read more
If you’re leading an IT team without a dedicated DBA, you’re not alone. Many small- to mid-sized organizations rely on a sysadmin or developer to “keep SQL Server running.” While that can work for a while, it often leaves teams blindsided when something breaks suddenly—or worse, when something breaks slowly. This is why it’s important…
Read more
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
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
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
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
Recent Comments