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!

Denne episoden er hentet fra en åpen RSS-feed og er ikke publisert av Podme. Den kan derfor inneholde annonser.

Episoder(1052)

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 Jul 34min

Security Begins at Procurement with Jessie Schofer

Security Begins at Procurement with Jessie Schofer

Bringing new software or SaaS into your organization is a security risk - how do you assess it? Richard chats with Jessie Schofer about her experiences in HR software acquisition, which led to the cre...

22 Jul 37min

Finding Security Vulnerabilities using AI with Sami Laiho

Finding Security Vulnerabilities using AI with Sami Laiho

How are large language models changing the way security vulnerabilities are found? Richard chats with Sami Laiho about the rapidly changing landscape in security exploits. Certain LLM models like Anth...

15 Jul 38min

Populært innen Business og økonomi

stopp-verden
dine-penger-pengeradet
e24-podden
rss-penger-polser-og-politikk
lydartikler-fra-aftenposten
rss-borsmorgen-okonominyhetene
rss-skravla-gar
finansredaksjonen
rss-pa-konto
pengepodden-2
tid-er-penger-en-podcast-med-peter-warren
pengesnakk
lederpodden
livet-pa-veien-med-jan-erik-larssen
rss-orjasater
stormkast-med-valebrokk-stordalen
morgenkaffen-med-finansavisen
utbytte
liberal-halvtime
rss-markedspuls-2