Understanding RPO and RTO with SQL Server In the realm of SQL Server management, two crucial concepts that every DBA and IT manager must understand are Recovery Point Objective (RPO) and Recovery Time Objective (RTO). These metrics are pivotal in planning for disaster recovery and ensuring business continuity. Let’s dive into what RPO and RTO mean, how they apply to …
There are 2 perspectives here to the DBA on vacation, typically in an organization with only a single DBA so there is no cross coverage when someone goes on vacation. The view as the DBA: I have done everything that I can to prepare the systems for vacation, but still I end up getting called for some regular maintenance job …
If you are reading this article becuase you are trying to repair your corruptin database, please reach out ot us at Stedman Solutions we can take a quick look and help determine your options for reparing the database. Contact us for a free 30 minute consultation. These stories come from a recording of a presentation by Steve Stedman and Derrick …
SQL Server Corruption: Stories About Causes of Corruption Read more »
Unlock the Full Potential of Your SQL Server with Stedman Solutions’ Managed Services In today’s fast-paced world, your SQL Server database is more crucial than ever. It’s the powerhouse behind your most critical operations. That’s where Stedman Solutions, LLC, steps in. We offer flexible, fully managed services tailored to the unique demands of your SQL Server environment. Our elite SQL …
Unlock the Full Potential of Your SQL Server with Stedman Solutions Managed Services Read more »
Today Microsoft released a new update for SQL Server. SQL Server 2019 CU27 for 2019 (15.0.4375.4 – June 2024) CU25 + GDR (15.0.4360.2 – April 2024) 2024-06-13 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None SQL Server 2022 RTM Download links: NoneCU13 …
Parameter Sniffing and Conditional Logic in SQL Server Stored Procedures: A Performance Pitfall Parameter sniffing is a well-known feature in SQL Server that can significantly impact query performance. While it often leads to optimized query execution, it can sometimes cause performance issues, especially when combined with conditional logic in stored procedures. In this article, we’ll explore how parameter sniffing interacts …
Parameter Sniffing and Conditional Logic in SQL Server Stored Procedures Read more »
I am scheduled on July 6th for a special session on Rockin’ the Code World with dotNetDave. I was on a session a couple of years ago of the show with Dave, and now I am coming back for another episode. During this episode we plan to talk about more of a non-technical item but something that we hopefully all …
Managing a SQL Server environment can be a daunting task, especially for businesses without a dedicated DBA team. SQL Server issues can lead to significant downtime, data corruption, and performance bottlenecks that can impact your bottom line. At Stedman Solutions, we specialize in SQL Server managed services, ensuring your systems run smoothly, securely, and efficiently. Here’s why our services are …
Why Your SQL Server Needs Expert Managed Services Read more »
The CHECK_EXPIRATION option is a security feature of SQL Server that allows you to enforce password expiration for SQL Server logins. When this option is set to ON for a login, it requires the login to change its password after a certain period of time has passed. Setting the CHECK_EXPIRATION option to ON for all SQL authenticated logins within the …
Securing SQL Server: CHECK_Expiration for SQL Server logins Read more »
Top 4 SQL Server Performance Tuning Mistakes and How Stedman Solutions Can Help 1. Ignoring Index Fragmentation Mistake: Over time, indexes become fragmented, leading to inefficient data retrieval and slower query performance. Solution: Stedman Solutions uses Database Health Monitor to regularly check for and address index fragmentation, ensuring your SQL Server remains optimized. 2. Poorly Written Queries Mistake: Inefficient queries …