<?xml version="1.0" encoding="UTF-8"?><rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>SQL Server Consulting &#8211; Straight Path Solutions</title>
	<atom:link href="http://straightpathsql.com/feed/" rel="self" type="application/rss+xml" />
	<link>https://straightpathsql.com/</link>
	<description>Database Managed Services and Pain Relief. Sleep at night!</description>
	<lastBuildDate>Wed, 09 Sep 2026 12:13:16 +0000</lastBuildDate>
	<language>en-US</language>
	<sy:updatePeriod>
	hourly	</sy:updatePeriod>
	<sy:updateFrequency>
	1	</sy:updateFrequency>
	

<image>
	<url>https://straightpathsql.com/wp-content/uploads/2026/03/cropped-straight-path-solutions-logo-square-32x32.png</url>
	<title>SQL Server Consulting &#8211; Straight Path Solutions</title>
	<link>https://straightpathsql.com/</link>
	<width>32</width>
	<height>32</height>
</image> 
	<item>
		<title>We Won ClearlyRated’s Best of IT Services Award Two Years in a Row</title>
		<link>https://straightpathsql.com/we-won-clearlyrateds-best-of-it-services-award-two-years-in-a-row/</link>
					<comments>https://straightpathsql.com/we-won-clearlyrateds-best-of-it-services-award-two-years-in-a-row/#respond</comments>
		
		<dc:creator><![CDATA[Mike Walsh]]></dc:creator>
		<pubDate>Wed, 09 Sep 2026 12:08:07 +0000</pubDate>
				<category><![CDATA[Company News]]></category>
		<category><![CDATA[Best in Service]]></category>
		<category><![CDATA[Client Ratings]]></category>
		<category><![CDATA[DBA Services]]></category>
		<category><![CDATA[feedback]]></category>
		<category><![CDATA[Growth Mindset]]></category>
		<category><![CDATA[Reviews]]></category>
		<guid isPermaLink="false">https://straightpathsql.com/?p=5323</guid>

					<description><![CDATA[<p>But we just found out that it was two years in a row. We achieved it for 2026 with our 2026 surveys and I asked about the criteria &#8211; we seem to have the required response rate and ratings most years, and they said yeah you&#8217;re right. You have it for 2025 and 2026. I ... <a title="We Won ClearlyRated’s Best of IT Services Award Two Years in a Row" class="read-more" href="https://straightpathsql.com/we-won-clearlyrateds-best-of-it-services-award-two-years-in-a-row/" aria-label="Read more about We Won ClearlyRated’s Best of IT Services Award Two Years in a Row">Read more</a></p>
<p>The post <a href="https://straightpathsql.com/we-won-clearlyrateds-best-of-it-services-award-two-years-in-a-row/">We Won ClearlyRated’s Best of IT Services Award Two Years in a Row</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></description>
										<content:encoded><![CDATA[
<p class="wp-block-paragraph" id="h-"><em>But we just found out that it was two years in a row. We achieved it for 2026 with our 2026 surveys and I asked about the criteria &#8211; we seem to have the required response rate and ratings most years, and they said yeah you&#8217;re right. You have it for 2025 and 2026. I think we would have had it past years also but not sure when they started.</em></p>



<p class="wp-block-paragraph"><strong>I am normally not a fan of all of those awards. I&#8217;ve had pay for play offers to get CIO Review Magazine best in service, CEO of the year, Azure Service Provider of the year, etc many years in a row. If I pay enough for the honor, I&#8217;ll get it and can even put a press release on the website. I&#8217;ve had the offers to be an &#8220;Author&#8221; on Forbes Publishing &#8211; they&#8217;ll assign me a ghost writer, and I can order as many copies as I want to give out &#8211; and it will only cost me 5-6 figures&#8230;.</strong></p>



<p class="wp-block-paragraph">But we found out this year that last year and this year, <a href="https://www.clearlyrated.com/it-services/nh-usa/sanbornville-nh/straight-path-it-solutions-llc-sanbornville-nh">Clearly Rated</a> has listed us in the Best Of IT Services category because of our NPS.</p>



<figure class="wp-block-image size-large is-resized"><a href="https://www.clearlyrated.com/it-services/nh-usa/sanbornville-nh/straight-path-it-solutions-llc-sanbornville-nh"><img decoding="async" width="956" height="318" src="https://straightpathsql.com/wp-content/uploads/2026/09/image-1-edited.png" alt="" class="wp-image-5328" style="aspect-ratio:3.357560658578856;width:412px;height:auto" srcset="https://straightpathsql.com/wp-content/uploads/2026/09/image-1-edited.png 956w, https://straightpathsql.com/wp-content/uploads/2026/09/image-1-edited-300x100.png 300w, https://straightpathsql.com/wp-content/uploads/2026/09/image-1-edited-768x255.png 768w" sizes="(max-width: 956px) 100vw, 956px" /></a></figure>



<p class="wp-block-paragraph">But this is a fun one. We do pay Clearly Rated, but we pay them before we know the results and we pay them no matter what the results are, we&#8217;re paying for the survey process and having it handled by an independent third party with audits and checks. We&#8217;ve been paying them for many years now to survey our clients. I want honest, transparent, and actionable feedback from our clients. We ask them how we&#8217;re doing, the renewals and low churn speak for themselves, but I have a growth mindset and we can always be just a bit better than we were. So we have them do the surveys, we can&#8217;t tweak the results and doctor them up. </p>



<figure class="wp-block-image size-full is-resized"><a href="https://www.clearlyrated.com/it-services/nh-usa/sanbornville-nh/straight-path-it-solutions-llc-sanbornville-nh"><img decoding="async" width="204" height="415" src="https://straightpathsql.com/wp-content/uploads/2026/09/image-2-edited.png" alt="" class="wp-image-5327" style="width:150px;height:auto" srcset="https://straightpathsql.com/wp-content/uploads/2026/09/image-2-edited.png 204w, https://straightpathsql.com/wp-content/uploads/2026/09/image-2-edited-147x300.png 147w" sizes="(max-width: 204px) 100vw, 204px" /></a></figure>



<p class="wp-block-paragraph">And apparently we&#8217;re better at taking care of client SQL Server environments than we are at keeping track of awards&#8230;</p>



<h2 id="h-why-we-use-clearlyrated-in-the-first-place" class="wp-block-heading">Why We Use ClearlyRated in the First Place</h2>



<p class="wp-block-paragraph">At first 7ish years ago, I had built a SurveyMonkey survey to send to users. How are we doing? Where can we improve?  The goal was to get a number score (Clearly rated uses NPS &#8211; NPS alone is bad, I think &#8211; it gets sentiment but not the why, and not the trends and micro-trends to continually improve service), but to find out where we can improve. You can chalk that up to one part always wanting to be a bit better, and one part being the kind of person who always thinks I&#8217;m just one implosion away from a bad moment. I wanted to make sure we were always a good value and earning the renewals, not just presuming on them.</p>



<p class="wp-block-paragraph">A friend told me about Clearly Rated that they used and they liked that it was arm&#8217;s length. The results are the results, but it is scientific, repeatable to survey and you can even see how your team does against each other (in the early days of Straight Path) or how your divisions are doing (today) so you can see if there is training to be done.</p>



<p class="wp-block-paragraph">We also wanted to solicit feedback. Sure I want the kudos and testimonials &#8211; and check out our page from the link above. We get them! But we also ask a loaded question that says even if you are happy, tell us one area we can improve. We then follow-up on those areas that folks identify. <br><br>In fact, it was the annual survey a number of years ago where we saw that while we got high marks and clearly folks loved us &#8211; we noticed one category was stronger in the &#8220;usually&#8221; category than the &#8220;always&#8221; category compared to the rest&#8230; <strong>Proactive. </strong>We ask a series of We are &#8230;&#8230; A good value/proactive/responsive/etc. And Proactive was looking like a solid B &#8211; but the others were in the A to A plus camp. We launched our proactive dashboards, and ultimately decided to make the tool that is our monitoring tool, Skopos, that we are in the midst of rolling out. Because the surveys said we could be just a bit more proactive.</p>



<p class="wp-block-paragraph">Feedback from clients who seem to mostly like us but are put on the spot to tell us where we can improve is priceless. And when there is a trend &#8211; that&#8217;s fodder for our annual goals and off-site meeting.</p>



<p class="wp-block-paragraph">The goal with this process isn&#8217;t to someday achieve some &#8220;good enough&#8221; rating and stop. It&#8217;s to set a target and keep working towards it.</p>



<h2 id="h-what-the-numbers-show" class="wp-block-heading">What The Numbers Show</h2>



<p class="wp-block-paragraph">Our team apparently earned the Clearly Rated Best of IT Services award in both 2025 and 2026. Our current public profile there shows we have 235 verified client ratings, 4.9 out of 5 stars and we have the 2025 and 2026 best in service award designations on our profile.</p>



<p class="wp-block-paragraph">Our team is amazing. I&#8217;m sure there are many great teams out there &#8211; and we&#8217;re friends with quite a few of them &#8211; but this is a testament to the concern for client service and our values (Trust360, Ownership Mentality, Generosity and Humility) in each member of our team. Our NPS is unheard of in most service industries &#8211; 93.5% in 2026, 90% in 2025. </p>



<p class="wp-block-paragraph">The numbers show that we listen, we care, we learn from them and we work hard at finding the themes and patterns to improve in. We will never have the attitude of <strong>&#8220;we&#8217;ve arrived.&#8221;</strong></p>



<h2 id="h-winning-twice-means-more-than-winning-once" class="wp-block-heading">Winning Twice Means More Than Winning Once</h2>



<p class="wp-block-paragraph">Seeing that we have high scores each year makes me really proud of the team and all they do to work on service delivery and relationship building. The survey responses that speak of us as a partner or part of our clients&#8217; teams speaks volumes about each person on our team and the way they care for our clients.</p>



<p class="wp-block-paragraph">Seeing that we won two years in a row means we didn&#8217;t just have a good or lucky year &#8211; it means our team is consistently doing what they need to be. Even if I hammer on the &#8220;where can we improve?&#8221; responses &#8211; I do it because I care about us striving to always get better. And the team doesn&#8217;t just put up with it, they listen and work on it.</p>



<p class="wp-block-paragraph">Winning a sale is great. Having a renewal after a first quarter is great since we don&#8217;t keep folks on a cell-phone contract like so many do. But year over year renewals for the long haul combined with surveys painting a similar picture over the years shows that our team is genuinely appreciated and that our focus on relationship, values, and culture first is working. I&#8217;m counting on that mattering well into the future, even as AI and automation seek to remove that connection and the values from the equation.</p>



<h2 id="h-it-does-not-mean-we-get-everything-right" class="wp-block-heading">It Does Not Mean We Get Everything Right</h2>



<p class="wp-block-paragraph">I just posted yesterday about <a href="https://straightpathsql.com/9-ways-managed-dba-services-can-go-wrong/" data-type="post" data-id="5120">9 ways that managed DBA services can go wrong</a>. And there are way more than 9 ways. Our one detractor score we ever got was still directed squarely at me. I have communication issues. I sometimes err on the side of Ownership Mentality and have picked the wrong hill to die on. I&#8217;ve grown, but I still get it wrong. Our team has had to be coached, we&#8217;ve dropped balls. Some client relationships weren&#8217;t right. We learned about the <a href="https://straightpathsql.com/3-times-you-should-not-hire-a-dba-as-a-service-provider/">3 bad fits</a> I blogged about a few weeks ago through the survey and self-reflection.</p>



<p class="wp-block-paragraph">But. We&#8217;ve heard all of the feedback. I&#8217;m sure our clients can tell you while rolling their eyes about the meeting request that Evan, our COO, and I send to hear more about the constructive feedback. We take each piece of feedback and learn from it. We teach the team. We coach. We make sessions at the annual meeting &#8211; we optimize to learn.</p>



<h2 id="h-the-feedback-matters-more-than-the-badge" class="wp-block-heading">The Feedback Matters More Than the Badge</h2>



<p class="wp-block-paragraph">Awards are useful external evidence, particularly in a market filled with self-reported claims and a gazillion accolades and headlines available to purchase. But a badge or a headline can&#8217;t tell you how to actually run your company better and where to make the tweaks. <br><br>It&#8217;s the client comments, the patterns, the trends, and the ratings that are tough to read that can promote the change. It&#8217;s the relentless follow-up on the feedback received that can give you the ideas to create a Proactive data warehouse and PowerBI reports for folks or finally make the gigantic investment in your own monitoring tool.</p>



<p class="wp-block-paragraph">We get the hard truths and the incremental improvements from surveys that we&#8217;d never get from buying that accolade I can buy 4-6 times a year in my e-mail or signing that deal to become &#8220;an author&#8221; of my own Forbes book.</p>



<p class="wp-block-paragraph">Things like:</p>



<ul class="wp-block-list">
<li>Better transitions when a lead DBA leaves and a new one joins (talked about that yesterday)</li>



<li>Better documentation for the team on our playbook to be consistent in service (Evan is working on that right now)</li>



<li>Better monthly communications at our monthly client check-ins.</li>



<li>Clearer escalation paths.</li>



<li>Paying a bit more attention to hours and engagement sizing from the start.</li>
</ul>



<p class="wp-block-paragraph">There is more. And there always will be something to improve. Likewise, with our team, we have our annual all-hands meeting in Boston this year in a few weeks. We ask our clients to be in emergency only mode for a few days with us while we retool, improve and come back stronger and better each year. But we ask the team to break into groups each year and write up issues for our issues list. And the leadership team works hard at engaging on improving those issues all year. We do a great job. But there will always be a thing to improve from a client. There will always be things about our model and how we do business that can be made better for our team. There are certainly moments where the human side of me and the self-doubt side of me would rather just pretend like things are fine and not do the surveys, not read the speaker feedback form after I deliver a session and not do the issues list. But we won&#8217;t grow if we don&#8217;t.</p>



<p class="wp-block-paragraph">Don&#8217;t get me wrong. The badge is really cool. And to have it two years in a row? I&#8217;m excited.</p>



<h2 id="h-thank-you" class="wp-block-heading">Thank You</h2>



<p class="wp-block-paragraph">As always a big thanks to the clients who take the time to respond each year and not get annoyed at the repeated reminders that the surveys are out there. Thank you to the team who work hard daily to keep our level of service always getting just a bit better. We have one of the most amazing teams out there. Sure they are the folks who are MVPs, authors, bloggers, community tool makers, and folks who taught the MCMs &#8211; but they are also people who genuinely care about our clients. And not just because of a feedback score. It shows.</p>



<p class="wp-block-paragraph">And thanks to the clients who share the tough feedback when we could have done a better job. It&#8217;s that feedback and your trust in us to share that with us that helps inspire us to get it right.</p>



<h2 id="h-closing-we-ll-try-to-pay-better-attention-next-year" class="wp-block-heading">Closing: We’ll Try to Pay Better Attention Next Year</h2>



<p class="wp-block-paragraph">If we win this in 2027, we&#8217;ll do a better job of noticing it so I can congratulate our team and thank our clients. If we don&#8217;t? I&#8217;ll tell you we didn&#8217;t and tell you what we learned. But either way, we&#8217;ll be doing our survey with Clearly Rated next year and learning what the survey shows us next spring and summer. </p>



<h3 id="h-some-links" class="wp-block-heading">Some Links</h3>



<ul class="wp-block-list">
<li>Our <a href="https://www.clearlyrated.com/it-services/nh-usa/sanbornville-nh/straight-path-it-solutions-llc-sanbornville-nh?utm_source=chatgpt.com">ClearlyRated profile</a>.</li>



<li>Our <a href="https://straightpathsql.com/sql-server-consulting/dba-as-a-service/" data-type="page" data-id="189">Remote SQL Server DBA/ DBA as a Service page.</a></li>



<li>Our <a href="https://straightpathsql.com/about/" data-type="page" data-id="95">AboutUs page </a></li>
</ul>



<p class="wp-block-paragraph"></p>



<p class="wp-block-paragraph"></p>
<p>The post <a href="https://straightpathsql.com/we-won-clearlyrateds-best-of-it-services-award-two-years-in-a-row/">We Won ClearlyRated’s Best of IT Services Award Two Years in a Row</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></content:encoded>
					
					<wfw:commentRss>https://straightpathsql.com/we-won-clearlyrateds-best-of-it-services-award-two-years-in-a-row/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>9 Ways Managed DBA Services can Go Wrong</title>
		<link>https://straightpathsql.com/9-ways-managed-dba-services-can-go-wrong/</link>
					<comments>https://straightpathsql.com/9-ways-managed-dba-services-can-go-wrong/#respond</comments>
		
		<dc:creator><![CDATA[Mike Walsh]]></dc:creator>
		<pubDate>Tue, 08 Sep 2026 14:30:42 +0000</pubDate>
				<category><![CDATA[DBA as a Service]]></category>
		<category><![CDATA[Buyers Guide]]></category>
		<category><![CDATA[Buying DBA Services]]></category>
		<category><![CDATA[How to buy DBA services]]></category>
		<category><![CDATA[Problems with managed services]]></category>
		<category><![CDATA[Remote DBA]]></category>
		<guid isPermaLink="false">https://straightpathsql.com/?p=5120</guid>

					<description><![CDATA[<p>We sell DBA as a Service here at Straight Path. Managed DBA services work most of the time, but sometimes it doesn&#8217;t, even for our clients. Remote DBA services can go wrong because the provider fails, because the client makes it difficult for the service model to work, or because neither side clearly defined the ... <a title="9 Ways Managed DBA Services can Go Wrong" class="read-more" href="https://straightpathsql.com/9-ways-managed-dba-services-can-go-wrong/" aria-label="Read more about 9 Ways Managed DBA Services can Go Wrong">Read more</a></p>
<p>The post <a href="https://straightpathsql.com/9-ways-managed-dba-services-can-go-wrong/">9 Ways Managed DBA Services can Go Wrong</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></description>
										<content:encoded><![CDATA[
<p class="wp-block-paragraph"><em>We sell DBA as a Service here at Straight Path. Managed DBA services work most of the time, but sometimes it doesn&#8217;t</em>,<em> even for our clients.</em></p>



<p class="wp-block-paragraph">Remote DBA services can go wrong because the provider fails, because the client makes it difficult for the service model to work, or because neither side clearly defined the ownership, expectations, and relationship in the first place.</p>



<p class="wp-block-paragraph">Usually when it goes poorly, everyone involved on both sides is competent and <strong>has the best of intentions</strong>, but nobody ever really clarified what &#8220;DBA as a Service&#8221; means.</p>



<p class="wp-block-paragraph">We&#8217;ve been a company for 15 years, since July of 2011, and we&#8217;ve been delivering DBA as a Service with a team the way we do today for about 10 of those years. That means we&#8217;ve seen versions of all of these&#8230; Situations where we&#8217;ve taken over a relationship, or given some advice, and even <strong><em>even situations where we could have done better ourselves and learned along the way.</em></strong></p>



<p class="wp-block-paragraph">If you&#8217;re thinking about moving forward with a Remote DBA firm/Managed DBA services/DBA as a Service firm (insert your favorite phrase here &#8211; Fractional DBA as some friends in the industry call it works, too) &#8211; here&#8217;s a list of some problems worth thinking about before you sign an agreement. With us, or any of our friends in the space.</p>



<p class="wp-block-paragraph">This post is part of our series about <a href="https://straightpathsql.com/tag/buying-dba-services/">Buying DBA Services</a>.  Some thoughts and tips to help you on your journey to buying services from us or our friends in the industry.</p>



<div class="wrapper-video">
<div style="position: relative; padding-top: 56.25%;">
  <iframe
    src="https://customer-zfb3lxtijbv9qz8k.cloudflarestream.com/915b128b1e077b751f4303b0e709e126/iframe?poster=https%3A%2F%2Fcustomer-zfb3lxtijbv9qz8k.cloudflarestream.com%2F915b128b1e077b751f4303b0e709e126%2Fthumbnails%2Fthumbnail.jpg%3Ftime%3D%26height%3D600"
    loading="lazy"
    style="border: none; position: absolute; top: 0; left: 0; height: 100%; width: 100%;"
    allow="accelerometer; gyroscope; autoplay; encrypted-media; picture-in-picture;"
    allowfullscreen="true"
  ></iframe>
</div>
</div>



<h3 id="h-1-what-happens-when-nobody-knows-who-actually-owns-the-sql-server-problem" class="wp-block-heading">1. What happens when nobody knows who actually owns the SQL Server problem?</h3>



<p class="wp-block-paragraph">Any new partner will create some gaps in ownership without great communication. A managed DBA relationship can definitely create friction when who owns what and who does what isn&#8217;t clear.</p>



<p class="wp-block-paragraph">Internal IT, the DBAaaS provider, an outside MSP, application vendors, developers, the cloud provider, storage/network teams, and SaaS application support can all assume someone else is watching. They can all assume they are the ones who should make the change, sometimes unilaterally. Backups, restore testing, storage alerts, Windows patching, SQL patching, vendor escalations, maintenance best practices, performance response, and downtime approval <strong>all need clear owners</strong>.</p>



<p class="wp-block-paragraph">When something breaks, “<em>that’s not us</em>” is a failure mode. So is the quieter version where everyone assumes the managed DBA team is covering something they were never scoped to own (or any of the teams are expected to own something they never should have.)</p>



<p class="wp-block-paragraph"><strong>Healthy version: responsibility, accountability, consultation, and information are explicit.</strong></p>



<h3 id="h-2-what-happens-when-your-remote-dba-provider-never-really-learns-your-environment" class="wp-block-heading">2. What happens when your Remote DBA provider never really learns your environment?</h3>



<p class="wp-block-paragraph">If every ticket feels like starting over&#8230; “Which application is this? Who’s the vendor? Why is it configured this way?” and the basics are never moved past, you don’t have an established DBA relationship. You have consultants with a recurring invoice.</p>



<p class="wp-block-paragraph">Institutional knowledge should accumulate: architecture, business context, which servers are fragile, which vendors require unusual settings, what changes the organization will not tolerate, and the history of prior decisions. </p>



<p class="wp-block-paragraph"><strong>Documentation, a named lead DBA with a regular meeting cadence learning the environment (and then documenting it for the rest of their team), and a team that actually uses ticket history and reads the notes are the difference.</strong><br><br><em>* &#8211; This is an area we&#8217;ve seen a need for improvement over the years. In the early years I pretty much knew it all &#8211; there are IP addresses I still remember for some of our clients who are still clients ten years later &#8211; but we are a bigger team, and standardizing documentation, making sure we track the important details and properly work on hand off is a key part of what Evan is doing as we continually mature operationally.</em></p>



<h3 id="h-3-can-dba-as-a-service-become-too-reactive" class="wp-block-heading">3. Can DBA as a Service become too reactive?</h3>



<p class="wp-block-paragraph">Yes. Admittedly it can happen. The opposite is also scary, and I still think maybe a bit more scary&#8230;</p>



<p class="wp-block-paragraph">A provider can look excellent on response metrics while repeatedly fixing the same underlying condition. Ticket → fix → ticket → fix. The SLA stays green while the real problem never gets addressed. That&#8217;s the &#8220;Security monitor&#8221; thing I always get at when I show my team that old Geico commercial I referenced in an <a href="https://straightpathsql.com/3-times-you-should-not-hire-a-dba-as-a-service-provider/" data-type="post" data-id="5078">earlier post</a>.</p>



<p class="wp-block-paragraph">The useful question is whether the team has both the capacity and the incentive to ask “<strong><em>why does this keep happening?</em></strong>” and then do something about it. Purely reactive managed DBA is just expensive break-fix. We&#8217;ve taken over from some of the break-fix only services.  But as I get at in that post I just linked to, some clients really just want the quick and reactive &#8220;fix&#8221; and not the solution.</p>



<p class="wp-block-paragraph"><strong>Know what you want here and ask the questions to understand if the approach will match what you need.</strong></p>



<h3 id="h-4-what-happens-when-you-buy-too-few-dba-hours" class="wp-block-heading">4. What happens when you buy too few DBA hours?</h3>



<p class="wp-block-paragraph">Undersizing can make for some awkward conversations without good, regular check-ins from your sales rep or Lead DBA (we don&#8217;t have sales reps here, but really &#8211; whoever manages your relationship with the provider. For us, it&#8217;s your lead DBA.)</p>



<p class="wp-block-paragraph">When there isn&#8217;t regular communication and a clear idea of desires, confusion wins. The client becomes reluctant to use the team. The DBA becomes reluctant to spend hours. Proactive work gets deferred. Technical debt survives. Six months later everyone wonders why nothing meaningful improved.</p>



<p class="wp-block-paragraph"><strong>Providers can contribute to this by underselling to win the deal. A correctly sized service is often cheaper than a cheap service that never has room to do the work. When usage genuinely drops, a good provider should tell you to move down a tier.</strong> <strong>A model that doesn&#8217;t fix someone at a level but allows flexing up and down to save on overage helps, also.</strong></p>



<h3 id="h-5-what-happens-when-the-dba-team-gives-good-advice-the-client-cannot-or-will-not-act-on" class="wp-block-heading">5. What happens when the DBA team gives good advice the client cannot (or will not) act on?</h3>



<p class="wp-block-paragraph">The recommendation is sound. The maintenance window never appears. Restore testing has no resources allocated and the budget excuse comes up. The upgrade keeps sliding to the point a client is open to security risks that impact their compliance. The vendor configuration stays broken because of politics, competing priorities, or a vendor that refuses to change.</p>



<p class="wp-block-paragraph">Sometimes the provider failed to translate the recommendation into clear business impact, realistic effort, and a next step that accounts for how your company actually works. Sometimes the client truly cannot or will not act. We find with good communication, a compromise and approach to getting towards compliance can happen. <em>Sometimes impasse wins, and that&#8217;s a situation that is waiting for a big and bad moment and, I think, ought to be discussed. </em></p>



<p class="wp-block-paragraph"><strong>DBA as a Service cannot outsource the client’s ability to make decisions or navigate internal reality, but a provider needs to be willing to have the tough conversations and &#8220;lead&#8221; the client &#8211; accepting that not <em>every hill is a hill to die on. </em>On the sales and onboarding calls be honest and open about your &#8220;can&#8217;t budge&#8221; scenarios, and get a sense for how the provider will or will not work around that.</strong></p>



<h3 id="h-6-what-happens-when-communication-is-bad" class="wp-block-heading">6. What happens when communication is bad?</h3>



<p class="wp-block-paragraph">Technical accuracy is not the same as successful communication. “MAXDOP is wrong” is a simple finding to use here, but insert any other one, phrased without context, and a finding can land as noise. Something the client experiences as urgent can look routine to the DBA. Sales language about “monitoring” can be heard as “a human is watching and will fix everything automatically.” For some shops they mean that for others they literally mean the monitoring, but the humans are watching during certain hours and days.</p>



<p class="wp-block-paragraph">Ticket updates the provider considers sufficient can be invisible to the people who actually need to know. Expectations always fail first in the &#8220;setting&#8221; phase &#8211; then they can fail in the meeting phase. A lot of the times, the situations I get brought into are almost always on the &#8220;failure to set and communicate side.&#8221; Turns out humans are humans and communicating well isn&#8217;t universal (I struggle with it &#8211; there are 2-3 clients over the past 15 years who would tell you all about my failures there.)</p>



<p class="wp-block-paragraph"><strong>Ask your provider how regular updates happen. Is it a &#8220;QBR&#8221; with a sales and account exec? Is it a monthly meeting with the DBA? Who can you call for escalations? Does someone review tickets and coach their team? Do others join our calls?</strong></p>



<h3 id="h-7-what-happens-when-emergency-and-after-hours-expectations-aren-t-clear" class="wp-block-heading">7. What happens when emergency and after-hours expectations aren’t clear?</h3>



<p class="wp-block-paragraph">“24×7,” “on-call,” “monitoring,” “15-minute response,” and “emergency support” can describe very different realities and there are a host of other nuances to add to those.</p>



<p class="wp-block-paragraph">Who notices the problem? Does the client have to initiate? What actually qualifies as P1? Does “response” mean acknowledgment or active troubleshooting? Is remediation included? What happens if the primary person doesn’t answer? What happens after hours?</p>



<p class="wp-block-paragraph"><strong>Ask any provider to walk you through exactly what happens at 2:13 a.m. when production is down. The clarity (or lack of it) is revealing. </strong></p>



<p class="wp-block-paragraph"><em>I&#8217;ll tell you right here &#8211; we don&#8217;t have a 24&#215;7 NOC watching alerts. It&#8217;s worked really well for our 130+ clients who we manage. Many manufacturers with 3 shifts, hospitals, Credit Unions who manage their own online banking with 24/7 up time SLAs, SaaS companies who make their year around Black Friday, and more have seen success with our support model. And we are fine without having that NOC &#8211; I personally believe that a DBA shouldn&#8217;t be the first tier of support. We are very clear about that on the sales calls. We have an on-call rotation with our full-time DBAs &#8211; you call the number and within 15 minutes a DBA is on a call with you.</em></p>



<h3 id="h-8-what-happens-when-the-lead-dba-leaves-or-the-relationship-with-them-breaks" class="wp-block-heading">8. What happens when the lead DBA leaves or the relationship with them breaks?</h3>



<p class="wp-block-paragraph">Even in a team model, most clients form a primary relationship with one person. At Straight Path we believe in &#8220;it takes a village&#8221;, and most of our clients get to know a lot of the folks on our team. But they still have a Lead DBA. We don&#8217;t have a salesperson doing a QBR &#8211; we have a Lead DBA in a monthly meeting (some clients are weekly or bi-monthly during active projects and some just need it for their relationship with all that&#8217;s going on.) When that person leaves the provider, changes roles, or the working relationship stops clicking and a client is better served by a different lead (for communication styles, skill depths or any number of reasons), context and tribal knowledge can disappear.</p>



<p class="wp-block-paragraph">A mature provider should have real documentation, shared history, and enough depth that the loss is painful but not catastrophic. Many do not. The client then experiences the service as starting over with someone who doesn’t know them.</p>



<p class="wp-block-paragraph"><strong>If the value of the relationship lives mostly in one human’s head, you still have key-person risk. Ask how they handle the transitions, what lessons they&#8217;ve learned over the years with it</strong>,</p>



<p class="wp-block-paragraph">* &#8211; <em>We&#8217;ve dealt with this ourselves. We have a really good &#8220;Sabbatical/Major Leave&#8221; transition plan and policy. No one&#8217;s sabbatical can occur until they&#8217;ve done really thorough handoffs and intros are made and our leadership team watches that handoff. It works amazingly well. But we never really thought to apply that same rigor to the &#8220;oh no a DBA is leaving!&#8221; &#8211; that happens so infrequently, our team just stays, but we learned that this year when a DBA left &#8211; a couple clients were not lost, but not handed off as well as they could have been to their amazing new DBA. We&#8217;ve worked on that with internal policies and a lot more review with DBA to DBA transitions, even when we&#8217;re just shuffling clients around for scheduling.</em></p>



<h3 id="h-9-can-a-managed-dba-provider-create-too-much-dependency" class="wp-block-heading">9. Can a managed DBA provider create too much dependency?</h3>



<p class="wp-block-paragraph">An unhealthy version of retention looks like this: “We can’t leave them because nobody else understands anything.” I think inertia should NEVER be a customer retention policy for a provider &#8211; because eventually the cruddy performance or repeat issues will erase their loyalty and there is nothing to keep them. Gatekeeping and knowledge hoarding are, likewise, a terrible retention plan for a DBA as a Service relationship. So is &#8220;the contract has an exit penalty&#8230;&#8221;</p>



<p class="wp-block-paragraph">If leaving would create an operational crisis solely because knowledge, credentials, architecture decisions, and history lived only in the provider’s heads and they always said &#8220;why are you asking that, just let us press those buttons, we got it, ignore us&#8230;&#8221;, then you&#8217;re in for a rude awakening someday&#8230;</p>



<p class="wp-block-paragraph">Healthy relationships document, transfer knowledge, keep access belonging to the client, and make transition possible. Clients should stay because the relationship continues to provide value, not because departure has been made artificially difficult. <br><strong><br>Ask if they mentor your team. Ask if it&#8217;s a sign of success to see a client downgrade a level because their team took on knowledge. Ask if they&#8217;ll tell you when it&#8217;s time to hire someone and how they can help you hire and train them. Listen carefully to the answer and push into any answers that make you question the authenticity. This is your environment, after all. And any managed service provider is here as a guest who should be staying because they are so helpful you can&#8217;t think of any other scenario than them staying &#8211; not because you have a fear of what can break when they leave.</strong></p>



<h3 id="h-how-to-avoid-these-problems-before-you-sign" class="wp-block-heading">How to avoid these problems before you sign</h3>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>Ask the provider…</th><th>What you’re trying to learn</th></tr></thead><tbody><tr><td>Who owns what in the environment? How will you call the ball?</td><td>Whether responsibility gaps are clear</td></tr><tr><td>Who will actually work with us over time?</td><td>Continuity and context </td></tr><tr><td>How do you learn and document our environment?</td><td>Whether knowledge accumulates</td></tr><tr><td>How do you balance proactive vs reactive work?</td><td>Whether you’re buying more than tickets</td></tr><tr><td>What happens if our hours are consistently too low or too high?</td><td>Whether incentives align and they&#8217;ll let you adjust levels</td></tr><tr><td>What do you do when you recommend something we can’t act on?</td><td>Whether they adapt to political and operational reality, see if there are hills they&#8217;ll die on and consider if there&#8217;s a reason they&#8217;d rather lose a relationship than let you have that risk.</td></tr><tr><td>Walk me through a 2 a.m. production outage.</td><td>What emergency coverage actually means, who calls, how it&#8217;s activate, if there&#8217;s a codeword and who has to notice it first</td></tr><tr><td>What happens when the lead DBA leaves or the relationship isn’t working?</td><td>Whether context survives people</td></tr><tr><td>What happens to knowledge, access, and documentation if we leave?</td><td>Whether departure is operationally possible</td></tr><tr><td>How do you follow-up with me? How do I escalate?</td><td>Is there a path to talk to someone when you feel the values aren&#8217;t being lived out? Do they do regular independent surveys and follow-up rigorously on feedback?</td></tr></tbody></table></figure>



<h3 id="h-can-straight-path-have-these-problems" class="wp-block-heading">Can Straight Path have these problems?</h3>



<p class="wp-block-paragraph">Yeah. I&#8217;ve highlighted a couple specific areas above with asterisks, but absolutely we can and have. I could come up with examples for most of these where we&#8217;ve learned somewhere over the past ten years, or are still learning.</p>



<p class="wp-block-paragraph">We’re humans running a service business. We have undersized engagements. We have had communication misses. I&#8217;ve picked the wrong hills to die on and learned. I&#8217;ve been over-protective of team members. We have had relationships where expectations weren’t aligned as cleanly as they should have been. We&#8217;re learning and growing, Clearly Rated has named us as Best In Service for IT Providers for the past two years and we build relationships that really last here, so it&#8217;s not all bad. But, yeah, there are a few I wish I could take back over the past ten years, and a few clients who I would have helped move on much much sooner because they weren&#8217;t a great fit. </p>



<p class="wp-block-paragraph">We have also had the more ordinary failures: moments where we needed to explain something differently, where a lead relationship wasn’t clicking and we were slow to adjust, or where we didn’t surface a constraint early enough.</p>



<p class="wp-block-paragraph"><strong>The interesting question is not whether a provider has ever experienced these failures. I’d be skeptical of anyone who’s been doing this for years and claims otherwise. The better questions are how they notice, how they course-correct, how clients can escalate, what happens when a lead relationship isn’t working,<em> and what they actually learn when something goes wrong or a client leaves.</em></strong></p>



<p class="wp-block-paragraph">That is the conversation worth having.</p>
<p>The post <a href="https://straightpathsql.com/9-ways-managed-dba-services-can-go-wrong/">9 Ways Managed DBA Services can Go Wrong</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></content:encoded>
					
					<wfw:commentRss>https://straightpathsql.com/9-ways-managed-dba-services-can-go-wrong/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>Do You Need a Remote DBA Team or Just SQL Server Consulting Hours?</title>
		<link>https://straightpathsql.com/do-you-need-a-remote-dba-team-or-just-sql-server-consulting-hours/</link>
					<comments>https://straightpathsql.com/do-you-need-a-remote-dba-team-or-just-sql-server-consulting-hours/#respond</comments>
		
		<dc:creator><![CDATA[Mike Walsh]]></dc:creator>
		<pubDate>Thu, 03 Sep 2026 12:00:16 +0000</pubDate>
				<category><![CDATA[DBA as a Service]]></category>
		<category><![CDATA[Buyers Guide]]></category>
		<category><![CDATA[Buying DBA Services]]></category>
		<category><![CDATA[Buying Decision]]></category>
		<category><![CDATA[Hours vs DBA]]></category>
		<guid isPermaLink="false">https://straightpathsql.com/?p=5117</guid>

					<description><![CDATA[<p>Not every company that needs us for SQL Server consulting needs a full Remote DBA team with our managed DBA as a Service offering. Sometimes just buying a bucket of hours makes more sense. If you already have your SQL Server operations in-hand (good monitoring, a team that responds appropriately, after hours support, and you ... <a title="Do You Need a Remote DBA Team or Just SQL Server Consulting Hours?" class="read-more" href="https://straightpathsql.com/do-you-need-a-remote-dba-team-or-just-sql-server-consulting-hours/" aria-label="Read more about Do You Need a Remote DBA Team or Just SQL Server Consulting Hours?">Read more</a></p>
<p>The post <a href="https://straightpathsql.com/do-you-need-a-remote-dba-team-or-just-sql-server-consulting-hours/">Do You Need a Remote DBA Team or Just SQL Server Consulting Hours?</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></description>
										<content:encoded><![CDATA[
<p class="wp-block-paragraph"><em>Not every company that needs us for SQL Server consulting needs a full Remote DBA team with our managed DBA as a Service offering. </em></p>



<p class="wp-block-paragraph"><strong>Sometimes just buying a bucket of hours makes more sense. </strong></p>



<p class="wp-block-paragraph">If you already have your SQL Server operations in-hand (good monitoring, a team that responds appropriately, after hours support, and you aren&#8217;t just relying on a <a href="https://straightpathsql.com/your-dba-isnt-the-problem-depending-on-one-dba-is/" data-type="post" data-id="5062">single DBA</a> who has to bring their laptop and phone on vacation) but you want some advice, tuning help, migration support you just don&#8217;t need an ongoing managed relationship.</p>



<p class="wp-block-paragraph">If part of the problem is you don&#8217;t have someone watching, you don&#8217;t really own the alerts (or keep seeing the same ones over and over) and your coverage disappears when the DBA is on vacation, or out sick (or quits&#8230;) &#8211; then you probably need the Remote DBA offering. </p>



<p class="wp-block-paragraph">One is buying &#8220;work&#8221; &#8211; the other is buying an ongoing relationship and comes with the break glass in case of emergency model already built in.</p>



<p class="wp-block-paragraph"><strong>Short answer up front: Choose the bucket of hours </strong>approach when you have that coverage locked in place, you know you are covered day to day, and don&#8217;t need an SLA on that team&#8217;s response. You want some expertise to mentor, guide, help, or offload some work to a team of experts. C<strong>hoose a Remote DBA team</strong> when you also want that monitoring coverage, a team that knows you and your environment and one that can proactively keep you out of most trouble but quickly respond with a 15-minute SLA when stuff goes bad.</p>



<p class="wp-block-paragraph"><em>This is part of our series of posts about <a href="https://straightpathsql.com/tag/buying-dba-services/">Buying DBA Services</a>. Trying to give a bit of a transparent look behind the scenes at where it makes sense to partner with a remote DBA shop like ours and where it may not.</em></p>



<h2 id="h-what-do-sql-server-consulting-hours-cost" class="wp-block-heading">What Do SQL Server Consulting Hours Cost?</h2>



<p class="wp-block-paragraph">At Straight Path we keep this pretty straight forward. <em>After years of paying for projects and realizing that costs always change when scope creeps (and it always does) or unknown unknowns become known, I made the decision to keep it simple &#8211; we sell a bucket of hours with a pretty simple approach:</em></p>



<ul class="wp-block-list">
<li><a href="https://straightpathsql.com/sql-server-consulting/">You can buy them in 20 or 40 hour increments</a>.</li>



<li>A 20 hour bucket costs $7,000. As of 9/1/26, a 40-hour bucket will cost $12,000</li>



<li>Effective hourly rate of $350/hr or $300/hr.</li>



<li>Hours are good for a full year from the purchase of the bucket.</li>



<li>Hours are billed in 15-minute increments</li>



<li>Our full DBA team is available &#8211; the right skillset for the right problem, and that can change based on the needs of a specific project.</li>



<li><strong>No ongoing monitoring/DBA as a Service infrastructure like daily health checks/alert review/etc.</strong></li>



<li>SLA is typical next-business day (though we try and beat that).</li>
</ul>



<p class="wp-block-paragraph"><strong>The bucket of hours approach shines when the need is pretty clear or at least set within some boundaries:</strong></p>



<ul class="wp-block-list">
<li>SQL Server upgrade/migration planning</li>



<li>Cloud migration projects</li>



<li>Performance troubleshooting</li>



<li>Mentoring your existing DBA team</li>



<li>Reviewing architecture and designs</li>



<li>Assistance with a project</li>



<li>Second opinions on a path forward</li>



<li>Helping your existing DBA team get through a new skillset and learning.</li>



<li><a href="https://straightpathsql.com/tag/cdo-as-a-service/" data-type="post_tag" data-id="583">Azure architecture and CDO services with Buck and team</a>.</li>
</ul>



<p class="wp-block-paragraph">Basically &#8211; buying a bucket of hours is <strong>not</strong> inferior to engaging with DBA as a Service. It&#8217;s the same team, the same skills, the same values. One is just better for certain situations.</p>



<h2 id="h-what-is-a-remote-dba-team" class="wp-block-heading">What is a Remote DBA team?</h2>



<p class="wp-block-paragraph">An ongoing relationship where some team of DBAs becomes <strong><em>your</em></strong> DBA team. They take on defined and structured responsibilities usually. Some will bring a monitoring tool they lease or carefully built. Some will rely on a bunch of SQL agent jobs and custom alerts to let them know when you are in trouble and most have an SLA of some sort on when they&#8217;ll get back with you on an issue. Some have different SLAs and response times based on plans. Some charge per instance and some per hour. </p>



<p class="wp-block-paragraph">At Straight Path we include things like:</p>



<ul class="wp-block-list">
<li>Monitoring with SQL Sentry and our proprietary Skopos DB monitoring tool that looks proactively and reactively at your server (We hate chasing the same problems over and over and simply reporting them. I talked about that in this post about <a href="https://straightpathsql.com/3-times-you-should-not-hire-a-dba-as-a-service-provider/" data-type="post" data-id="5078">clients who are a bad fit.</a>)</li>



<li>Daily health check e-mail that was human reviewed (without touching your hours for that review)</li>



<li>Alert review and triage (again, without touching your hours until we connect and work with you)</li>



<li><a href="https://straightpathsql.com/sql-server-consulting/dba-as-a-service/" data-type="page" data-id="189">An established escalation and on-call process including our 15-minute P1 response</a>.</li>



<li>The relationship is really about the relationship and we lead each client relationship with a Lead DBA, not a sales person.</li>



<li>Actual DBA work against the included hours.</li>
</ul>



<p class="wp-block-paragraph">You can see a lot more about DBA as a Service pricing on our<a href="https://straightpathsql.com/sql-server-consulting/dba-as-a-service/" data-type="page" data-id="189"> DBA as a Services page</a> itself or in this <a href="https://straightpathsql.com/how-much-does-dba-as-a-service-cost-whats-included-what-uses-hours-and-why-we-price-it-this-way/">post about some common pricing questions</a>.</p>



<h2 id="h-what-s-the-difference-between-remote-dba-hours" class="wp-block-heading">What&#8217;s the Difference Between Remote DBA/Hours?</h2>



<figure class="wp-block-table"><table class="has-fixed-layout"><tbody><tr><td><strong>Question</strong></td><td><strong>SQL Server Consulting</strong></td><td><strong>Remote DBA Team</strong></td></tr><tr><td>Access to Senior SQL Server DBAs?</td><td>Yes</td><td>Yes</td></tr><tr><td>Can they do Troubleshooting and Projects?</td><td>Yes</td><td>Yes</td></tr><tr><td>Ongoing Monitoring?</td><td>No</td><td>Yes</td></tr><tr><td>Daily human reviewed health check?</td><td>No</td><td>Yes</td></tr><tr><td>Alert triage/response?</td><td>No</td><td>Yes</td></tr><tr><td>Access to on-call process?</td><td>No</td><td>Yes</td></tr><tr><td>Already familiar with your environment?</td><td>Depends on prior work and scope</td><td>Yes, by design</td></tr><tr><td>Proactive identification of issues?</td><td>Client initiated/based on the scope</td><td>Built-in</td></tr><tr><td>Best for occasional specialist needs?</td><td>Yes</td><td>Often overkill</td></tr><tr><td>Ongoing accountability?</td><td>Primarily on the client</td><td>Yes (monthly check-ins, escalations)</td></tr><tr><td>Best when DBA coverage is a need?</td><td>Usually not</td><td>Yes</td></tr></tbody></table></figure>



<p class="wp-block-paragraph">That table gets to the heart of it for the most part. </p>



<h3 id="h-why-does-a-remote-dba-service-cost-more-than-the-same-number-of-hours" class="wp-block-heading">Why does a Remote DBA service cost more than the same number of hours?</h3>



<p class="wp-block-paragraph">It depends a bit on the bucket and the level of service. Some other recent posts get into the costs of the service and pricing more but we can look at an example.</p>



<p class="wp-block-paragraph">A bucket of 40 hours goes for $12,000. If you buy Micro with an annual commitment, it costs $20,000 ($6,000/quarter when bought quarterly instead of annually). So that&#8217;s 40 hours for $12,000 or $20,000.</p>



<p class="wp-block-paragraph"><em>Why would anyone pay that extra $8,000?</em></p>



<p class="wp-block-paragraph">Arguably, <strong>some companies just shouldn&#8217;t</strong>. If you need the work and not the relationship and DBA team that can flex up and down and respond? Buy the bucket &#8211; a bucket of hours is a bit easier to manage, requires less behind the scenes time that we choose to not bill separately for and we honestly make a bit more margin with the bucket of hours than DBA as a Service to be transparent.</p>



<p class="wp-block-paragraph">The additional cost isn&#8217;t giving you more labor. That additional $667 a month is paying for all of the infrastructure and support built into the DBA as a Service offering. I got into those details a lot more already in the post about the <a href="https://straightpathsql.com/hiring-a-full-time-dba-vs-dba-as-a-service/">value of hiring full-time vs bringing in a remote dba company</a> on Tuesday. One point from that post worth mentioning here is that those costs are fixed and the bigger the plan you are on for DBA as a Service, the more the cost of those are absorbed into the relationship.<br><br>A quarter of Diamond, for instance, lists at $19,000 with 75 hours. 5 hours of overage at Diamond costs $1,250 so the quarter would have cost you $20,250 (though we often will let a client steal a couple or few hours of overage ahead at our Gold and Diamond levels if it&#8217;s unusual usage and the next quarter should be back to normal &#8211; we like to keep the billing as level as we can unless there is a genuine project need or big emergency). Two 40 hour buckets would get you 80 hours and cost you $24,000. Gold costs $14,000 for 45 hours, again a better option if you need that ongoing support. And clients often switch levels up and down based on forecasted need and we don&#8217;t keep people stuck on a contract &#8211; each quarter is earned or a client can leave without paying a big exit fee (I don&#8217;t love paying for the lawyers when we don&#8217;t need to.)</p>



<h3 id="h-what-happens-during-an-emergency-under-each-model" class="wp-block-heading">What happens during an emergency under each model?</h3>



<p class="wp-block-paragraph">With a bucket of hours &#8211; you have access to the consultants. Clients absolutely do engage with us when the server room is on fire and they need help now &#8211; but that&#8217;s a conversation at the sales call and if we have the capacity and availability we&#8217;ll do our best to support you. Our SLA, though, is still next business day response and if we have the capacity to get you back on the rails and you have hours remaining &#8211; we aren&#8217;t there for your next emergency in that same way as a DBA as a Service client has.</p>



<p class="wp-block-paragraph">We can&#8217;t really guarantee emergency coverage or even give the bucket of hours clients access to call our on-call line and get the on-call DBA. Our managed DBA services clients are proactively managed with us. This means we know what your environment looks like. For most clients, we are owning and managing your backup and maintenance, we know it&#8217;s good because our tools tell us when it&#8217;s not. We are able to head off most disasters and we have your info in our systems when you call the on-call number at 2AM and our team on-call that week not only knows you, but knows the playbook you are managed by. We just can&#8217;t be as confident with success when you aren&#8217;t managed by us.</p>



<p class="wp-block-paragraph">With DBA as a Service &#8211; you get the number, during the day, we may even call you and tell you you have an emergency and we are already in the teams call troubleshooting and we send you a link to join. We&#8217;re there for you and we are responding to your alerts and your calls and we&#8217;re with you until resolved.</p>



<h3 id="h-can-you-have-an-internal-dba-team-and-still-use-a-remote-dba-team" class="wp-block-heading">Can you have an internal DBA team and still use a Remote DBA Team?</h3>



<p class="wp-block-paragraph">Absolutely. It happens more often than not. Hybrid patterns can look like:</p>



<ul class="wp-block-list">
<li>Vacation/Illness coverage</li>



<li>Escalation path for a solo DBA</li>



<li>A specialist with depth in areas the current DBA doesn&#8217;t yet possess</li>



<li>Project help</li>



<li>Coverage of alerts and after hours -so your DBA team can get a break on the alerts and after-hours</li>



<li>A second set of eyes for a solo DBA</li>



<li>A group of senior DBAs who teach the classes, speak at the conferences, etc for your existing DBA team</li>



<li>Reducing the risk imposed by a single DBA who is the only one with all the details</li>
</ul>



<p class="wp-block-paragraph">More than a handful of our clients or more have existing DBA teams and it&#8217;s a great relationship. They learn and grow, we partner and aren&#8217;t there to replace them &#8211; in fact the way i describe our core value of humility to our team is <strong>&#8220;<em>Let their team take the credit, we just want the bill paid</em>&#8230;&#8221; </strong>Obviously, that&#8217;s partially joking &#8211; we pride ourselves on longstanding relationship with clients. That&#8217;s why our team has grown from just me steadily to 22 on the team. Clients tend to stay for a long time and we do pretty well on our annual <a href="https://www.clearlyrated.com/it-services/nh-usa/sanbornville-nh/straight-path-it-solutions-llc-sanbornville-nh">NPS surveys that Clearly Rated</a> runs for us. We&#8217;re in it for the success of their DBAs &#8211; because we&#8217;ve all been the full time DBA when the consultants were brought in &#8211; we get it.</p>



<h3 id="h-can-you-start-with-remote-dba-and-move-to-just-hours-or-vice-versa" class="wp-block-heading">Can you start with Remote DBA and move to just hours or vice versa?</h3>



<p class="wp-block-paragraph">Of course. Clients will sometimes move on that journey for various reasons.</p>



<p class="wp-block-paragraph">A common one is we wind up identifying with our client that there is just an increasing amount of work and they&#8217;d be better served by having a DBA team and we can help them find a team, interview them and work to reduce our hours and increase their knowledge and maybe move to a backstop bucket of hours for that training, mentoring, and pinch coverage (we can&#8217;t do the ongoing DBA support after hours without monitoring &#8211; but we have made exceptions when a company was slowly transitioning to covering on their own..)</p>



<p class="wp-block-paragraph">Quite often a client who buys a bucket of hours realizes that the findings we keep coming up with are real and they see the cobwebs that they just didn&#8217;t know existed until they told us to start looking. And it becomes apparent that they&#8217;ve gotten to where they are by one part luck and one part brute force and they want to start doing things right and want a DBA team supporting them without the cost of hiring two DBAs to really cover them and they move over to becoming a DBA as a Service client and we will roll their hours in and make sure they don&#8217;t lose them.</p>



<p class="wp-block-paragraph">We purposefully don&#8217;t lock folks into anything here. The bucket expires after a year or when the hours are used. The DBA as a Service is an agreement that renews every quarter if we&#8217;ve earned it and someone can leave with a month notice.</p>



<p class="wp-block-paragraph"><strong>How should you decide?</strong></p>



<figure class="wp-block-table"><table class="has-fixed-layout"><tbody><tr><td><strong>If this sounds like you&#8230;</strong></td><td><strong>I&#8217;d start off considering&#8230;</strong></td></tr><tr><td>“We know what needs doing; we occasionally need expert help doing it.”</td><td>Consulting hours</td></tr><tr><td>“We need help with a defined SQL Server project.”</td><td>Consulting hours</td></tr><tr><td>“Our internal DBA occasionally needs specialist backup.”</td><td>Consulting hours or hybrid</td></tr><tr><td>“Nobody is consistently watching SQL Server.”</td><td>Remote DBA</td></tr><tr><td>“We have monitoring but nobody really owns the alerts.”</td><td>Remote DBA</td></tr><tr><td>“Our one DBA is excellent, but everything depends on that person.”</td><td>Remote DBA / hybrid</td></tr><tr><td>“We want someone who knows the environment before an emergency.”</td><td>Remote DBA</td></tr><tr><td>“We have enough ongoing DBA work for a full-time person.”</td><td>Consider hiring a DBA and using us as a hybrid backstop for them to not be alone</td></tr><tr><td>“We’re not sure what condition the environment is in.”</td><td><a href="https://straightpathsql.com/sql-server-health-check/" data-type="page" data-id="3941">Start with a Health Check</a> (but be aware &#8211; that just reports the findings and gives you a plan &#8211; but it depends on you fixing the findings unless you buy a bucket. If you are buying the bucket anyway we can do the health check inside of the bucket and save that extra spend.)</td></tr></tbody></table></figure>



<p class="wp-block-paragraph">The goal isn&#8217;t to solve for the lowest &#8220;effective hourly rate&#8221; &#8211; there&#8217;s not that much difference at the end of the year. It&#8217;s to find out what problem you are trying to solve with outside help whether it&#8217;s Straight Path or another group.</p>



<p class="wp-block-paragraph"><strong>At the end of the day&#8230; </strong>If you need occasional SQL Server expertise and don&#8217;t need that up-time chasing DBA team &#8211; maybe you need to buy a bucket of hours. If you want that team watching and supporting, it&#8217;s probably DBA as a Service. <br><br>And if you picked the &#8220;wrong&#8221; choice &#8211; have no fear with Straight Path at least, we&#8217;re a small company, I&#8217;m still the sales guy and &#8220;final arbiter&#8221; of sales-y and relationship decisions (though Evan and the team all agree on the values, it&#8217;s why the team keeps taking their 5-year sabbaticals and why some are nearing their second sabbatical already..) if we picked wrong, we&#8217;ll figure out the math on moving to the model you actually need. It&#8217;s just a lot easier to go into it knowing what you need up front.<br><br><a href="https://straightpathsql.com/contact/" data-type="page" data-id="97">Reach out</a> and I&#8217;m happy to jump into a chat with you about your needs. I&#8217;ll not only tell you which of our options are best for you, I&#8217;ll tell you when we&#8217;re the wrong fit for you and when you just need to hire a team instead of going with consulting. <a href="https://straightpathsql.com/hiring-a-full-time-dba-vs-dba-as-a-service/" data-type="post" data-id="5102">Here&#8217;s some math to help on that decision even.</a></p>



<p class="wp-block-paragraph"></p>
<p>The post <a href="https://straightpathsql.com/do-you-need-a-remote-dba-team-or-just-sql-server-consulting-hours/">Do You Need a Remote DBA Team or Just SQL Server Consulting Hours?</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></content:encoded>
					
					<wfw:commentRss>https://straightpathsql.com/do-you-need-a-remote-dba-team-or-just-sql-server-consulting-hours/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>Hiring a Full-Time DBA vs DBA as a Service</title>
		<link>https://straightpathsql.com/hiring-a-full-time-dba-vs-dba-as-a-service/</link>
					<comments>https://straightpathsql.com/hiring-a-full-time-dba-vs-dba-as-a-service/#respond</comments>
		
		<dc:creator><![CDATA[Mike Walsh]]></dc:creator>
		<pubDate>Mon, 31 Aug 2026 19:51:54 +0000</pubDate>
				<category><![CDATA[Database Administration]]></category>
		<category><![CDATA[Buying DBA Services]]></category>
		<category><![CDATA[DBA as a Service]]></category>
		<category><![CDATA[Remote DBA]]></category>
		<guid isPermaLink="false">https://straightpathsql.com/?p=5102</guid>

					<description><![CDATA[<p>I could build you a calculator right now that proves we are always the cheaper choice... Here is how I would do it. I would go find the highest DBA salary survey I could get my hands on, one of the ones that samples a couple dozen people in expensive metros and reports it as ... <a title="Hiring a Full-Time DBA vs DBA as a Service" class="read-more" href="https://straightpathsql.com/hiring-a-full-time-dba-vs-dba-as-a-service/" aria-label="Read more about Hiring a Full-Time DBA vs DBA as a Service">Read more</a></p>
<p>The post <a href="https://straightpathsql.com/hiring-a-full-time-dba-vs-dba-as-a-service/">Hiring a Full-Time DBA vs DBA as a Service</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></description>
										<content:encoded><![CDATA[
<p class="wp-block-paragraph" id="h-i-could-build-you-a-calculator-right-now-that-proves-we-are-always-the-cheaper-choice"><strong><em>I could build you a calculator right now that proves we are always the cheaper choice.</em>..</strong></p>



<p class="wp-block-paragraph">Here is how I would do it. I would go find the highest DBA salary survey I could get my hands on, one of the ones that samples a couple dozen people in expensive metros and reports it as a national average, or take the 99th percentile salaries over on Brent&#8217;s salary survey. I would take that number and apply a &#8220;true cost of an employee&#8221; multiplier of 1.8 or 2.0. Then I would add health insurance and payroll taxes and retirement on top of that multiplier, even though the multiplier already had all of them in it. I would assume you replace the person every couple or few years and carry the full replacement cost as an annual line with recruiting costs thrown in. I would sprinkle in a downtime statistic from a survey of Fortune 500 companies and apply it to your environment universally. And I would land somewhere definitely north of $250,000 a year for one DBA, put our price next to it, and let the calculator do the rest.</p>



<p class="wp-block-paragraph"><strong>That math exists. You can find it in about four minutes. Some of it is on hiring vs using a service calculators and webpages out there right now.</strong></p>



<p class="wp-block-paragraph">I&#8217;m not going to play that game here, though&#8230; Our first value is Trust360 and everything else we do sits on top of it. If I fudge the one number on this page that you can actually go check, why would you believe anything else I tell you about backups or corruption or whether your availability group is configured correctly?</p>



<p class="wp-block-paragraph">So here is the honest version, and I will tell you how it ends right now, up front, before you scroll.</p>



<p class="wp-block-paragraph"><strong>On a per-hour basis, hiring a DBA beats us. Every tier we sell. For most salary ranges. It&#8217;s not really close on that hourly basis, and it&#8217;s even further on our smallest plan, the Micro plan.</strong></p>



<p class="wp-block-paragraph"><em>Which leaves the actually interesting question, which is why anybody hires us at all</em>. Stick around for that part, because the answer is real and it is not &#8220;but you get 24/7 coverage!&#8221; This is part of our series of posts about <a href="https://straightpathsql.com/tag/buying-dba-services/">Buying DBA Services</a>. Trying to give a bit of a transparent look behind the scenes at where it makes sense to partner with a remote DBA shop like ours and where it may not.</p>



<div class="wrapper-video">
<div style="position: relative; padding-top: 56.25%;">
  <iframe
    src="https://customer-zfb3lxtijbv9qz8k.cloudflarestream.com/62c84dd65310b25f92fba109424612dc/iframe?poster=https%3A%2F%2Fcustomer-zfb3lxtijbv9qz8k.cloudflarestream.com%2F62c84dd65310b25f92fba109424612dc%2Fthumbnails%2Fthumbnail.jpg%3Ftime%3D%26height%3D600"
    loading="lazy"
    style="border: none; position: absolute; top: 0; left: 0; height: 100%; width: 100%;"
    allow="accelerometer; gyroscope; autoplay; encrypted-media; picture-in-picture;"
    allowfullscreen="true"
  ></iframe>
</div>
</div>



<h2 id="h-what-assumptions-are-we-using" class="wp-block-heading">What assumptions are we using?</h2>



<p class="wp-block-paragraph">I am putting these first, before the numbers, because every single one of them is a dial. Turn any of these and you get a different answer, and anybody who buries their assumptions at the bottom (or leaves them out entirely) is hoping you will not notice which dial they turned.</p>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>Assumption</th><th>What we used</th><th>Where it comes from</th></tr></thead><tbody><tr><td>Mid-level DBA base salary</td><td>$110,000</td><td>BLS puts the median for database administrators at $104,620. Robert Half&#8217;s 2026 guide projects $95,500 to $137,500. ZipRecruiter&#8217;s 2026 average is $119,317 with the middle half between $108,500 and $131,500. The Brent Ozar salary survey has some really great details also. And it may make this number a bit higher depending on what you mean by mid-level.</td></tr><tr><td>Senior DBA base salary</td><td>$160,000</td><td> A 20-year SQL Server specialist is not a $110,000 hire, and if you think they are, you probably haven&#8217;t tried to hire one lately. $160k gets us to around the 70th percentile of the 15+ year DBAs in Brent Ozar&#8217;s 2026 salary survey. And I think $160k is doing a disservice to the top-notch, most experienced folks, but that&#8217;s fine. I don&#8217;t want to inflate things here.</td></tr><tr><td>Employer share of health insurance</td><td>$20,143</td><td>KFF 2025 Employer Health Benefits Survey, family coverage. Use about $7,885 if you are modeling single coverage</td></tr><tr><td>FICA (Social Security and Medicare &#8211; The employer part)</td><td>7.65%</td><td>Applies to the full salary at both levels</td></tr><tr><td>401k match</td><td>3%</td><td>We&#8217;re at 3.5% &#8211; some are up to 4-5% went conservative here.</td></tr><tr><td>Workers comp, FUTA, SUTA</td><td>About 2% of wages</td><td>Varies a lot by state and it actually has a cap so the 2% may be high &#8211; but every state (as I&#8217;ve learned) is dramatically different</td></tr><tr><td>Equipment, software, training </td><td>$3,000 to $5,000</td><td>Add in conferences and it can go high, and after hiring Richie Rump and looking at what AI has done to the price of memory, this is definitely a bit low&#8230;</td></tr><tr><td>Recruiting</td><td>Two versions shown</td><td>Either in-house cost per hire, or an agency at 22% of first year salary, amortized over a 4 year tenure (I do think DBAs tend to jump around &#8211; but in a bumpy economy they jump a bit less..)</td></tr><tr><td>Tenure</td><td>4 years</td><td>Some folks build in 2-3 years, I went with 4. I see DBAs with all sorts of tenure out there. Seems like the great ones might jump around a bit more in a good economy, though. I did &#8211; but maybe I was always a consultant..</td></tr><tr><td>Non-DBA time</td><td>25% to 35%</td><td>How much &#8220;on the clock&#8221; time isn&#8217;t actually spent DBAing..</td></tr></tbody></table></figure>



<p class="wp-block-paragraph">We did not apply a total compensation multiplier and then add benefits again on top of it. That multiplier already contains health insurance, payroll taxes, retirement, and paid leave. Doing both counts the same dollars twice and it is worth about $30,000 &#8211; $40,000 of fake cost.</p>



<p class="wp-block-paragraph">And we did not put a downtime statistic anywhere in this article. You can find all sorts of surveys saying an hour of downtime costs high six-figures, and those surveys sample big enterprises. Using them to scare a mid-market company running four SQL Servers is a good way to make things seem more expensive. </p>



<p class="wp-block-paragraph">And for real &#8211; check out the <a href="https://www.brentozar.com/archive/2026/01/announcing-the-2026-data-professional-salary-survey-results-and-theyre-great/">Salary Survey Brent Ozar does every year.</a> The data is rich &#8211; and there are some outliers perhaps and its anonymous human submitted and he doesn&#8217;t edit or massage it so the numbers are raw &#8211; I think we could have made this be $125k for the mid level non Jr. DBA and maybe even $165/170k for the Senior DBA &#8211; more for superstars. But the numbers work fine either way. </p>



<h2 id="h-what-does-a-full-time-sql-server-dba-actually-cost" class="wp-block-heading">What does a full-time SQL Server DBA actually cost?</h2>



<p class="wp-block-paragraph">Somewhere between about $149,000 and $214,000 a year fully loaded, depending on whether you are hiring a solid mid-level person or a genuine senior specialist. That works out to a multiplier of roughly 1.3 to 1.4 times base salary, not the 1.8 or 2.0 you will see quoted.</p>



<h3 id="h-a-mid-level-dba-at-110-000-base" class="wp-block-heading">A mid-level DBA at $110,000 base</h3>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>Component</th><th>Annual</th></tr></thead><tbody><tr><td>Base salary</td><td>$110,000</td></tr><tr><td>FICA at 7.65%</td><td>$8,415</td></tr><tr><td>Health insurance, employer share, family</td><td>$20,143</td></tr><tr><td>401k match at 3%</td><td>$3,300</td></tr><tr><td>Workers comp, FUTA, SUTA</td><td>$2,200</td></tr><tr><td>Equipment, software, training</td><td>$4,000</td></tr><tr><td>Recruiting, amortized over 4 years</td><td>$1,200 to $6,100</td></tr><tr><td><strong>Fully loaded</strong></td><td><strong>About $149,000 to $154,000</strong></td></tr></tbody></table></figure>



<h3 id="h-a-senior-dba-at-160-000-base" class="wp-block-heading">A senior DBA at $160,000 base</h3>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>Component</th><th>Annual</th></tr></thead><tbody><tr><td>Base salary</td><td>$160,000</td></tr><tr><td>FICA at 7.65%</td><td>$12,240</td></tr><tr><td>Health insurance, employer share, family</td><td>$20,143</td></tr><tr><td>401k match at 3%</td><td>$4,800</td></tr><tr><td>Workers comp, FUTA, SUTA</td><td>$3,200</td></tr><tr><td>Equipment, software, training</td><td>$5,000</td></tr><tr><td>Recruiting, agency at 22%, amortized over 4 years</td><td>$8,850</td></tr><tr><td><strong>Fully loaded</strong></td><td><strong>About $214,233</strong></td></tr></tbody></table></figure>



<p class="wp-block-paragraph">Salary is the big number and it stays the big number. The benefits and taxes and recruiting are real and they matter, <em>but they do not double your cost.</em></p>



<h2 id="h-how-many-hours-of-actual-dba-work-do-you-get" class="wp-block-heading">How many hours of actual DBA work do you get?</h2>



<p class="wp-block-paragraph">This is where the interesting part is, and it is the number nobody wants to talk about.</p>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th></th><th>Hours</th></tr></thead><tbody><tr><td>52 weeks at 40 hours</td><td>2,080</td></tr><tr><td>Less 15 vacation days</td><td>-120</td></tr><tr><td>Less 4 sick days</td><td>-32</td></tr><tr><td>Less 11 holidays</td><td>-88</td></tr><tr><td><strong>Hours they are actually at work</strong></td><td><strong>1,840</strong></td></tr></tbody></table></figure>



<p class="wp-block-paragraph">Now take out the part of the week that is not database work. Standups, status meetings, the security questionnaire somebody needs filled out, the ticket that turned out to be a network problem, helping with the thing that is not their job but nobody else can do it either, the interview loop for the other open req, annual training, and the twenty minutes every morning that go somewhere nobody can account for.</p>



<p class="wp-block-paragraph">I&#8217;ve been the full-time DBA in the office. And I lived it.. The time goes fast &#8211; hallway meetings, getting sucked into a debate, idle chat. I&#8217;m also not adding the &#8220;extra hours&#8221; that many of us DBA types work. The math is rough here &#8211; but I&#8217;m going somewhere rather generic here.</p>



<p class="wp-block-paragraph">At 25% non-DBA time you get about <strong>1,380 hours</strong> of actual database work in a year. At 35% you get about <strong>1,200</strong>. If you think those numbers are too generous or too harsh for your shop, move them, that is fine, the point is that you are not buying 2,080.</p>



<h3 id="h-so-what-does-an-hour-of-real-dba-work-cost-you" class="wp-block-heading">So what does an hour of real DBA work cost you?</h3>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th></th><th>At 1,380 hours</th><th>At 1,200 hours</th></tr></thead><tbody><tr><td>Mid-level DBA, $149,000 loaded</td><td><strong>$108/hr</strong></td><td><strong>$124/hr</strong></td></tr><tr><td>Senior DBA, $214,233 loaded</td><td><strong>$155/hr</strong></td><td><strong>$178/hr</strong></td></tr></tbody></table></figure>



<h2 id="h-what-does-dba-as-a-service-cost-per-hour" class="wp-block-heading">What does DBA as a Service cost per hour?</h2>



<p class="wp-block-paragraph">Our pricing is on the website and has been since we started. Transparency saves everyone time.</p>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>Our plan</th><th>Annual at list</th><th>Quarterly Hours * 4</th><th>Effective cost per hour</th></tr></thead><tbody><tr><td>Micro</td><td>$24,000</td><td>40</td><td><strong>$600</strong></td></tr><tr><td>Silver</td><td>$40,000</td><td>100</td><td><strong>$400</strong></td></tr><tr><td>Gold</td><td>$56,000</td><td>180</td><td><strong>$311</strong></td></tr><tr><td>Diamond</td><td>$76,000</td><td>300</td><td><strong>$253</strong></td></tr><tr><td>20 hour bucket</td><td>$7,000</td><td>20</td><td><strong>$350</strong></td></tr></tbody></table></figure>



<h2 id="h-is-it-cheaper-to-hire-a-dba-or-use-a-managed-service" class="wp-block-heading">Is it cheaper to hire a DBA or use a managed service?</h2>



<p class="wp-block-paragraph"><strong>Per hour, hiring wins, and it is not really that close of a call.</strong></p>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>Option</th><th>Cost per hour of DBA work</th></tr></thead><tbody><tr><td>Mid-level employee</td><td>$108 to $124</td></tr><tr><td>Senior employee</td><td>$155 to $178</td></tr><tr><td>Us on Diamond</td><td>$253</td></tr><tr><td>Us on Gold</td><td>$311</td></tr><tr><td>Us on Silver</td><td>$400</td></tr><tr><td>Us on Micro</td><td>$600</td></tr></tbody></table></figure>



<p class="wp-block-paragraph">There it is. We are two to four times more expensive per hour for our most expensive hourly (and lowest priced per quarter) plan, <strong><em>and I do not have a clever way to make that table say something else, so I am not going to try.</em></strong></p>



<p class="wp-block-paragraph">If you want to stop reading here and go post a job req, I understand, and honestly for some of you that is the right move and we&#8217;ll talk more about that in a bit and I already posted a couple weeks ago about <a href="https://straightpathsql.com/3-times-you-should-not-hire-a-dba-as-a-service-provider/">clients where we aren&#8217;t the best fit.</a></p>



<h2 id="h-why-does-micro-cost-more-per-hour-than-diamond" class="wp-block-heading">Why does Micro cost more per hour than Diamond?</h2>



<p class="wp-block-paragraph">I&#8217;ve been posting a lot about the &#8220;business of business&#8221; and I posted last week a bit about how our levels work so I won&#8217;t go to deep here, but I&#8217;m sure you may be like &#8220;<em>uhh why is the Micro, lowest priced quarterly plan the most expensive?!?</em>&#8221; <strong>Because there is a floor under every engagement we take, and the floor costs us about the same whether you buy 10 hours a quarter or 75.</strong></p>



<p class="wp-block-paragraph">Here is everything that runs on your environment regardless of which plan you are on, and whether it eats your hours:</p>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>What runs no matter which plan you buy</th><th>Does it consume your hours?</th></tr></thead><tbody><tr><td>Skopos, our monitoring platform, deployed and hosted and maintained</td><td>No (though building in filters and tweaking alerts for requests does consume hours)</td></tr><tr><td>One SQL Sentry license included</td><td>No</td></tr><tr><td>A daily health check produced and reviewed by a human on our support team, every business day</td><td>No &#8211; we don&#8217;t bill for the review of that report &#8211; the creation of the tickets from it and the priority escalation. Our billing starts when we start actually connecting and working with you.</td></tr><tr><td>Alert triage and review, Monday through Friday, 8 to 5 Eastern</td><td>No &#8211; reviewing alerts, jumping to the P1s and creating tickets &#8211; like the health checks daily &#8211; isn&#8217;t billed.</td></tr><tr><td>The on-call rotation, including what we pay the DBA who takes the week and the answering service and all of that.</td><td>No (though we do charge a fee per access, waived for Gold and Diamond clients for 1 or 2 calls per year &#8211; and we really work our tails off to be proactive and not get calls &#8211; but I still have to pay one of our DBAs to be on-call just in case &#8211; and we have backups and a whole process for that.)</td></tr><tr><td>The plumbing behind a 15 minute P1 response, the answering service, the escalation chain, the backup escalation</td><td>No</td></tr><tr><td>Your named lead DBA and internal accountability and internal management and internal leadership review on accounts.</td><td>No (though the DBA is billing when they are working or talking with you, naturally)</td></tr><tr><td>Actual work on your servers</td><td>Yes, billed in 15 minute increments</td></tr></tbody></table></figure>



<p class="wp-block-paragraph">Spread that base cost &#8211; especially the tooling and monitoring and reviews across 40 hours a year and it is brutal. Spread it across 300 and it nearly disappears. Micro&#8217;s $600 an hour is not us charging a premium for expertise at the low end, it is a small number of hours carrying a fixed cost that does not shrink. We don&#8217;t sell monitoring only &#8211; If we did, we&#8217;d some of that fixed price would move out of the plans and the effective hourly number would look quite a bit lower.</p>



<p class="wp-block-paragraph">Which leads to a recommendation that costs us money: <strong>if you are evaluating Micro on an hourly basis, you are evaluating it wrong.</strong> Micro exists to buy you monitoring, daily eyes, and a phone number that a full senior heavy team of US based FTE DBAs answers, with a small allotment of hours attached. If what you actually want is hours, and not monitoring, buy a bucket instead. It is $350 an hour and it comes with none of that other stuff,<strong> and we will tell you that on the call, because we would rather sell you the right thing</strong>.</p>



<h2 id="h-so-why-on-earth-would-you-hire-us" class="wp-block-heading">So why on earth would you hire us?</h2>



<p class="wp-block-paragraph">Because the per-hour number is the wrong question for most of the companies reading this. </p>



<p class="wp-block-paragraph"><strong>Per hour, we lose. Per year, when a company doesn&#8217;t have sustained heavy DBA needs, we start to really win.</strong></p>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th></th><th>Annual cost</th></tr></thead><tbody><tr><td>Mid-level DBA, fully loaded</td><td>$149,000</td></tr><tr><td>Senior DBA, fully loaded</td><td>$214,000</td></tr><tr><td>Us, Gold (180 hours, plus monitoring and on-call)</td><td>$56,000</td></tr><tr><td>Us, Silver (100 hours, plus monitoring and on-call)</td><td>$40,000</td></tr></tbody></table></figure>



<p class="wp-block-paragraph">The employee is more efficient per hour. <strong>They are also a fixed cost, and you buy all 1,180 hours whether you need them or not</strong>. In fact, when I left the managed services company I was working for trying to build a SQL Server practice with them &#8211; I realized we just weren&#8217;t going to do it. Most IT MSPs have a harder time justifying a full-time SQL Server DBA services practice. The rates are higher, the size of the team to really support is a bit high and the sales teams aren&#8217;t used to selling it. I saw the writing on the wall that we just weren&#8217;t growing so I talked to the partners who take a chance on bringing me in. I did the math. I said you don&#8217;t use me for a lot of billable hours. So I&#8217;m teaching, blogging, marketing, hanging out, and just kind of being around a lot of the time &#8211; which means when I do work &#8211; my hourly cost is way higher than the math here shows &#8211; and my salary was on the lower end. I was ready to be foolish enough and go off on my own and I made a plan where I would leave &#8211; they&#8217;d make a REALLY good deal on me per hour &#8211; and I had one really low rate if I was training or just doing biz dev with them &#8211; one higher (but still absurdly low) rate if I was billing. They&#8217;d be my anchor client &#8211; and get first dibs on my time and for that we&#8217;d have a 3, 6 and 9 month guarantee of my availability and their billing.  They needed DBA as a Service &#8211; I just didn&#8217;t know it would be a thing then &#8211; and I gave it to them (as a solo person &#8211; which means coverage and support is tough when I got busier and had to juggle clients &#8211; it&#8217;s good to have a team now.)</p>



<h3 id="h-where-is-the-actual-crossover" class="wp-block-heading">Where is the actual crossover?</h3>



<p class="wp-block-paragraph">This is the number I would want if I were you, so here it is.</p>



<p class="wp-block-paragraph">Start with Gold or Diamond and add overage as you go. Depending on the level of resource and the salary range and your details &#8211; somewhere between 400-800 hours a year is where things start to cross over to &#8220;we&#8217;re definitely more expensive&#8221;</p>



<p class="wp-block-paragraph">Translate that to a week and <strong>if you consistently need more than about 10  to 15 hours a week of real, hands-on database work, hiring somebody starts to outright win on cost if that&#8217;s the only metric you care about.</strong></p>



<p class="wp-block-paragraph">Note the word &#8220;real.&#8221; Not 15 hours of somebody being available. Fifteen hours of actual database work. Many of the companies I talk to who are convinced they need a full-time DBA are looking at a backlog, not a regular workload, and those are different things. Clear the backlog in year one or a half a year and then ask yourself what year two looks like.</p>



<h3 id="h-the-four-other-reasons-which-are-not-about-cost" class="wp-block-heading">The four other reasons, which are not about cost</h3>



<p class="wp-block-paragraph"><strong>You are buying one person&#8217;s skill set when you hire.</strong> Nobody is simultaneously an availability groups expert, a replication expert, a query plan person, an Azure architect, and a security specialist. They are strong at two or three of those and learning the rest on your time.</p>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>The thing you need twice a year</th><th>One person</th><th>A team</th></tr></thead><tbody><tr><td>An AG design reviewed before you commit</td><td>Whoever you hired, probably learning unless that was their strength</td><td>Somebody who has done dozens &#8211; and we&#8217;ve seen them all fail in really unique ways. (Cue the farmers insurance jingle &#8211; we know a thing or two&#8230; because we&#8217;ve seen a thing or two.)</td></tr><tr><td>Replication upgraded without reinitializing eight subscribers</td><td>Blog posts at 11pm and some AI suggesting DMVs that may or may not exist</td><td>Someone who supports all kinds and contracts with a guru whose specialty it is</td></tr><tr><td>A query plan that makes no sense</td><td>Depends entirely who you hired</td><td>The person who used to teach the tuning course to MCM candidates or who is well known among our team as the queen of query performance &#8211; plus a strong set of others who are just as good as Andy and Tara at much of this.</td></tr><tr><td>An Azure architecture and cost review</td><td>Probably not their background</td><td>A former Microsoft data platform guy who was on the team to help launch Azure in our CDO and Azure Architect, Buck. (And we cross train &#8211; all learning from the firehose of knowledge that he is.)</td></tr></tbody></table></figure>



<p class="wp-block-paragraph"><strong>They go on vacation, and then they leave.</strong> One DBA is capacity, not coverage. <a href="https://straightpathsql.com/your-dba-isnt-the-problem-depending-on-one-dba-is/" data-type="post" data-id="5062">We wrote a whole thing about the perils of being a solo DBA</a> and I will not repeat it here, but the short version is that <strong><em>one is none, two is one</em></strong>.</p>



<p class="wp-block-paragraph"><strong>When things go badly wrong, we flex, and we try not to profit from your bad week.</strong> Here is our actual policy &#8211; a client can leave us with 30 days&#8217; notice (no cell-phone contracts &#8211; why would I want to keep a bad fit client hostage to a contract) and each quarter we evaluate and pick the level that&#8217;s right for the hours needed for a client. If someone needs more hours in a quarter once it&#8217;s picked they use overage.</p>



<p class="wp-block-paragraph"><strong>In reality, though we like to be flexible and lean into our Generosity value</strong>. When it&#8217;s just a bit of overage, it makes sense to just make everyone&#8217;s life easier and not make the AP folks at our clients hate us and confuse them with &#8220;mid-quarter upgrades&#8221; &#8211; but we also care way more about long-term relationships. Our clients simply stay with us &#8211; for a really really long time &#8211; like our team &#8211; we will often work with a client and maybe upgrade next quarter to the higher level and let them steal hours ahead or, if the need arises soon enough, look the other way and let someone upgrade the current quarter. Saving overage for the smaller one offs.</p>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>Situation</th><th>What we do</th></tr></thead><tbody><tr><td>You need more hours in a quarter than your plan includes</td><td>We sell overage at your plan&#8217;s rate</td></tr><tr><td>It is a real emergency and the overage is going to be ugly</td><td>We will often do a courtesy mid-quarter upgrade or upgrade the next quarter and let someone &#8220;steal from the future&#8221; instead, because that costs you less than the overage would</td></tr><tr><td>Why we do that</td><td>Because we do not want an incentive that pays us more the worse your month goes.</td></tr></tbody></table></figure>



<p class="wp-block-paragraph">You will pay more in a quarter where your environment tried to fall over. You are paying for the hours that saved it. And in most years, added up, our clients running anywhere from one instance to scores of them have spent less than a hire would have cost, without giving up a phone number at 2am. So our base is a lot less than the full-time if the hours each week aren&#8217;t high &#8211; and in a &#8220;oh no&#8221; flex situation &#8211; you may have a more expensive month, but you still work out better by the year.</p>



<p class="wp-block-paragraph"><strong>Sometimes the answer is both, and this is the option most articles skip.</strong> Keep your DBA. Put a team behind them.</p>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>Need</th><th>Your DBA alone</th><th>Your DBA plus us</th></tr></thead><tbody><tr><td>Vacation coverage</td><td>None/Training backups and documentation</td><td>Covered</td></tr><tr><td>Escalation when they are stuck</td><td>Google, or a forum post, Ask your nearest LLM</td><td>Named senior DBAs who have probably seen it &#8211; and our monitoring has probably already identified the P1 and we&#8217;re probably already starting up the P1 meeting.</td></tr><tr><td>Specialty depth</td><td>Whatever they happen to know</td><td>The team&#8217;s knowledge</td></tr><tr><td>What it does for them</td><td>Isolation, and eventually burnout if its busy enough</td><td>Peer relationships with MVPs, authors, community tools folks, mentors and 25 year specialists, and somebody to check their work and teach them</td></tr><tr><td>If they resign</td><td>Your environment walks out with them</td><td>Continuity</td></tr><tr><td>Cost</td><td>Their fully loaded salary</td><td>Their salary, plus the right plan for your needs</td></tr></tbody></table></figure>



<p class="wp-block-paragraph">That last row is worth sitting with. A capable mid level or Junior in-house DBA plus a Silver plan runs about $150,000 &#8211; $180,000 all in. Hiring a second DBA for coverage runs whatever the loaded cost for the level you need is. And your existing person gets a peer group in their corner.</p>



<h2 id="h-when-should-you-hire-a-full-time-dba-instead-of-outsourcing" class="wp-block-heading">When should you hire a full-time DBA instead of outsourcing?</h2>



<p class="wp-block-paragraph">Hire when most of these are true:</p>



<ul class="wp-block-list">
<li>You genuinely have 15 or more hours a week of hands-on database work, sustained, not a one-time backlog</li>



<li>A real chunk of that work is development, ETL, or data engineering, which we are frankly too expensive to do 40 hours a week with a managed DBA services company</li>



<li>You want somebody in your daily standups, in every change control meeting and IT team meeting, and/or in the building</li>



<li>Deep knowledge of your specific application matters more to you than breadth across database specialties</li>



<li>You can hire well, and you have a plan to keep that person interested after the backlog is gone</li>
</ul>



<p class="wp-block-paragraph">Be careful about hiring when:</p>



<ul class="wp-block-list">
<li>The pile of work you are looking at is remediation, not steady state</li>



<li>You are hiring for coverage instead of capacity, because <strong>one person is not coverage</strong></li>



<li>You cannot answer who mentors them, who reviews their work, or who covers their vacation</li>
</ul>



<p class="wp-block-paragraph">And if you read all of that and land on &#8220;we should hire,&#8221; <strong>then hire.</strong> Tell us and we can even sell you a bucket of hours good for the year and help you write the req, sit in on the technical interview, and if you want, review their work quarterly so they have somebody senior to argue with. We would rather have that relationship than sell you a plan you should not have bought.</p>



<h2 id="h-the-short-version" class="wp-block-heading">The short version</h2>



<p class="wp-block-paragraph">Per hour, we cost two to four times what an employee costs. That is true and it is on this post in a table above.</p>



<p class="wp-block-paragraph">Per year, if you don&#8217;t have enough to keep a DBA sufficiently busy, we  can cost a fraction of a hire and you get monitoring, a team, and coverage when somebody is out that can still flex up for the emergencies.</p>



<p class="wp-block-paragraph">Above about 10 to 15 hours a week of real,sustained, DBA work, go hire someone, but we can still help provide that coverage and expertise &#8211; maybe you can hire a skillset down and we can level them up with you and they stay a bit longer.</p>



<p class="wp-block-paragraph"></p>
<p>The post <a href="https://straightpathsql.com/hiring-a-full-time-dba-vs-dba-as-a-service/">Hiring a Full-Time DBA vs DBA as a Service</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></content:encoded>
					
					<wfw:commentRss>https://straightpathsql.com/hiring-a-full-time-dba-vs-dba-as-a-service/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>How Much Does DBA as a Service Cost? What&#8217;s Included, What Uses Hours, and Why We Price It This Way</title>
		<link>https://straightpathsql.com/how-much-does-dba-as-a-service-cost-whats-included-what-uses-hours-and-why-we-price-it-this-way/</link>
					<comments>https://straightpathsql.com/how-much-does-dba-as-a-service-cost-whats-included-what-uses-hours-and-why-we-price-it-this-way/#respond</comments>
		
		<dc:creator><![CDATA[Mike Walsh]]></dc:creator>
		<pubDate>Mon, 24 Aug 2026 11:30:00 +0000</pubDate>
				<category><![CDATA[Database Administration]]></category>
		<category><![CDATA[DBA as a Service]]></category>
		<category><![CDATA[About StraightPath Solutions]]></category>
		<category><![CDATA[Buying DBA Services]]></category>
		<category><![CDATA[DBA Service Pricing]]></category>
		<category><![CDATA[Pricing]]></category>
		<guid isPermaLink="false">https://straightpathsql.com/?p=5105</guid>

					<description><![CDATA[<p>Officially &#8211; we publish our DBA as a Service pricing because we&#8217;d rather you know what this costs and how it works before we ever get on a sales call. Unofficially? I put the pricing up there because I HATE looking for a service and seeing &#8220;contact us for pricing.&#8221; I know what&#8217;s coming next, ... <a title="How Much Does DBA as a Service Cost? What&#8217;s Included, What Uses Hours, and Why We Price It This Way" class="read-more" href="https://straightpathsql.com/how-much-does-dba-as-a-service-cost-whats-included-what-uses-hours-and-why-we-price-it-this-way/" aria-label="Read more about How Much Does DBA as a Service Cost? What&#8217;s Included, What Uses Hours, and Why We Price It This Way">Read more</a></p>
<p>The post <a href="https://straightpathsql.com/how-much-does-dba-as-a-service-cost-whats-included-what-uses-hours-and-why-we-price-it-this-way/">How Much Does DBA as a Service Cost? What&#8217;s Included, What Uses Hours, and Why We Price It This Way</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></description>
										<content:encoded><![CDATA[
<p class="wp-block-paragraph"><em>Officially &#8211; we publish our DBA as a Service pricing because we&#8217;d rather you know what this costs and how it works before we ever get on a sales call. <strong>Unofficially</strong>? I put the pricing up there because I HATE looking for a service and seeing &#8220;contact us for pricing.&#8221; I know what&#8217;s coming next, and I&#8217;m not looking forward to it.</em></p>



<p class="wp-block-paragraph">Our pricing for our Remote DBA service is deliberately pretty simple: o<strong>ne quarterly price, one pool of DBA hours, and a set of services that come with the relationship whether you use every hour or not.</strong></p>



<p class="wp-block-paragraph">The number itself is the easy part and that doesn&#8217;t take a lot of time on calls with potential customers to sort through, but what people usually want to understand is what that number actually buys, what uses their hours, what doesn&#8217;t, and what happens when their needs change.</p>



<p class="wp-block-paragraph">So I&#8217;ll try and answer most of those questions here. I don&#8217;t mind answering them in the calls also, but I like solutioning and sorting out relationship fit and figuring out the specific challenges on the calls and if we can answer a few questions ahead of time with some posts and videos, that&#8217;s more time to talk about the unique challenges.</p>



<div class="wrapper-video">
<div style="position: relative; padding-top: 56.25%;">
  <iframe
    src="https://customer-zfb3lxtijbv9qz8k.cloudflarestream.com/38709d7c833112554a5aeccd47c6a21b/iframe?poster=https%3A%2F%2Fcustomer-zfb3lxtijbv9qz8k.cloudflarestream.com%2F38709d7c833112554a5aeccd47c6a21b%2Fthumbnails%2Fthumbnail.jpg%3Ftime%3D14s%26height%3D600"
    loading="lazy"
    style="border: none; position: absolute; top: 0; left: 0; height: 100%; width: 100%;"
    allow="accelerometer; gyroscope; autoplay; encrypted-media; picture-in-picture;"
    allowfullscreen="true"
  ></iframe>
</div>
</div>



<p class="wp-block-paragraph">I talk a bit more about the philosophy (and my extreme dislike for &#8220;contact us for pricing details&#8221; on a website in the above video.</p>



<p class="wp-block-paragraph"><strong>This post is Part of our <a href="https://straightpathsql.com/tag/buying-dba-services/" data-type="post_tag" data-id="800">Buying DBA Services</a> series:</strong> We’re sharing what we’ve learned from inside the managed DBA business over the years to help you understand the costs, tradeoffs, problems, and questions to ask before choosing a provider. The goal is to help you make the right decision, whether that means hiring Straight Path, another DBA company, an internal DBA, or nobody at all.</p>



<h2 id="h-how-much-does-straight-path-s-dba-as-a-service-cost" class="wp-block-heading">How much does Straight Path&#8217;s DBA as a Service cost?</h2>



<p class="wp-block-paragraph">It&#8217;s on the DBA as a Service page but as of today:</p>



<ul class="wp-block-list">
<li>Micro: $6,000/quarter for 10 hours, overage hours are $295/hr.</li>



<li>Silver: $10,000/quarter for 25 hours, overage hours are $275/hr.</li>



<li>Gold: $14,000/quarter for 45 hours, overage hours are $265/hr.</li>



<li>Diamond: $19,000/quarter for 75 hours, overage hours are $250/hr.</li>
</ul>



<p class="wp-block-paragraph">Gold and Diamond let you roll forward hours, all levels get the same monitoring and full team relationship, all have access to us after hours. Silver and up start with a Senior DBA owning the relationship, Micros are owned by the amazing DBAs on our support team. But the full team serves all clients &#8211; we don&#8217;t gatekeep you from the right resource based on your level. More details are on the pricing page.</p>



<h2 id="h-why-do-you-charge-quarterly-instead-of-monthly" class="wp-block-heading">Why do you charge quarterly instead of monthly?</h2>



<p class="wp-block-paragraph">We actually started pricing monthly way back when &#8211; but a few things hit:</p>



<ol class="wp-block-list">
<li>More overhead &#8211; it was a LOT more to track and send invoices.</li>



<li>We made more money from overage from clients in some months while other months had hours left over &#8211; a lot can change month to month.</li>



<li>We wanted more stability in the billing for our client and a bit more time to be proactive.</li>
</ol>



<p class="wp-block-paragraph">Monthly is too much churn and too hard to predict. Quarterly can be difficult for some clients but it tends to be the right cycle for natural ebbs and flows in a relationship and normalizes over the 3 months. Some clients wind up on semi-annual and annual plans and for many clients that works well &#8211; for some it&#8217;s a bit too far out to predict if they don&#8217;t have a great annual forecast of work and are going through changes.</p>



<h2 id="h-why-don-t-you-price-dba-as-a-service-by-the-number-of-sql-server-instances" class="wp-block-heading">Why don&#8217;t you price DBA as a Service by the number of SQL Server instances?</h2>



<p class="wp-block-paragraph">Instance count just doesn&#8217;t really equate to workload. The age old SQL Server DBA answer to every question is &#8220;It depends&#8221; &#8211; and that really applies to a question like &#8220;how busy is one instance?&#8221; We have a few clients with a single SQL Server instance who are easily Diamonds forever because of all the important work, help with tuning and SQL Dev work they need, and some that have scores of instances  with or without a DBA that can get by on Silver or even Micro. We charge by hours and we let folks change levels quarter by quarter based on needs. This really has worked well.</p>



<h2 id="h-what-is-included-in-the-quarterly-price" class="wp-block-heading">What is included in the quarterly price?</h2>



<ul class="wp-block-list">
<li>Monitoring of their entire estate &#8211; daily health checks, alerts as they happen that are watched by our triage team M-F 8AM to 5PM no charges for the tools to be there or the daily health review summary our team looks at and sends or the alert triage. We bill when we get connected.</li>



<li>A single instance of SQL sentry monitored (more available at our discount &#8211; priced with a really steep discount &#8211; we aren&#8217;t a software reseller &#8211; we&#8217;re just passing on a discount we get for buying in bulk)</li>



<li>A staffed on-call team and escalations.</li>



<li>A lead DBA and access to some of the best of the best DBAs (and access to CDO services, Azure architecture and more with Buck on the team)</li>



<li></li>
</ul>



<h2 id="h-what-actually-uses-my-included-dba-hours" class="wp-block-heading">What actually uses my included DBA hours?</h2>



<p class="wp-block-paragraph">Whatever you need. I guess you could simply just say, <strong>work. </strong>We sometimes get calls asking &#8220;what about if it&#8217;s emergency work? what if it&#8217;s proactive? Is it different for reactive? What if it&#8217;s reactive but it&#8217;s a Tuesday? What if it&#8217;s after hours patching work? What if it&#8217;s project work vs fix it work? <br><br>We don&#8217;t play that game here. For two reasons. One because it&#8217;s confusing as heck for the customers and a strange service model. The other? Because I don&#8217;t want to have to track all of that. If we&#8217;re connecting and doing work or talking to you about things or in a meeting &#8211; we&#8217;re billing in 15 minute increments. <br><br>After hours work is still billed in 15-minute increments, but we start the clock at an hour then go to 15 minute increments. So theoretically, if something after hours only took 45 minutes, an hour is deducted from the retainer &#8211; but I can&#8217;t think of many after hours things that are 30 minute things by the time you get connected, load the ticket, confirm the plan, test the work, etc.</p>



<p class="wp-block-paragraph"></p>



<h2 id="h-why-does-micro-have-a-higher-effective-hourly-rate-than-silver-gold-or-diamond" class="wp-block-heading">Why does Micro have a higher effective hourly rate than Silver, Gold, or Diamond?</h2>



<p class="wp-block-paragraph">There is a fixed cost to ever DBA as a Service relationship. We don&#8217;t do a &#8220;monitoring only&#8221; plan &#8211; but if we did we&#8217;d see a bit more normalization between the levels. The things like the monitoring infrastructure and support and dev team and security, our own security and audit compliance, the back office, the team reviewing the alerts and doing the daily health checks that aren&#8217;t billing clients for hours. We&#8217;re paying for the team to be on-call whether they get a call or not. Mentoring and training. All of these costs are baked into what we do as a company but the fixed client service costs like the alerting and tooling &#8211; that has a bit less room to &#8220;hide&#8221; when a plan like Micro has 10 hours per quarter. </p>



<h2 id="h-what-happens-if-i-don-t-use-all-of-my-hours" class="wp-block-heading">What happens if I don&#8217;t use all of my hours?</h2>



<p class="wp-block-paragraph">For the Micro and Silver tiers &#8211; we don&#8217;t have rollover, but we also don&#8217;t like a client losing hours. These plans are really &#8220;up to&#8221; plans but we do our best to use all of the hours. We have monthly check-in calls and report the hours, we review things, we have a heavy focus on proactive support and catching things before they go bad &#8211; and we escalate and keep calling if we aren&#8217;t getting feedback. We want to be the most valuable partner that each of our clients work with &#8211; and we pride ourselves on winning the best in service award from Clearly Rated, the folks who do our independent surveys. We love it when a client tells us that we&#8217;re a partner, not a vendor. We do our best to use the hours.</p>



<p class="wp-block-paragraph">For Gold and Diamond we have rollover available 10 and 25 hours respectively. </p>



<p class="wp-block-paragraph">And when a client consistently uses less hours &#8211; our leads suggest a downgrade if there are no plans to use them in the future.</p>



<h2 id="h-what-happens-if-i-use-more-hours-than-my-plan-includes" class="wp-block-heading">What happens if I use more hours than my plan includes?</h2>



<p class="wp-block-paragraph">Every client can purchase overage. We <strong>never</strong> assume overage either. When a client gets close on hours, their lead DBA sends them a note saying they are burning at a higher rate than their level is at and we ask for which stance they&#8217;d like us to take. Allow us to consume up to some number of hours overage at the overage rate (we don&#8217;t bill it then &#8211; we just get a limit and approval and then bill only what&#8217;s used at the end of the quarter.), save some for emergencies, allow only emergency overage, or hold work at the level.</p>



<p class="wp-block-paragraph">Each level has different overage rates as described above and on the pricing page. </p>



<p class="wp-block-paragraph">The overage rates are a lot less expensive than the Bucket of Hours rates. This isn&#8217;t to punish a bucket of hours client, but it&#8217;s to optimize for the relationship &#8211; and with an existing DBA as a Service client, we&#8217;re often able to better plan and predict and even head off some of the work because we&#8217;re really part of their team. I think of it as our clients on DBA as a Service are in some sort of a membership with us. (That said when a bucket of hours gets usage up high &#8211; we&#8217;ll often offer price breaks and relationship breaks.)<br><br>We also will look at an emergency or faster than planned usage as a way to really optimize for the relationship. We try and be creative when it makes sense and let a client upgrade their next quarter and steal ahead (we make a bit less for the overage &#8211; but we haven&#8217;t profited off of a big emergency &#8211; leaving overage for the 10-20 hours above and beyond that happen from time to time not a true increase in workload where the next level just makes sense.)</p>



<h2 id="h-why-don-t-you-charge-different-rates-for-projects-emergencies-performance-tuning-upgrades-patching-and-other-types-of-dba-work" class="wp-block-heading">Why don&#8217;t you charge different rates for projects, emergencies, performance tuning, upgrades, patching, and other types of DBA work?</h2>



<p class="wp-block-paragraph">I don&#8217;t want a client wondering &#8220;shoot which SKU of work is this before I call?!&#8221; I want them thinking of us as their partner, in it for them &#8211; <strong><em>with them</em></strong> &#8211; and if it&#8217;s work &#8211; it&#8217;s just being billed in 15 minute increments. Back when I was on the ambulance as a volunteer &#8211; I loved patient care and figuring stuff out and stabilizing a crisis &#8211; I really, <strong><em>hated</em></strong><em> </em>the paperwork. Imagine all of the paperwork and work we&#8217;d have to do to have a million different rates based on a flow chart of ideas. Nah&#8230; If we&#8217;re working with you &#8211; we&#8217;re billing the retainer in 15 minute increments. Case closed.<br><br>(That said after hours support calls are assessed a $500 fee &#8211; one and two calls are waived a year for Gold and Diamond) We pride ourselves on getting few calls &#8211; the fee is at the right level to be worth it for an emergency, but a bit too high for a &#8220;stubbed toe&#8221; &#8211; the reason we don&#8217;t get the calls isn&#8217;t the fee &#8211; it&#8217;s our proactive stance &#8211; we like to setup an environment for success ahead of time and focus so hard on prevention.</p>



<h2 id="h-can-i-just-buy-a-bucket-of-consulting-hours-instead" class="wp-block-heading">Can I just buy a bucket of consulting hours instead?</h2>



<p class="wp-block-paragraph">Absolutely. <br><br>Buckets of hors list today for $7,000 for 20 hours and we just moved the pricing to $12,000 if a client buys 40 hours at a time. The hours are good until they are exhausted or for a year, whichever comes first. We bill those in 15 minute increments also.</p>



<p class="wp-block-paragraph">Buckets are great if you don&#8217;t want monitoring, if you don&#8217;t need alerting, if you don&#8217;t need a support team to call &#8211; we are getting fewer of our team members access and the work is planned work where we are helping with a defined project, some tuning, a health check and fixes afterwards.</p>



<p class="wp-block-paragraph">The buckets of hours are NOT for support or break fix after hours or with the 15-minute P1 response (though we still try and help where we can and when we can &#8211; the buckets are optimized for project work that is planned and no real DBA support.)</p>



<p class="wp-block-paragraph"><strong>If you just need hours and not support and relationship &#8211; just buy the hours.</strong></p>



<h2 id="h-how-do-you-decide-which-dba-as-a-service-level-i-should-start-with" class="wp-block-heading">How do you decide which DBA as a Service level I should start with?</h2>



<p class="wp-block-paragraph">Normally on a call with a potential customer, right about now I&#8217;d wet my finger and put it up to the wind and say &#8220;it&#8217;s a bit of a guessing game.&#8221; And, yeah, I really do that far too much (with clean hands!!)<br><br>But we kind of &#8220;figure it out&#8221; on the call. We hear about the pain points, the size of the environment, the size of the team monitoring it, the answers to questions and we take all of the clients we&#8217;ve served who feel and look like you and we are able to narrow it down fairly accurately. Onboarding is taken out of those hours also so we talk about the onboarding process &#8211; more pain = more time to manage and setup accounts and PAM tools and MFAs and second and tertiary accounts. <br><br>But we also tend to optimize for a higher level for the first quarter and we just tell the client if you go with Gold or Diamond based on what it feels like &#8211; and we bit off to many hours we&#8217;ll give you a one time courtesy rollover &#8211; you can rollover all unused hours instead of the 10 or 25 to the next quarter &#8211; so we de-risk it and if the hours are used the way we expect (and, usually, they are) we saved them overage, made a little less margin and were able to really help.</p>



<p class="wp-block-paragraph"><strong>But it&#8217;s an estimate- and we get it wrong sometimes and that&#8217;s why I love running a small company where I&#8217;m the sales guy, customer experience officer and founder &#8211; we figure it out and make it right. But we&#8217;ve been doing this for a long time and we get it right more often than not.</strong></p>



<h2 id="h-are-your-dbas-incentivized-to-use-all-of-my-hours" class="wp-block-heading">Are your DBAs incentivized to use all of my hours?</h2>



<p class="wp-block-paragraph">They are incentivized to serve you, make you feel protected and cared for, the NPS score of their customers in our annual review, and living to our values (Trust360, Generosity, Humility, Ownership mentality.) So they are incentivized to serve you. That means use the hours we have, not just go into overage because we can and try and blend proactive work to reactive needs and to your budget. If they think more hours are needed they&#8217;ll tell you &#8211; if the budget is there to go up a level we&#8217;ve saved you from overage and keep working, if the budget is a tier lower, we titrate to effect.</p>



<p class="wp-block-paragraph">We like long-term client relationships and we have lower churn rates of team and customers and I want to keep it that way. We don&#8217;t want to bill for solving the same alarm over and over again, we don&#8217;t want to actually have you use on-call &#8211; and we want to make sure we get what needs to get done and we&#8217;ll tell you if your hours are too high or too low &#8211; but we&#8217;ll respect the budget. <strong>It&#8217;s absolutely an amazing sign of success when we see a client start at Diamond, move to Gold and then live at Silver because we&#8217;ve solved many of their challenges for real &#8211; it just means I have to have a few more sales calls when we do it, but so be it.</strong></p>



<h2 id="h-can-i-move-between-service-levels" class="wp-block-heading">Can I move between service levels?</h2>



<p class="wp-block-paragraph">Absolutely &#8211; we need 30 days&#8217; notice to move levels. We suggest down or upgrades based on what we see and we work with you to pick the right option.</p>



<h2 id="h-do-i-have-to-sign-a-long-term-contract" class="wp-block-heading">Do I have to sign a long-term contract?</h2>



<p class="wp-block-paragraph">No. Heck no. We once had a client &#8211; someone I used to work with and wanted our service &#8211; need to wait some time before he could break a contract with another, bigger DBA as a Service client, or pay some exorbitant fee. That reminds me of a scene I hated when I had a summer job. I was working at a beach side store on the east coast &#8211; in my small town. And we made fried clams and the owner got after me once because I didn&#8217;t properly &#8220;fold the bottom of the box up&#8221; &#8211; basically we were instructed to squeeze the bottom of the box for each size where the boxes were made &#8211; it meant the bottom was now I don&#8217;t know 1 inch? half an inch higher? And at a point so this mean that maybe 2-3 less fried clams (or scallops or whatever) would fit in the box. I didn&#8217;t like it &#8211; and I asked what if the customers notice? He pointed to the beach and said &#8220;every single day we get how many new people here? and we&#8217;re <strong>the store</strong> here &#8211; where are they going to go? and I don&#8217;t need repeat business it&#8217;s new folks every year.&#8221;<br><br>A lot of our values and approach to business are informed by crap I&#8217;ve had to deal with or don&#8217;t like at places. The long term contracts is 100% there as well. Stay because you like us, because we&#8217;ve earned your renewal. If we haven&#8217;t? Then we don&#8217;t deserve your business. We need 30 days&#8217; notice to leave us, too. With no penalty (though you may have to suffer through a call with Evan, our COO, and I to learn lessons and make sure there&#8217;s nothing we can do to make it better.</p>



<h2 id="h-what-happens-after-hours" class="wp-block-heading">What happens after hours?</h2>



<p class="wp-block-paragraph">We do planned work after hours all the time as described above with the hours. If it&#8217;s an emergency you call our on-call number. 888-SQL-DATA and press option 2 and you talk to our answering service who then calls our on-call DBA. They have 5 minutes to answer or they get called again. After the second 5 minutes they call the backup. After 5 minutes there they call Evan or I. The team doesn&#8217;t want Evan or I called &#8211; usually the backup never has to get called &#8211; and then our team member is on with you. Our SLA is to be on a call within 15 minutes of you calling and to be able to be online working with you within an hour at the worst (the team covers for each other and we often will have folks jump in even if not on-call &#8211; we all get an e-mail when the on-call number is first called &#8211; and Evan, Sheila, and I get a text and we all watch&#8230; We sometimes trip over each other to help &#8211; but I&#8217;d rather it be that way.)</p>



<h2 id="h-what-should-i-compare-when-i-m-looking-at-another-dba-provider-s-price" class="wp-block-heading">What should I compare when I&#8217;m looking at another DBA provider&#8217;s price?</h2>



<p class="wp-block-paragraph">Don&#8217;t just compare the number.</p>



<p class="wp-block-paragraph">Ask the questions above. Ask questions like:</p>



<ul class="wp-block-list">
<li>What is included in the base price?</li>



<li>What consumes hours?</li>



<li>What doesn&#8217;t consume hours?</li>



<li>Is monitoring included?</li>



<li>Who actually reviews the monitoring?</li>



<li>What happens when an alert fires?</li>



<li>What happens after hours?</li>



<li>Are emergencies billed differently?</li>



<li>Is project work billed differently?</li>



<li>What happens if I don&#8217;t use everything?</li>



<li>Can I change service levels?</li>



<li>Who actually works on my SQL Servers?</li>



<li>Who owns the relationship?</li>



<li>What is explicitly NOT included?</li>



<li>What happens if I decide to leave?</li>
</ul>



<p class="wp-block-paragraph">Evaluate the answers, see how you fit with them and pick the best fit for your needs out of a few providers.</p>



<h2 id="h-which-straight-path-dba-as-a-service-level-is-right-for-me" class="wp-block-heading">Which Straight Path DBA as a Service level is right for me?</h2>



<h3 id="h-micro" class="wp-block-heading">Micro</h3>



<p class="wp-block-paragraph">Micro clients are the one client with two major differences:</p>



<ol class="wp-block-list">
<li>You have a Support Team DBA as your primary DBA.</li>



<li>You have to allow us to use a shared access methodology (which is secure, MFA, etc and we are happy to describe that on the call with you.)</li>
</ol>



<p class="wp-block-paragraph">Micro is great if you want the monitoring, the relationship, the ability to flex up. Maybe you have a small environment &#8211; and are growing and want someone there with you. Maybe you have a DBA team and want coverage. We&#8217;ve thought about renaming this service to Essentials &#8211; all of our tools &#8211; our full team &#8211; we keep the lights on but don&#8217;t have a ton of hours to go deep with the proactive. </p>



<h3 id="h-silver" class="wp-block-heading">Silver</h3>



<p class="wp-block-paragraph">You need between 15-25 hours a quarter and have enough complexity to need that Senior DBA relationship and you want us to have time to be proactive and keep ahead of things in your smaller environment. </p>



<h3 id="h-gold" class="wp-block-heading">Gold</h3>



<p class="wp-block-paragraph">This is 45 hours a quarter and has one on-call fee per year waived and rollover available. This is where we start getting to busier environments, a bit more going on and the hours are needed &#8211; we&#8217;re doing more tuning and performance work , helping do a lot of future proofing. You may or may not have a DBA team. We&#8217;ve thought about renaming this level to Professional one day and maybe finding some number of hours that would make Silver and Gold turn into it- The main difference to Silver is the hours but it&#8217;s not that huge of a leep -but it saves you $1,500 a quarter in overage if you need to go over.</p>



<h3 id="h-diamond" class="wp-block-heading">Diamond</h3>



<p class="wp-block-paragraph">You need 75 or more hours a quarter, we&#8217;re doing a lot more work and there is more complexity. We&#8217;ve thought about renaming this to &#8220;Enterprise&#8221; one day. You&#8217;d get two on-call fees waived per year.</p>



<h3 id="h-a-bucket-of-hours" class="wp-block-heading">A bucket of hours</h3>



<p class="wp-block-paragraph">I talked about that above &#8211; but really you just need the work, don&#8217;t need or want the monitoring, the ongoing reviews and relationships and SLAs &#8211; but you&#8217;d love the expertise that comes from a team like ours.</p>



<h2 id="h-the-short-version" class="wp-block-heading">The short version</h2>



<p class="wp-block-paragraph">Our DBA as a Service pricing is designed around the amount of DBA work and coverage you actually need, not simply the number of SQL Server instances you own or any other metrics that are really open to interpretation.</p>



<p class="wp-block-paragraph">You pay one quarterly price. You get a pool of DBA hours plus the monitoring, tooling, coverage, and team infrastructure that comes with the service. We don&#8217;t have different rates for different tickets or access to the &#8220;good SLA&#8221;. It&#8217;s just a pool of hours for you to use how you need.</p>



<p class="wp-block-paragraph">If you need more, we can use overage or move you up. If you consistently need less, we can move you down.</p>



<p class="wp-block-paragraph">And if you don&#8217;t need an ongoing managed relationship at all, we&#8217;ll happily sell you a bucket of consulting hours instead.</p>



<p class="wp-block-paragraph">The goal isn&#8217;t to put every company into the biggest DBA as a Service plan we can sell.</p>



<p class="wp-block-paragraph">It&#8217;s to figure out what kind of DBA help you actually need and price the relationship accordingly and grow with you even if as the relationship grows the hours may drift down because of what we&#8217;ve accomplished. That&#8217;s success.</p>



<p class="wp-block-paragraph"><strong>Still not sure which option fits?</strong></p>



<p class="wp-block-paragraph">That&#8217;s normal. We don&#8217;t expect you to diagnose your own DBA workload before talking to us. If you reach out, we&#8217;ll ask about your environment, your team, what keeps breaking, what&#8217;s coming up, and what you actually want help with. Sometimes we&#8217;ll recommend DBA as a Service. Sometimes we&#8217;ll recommend a bucket. And sometimes we&#8217;ll tell you that what you really need is to hire somebody. <a href="https://outlook.office.com/bookwithme/user/5258149c14a34c6c8802b5287bb46145@straightpathsql.com/meetingtype/M8_Fl2w6NkOgLjBj_Pj_BA2?bookingcode=59806524-f834-42be-b1aa-d3e99c90fa18&amp;anonymous&amp;ismsaljsauthenabled&amp;ep=mlink">Book some time with me</a> or <a href="https://straightpathsql.com/contact/" data-type="page" data-id="97">reach out</a>  &#8211; we don&#8217;t have a sales team or sales process &#8211; we have a conversation and see if we&#8217;re right for each other.</p>
<p>The post <a href="https://straightpathsql.com/how-much-does-dba-as-a-service-cost-whats-included-what-uses-hours-and-why-we-price-it-this-way/">How Much Does DBA as a Service Cost? What&#8217;s Included, What Uses Hours, and Why We Price It This Way</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></content:encoded>
					
					<wfw:commentRss>https://straightpathsql.com/how-much-does-dba-as-a-service-cost-whats-included-what-uses-hours-and-why-we-price-it-this-way/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>Are Your SQL Servers Actually Secure? Linked In Live event on 9/16</title>
		<link>https://straightpathsql.com/are-your-sql-servers-actually-secure-linked-in-live-event-on-9-16/</link>
					<comments>https://straightpathsql.com/are-your-sql-servers-actually-secure-linked-in-live-event-on-9-16/#respond</comments>
		
		<dc:creator><![CDATA[Mike Walsh]]></dc:creator>
		<pubDate>Thu, 20 Aug 2026 12:59:26 +0000</pubDate>
				<category><![CDATA[SQL Server Health Check]]></category>
		<category><![CDATA[SQL Server Security]]></category>
		<category><![CDATA[Best Practices]]></category>
		<category><![CDATA[DBA]]></category>
		<category><![CDATA[sp_CheckBackup]]></category>
		<category><![CDATA[sp_CheckHealth]]></category>
		<category><![CDATA[sp_CheckSecurity]]></category>
		<category><![CDATA[sp_CheckTempdb]]></category>
		<guid isPermaLink="false">https://straightpathsql.com/?p=5163</guid>

					<description><![CDATA[<p>The post <a href="https://straightpathsql.com/are-your-sql-servers-actually-secure-linked-in-live-event-on-9-16/">Are Your SQL Servers Actually Secure? Linked In Live event on 9/16</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></description>
										<content:encoded><![CDATA[<p>The post <a href="https://straightpathsql.com/are-your-sql-servers-actually-secure-linked-in-live-event-on-9-16/">Are Your SQL Servers Actually Secure? Linked In Live event on 9/16</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></content:encoded>
					
					<wfw:commentRss>https://straightpathsql.com/are-your-sql-servers-actually-secure-linked-in-live-event-on-9-16/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>Introducing sp_CheckHealth: Check Your Overall SQL Server Health</title>
		<link>https://straightpathsql.com/introducing-sp_checkhealth-check-your-overall-sql-server-health/</link>
					<comments>https://straightpathsql.com/introducing-sp_checkhealth-check-your-overall-sql-server-health/#respond</comments>
		
		<dc:creator><![CDATA[Jeff Iannucci]]></dc:creator>
		<pubDate>Wed, 19 Aug 2026 10:00:00 +0000</pubDate>
				<category><![CDATA[SQL Server Health Check]]></category>
		<category><![CDATA[Best Practices]]></category>
		<category><![CDATA[Free Tools]]></category>
		<category><![CDATA[sp_CheckHealth]]></category>
		<category><![CDATA[SQL Server]]></category>
		<guid isPermaLink="false">https://straightpathsql.com/?p=5154</guid>

					<description><![CDATA[<p>Imagine you inherited a new SQL Server instance, or even several instances, and you need to perform a quick &#8220;sanity check&#8221; to see if anything is off. There are probably a hundred different things a Database Administrator (or someone who has to play the role of the DBA) would want to check to see to ... <a title="Introducing sp_CheckHealth: Check Your Overall SQL Server Health" class="read-more" href="https://straightpathsql.com/introducing-sp_checkhealth-check-your-overall-sql-server-health/" aria-label="Read more about Introducing sp_CheckHealth: Check Your Overall SQL Server Health">Read more</a></p>
<p>The post <a href="https://straightpathsql.com/introducing-sp_checkhealth-check-your-overall-sql-server-health/">Introducing sp_CheckHealth: Check Your Overall SQL Server Health</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></description>
										<content:encoded><![CDATA[
<p class="wp-block-paragraph">Imagine you inherited a new SQL Server instance, or even several instances, and you need to perform a quick &#8220;sanity check&#8221; to see if anything is off. There are probably a hundred different things a Database Administrator (or someone who has to play the role of the DBA) would want to check to see to determine the state of a SQL Server instance&#8217;s health.</p>



<p class="wp-block-paragraph">We do this every day here at Straight Path using <a href="https://straightpathsql.com/sp_check/sp_checkhealth/">sp_CheckHealth</a>, and we wanted to share it with you.<br><br>Here at Straight Path Solutions, we&#8217;re big fans of community tools like <a href="https://github.com/amachanic/sp_whoisactive/releases">sp_WhoIsActive</a>, <a href="https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/releases">Brent Ozar&#8217;s First Responder&#8217;s Kit</a>, and <a href="https://github.com/erikdarlingdata/DarlingData">Erik Darling&#8217;s suite of helpful stored procedures</a>. As database administrators who are constantly looking at new clients and new servers, we wanted one tool we could run the moment we sit down in front of an unfamiliar instance to get the lay of the land and see what needs our attention first. Like many of you, we’ve been using <a href="https://www.brentozar.com/blitz/">sp_Blitz</a> for years, but we wanted a tool that was more focused on administration-related issues. So, we wrote one.</p>



<p class="wp-block-paragraph">You can <a href="https://github.com/Straight-Path-Solutions/sp_Check/tree/main/sp_CheckHealth">download sp_CheckHealth now</a> from our GitHub repository, along with several other helpful tools for SQL Server.</p>



<h2 id="h-what-does-sp-checkhealth-do" class="wp-block-heading"><strong>What does sp_CheckHealth do?</strong></h2>



<p class="wp-block-paragraph">This tool will give you a fast, comprehensive picture of a SQL Server instance. It gathers the kind of information you would otherwise collect by clicking through a dozen dialogs and running a handful of scripts, and it flags potential issues so you can decide what to deal with first. The findings are organized into categories like Recoverability, Security, Availability, Integrity, Reliability, and Performance, and each one comes with details and an action step so you aren’t left guessing about what to do next.</p>



<p class="wp-block-paragraph">This tool has several modes that present a different set of data, depending on what you want to examine.</p>



<ul class="wp-block-list">
<li>@Mode = 0: only the problematic issues we could find.</li>



<li>@Mode = 1: instance information only, with one finding per row.</li>



<li>@Mode = 11: instance information only, returned as a single row. This is handy if you want to collect the same facts from many instances and stack them together, especially if you have a <a href="https://learn.microsoft.com/en-us/ssms/register-servers/create-a-central-management-server-and-server-group">Central Management Server</a> that you can query.</li>



<li>@Mode = 99: instance information and problematic issues together (the default).</li>
</ul>



<h2 id="h-how-do-i-use-it" class="wp-block-heading"><strong>How do I use it?</strong></h2>



<p class="wp-block-paragraph">Execute the script to create sp_CheckHealth in the database of your choice.</p>



<p class="wp-block-paragraph">Executing it without using parameters runs @Mode = 99 and returns a single result set that includes your instance information followed by any problematic findings, sorted so the most important items are at the top.</p>



<p class="wp-block-paragraph">Although you can simply execute it as is, there are several optional parameters.</p>



<p class="wp-block-paragraph"><strong>@Help</strong> – the default is 0, but setting this to 1 will return some helpful information about sp_CheckHealth and its usage in case you aren&#8217;t able to read this web page.</p>



<p class="wp-block-paragraph"><strong>@Mode</strong> – see the previous few paragraphs to decide which Mode you want to use.</p>



<p class="wp-block-paragraph"><strong>@DatabaseName</strong> – the default results include information for all databases, but use this parameter if you have a specific database that you are reviewing. Using this parameter can greatly reduce the results.</p>



<p class="wp-block-paragraph"><strong>@Override</strong> – by default the stored procedure will quit and notify you if you run it on an instance with 50 or more databases, since collecting the history on that many databases can use substantial resources. Use this parameter to override that and run the full check.</p>



<p class="wp-block-paragraph"><strong>@VersionCheck</strong> – the default is 0, but setting this to 1 will return the version number and version date of the copy of sp_CheckHealth you are running, and nothing else.</p>



<h2 id="h-what-do-the-importance-levels-mean" class="wp-block-heading"><strong>What do the Importance levels mean?</strong></h2>



<p class="wp-block-paragraph"><strong>1 – High</strong>. This is the stuff that needs your attention, like recoverability gaps, integrity problems, or configuration that is actively working against you. Try to address these when you can.</p>



<p class="wp-block-paragraph"><strong>2 – Medium</strong>. This is the stuff that may or may not be intentional, like certain settings, trace flags, or security configuration. Review these findings to make sure they were all intended or expected.</p>



<p class="wp-block-paragraph"><strong>3 – Low</strong>. This is stuff that probably isn&#8217;t a problem, but you should be aware of it anyway.</p>



<h2 id="h-what-are-the-requirements-to-use-sp-checkhealth" class="wp-block-heading"><strong>What are the requirements to use sp_CheckHealth?</strong></h2>



<p class="wp-block-paragraph">There are two requirements.</p>



<p class="wp-block-paragraph"><strong>Your SQL Server instance should be using SQL Server 2014 or higher. </strong>If you are using an earlier version, execution of the stored procedure will skip some checks because some of the DMVs used don&#8217;t exist in earlier versions. The results should still be valid and helpful, but you should really consider upgrading to a newer version. Or maybe it errors out for earlier versions, but if it does we can’t help you other than to say that you should plan to migrate to a supported version.</p>



<p class="wp-block-paragraph"><strong>You need to have VIEW SERVER STATE and VIEW ANY DEFINITION permissions.</strong> This tool uses several system tables and DMVs to collect information about your SQL Server instance, and these permissions will allow you to read nearly all necessary information. There are some checks that require permission in the sysadmin role, but those are skipped if this permission is not present.</p>
<p>The post <a href="https://straightpathsql.com/introducing-sp_checkhealth-check-your-overall-sql-server-health/">Introducing sp_CheckHealth: Check Your Overall SQL Server Health</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></content:encoded>
					
					<wfw:commentRss>https://straightpathsql.com/introducing-sp_checkhealth-check-your-overall-sql-server-health/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>Why SQL Server Health Check Findings Don&#8217;t Get Implemented (And What to Ask Before You Buy One)</title>
		<link>https://straightpathsql.com/why-sql-server-health-check-findings-dont-get-implemented/</link>
					<comments>https://straightpathsql.com/why-sql-server-health-check-findings-dont-get-implemented/#respond</comments>
		
		<dc:creator><![CDATA[Mike Walsh]]></dc:creator>
		<pubDate>Tue, 18 Aug 2026 13:15:18 +0000</pubDate>
				<category><![CDATA[Database Administration]]></category>
		<category><![CDATA[SQL Server Health Check]]></category>
		<guid isPermaLink="false">https://straightpathsql.com/?p=5090</guid>

					<description><![CDATA[<p>We inherit a lot of SQL Server environments. And a thing that happens more often than I&#8217;d like is that we find a completed SQL Server health check sitting in the environment already. A pretty darn good one, too. The findings are right, the recommendations make sense, and a lot of the time we know ... <a title="Why SQL Server Health Check Findings Don&#8217;t Get Implemented (And What to Ask Before You Buy One)" class="read-more" href="https://straightpathsql.com/why-sql-server-health-check-findings-dont-get-implemented/" aria-label="Read more about Why SQL Server Health Check Findings Don&#8217;t Get Implemented (And What to Ask Before You Buy One)">Read more</a></p>
<p>The post <a href="https://straightpathsql.com/why-sql-server-health-check-findings-dont-get-implemented/">Why SQL Server Health Check Findings Don&#8217;t Get Implemented (And What to Ask Before You Buy One)</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></description>
										<content:encoded><![CDATA[
<p class="wp-block-paragraph">We inherit a lot of SQL Server environments. And a thing that happens more often than I&#8217;d like is that we find a completed SQL Server health check sitting in the environment already. <strong>A pretty darn good one, too. </strong>The findings are right, the recommendations make sense, and a lot of the time we know the person who wrote it, because it&#8217;s a small tech community and we respect the folks doing this work.</p>



<p class="wp-block-paragraph">Then we look at the date on the report. It&#8217;s a <em>year old.</em> And then we look at the environment and not one of the important recommendations has been done. For more than a few of these times,<strong> none of them have been done</strong>.</p>



<p class="wp-block-paragraph"><em>And sometimes it could even be our own report from long ago&#8230;</em></p>



<p class="wp-block-paragraph">That&#8217;s the uncomfortable part, and it&#8217;s the reason I wanted to write this, life is too short to not be transparent and think about how to solve these things at the same time. <strong>If you&#8217;re thinking about paying anybody for a SQL Server health check or health assessment or whatever your favorite name for it is (and that includes paying us), the report is not actually the thing you should be evaluating. What happens after the report is the thing.</strong></p>



<p class="wp-block-paragraph"><strong>The short version:</strong> health check findings don&#8217;t get implemented because a finding without an owner, a date, and a follow-up is just documentation. The report usually didn&#8217;t fail. What happened after the report failed, and some of that is on the consultant who wrote it when we don&#8217;t make sure you&#8217;re ready to go, know what to do, why you should do it, and how to communicate it and verify it.</p>



<div class="wrapper-video">
<div style="position: relative; padding-top: 56.25%;">
  <iframe
    src="https://customer-zfb3lxtijbv9qz8k.cloudflarestream.com/d1b5e1244db7a32c44d07c6316118251/iframe?poster=https%3A%2F%2Fcustomer-zfb3lxtijbv9qz8k.cloudflarestream.com%2Fd1b5e1244db7a32c44d07c6316118251%2Fthumbnails%2Fthumbnail.jpg%3Ftime%3D0s%26height%3D600&#038;startTime=0s"
    loading="lazy"
    style="border: none; position: absolute; top: 0; left: 0; height: 100%; width: 100%;"
    allow="accelerometer; gyroscope; autoplay; encrypted-media; picture-in-picture;"
    allowfullscreen="true"
  ></iframe>
</div>
</div>



<h2 id="h-why-don-t-sql-server-health-check-findings-get-implemented" class="wp-block-heading">Why don&#8217;t SQL Server health check findings get implemented?</h2>



<p class="wp-block-paragraph">The interesting thing is that this is almost never a knowledge problem. When we come in, the client usually remembers the assessment. They&#8217;ll say &#8220;oh yeah, we had one of those done, here&#8217;s the report if you want it.&#8221; Some of them go a step further and ask us to help implement the findings somebody else gave them and provide us the reports and documents and say &#8220;here &#8211; help us do this stuff&#8230;.&#8221;</p>



<p class="wp-block-paragraph"><strong><em>So they knew. They were told exactly what needed to change. And a year later nothing changed. There are four reasons we see this over and over, and the last one is the one us consultants don&#8217;t like talking about.</em></strong></p>



<h2 id="h-is-a-recommendation-the-same-thing-as-an-implementation-plan" class="wp-block-heading">Is a recommendation the same thing as an implementation plan?</h2>



<p class="wp-block-paragraph">No, and this is the biggest one.</p>



<p class="wp-block-paragraph">&#8220;You should test your restores.&#8221; Great. No duh&#8230;. But now go be the person who has to do that, and look at the questions that recommendation leaves sitting on your desk.</p>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>The recommendation says</th><th>The person doing it still has to answer</th></tr></thead><tbody><tr><td>Test your restores</td><td>Which systems, and in what order?</td></tr><tr><td></td><td>Restore to where? What server, what storage, whose budget?</td></tr><tr><td></td><td>Who does it, and is it in their job description?</td></tr><tr><td></td><td>How often, and when does the first one happen?</td></tr><tr><td></td><td>How do we know the restore was actually good? Do we run CHECKDB against it? Do we do an app test? Is the CheckDB good enough? How do we know?</td></tr><tr><td></td><td>What do we do with the restored copy afterward?</td></tr><tr><td></td><td>Does this need a maintenance window?</td></tr><tr><td></td><td>What happens if the test fails, and who gets told?</td></tr></tbody></table></figure>



<p class="wp-block-paragraph">The recommendation can be technically perfect and still die right there, because nobody answered the questions that nag the person who has to own it (and their leadership team and change control boards.) And so it becomes one more line on a report that gets filed on a shelf somewhere (you can see a little bit of my messy bookshelf behind me in the video, so I&#8217;m not throwing stones &#8211; though I keep the <strong><em>really</em></strong> messy shelves off camera.)</p>



<p class="wp-block-paragraph"><strong>A finding without an owner and without a date and without a task is documentation. It is not a plan.</strong></p>



<h2 id="h-why-do-critical-findings-keep-getting-pushed-to-next-month" class="wp-block-heading">Why do critical findings keep getting pushed to next month?</h2>



<p class="wp-block-paragraph">Because normal life happens, and normal life is relentless. </p>



<p class="wp-block-paragraph">A performance problem shows up and it takes priority, and honestly it&#8217;s funner to work on for most of us DBA types. Somebody needs a report by Thursday. Disk space gets tight. There&#8217;s a deployment. Six meetings get scheduled in the same hour and you have to pick at least 3 of them to kind of attend. And the critical recommendation from the assessment becomes &#8220;we&#8217;ll get to that next month,&#8221; and then next quarter, and you already know how that story ends because we&#8217;ve all lived it.</p>



<p class="wp-block-paragraph">We wrote about this in our post on the <a href="https://straightpathsql.com/your-dba-isnt-the-problem-depending-on-one-dba-is/" data-type="post" data-id="5062">perils of being a solo DBA</a>, and it&#8217;s the same problem. As a company who uses EOS, this falls in the &#8220;Capacity&#8221; category not the Gets it or Wants it category (IYKYK). </p>



<h2 id="h-are-dba-consultants-explaining-findings-in-a-way-the-business-can-act-on" class="wp-block-heading">Are DBA Consultants explaining findings in a way the business can act on?</h2>



<p class="wp-block-paragraph">Often, no, and this one is on us as a profession.</p>



<p class="wp-block-paragraph">We walk into a room and tell an IT Director that MaxDOP is wrong, or the recovery model doesn&#8217;t line up with what Veeam is actually doing, or there&#8217;s a security configuration problem. All true. All meaningless to somebody who is already holding a list of 47 things from one sysadmin, plus everything coming down from above, plus what clients are pushing in, plus whatever the SOC 2 people asked for this week (we&#8217;re nearing the end of our first SOC2 audit &#8211; and a question from the auditor takes priority, I get it now!)</p>



<p class="wp-block-paragraph">If we don&#8217;t describe the business impact and answer their questions, it doesn&#8217;t get prioritized,<strong><em> and if it doesn&#8217;t get prioritized it doesn&#8217;t get done.</em></strong></p>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>What we tend to say</th><th>What the person deciding actually needs</th></tr></thead><tbody><tr><td>Your recovery model is wrong</td><td>If we lose this server at 2pm, here&#8217;s how much data is gone and here&#8217;s what that costs</td></tr><tr><td>You have no CHECKDB job</td><td>We can&#8217;t currently tell you whether your data is already corrupt, and backups of corrupt data don&#8217;t help. I don&#8217;t even want us to go to sleep this weekend until we do a checkdb and pray about the results and see them&#8230;</td></tr><tr><td>MaxDOP is misconfigured</td><td>Queries are competing for CPU, here&#8217;s the report that runs slow because of it</td></tr><tr><td>Security configuration issue</td><td>Here&#8217;s who can currently do what, and here&#8217;s how that reads to an auditor</td></tr></tbody></table></figure>



<p class="wp-block-paragraph">The frame that works is pretty simple. Here&#8217;s what can happen to the business if we don&#8217;t do this. Here&#8217;s how likely we think that is. Here&#8217;s what it takes to fix, in money and time and downtime and reboots. Here&#8217;s the risk of making the change, and here&#8217;s the risk of doing nothing.<strong><em> And here&#8217;s what I&#8217;d fix first and why.</em></strong></p>



<h2 id="h-are-consultants-part-of-the-problem" class="wp-block-heading">Are consultants part of the problem?</h2>



<p class="wp-block-paragraph">Yes, at least partly, and this is the part I don&#8217;t think we talk about enough.</p>



<p class="wp-block-paragraph">If I hand you a brilliant report with 70 findings, take your check, wish you luck, and come back a year later to find you did none of it, <em>I have to at least ask myself whether I actually helped you. Why are all of these still here?</em></p>



<p class="wp-block-paragraph">Did I explain it well enough? Did I make the priorities obvious? Did I describe the risk in language your business could use? Did I give you an achievable first step, and did I help you pick the right first thing and then the second thing? Did we establish an owner? Did I follow up with you at all? Was I there to answer questions and encourage you? Did I offer to help you make the changes?</p>



<p class="wp-block-paragraph">Yes, I took your money and I delivered the report and legally the contract was met if you just bought a health check only (We do<a href="https://straightpathsql.com/sql-server-health-check/" data-type="page" data-id="3941"> sell a SQL Server health check for $997</a> and we go deep enough with it, but we prefer to sell a bucket of 20 hours, do the health check in the first bunch of hours and have time left over to help actually implement the changes and maybe even follow up a few times if you like.)<strong> But why did I deliver it, and why did you pay for it?</strong> <em>Was it because you wanted a nice looking PDF, or was it because you wanted to know what was bad and how to fix it?</em></p>



<p class="wp-block-paragraph">There&#8217;s one more question in there too, which is whether my recommendations were even realistic in your environment. There are two kinds of best practices out there. There are the ones that are right for you and your environment, and there are the ones that are right in a textbook somewhere. Sure, disable the sa account. But if you&#8217;re running a vendor app that flat out will not work any other way, is that recommendation helping you, or should we have gotten on a call with your vendor instead?</p>



<p class="wp-block-paragraph"><strong>None of that means the consultant owns your decisions.</strong> We can&#8217;t. You and your business have to own the decision and you have to act. But we see this enough that it&#8217;s good to think through.</p>



<h2 id="h-what-should-a-sql-server-health-assessment-actually-give-you" class="wp-block-heading">What should a SQL Server health assessment actually give you?</h2>



<p class="wp-block-paragraph">These days I care a lot less about handing somebody a big list. <strong><em>A big list is easy.</em></strong> <strong>You can get your own big list with all of our free community <a href="https://straightpathsql.com/resources/tools/">SP_Check tools</a> &#8211; especially now that we&#8217;ve released sp_CheckHealth that we use internally to drive a lot of our health checks</strong>. You can find the latest free app or vibe coded tool and see what&#8217;s not ideal today. What you actually need to walk away knowing is where you&#8217;re going to get hurt, what has to be fixed first, what can wait, and who needs to be in the room for each decision. And understand which to apply when and which to hold off on because the ingredients aren&#8217;t right for it for you.</p>



<p class="wp-block-paragraph">Every finding should carry six things:</p>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>Component</th><th>The question it answers</th><th>What happens when it&#8217;s missing</th></tr></thead><tbody><tr><td>Finding</td><td>What is it?</td><td>Nothing to act on</td></tr><tr><td>Explanation</td><td>Why does it matter, and how does it actually work?</td><td>It gets ignored or argued with</td></tr><tr><td>Priority</td><td>What do I fix first, and what can wait?</td><td>Everything looks equally urgent, so nothing moves</td></tr><tr><td>Owner</td><td>Who is doing this?</td><td>It stays everyone&#8217;s job, which means nobody&#8217;s</td></tr><tr><td>Date</td><td>When?</td><td>It slides to next month, forever</td></tr><tr><td>Follow-up</td><td>Who notices in six months if it didn&#8217;t happen?</td><td>You buy the same assessment again in two years</td></tr></tbody></table></figure>



<p class="wp-block-paragraph">If the last three are missing, none of us should act surprised when the same findings show up again.</p>



<p class="wp-block-paragraph">And the practical detail matters just as much as the finding. If we tell you to reformat a drive to a 64K allocation unit and we don&#8217;t also say &#8220;please don&#8217;t do that tomorrow afternoon on the production box with live databases on it,&#8221; that&#8217;s a failure of the report, not a failure of the reader. What needs downtime, what doesn&#8217;t, what&#8217;s going to blow away your plan cache and give you an ugly twenty minutes, what&#8217;s going to take you offline until you restore if you don&#8217;t do the right steps?  That belongs in the deliverable so you can work with the approval process and get the stuff approved. That&#8217;s why we prefer to stick around and get our hands dirty with the bucket of 20 hours. For the same price as some health assessments, we&#8217;ll do the assessment, stretch our hours and make the changes with you, teaching as we go billing in 15-minute increments. We like to see you pay for the findings &#8211; and walk away healthy. We can  spend the next bucket of hours or do DBA as a Service with you on the funner &#8220;next&#8221; stuff.</p>



<h2 id="h-who-owns-fixing-what-a-health-check-finds" class="wp-block-heading">Who owns fixing what a health check finds?</h2>



<p class="wp-block-paragraph">Somebody has to, and it&#8217;s worth being clear-eyed about who before you buy anything.</p>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>Task</th><th>A health assessment</th><th>Ongoing DBA ownership</th></tr></thead><tbody><tr><td><strong>Tells you where you&#8217;re exposed</strong></td><td>Yes</td><td>Yes</td></tr><tr><td><strong>Prioritizes it for you</strong></td><td>Should</td><td>Yes</td></tr><tr><td><strong>Does the work</strong></td><td>No</td><td>Yes</td></tr><tr><td><strong>Notices in six months</strong></td><td>No</td><td>Yes</td></tr><tr><td><strong>Good fit when</strong></td><td>You have someone to act on it, you understand the priority and info, the health assessment helps you walk away with a plan and you have confidence in making the changes</td><td>You don&#8217;t have that someone &#8211; or they&#8217;re stretched too thin.</td></tr></tbody></table></figure>



<p class="wp-block-paragraph">A health check can tell you where you&#8217;re exposed. Someone still has to do the work to un-expose you. Sometimes that&#8217;s your internal DBA. Sometimes it&#8217;s the person on the team who can spell SQL because you don&#8217;t have a DBA. Sometimes it&#8217;s a consultant, and sometimes it&#8217;s a DBA as a Service team working alongside you. Any of those can work. But the &#8220;hope it gets fixed and someday we may&#8221; approach won&#8217;t work most of the time.</p>



<h2 id="h-what-should-you-ask-before-you-buy-a-health-check-from-anyone" class="wp-block-heading">What should you ask before you buy a health check from anyone?</h2>



<p class="wp-block-paragraph">This is the part I&#8217;d genuinely like you to take with you, whether you buy from us, from one of our friends in the community, or you download a free community tool (our or anyone&#8217;s) and run your own.</p>



<p class="wp-block-paragraph">Don&#8217;t just ask what&#8217;s in the report. Ask what happens after it.</p>



<figure class="wp-block-table"><table class="has-fixed-layout"><thead><tr><th>Ask this</th><th>A good answer sounds like</th><th>A bad answer sounds like</th></tr></thead><tbody><tr><td>What happens after you hand me the report?</td><td>We walk it through with your team and agree on the first three things</td><td>We&#8217;ll send it over and you can reach out with questions</td></tr><tr><td>Who helps me prioritize this?</td><td>We do, in your context, with your constraints</td><td>It&#8217;s ranked high/medium/low in the document</td></tr><tr><td>Who owns the next steps?</td><td>We&#8217;ll name an owner for each finding with you and can answer questions about who typically owns it</td><td>That&#8217;s on your side</td></tr><tr><td>Will you teach us, or just tell us?</td><td>We&#8217;ll show your team why, so you can maintain it, we can even help you on the implementation nights</td><td>Here&#8217;s the fix</td></tr><tr><td>Who notices in six months if none of it happened?</td><td>We follow up</td><td>(silence)</td></tr><tr><td>Are these recommendations realistic in my environment?</td><td>We&#8217;ll flag which ones your vendor or app constrains</td><td>These are industry best practices</td></tr></tbody></table></figure>



<h2 class="wp-block-heading">What Should You Do Next?</h2>



<p class="wp-block-paragraph">If this post has you wondering about the health of your own SQL Server environment, you have a few options.</p>



<p class="wp-block-paragraph"><strong>Want to do it yourself?</strong> We’ve released our SQL Server health check tools for free. Start with <strong><a href="https://straightpathsql.com/introducing-sp_checkhealth-check-your-overall-sql-server-health/" data-type="post" data-id="5154">sp_CheckHealth</a></strong>, and use tools like <strong><a href="https://straightpathsql.com/introducing-sp_checksecurity/" data-type="post" data-id="610">sp_CheckSecurity</a></strong> to dig deeper into specific areas. Jeff Iannucci and I are also doing a series of free sessions walking through how to assess your own SQL Server environment and what to do with what you find.</p>



<p class="wp-block-paragraph"><strong>Want somebody to help you do the health check?</strong> We do SQL Server health checks, too. We’ll help you understand what’s actually dangerous, what should be fixed first, what can wait, and what the path forward should look like. The goal isn’t to hand you a PDF. It’s to leave you knowing what to do next.</p>



<p class="wp-block-paragraph"><strong>Need somebody to actually own this with you?</strong> Sometimes a health check isn’t really the problem. You already know there’s technical debt. You don’t have enough DBA capacity to work through it, or you need ongoing monitoring, coverage, and senior DBA help. If that sounds more like your situation, we’ve put together and are continuing to contribute to our <strong><a href="https://straightpathsql.com/tag/buying-dba-services/" data-type="post_tag" data-id="800">Buying DBA Services</a></strong> post series explaining how managed DBA services work, what they cost, when they make sense, when they don’t, and what to ask before you hire any of the great shops providing that service out there.</p>



<p class="wp-block-paragraph"><strong>Do It Yourself → Do your own SQL Server health check. </strong>Start with <a href="https://straightpathsql.com/introducing-sp_checkhealth-check-your-overall-sql-server-health/" data-type="post" data-id="5154">SP_CheckHealth</a>, check out the monthly webinar series Jeff and I are doing on linked in. Intro session recording is <a href="https://www.linkedin.com/events/7475162901570498560?viewAsMember=true">here</a>, follow <a href="https://www.linkedin.com/in/mikepwalsh">me on LinkedIn</a> to see the links for the next ones. </p>



<p class="wp-block-paragraph"><strong>Get a Health Check → </strong>Buy a <a href="https://straightpathsql.com/sql-server-health-check/" data-type="page" data-id="3941">$997 SQL Server Health Check</a> from us if you want some help and review/documentation. </p>



<p class="wp-block-paragraph"><strong>Get Ongoing DBA Help → </strong>Check out our series of posts about the buying DBA services or check out our remote SQL Server dba services &#8211; <a href="https://straightpathsql.com/sql-server-consulting/dba-as-a-service/" data-type="page" data-id="189"> DBA as a Service</a>.</p>



<p class="wp-block-paragraph"><strong>At the end of the day&#8230;</strong></p>



<p class="wp-block-paragraph">If you&#8217;re doing it yourself with a free tool, the questions don&#8217;t change, they just become an internal conversation. Somebody on your side has to own accountability, or you&#8217;ve generated a very accurate list of things that will still be true next year. If you want help with your <a href="https://straightpathsql.com/sql-server-health-check/" data-type="page" data-id="3941">SQL Server health check, for $997, we can help</a>.</p>



<p class="wp-block-paragraph"><strong>Because at the end of the day, the best assessment in the world doesn&#8217;t reduce one single bit of risk if it&#8217;s stuck in a PDF.</strong></p>



<p class="wp-block-paragraph"></p>
<p>The post <a href="https://straightpathsql.com/why-sql-server-health-check-findings-dont-get-implemented/">Why SQL Server Health Check Findings Don&#8217;t Get Implemented (And What to Ask Before You Buy One)</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></content:encoded>
					
					<wfw:commentRss>https://straightpathsql.com/why-sql-server-health-check-findings-dont-get-implemented/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>Are Your SQL Servers Actually Healthy? LinkedIn Live Event 8/19/26</title>
		<link>https://straightpathsql.com/are-your-sql-servers-actually-healthy-linkedin-live-event-8-19-26/</link>
					<comments>https://straightpathsql.com/are-your-sql-servers-actually-healthy-linkedin-live-event-8-19-26/#respond</comments>
		
		<dc:creator><![CDATA[Mike Walsh]]></dc:creator>
		<pubDate>Mon, 17 Aug 2026 21:35:52 +0000</pubDate>
				<category><![CDATA[Database Administration]]></category>
		<category><![CDATA[Best Practices]]></category>
		<category><![CDATA[database administration]]></category>
		<category><![CDATA[DBA]]></category>
		<category><![CDATA[Free Tools]]></category>
		<category><![CDATA[sp_CheckBackup]]></category>
		<category><![CDATA[sp_CheckSecurity]]></category>
		<category><![CDATA[SQL Server]]></category>
		<category><![CDATA[SQL Server Backup]]></category>
		<category><![CDATA[Straight Up SQL Server Tips]]></category>
		<guid isPermaLink="false">https://straightpathsql.com/?p=5141</guid>

					<description><![CDATA[<p>The post <a href="https://straightpathsql.com/are-your-sql-servers-actually-healthy-linkedin-live-event-8-19-26/">Are Your SQL Servers Actually Healthy? LinkedIn Live Event 8/19/26</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></description>
										<content:encoded><![CDATA[<p>The post <a href="https://straightpathsql.com/are-your-sql-servers-actually-healthy-linkedin-live-event-8-19-26/">Are Your SQL Servers Actually Healthy? LinkedIn Live Event 8/19/26</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></content:encoded>
					
					<wfw:commentRss>https://straightpathsql.com/are-your-sql-servers-actually-healthy-linkedin-live-event-8-19-26/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
		<item>
		<title>Should You Keep the Managed DBA Service After Acquisition? Pros and Cons</title>
		<link>https://straightpathsql.com/should-you-keep-the-managed-dba-service-after-acquisition-pros-and-cons/</link>
					<comments>https://straightpathsql.com/should-you-keep-the-managed-dba-service-after-acquisition-pros-and-cons/#respond</comments>
		
		<dc:creator><![CDATA[Mike Walsh]]></dc:creator>
		<pubDate>Thu, 13 Aug 2026 15:47:30 +0000</pubDate>
				<category><![CDATA[DBA as a Service]]></category>
		<category><![CDATA[Buying DBA Services]]></category>
		<category><![CDATA[Contracts]]></category>
		<category><![CDATA[Due diligence]]></category>
		<category><![CDATA[M&A]]></category>
		<guid isPermaLink="false">https://straightpathsql.com/?p=5114</guid>

					<description><![CDATA[<p>Awhile back I wrote about how acquirers can maximize ROI with their SQL Server during due diligence. That post was about the deal and using some expertise to help before. This post is for some choices after the ink dries on your new acquisition. There&#8217;s a pattern we&#8217;ve lived through many times at Straight Path. ... <a title="Should You Keep the Managed DBA Service After Acquisition? Pros and Cons" class="read-more" href="https://straightpathsql.com/should-you-keep-the-managed-dba-service-after-acquisition-pros-and-cons/" aria-label="Read more about Should You Keep the Managed DBA Service After Acquisition? Pros and Cons">Read more</a></p>
<p>The post <a href="https://straightpathsql.com/should-you-keep-the-managed-dba-service-after-acquisition-pros-and-cons/">Should You Keep the Managed DBA Service After Acquisition? Pros and Cons</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></description>
										<content:encoded><![CDATA[
<p class="wp-block-paragraph"><em>Awhile back I wrote about <a href="https://straightpathsql.com/maximizing-sql-server-roi-in-ma/" data-type="post" data-id="604">how acquirers can maximize ROI with their SQL Server during due diligence</a>. That post was about the deal and using some expertise to help before. This post is for some choices after the ink dries on your new acquisition.</em> </p>



<p class="wp-block-paragraph"><strong>There&#8217;s a pattern we&#8217;ve lived through <em>many times</em> at Straight Path. </strong>A client we&#8217;ve served for many years gets acquired. Sometimes they are folded into a larger holding company and the client is held forever, sometimes they are raided for their contracts and a few people, sometimes it&#8217;s a private equity group making a platform play maybe there&#8217;s a strategic benefit. In all cases, eventually &#8211; sometimes months &#8211; sometimes years &#8211; later new leadership comes in for the mandated expense review and contract review. Where can the cuts happen? Where can EBITDA be protected? <strong><em>And they usually find us</em></strong>&#8230; <em>We don&#8217;t do cell-phone contracts, each quarter is renewed if it&#8217;s earned, and if it&#8217;s not &#8211; we don&#8217;t want to force a bad fit. That model really works and it helps us operate within our values even before we&#8217;ve sent an invoice. <strong>But here?  The model can break. For us, sure, we&#8217;ll be fine and find new clients, but also for the company we&#8217;ve served for a long time. We&#8217;re the easy cut. No long term contract, we aren&#8217;t even that expensive, so how much value can we really be adding?</strong></em></p>



<p class="wp-block-paragraph">Cutting the niche database managed services provider is a pretty easy decision on paper. No severance, no HR talks, not even a contract to really unwind. Surprisingly, we wind up staying more often than not &#8211; and for many of those firms we&#8217;re still with them as a resource across their entire portfolio of clients because they get the value a team with breadth and depth in SQL Server, Cloud, Databases, Performance, etc that operates in a fractional model. Sometimes we get the cut. <strong>A couple of times we&#8217;ve gotten the cut and then called back in later&#8230;</strong></p>



<p class="wp-block-paragraph">I&#8217;m obviously a bit biased&#8230; I run a company that I founded with a team that has grown with me and stays with the company and I think we do a great job. But we also help sometimes with due diligence work FOR these acquirers and we&#8217;ve even helped some clients hire the right full-time DBA that replaces us when that is the best answer. So I want to talk about the case for and the case against keeping a company like us&#8230;</p>



<h2 id="h-the-case-against-keeping-dba-as-a-service-team" class="wp-block-heading">The Case Against Keeping DBA as a Service Team</h2>



<p class="wp-block-paragraph"><strong><em>There are real reasons to cut a service like ours. Below are a few and if any hit where you are &#8211; you probably should cut us or the company like ours.</em></strong></p>



<h3 id="h-you-have-a-genuine-shared-services-team-with-capacity-and-expertise" class="wp-block-heading">You have a genuine shared services team with capacity and expertise</h3>



<p class="wp-block-paragraph">Some acquirers &#8211; especially the larger vertical software guys have built amazing central platform/database teams that serve their entire portfolio of companies. If that team exists, has senior SQL Server people on it (today SQL server is our platform, though we are in the midst of also becoming a Postgres team, more on that soon) and it can absorb another platform &#8211; <strong>you absolutely should consolidate that support. </strong>You have one standard operating book, one toolset, and you still get one throat to choke &#8211; but instead of it being mine it&#8217;s the leader of that team. <em>I think the key emphasis here is on genuinely having that. If they are stretched across platforms in your portco, generalists and don&#8217;t have the bench of MVPs, authors, trainers, bloggers, etc that your partner has &#8211; it could become a case to keeping us around a bit.</em></p>



<h3 id="h-the-product-is-being-managed-down" class="wp-block-heading">The product is being managed down.</h3>



<p class="wp-block-paragraph">Business is business, and I hate to see a product team I loved to work with and build a relationship with have their product be the one chosen to be redundant to the software the new owners already had. But if the buy was for quieting a competitor or moving the MRR to the new product, it&#8217;s the decision. Some products get invested in, some get maintained, some get milked along towards sunset and migrations. If the plan for a product is slow wind-down, no new onboardings and sales and customer retention and experience matters a bit less &#8211; you may not need as much proactive database support. You don&#8217;t need the architectural advice and support, the tuning to keep the clients happy and leaving good reviews or the team catching the P1 before it happens. You still need to test your restores, keep your client&#8217;s data secure and stay out of the news with a breach headline &#8211; but you maybe can split the tasks among your team or have us wind down to just some hours to support and no actual monitoring and best practices ahead of the curve. We&#8217;ll sell you a bucket of hours to help you if you&#8217;d like but it makes sense to manage it less if you&#8217;re winding it down.</p>



<h3 id="h-the-workload-justifies-investing-in-a-dba-team" class="wp-block-heading">The workload justifies investing in a DBA team.</h3>



<p class="wp-block-paragraph">We tell folks before they sign with us &#8211; if you need 40 hours a week of DBA team, we&#8217;re too expensive. I have a post coming out in a couple of weeks that does all of that math &#8211; and it&#8217;s actually closer to 15 hours of consistent steady work &#8211; if you are looking at a numbers by the hour game only &#8211; we lose there. Sure I believe h<a href="https://straightpathsql.com/your-dba-isnt-the-problem-depending-on-one-dba-is/" data-type="post" data-id="5062">aving one DBA is the same thing as having none</a> and I blogged about that last week. Maybe it&#8217;s time to really invest if the work is not getting done and you need a DB developer or DBA there full time. We can help you transition that work to someone and even help you find and train that person. And if you get a team of DBAs who can cover you around the clock for emergencies, the case is closed &#8211; you don&#8217;t need us in there, and you can save that $20,000 &#8211; $72,000 a year you&#8217;d spend on us depending on the level.</p>



<h3 id="h-you-re-reducing-vendor-count-for-real-risk-reasons" class="wp-block-heading">You&#8217;re reducing vendor count for real risk reasons.</h3>



<p class="wp-block-paragraph">This one is a little trickier. We are in the midst of our SOC2 audit and it&#8217;s going well, should have our report in hand in a month. And we serve credit unions, banks, healthcare providers, insurance, governments, etc. I think the risk factor isn&#8217;t there with us, and we answer plenty of security questionnaires for vendors and haven&#8217;t failed one yet. That said  &#8211; we&#8217;re your DBA team so we need certain access, we need certain tools in place, and if we can&#8217;t get that for a real risk reason or that&#8217;s just the policy from on high &#8211; then why pay for a service that you can&#8217;t fully utilize.</p>



<h2 id="h-the-case-for-keeping-the-service" class="wp-block-heading">The Case for Keeping The Service</h2>



<h3 id="h-your-arr-sleeps-in-your-database" class="wp-block-heading">Your ARR sleeps in your database</h3>



<p class="wp-block-paragraph">Monthly recurring revenue is the lifeblood of the vertical SaaS company world. Your customers have a seemingly endless number of places to put their monthly fees and I could have sworn I wrote a blog post long ago about why Inertia was a terrible customer retention strategy &#8211; I can&#8217;t find the post or a draft so I&#8217;m not sure, I mentioned it in the<a href="https://straightpathsql.com/maximizing-sql-server-roi-in-ma/" data-type="post" data-id="604"> M&amp;A advice</a> post at least. I still think it&#8217;s a poor strategy either way. Customers will leave eventually when that is the strategy. And the renewals go down, the EBITDA slips&#8230;  Cutting the team who helps keep you in a proactive stance, teaches your team, tunes the environment, and stays ahead of the future corners and has been lobbying the existing team for upgrades and improvements for years is risky. </p>



<h3 id="h-the-math-usually-doesn-t-math-the-way-the-report-from-finance-suggests" class="wp-block-heading">The math usually doesn&#8217;t math the way the report from finance suggests&#8230;</h3>



<p class="wp-block-paragraph">A single senior DBA with all-in costs runs somewhere around $190,000 &#8211; $220,000 (I just did some review for the post coming in a couple of weeks) or more once benefits, taxes, training,etc is added. And like I already said above, one is none &#8211; you have no coverage and if you don&#8217;t keep them interested &#8211; they&#8217;re gone. Not every company, though, always needs the full time DBA hands on keys, so a lot of that salary for many (not all) companies can become an expensive insurance policy. Our team is bringing our own monitoring tool, SQL Sentry, and a team of experts to be your DBA team. For a fraction of the cost &#8211; and for many companies at, say, our Gold level, we&#8217;re talking about $56,000 per year if they aren&#8217;t on an annual arrangement with a slight discount &#8211; even if you add in two emergencies and a migration with some overage &#8211; you&#8217;re easily under $75k for the year. And many clients who are in a niche SaaS industry are getting my with Silver ($40k a year) or Micro ($24k a year if bought by the quarter, $20k if bought by the year) with our team as their team. And all those monitoring tools are run by SaaS companies who want more MRR and longer deals, so we&#8217;re saving you from contracts with them since the tooling comes with  us.</p>



<h3 id="h-you-re-gonna-need-that-deep-dba-bench-at-somepoint-again" class="wp-block-heading">You&#8217;re gonna need that deep DBA bench at somepoint again</h3>



<p class="wp-block-paragraph">Assets get sold, even when the plan was to hold permanently &#8211; the economy shifts and stuff moves, merges happen later. When that day comes the new buyers are going to ask those questions about performance, security, compliance, why haven&#8217;t you upgraded? Prove out the RPO and RTO the SLA says you offer. Those questions are a lot easier when the DBA team is an extension of your team and, as our reviews suggest, operates like a part of your team. We make those questions get answered with ease and the proof is in the pudding usually.</p>



<h3 id="h-the-spend-is-already-shaped-like-the-way-you-probably-operate" class="wp-block-heading">The spend is already shaped like the way you probably operate</h3>



<p class="wp-block-paragraph">At least when Straight Path is your DBA as a Service provider. Probably most of our friendly competition also. Our model is pretty simple: <strong>a relationship based model priced quarterly, renewed quarterly if earned, no long-term exit clause in the contract and it can flex down when spend goes down and flex up when the needs are higher (saving you money from overage.) </strong>If integration means there are some aspects of service your central services/platform/DB team can deliver, we can reduce our costs and hours. If you bring in a multi-hat wearing person who can take on some of the work but still need us a backstop or mentor &#8211; we reduce and mentor. And you still always get a chance to exit us every 90 days as things change. This seems pretty aligned to a disciplined portfolio management strategy as any outside vendor relationship can get.</p>



<h2 id="h-five-questions-to-answer-before-you-cut-the-line-item" class="wp-block-heading">Five Questions to Answer Before You Cut the Line Item</h2>



<ol class="wp-block-list">
<li><strong>Who watched the databases at 2AM last month?</strong> Who was ready to swing in and fix the issue with a simple phone call and could fix it while the leadership team slept hopefully unaware? <em><strong>Who will watch it after the cut?</strong> <strong>How quickly will they solve it?</strong></em></li>



<li><strong>What did the last unplanned outage cost?</strong> In dollars? In renewals? In reviews? Who fixed it? <strong>Who fixes the next one?</strong></li>



<li><strong>If we move to the central team, how busy are they?</strong> How much attention does this new platform get? How expert are they at the specifics of this environment?</li>



<li><strong>Who will push us to make the right decisions based on working with hundreds of customers? </strong>Do we know enough about what we don&#8217;t know? Do we have the wisdom across a lot of clients to know why one decision isn&#8217;t as good as the other? Will the new folks be unbiased or will they prefer a certain direction because of their own incentives?</li>



<li><strong>What are we actually saving net of monitoring tools, on-call coverage, the hire we will need and the risk we&#8217;re asking to take on?</strong></li>
</ol>



<p class="wp-block-paragraph">If the answers and the info above still push towards making the cut &#8211; then cut and any great managed services provider worth keeping in your contacts will do a clean knowledge transfer and leave that bridge in-tact and door open. We do every time because tech is small and the industry is small. The relationships often outlast the transactions and we get called in when someone moves on &#8211; and we&#8217;ve literally been called back when the big company management team switches out the leadership team again and they realize that the databases weren&#8217;t getting the love they needed.</p>
<p>The post <a href="https://straightpathsql.com/should-you-keep-the-managed-dba-service-after-acquisition-pros-and-cons/">Should You Keep the Managed DBA Service After Acquisition? Pros and Cons</a> appeared first on <a href="https://straightpathsql.com">SQL Server Consulting - Straight Path Solutions</a>.</p>
]]></content:encoded>
					
					<wfw:commentRss>https://straightpathsql.com/should-you-keep-the-managed-dba-service-after-acquisition-pros-and-cons/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
			</item>
	</channel>
</rss>
