sueden.social ist einer von vielen unabhängigen Mastodon-Servern, mit dem du dich im Fediverse beteiligen kannst.
Eine Community für alle, die sich dem Süden hingezogen fühlen. Wir können alles außer Hochdeutsch.

Serverstatistik:

2 Tsd.
aktive Profile

#SQLServer

2 Beiträge2 Beteiligte0 Beiträge heute

Azure & DevOps Podcast Episode 345 - .NET Aspire and Databases with Jerry Nixon and host Jeffrey Palermo.

feed.azuredevops.show/net-aspi

feed.azuredevops.showAzure & DevOps Podcast: .NET Aspire and Databases with Jerry Nixon - Episode 345Jerry Nixon is a Principal Program Manager on the SQL Server team focused on the Data API builder. He’s also a fanatic for #CSharp, #StarTrek, and Etymology. He also serves as a professor at Colorado Christian University.   Topics of Discussion: [3:34] Why Jerry describes his life as a pearl necklace. [5:15] Jerry recommends the book Never Eat Alone and the importance of community. [6:01] How engineers and parenting are aligned. [7:02] Jerry reflects on Microsoft’s history of evangelism, the rise of “opinionated” frameworks, and how .NET Aspire revives a form of proven prescriptive guidance. [9:35] Prescriptive guidance. [12:03] The inevitable evolution of .NET Aspire and how it simplifies container-based development by handling orchestration behind the scenes. [16:56] Paying more attention and awareness to the developer community. [18:30] How GraphQL fits into the Data API Builder experience, giving developers flexibility without needing to write complex backends. [21:40] Jerry talks about community feedback on Data API Builder and how real-world use cases help prioritize features and fix gaps in tooling. [31:02] Jerry’s perspective on building container-based solutions. [32:15] Data API Builder’s community involvement and upcoming features. [36:15] Docker Desktop. [38:58] The architectural concept of Data API Builder. [44:42] C# coding conventions at Microsoft and the friendly battles over things like naming, underscores, and formatting styles across internal teams.   Mentioned in this Episode: — New Video Podcast! Email us at . (Sponsor) , by Jeffrey Palermo   Want to Learn More? Visit for show notes and additional episodes.

Yo, #sqlserver tuners and optimizers, I have a question: under what circumstances would a #queryplan prefer a scan of a clustered index rather than a seek of a non-clustered index with the same predicate and output fields?

I've been pouring over query plans lately, trying to reduce pressure of processes in an environment that sees thousands of processes running, with hundreds at the same time, contending for data access, CPU time, and file locks.

The latest release of PSBlitz:

- is now code-signed with a Certum open source code signing certificate
- retains CRLF in query text so that line comments (--) are no longer a problem
- now prompts for advanced options when ran in interactive mode
- logs sub-step status and timing when -DebugInfo is used
- has a new report page for database objects with dangerous SET options
- other bug fixes and minor improvements
#sqlserver #sqldba #powershell #mssqlserver #mssql
github.com/VladDBA/PSBlitz