--- title: [Video] Office Hours: Desert Database Q&A | daily.dev description: Brent Ozar hosts a Q&A session covering SQL Server topics including Parameter Sensitive Plan Optimization (PSPO) on SQL 2022, passing collections without... canonical: https://daily.dev/posts/video-office-hours-desert-database-q-a-gw8qcrvck twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: [Video] Office Hours: Desert Database Q&A | daily.dev og:description: Brent Ozar hosts a Q&A session covering SQL Server topics including Parameter Sensitive Plan Optimization (PSPO) on SQL 2022, passing collections without... og:url: https://daily.dev/posts/video-office-hours-desert-database-q-a-gw8qcrvck og:image: https://api.daily.dev/og/posts/gw8QcRVcK.png og:image:alt: [Video] Office Hours: Desert Database Q&A 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: Desert Database Q&A **[Brent Ozar](https://daily.dev/sources/brentozar)** · 3 min read · 0 upvotes · 0 comments ## Summary Brent Ozar hosts a Q&A session covering SQL Server topics including Parameter Sensitive Plan Optimization (PSPO) on SQL 2022, passing collections without parameter sensitivity issues, MAXDOP configuration on Azure VMs, table column count limits, multi-terabyte database risks, plan guides vs Query Store forced plans, FileTable vs S3 storage, NVMe SSD impact on memory importance, data warehouse ingestion strategies, and using AI in DBA workflows. Also touches on SQL Server monitoring tools and MCP server integration with SQL Server. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## 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: 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 a Lava Field](https://daily.dev/posts/video-office-hours-in-a-lava-field-jjvbt6a24) · Brent Ozar · 0 upvotes · 0 comments - [\[Video\] Office Hours Overlooking Rome](https://daily.dev/posts/video-office-hours-overlooking-rome-d3m1qgpmf) · 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) [View this post on daily.dev](https://daily.dev/posts/video-office-hours-desert-database-q-a-gw8qcrvck) ```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: Desert Database Q&A","url":"https://daily.dev/posts/video-office-hours-desert-database-q-a-gw8qcrvck","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/video-office-hours-desert-database-q-a-gw8qcrvck"},"datePublished":"2026-07-31T13:15:53.715Z","dateModified":"2026-07-31T13:24:04.667Z","description":"Brent Ozar hosts a Q&A session covering SQL Server topics including Parameter Sensitive Plan Optimization (PSPO) on SQL 2022, passing collections without...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/615e390b2643a9099a56c54e33a44fce?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/615e390b2643a9099a56c54e33a44fce?_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-desert-database-q-a-gw8qcrvck","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"database,azure,microsoft-sql-server","timeRequired":"PT3M"} {"@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: Desert Database Q&A"}]} ```