Using Query Store to Help Developers Understand Query Performance with Erin Stellato
RunAs Radio17 Apr 2019

Using Query Store to Help Developers Understand Query Performance with Erin Stellato

How do you make your SQL queries go faster? Richard chats with Erin Stellato about how Query Store in SQL Server 2017 and its ability to provide detailed information on query performance, including where SQL Server is compiling new query plans for repeated calls. Erin talks about how ORMs can cause repeated ad-hoc queries and how Query Store can be used to help educate developers and explore options for tuning those queries with stored procedures or parameterization. But you can't blame code by default - Query Store can be used for a variety of performance tuning options, on-premises and in the cloud!

Det här avsnittet är hämtat från ett öppet RSS-flöde och publiceras inte av Podme. Det kan innehålla reklam.

Avsnitt(1054)

Patching in 2026 with Susan Bradley

Patching in 2026 with Susan Bradley

How has patching changed in 2026? Richard chats with patching goddess Susan Bradley about what she's seeing in vendor patches and how they're affecting consumers and businesses. On one hand, you have ...

16 Sep 35min

State of WSUS with Adam Marshall

State of WSUS with Adam Marshall

Windows Server Update Services (WSUS) was deprecated in Sept 2024 - when does it go away? Richard talks to Adam Marshall about how WSUS is still an essential service for Configuration Manager, include...

9 Sep 28min

Reimagining Intranets with Susan Hanley

Reimagining Intranets with Susan Hanley

How does AI change the intranet? Richard chats with Susan Hanley about her work helping organizations build great intranets and how tools like M365 Copilot are changing the intranet. Susan talks about...

2 Sep 36min

Security Features of PowerShell 7 with Mike O'Neill

Security Features of PowerShell 7 with Mike O'Neill

How secure are your PowerShell scripts? Richard talks to Mike O'Neill about the powerful security features introduced with PowerShell 7.3 and above, including session configuration files and clean blo...

26 Aug 31min

Automatic Attack Disruption with Liz Tesch

Automatic Attack Disruption with Liz Tesch

What if Microsoft Defender not only detected attackers - but also fought back? Richard talks to Liz Tesch about Microsoft Defender Automatic Attack Disruption and Predictive Shielding. Liz talks about...

19 Aug 38min

The Content Management System Landscape with Matt Garrepy

The Content Management System Landscape with Matt Garrepy

What is the state of content management systems today? Richard chats with Matthew Garrepy of CMS Critic about his views on how the CMS market continues to evolve. Matt digs into the build-vs-buy conve...

12 Aug 40min

Ransomware Readiness with Heather Renze

Ransomware Readiness with Heather Renze

The risk of ransomware is real - are you ready? Richard talks with Heather Renze about her experiences dealing with a ransomware attack and how to get prepared when it happens to you. Heather talks ab...

5 Aug 37min

Azure Virtual Desktop Hybrid with Travis Roberts

Azure Virtual Desktop Hybrid with Travis Roberts

More ways to use Azure Virtual Desktop! Richard chats with Travis Roberts about how Azure Virtual Desktop continues to evolve and provides more options for remote users. Travis talks about how AVD gre...

29 Juli 34min

Populärt inom Business & ekonomi

framgangspodden
varvet
rss-jossan-nina
24fragor
rss-borsens-finest
svd-tech-brief
avanzapodden
uppgang-och-fall
badfluence
rss-inga-dumma-fragor-om-pengar
bathina-en-podcast
rss-dagen-med-di
rss-kort-lang-analyspodden-fran-di
tabberaset
lastbilspodden
fill-or-kill
rikatillsammans-om-privatekonomi-rikedom-i-livet
market-makers
kapitalet-en-podd-om-ekonomi
affarsvarlden