<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/posts/video-office-hours-off-the-coast-of-long-beach-gl0wmygtn" -->

---
title: [Video] Office Hours Off the Coast of Long Beach | daily.dev
description: A weekly Q&A video where a SQL Server expert answers top-voted community questions submitted via a live polling site. Topics covered include shrinking a 25TB...
canonical: https://daily.dev/posts/video-office-hours-off-the-coast-of-long-beach-gl0wmygtn
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:type: website
og:site_name: daily.dev
og:title: [Video] Office Hours Off the Coast of Long Beach | daily.dev
og:description: A weekly Q&A video where a SQL Server expert answers top-voted community questions submitted via a live polling site. Topics covered include shrinking a 25TB...
og:url: https://daily.dev/posts/video-office-hours-off-the-coast-of-long-beach-gl0wmygtn
og:image: https://api.daily.dev/og/posts/gL0WMyGTN.png
og:image:alt: [Video] Office Hours Off the Coast of Long Beach
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.

# [Video] Office Hours Off the Coast of Long Beach

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

## Summary

A weekly Q&A video where a SQL Server expert answers top-voted community questions submitted via a live polling site. Topics covered include shrinking a 25TB database by rebuilding with only recent data, career advice for transitioning from traditional to developmental DBA roles on Azure, speculation on whether AI-assisted development will speed up SQL Server release cadence, pricing comparisons between Azure SQL and Oracle Cloud database, diagnosing CDC (sp_cdc_scan) lag on a high-transaction 5TB database, thoughts on reading all SQL Server documentation, and migration paths now that SSRS won't ship with SQL Server 2025.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.brentozar.com/archive/2026/09/video-office-hours-off-the-coast-of-long-beach>

## Questions this post answers

### What are the alternatives to SSRS now that Microsoft isn't shipping it with SQL Server 2025?

Microsoft is not shipping SSRS (SQL Server Reporting Services) with SQL Server 2025, forcing teams to find alternative reporting solutions for both SQL Server and PostgreSQL environments. Specific replacement paths remain an open question that DBAs are actively discussing, since there is no direct drop-in successor bundled with the new release.

_Teams planning a SQL Server 2025 upgrade can track reporting tool alternatives and migration guidance on daily.dev._

### How can I shrink a 25 TB SQL Server database without hurting performance?

Directly shrinking a 25 TB database causes performance impact, so an alternative is building a fresh database seeded with only the last two years of data and then cutting over to it, rather than archiving and shrinking the existing one in place. This approach avoids the heavy I/O and blocking typically triggered by shrink operations on very large databases.

_DBAs weighing database size reduction strategies can find similar real-world approaches on daily.dev._

### Why does SQL Server CDC (sp_cdc_scan) fall behind and then suddenly catch up under high load?

On a roughly 5 TB database with high transaction volume, sp_cdc_scan can lag hours behind during load even with low-millisecond disk waits, then catch up rapidly once load drops. Setting maxtrans=5000 helped slightly but did not fully resolve the lag, suggesting further diagnostics are needed beyond basic disk latency and batch size tuning.

_Engineers troubleshooting CDC lag under load can compare notes on similar SQL Server issues via daily.dev._

## Similar posts on daily.dev

- [\[Video\] Office Hours: Off St. Thomas](https://daily.dev/posts/video-office-hours-off-st-thomas-wvdhlmuys) · Brent Ozar · 0 upvotes · 0 comments
- [\[Video\] Office Hours in Zhengzhou, China](https://daily.dev/posts/video-office-hours-in-zhengzhou-china-hjai6sfgm) · Brent Ozar · 0 upvotes · 0 comments
- [\[Video\] Office Hours: Open Q&A for Microsoft Databases](https://daily.dev/posts/video-office-hours-open-q-a-for-microsoft-databases-5qyywfnuf) · Brent Ozar · 0 upvotes · 0 comments
- [\[Video\] Office Hours in the Home Bar](https://daily.dev/posts/video-office-hours-in-the-home-bar-ver6khyae) · Brent Ozar · 0 upvotes · 0 comments
- [\[Video\] Office Hours in a Lava Field](https://daily.dev/posts/video-office-hours-in-a-lava-field-jjvbt6a24) · Brent Ozar · 0 upvotes · 0 comments

---

Tags: [#database](https://daily.dev/tags/database), [#azure](https://daily.dev/tags/azure), [#microsoft-sql-server](https://daily.dev/tags/microsoft-sql-server), [#change-data-capture](https://daily.dev/tags/change-data-capture)

[View this post on daily.dev](https://daily.dev/posts/video-office-hours-off-the-coast-of-long-beach-gl0wmygtn)

```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":"[Video] Office Hours Off the Coast of Long Beach","url":"https://daily.dev/posts/video-office-hours-off-the-coast-of-long-beach-gl0wmygtn","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/video-office-hours-off-the-coast-of-long-beach-gl0wmygtn"},"datePublished":"2026-09-24T13:19:01.671Z","dateModified":"2026-09-24T13:19:24.702Z","description":"A weekly Q\u0026A video where a SQL Server expert answers top-voted community questions submitted via a live polling site. Topics covered include shrinking a 25TB...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/5262bad9042e449a6db719b1fd2b0f00?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/5262bad9042e449a6db719b1fd2b0f00?_a=AQAEuop","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/video-office-hours-off-the-coast-of-long-beach-gl0wmygtn","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"database,azure,microsoft-sql-server,change-data-capture","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":"[Video] Office Hours Off the Coast of Long Beach"}]}
{"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/video-office-hours-off-the-coast-of-long-beach-gl0wmygtn#faq","mainEntity":[{"@type":"Question","name":"What are the alternatives to SSRS now that Microsoft isn't shipping it with SQL Server 2025?","acceptedAnswer":{"@type":"Answer","text":"Microsoft is not shipping SSRS (SQL Server Reporting Services) with SQL Server 2025, forcing teams to find alternative reporting solutions for both SQL Server and PostgreSQL environments. Specific replacement paths remain an open question that DBAs are actively discussing, since there is no direct drop-in successor bundled with the new release. Teams planning a SQL Server 2025 upgrade can track reporting tool alternatives and migration guidance on daily.dev."}},{"@type":"Question","name":"How can I shrink a 25 TB SQL Server database without hurting performance?","acceptedAnswer":{"@type":"Answer","text":"Directly shrinking a 25 TB database causes performance impact, so an alternative is building a fresh database seeded with only the last two years of data and then cutting over to it, rather than archiving and shrinking the existing one in place. This approach avoids the heavy I/O and blocking typically triggered by shrink operations on very large databases. DBAs weighing database size reduction strategies can find similar real-world approaches on daily.dev."}},{"@type":"Question","name":"Why does SQL Server CDC (sp_cdc_scan) fall behind and then suddenly catch up under high load?","acceptedAnswer":{"@type":"Answer","text":"On a roughly 5 TB database with high transaction volume, sp_cdc_scan can lag hours behind during load even with low-millisecond disk waits, then catch up rapidly once load drops. Setting maxtrans=5000 helped slightly but did not fully resolve the lag, suggesting further diagnostics are needed beyond basic disk latency and batch size tuning. Engineers troubleshooting CDC lag under load can compare notes on similar SQL Server issues via daily.dev."}}]}
```

