<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/posts/if-you-had-to-go-back-on-prem-tsql2sday-qqsea14u6" -->

---
title: If You Had to Go Back On-Prem… #tsql2sday | daily.dev
description: A T-SQL Tuesday response exploring the real-world challenges of migrating back from cloud to on-premises infrastructure. Key gotchas include the current...
canonical: https://daily.dev/posts/if-you-had-to-go-back-on-prem-tsql2sday-qqsea14u6
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:type: website
og:site_name: daily.dev
og:title: If You Had to Go Back On-Prem… #tsql2sday | daily.dev
og:description: A T-SQL Tuesday response exploring the real-world challenges of migrating back from cloud to on-premises infrastructure. Key gotchas include the current...
og:url: https://daily.dev/posts/if-you-had-to-go-back-on-prem-tsql2sday-qqsea14u6
og:image: https://api.daily.dev/og/posts/Qqsea14u6.png
og:image:alt: If You Had to Go Back On-Prem… #tsql2sday
og:image:width: 1200
og:image:height: 630
og:locale: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# If You Had to Go Back On-Prem… #tsql2sday

**[Brent Ozar](https://daily.dev/sources/brentozar)** · 2 min read · 0 upvotes · 0 comments

## Summary

A T-SQL Tuesday response exploring the real-world challenges of migrating back from cloud to on-premises infrastructure. Key gotchas include the current hardware shortage driven by AI demand, the lost skill of calm on-prem outage troubleshooting without a vendor to blame, and the risk of a single cloud-native dependency blocking the entire reverse migration.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.brentozar.com/archive/2026/06/if-you-had-to-go-back-on-prem-tsql2sday>

## Similar posts on daily.dev

- [Bridging the IT Divide Without Breaking What Already Works](https://daily.dev/posts/bridging-the-it-divide-without-breaking-what-already-works-ujmr1yyv3) · DevOps.com · 0 upvotes · 0 comments
- [Innovation spotlight: How 3 customers are driving change with migration to Azure SQL](https://daily.dev/posts/innovation-spotlight-how-3-customers-are-driving-change-with-migration-to-azure-sql-0bznr7bjk) · Microsoft Azure · 0 upvotes · 0 comments
- [Cloud repatriation is back on the agenda](https://daily.dev/posts/cloud-repatriation-is-back-on-the-agenda-o85bz46zh) · InfoWorld · 0 upvotes · 0 comments

---

Tags: [#infrastructure](https://daily.dev/tags/infrastructure), [#microsoft-sql-server](https://daily.dev/tags/microsoft-sql-server)

[View this post on daily.dev](https://daily.dev/posts/if-you-had-to-go-back-on-prem-tsql2sday-qqsea14u6)

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]}
{"@context":"https://schema.org","@type":"TechArticle","headline":"If You Had to Go Back On-Prem… #tsql2sday","url":"https://daily.dev/posts/if-you-had-to-go-back-on-prem-tsql2sday-qqsea14u6","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/if-you-had-to-go-back-on-prem-tsql2sday-qqsea14u6"},"datePublished":"2026-06-09T13:19:08.885Z","dateModified":"2026-06-09T13:19:25.594Z","description":"A T-SQL Tuesday response exploring the real-world challenges of migrating back from cloud to on-premises infrastructure. Key gotchas include the current...","image":"https://media.daily.dev/image/upload/s--qPvKM23u--/f_auto/v1722860399/public/Placeholder%2009","thumbnailUrl":"https://media.daily.dev/image/upload/s--qPvKM23u--/f_auto/v1722860399/public/Placeholder%2009","isAccessibleForFree":true,"articleSection":"Brent Ozar","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Brent Ozar","logo":"https://media.daily.dev/image/upload/s--uHhajUhc--/c_limit,w_256/f_auto,q_auto/v1780213426/logos/brentozar?_a=BAMAMiWQ0","url":"https://daily.dev/sources/brentozar"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/if-you-had-to-go-back-on-prem-tsql2sday-qqsea14u6","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"infrastructure,microsoft-sql-server","timeRequired":"PT2M"}
{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Brent Ozar","item":"https://daily.dev/sources/brentozar"},{"@type":"ListItem","position":3,"name":"If You Had to Go Back On-Prem… #tsql2sday"}]}
```

