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
“This SQL Server is critical. It’s used 24/7. So, we’re behind on patching, and we disabled our scheduled preventative maintenance jobs because they interfered with production. Our database is just too important to do that. We know that maintenance is important, but we just can’t.” Does that sound familiar? I hope not. It’s not a…
Read more
Being an “Accidental DBA” is a role some IT professionals find themselves in. Whether you’re an IT generalist, a software developer, or another professional tasked with SQL Server management on top of your primary responsibilities, the role can feel daunting. From maintaining performance to ensuring security, from verifying backups to responding to problems, SQL Server…
Read more
When it comes to running your business, a well-maintained SQL Server infrastructure is often the unsung hero. SQL Server is often behind the scenes, powering critical systems, supporting decision-making, and safeguarding vital data. However, when it’s neglected, the costs—both visible and hidden—can quickly spiral out of control. The cost of neglecting SQL Server Let’s look…
Read more
Managing SQL Server infrastructure in-house can present more challenges than many companies anticipate. Between constant security threats, performance monitoring, and ensuring high availability, the demands on a database administrator (DBA) are extensive. For many companies, especially those without a large IT staff, these needs can strain resources and impact profitability. Outsourcing SQL Server management offers…
Read more
Since Microsoft SQL Server databases are critical for many organizations, protecting SQL Server from disasters such as security breaches and data loss isn’t optional—it’s essential. This is especially true for sectors like healthcare, banking, and FinTech. I’ve suffered a great many catastrophes in my life. Most of them never happened. -Mark Twain Mark Twain’s quip…
Read more
Keeping SQL Servers secure is essential, especially in highly regulated industries like finance, healthcare, and government. The Center for Internet Security (CIS) offers a valuable resource for SQL Server administrators: a set of security benchmarks that provide actionable, best-practice guidance to secure SQL Server instances effectively. Implementing these standards helps reduce vulnerabilities, achieve compliance, and…
Read more
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
If you’re running an older version of SQL Server, you might be wondering if it’s time to upgrade. SQL Server 2022 brings powerful new features for both on-premises and cloud environments. It promises better performance, stronger security, and real-time analytics. But with the potential announcement of SQL Server vNext looming, is now the right time…
Read more
As an IT leader in a heavily regulated sector such as finance or healthcare, you’re no stranger to audits. They’re a critical part of ensuring compliance with regulations like the Sarbanes-Oxley Act (SOX), the Gramm-Leach-Bliley Act (GLBA), the PCS Security Standards Council (PCI DSS), and the Health Insurance Portability and Accountability Act (HIPAA). Still, audits…
Read more
Recent Comments