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
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
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
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.
“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
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
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
Recent Comments