Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
techhub.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A hub primarily for passionate technologists, but everyone is welcome

Administered by:

Server stats:

5.2K
active users

techhub.social: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.7

#sqlserver

8 posts8 participants0 posts today
Public
Brendan Hayward

I've been slowly chipping away at my site querydiff.com
I got annoyed at #sqlserver management studio and made a website instead.
You can now load an example pair of #query plans to compare them. See what the site does if you don't have a query plan in a nice xml file ready to go.
1/2

Public
Alvin Ashcraft

Azure & DevOps Podcast Episode 345 - .NET Aspire and Databases with Jerry Nixon and host Jeffrey Palermo. buff.ly/Bn4lTiN #podcast #devcommunity #sqlserver #database #aspire #dotnet #dotnetaspire #cloudnative

Azure & DevOps Podcast: .NET A...

buff.lyAzure & 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.
Public
Alvin Ashcraft 🐿️

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.
#podcast#devcommunity#sqlserver
Public
Vlad :verified:

The latest release of PSBlitz:
- adds file IO stats to the database files info table
- includes sessions by state and newest connection time as part of the client connections table in the Instance Overview page
- increases the connection timeout to accommodate Azure connection approval prompts
- fixes a bug where the database info check would fail on Azure SQL MI
- addresses a bug in the CSS of the Azure SQL DB Info page
#sqlserver #sqldba #powershell #mssqlserver #mssql
github.com/VladDBA/PSBlitz

a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files. - VladDBA/...
GitHubGitHub - VladDBA/PSBlitz: a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files.a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files. - VladDBA/...
Public
Ænðr E. Feldstraw

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.

ExploreLive feeds
About