Podcasts about query store

Grant Fritchey has over thirty years of experience in IT, specializing in development and database administration. He works for Red Gate Software as a Product Advocate and writes articles for SQL Server Central and Simple-Talk. He is the author of “SQL Server Execution Plans” and “SQL Server Query Performance Tuning.” He also co-authored “Query Store for SQL Server 2019,” “Expert Performance Indexing,” “SQL Server MVP Deep Dives 2,” “Beginning SQL Server 2012 Administration,” and “Pro SQL Server 2012 Practices.”   He presents at conferences and user groups worldwide and is available for part-time, short-term consulting contracts.Since 2009, he has been recognized as a Microsoft SQL Server MVP. He has received the AWS Community Builder award for the past five years. In 2014, he was honored as a Dunn & Bradstreet MVP, and in 2011, he received the Tech10 Award in Rhode Island.   Topics of Discussion: [:35] Introduction of Grant Fritchey and his career in IT and database administration. [3:23] Grant's journey from software development to becoming a DBA. [5:13] The importance of database selection and how different types of databases serve different needs. [11:27] Grant's view on the addition of document support to major database platforms. [13:29] Database hygiene basics and the importance of regular backups and restore practices. [19:26] The business side of database recovery and balancing cost with recovery objectives (RPO/RTO). [25:03] Grant's recommendations for testing database restores. [28:08] Automation in DevOps and the importance of human training in recovery processes. [31:53] Managing data warehouses and recovery strategies for large databases. [35:12] Resources for developers without dedicated DBAs to ensure good database hygiene.   Mentioned in this Episode: Clear Measure Way Architect Forum Software Engineer Forum Programming with Palermo — New Video Podcast! Email us at programming@palermo.net. Clear Measure, Inc. (Sponsor) .NET DevOps for Azure: A Developer's Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon! Jeffrey Palermo's Twitter — Follow to stay informed about future events! SimpleTalk by Redgate ScaryDBA.com Grant Fritchey on X   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

A Microsoft Data Platform MVP, Grant Fritchey works for Red Gate Software as a Product Advocate. Grant has more than 30 years of experience in the industry as a DBA and developer. Grant is an active participant in the SQL Server Central discussion forums. He writes articles for SQL Server Central and Simple-Talk. He blogs regularly at scarydba.com. Grant is the author of several books including SQL Server Query Performance Tuning and SQL Server Execution Plans. Grant teaches classes on data management and databases around the world. He teaches in the smallest user group settings and at the largest events.   Topics of Discussion: [2:24] How did Grant get into the industry? [5:40 Are there any big shifts that more recent developers and all developers need to know about shifts in how databases have worked? [13:10] What should developers know about the ecosystem when you've taken a system and broken it up into multiple applications? [16:07] What has changed in Grant's book, Query Performance Tuning? [20:34] Performance comes down to the code. It always comes down to the code. [23:58] What are some of the main tools that developers should have in their toolbox? [26:20] Why Grant recommends Extended Events and Query Store. [32:41] Grant gives us his sales pitch. [38:40] What does Grant think the future looks like?   Mentioned in this Episode: Clear Measure Way Architect Forum Software Engineer Forum Programming with Palermo — New Video Podcast! Email us programming@palermo.network Clear Measure, Inc. (Sponsor) .NET DevOps for Azure: A Developer's Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon! Jeffrey Palermo's Twitter — Follow to stay informed about future events! Architect Tips — Video podcast! Azure DevOps Query Performance Tuning ScaryDBA.com SQL   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

How do you keep your SQL queries fast? Richard chats with Monica Rathbun about her approaches to SQL Server query tuning. Monica starts with defining the problem - how do we know that the database is the performance bottleneck? The conversation dives into measuring query performance and the power of Query Store, but only on SQL Server 2016 and above, so get upgrading! Entity Framework is a standard tool for developers to automate access to SQL. Still, it can generate some pretty ugly queries, and Monica talks about different ways to improve them, including the old standby of writing a stored procedure. Lots of ideas for folks struggling to make their databases go fast!Links:Monitoring Performance with Query StoreCommon Table ExpressionsCursors in SQL ServerSQL Server ProfilerGlenn's SQL Server Performance BlogRecorded February 22, 2022

Join us for an introduction to the latest release of SQL Server and learn about all its new capabilities from cloud-connected to built-in query intelligence.[00:50] What's new[01:42] The next step for SQL Server[02:13] SQL Server 2022[05:09] Query Store and Intelligent Query Processing[07:09] Industry-leading database engine[08:37] Data lake virtualization and object storage[10:13] Extending T-SQL[11:47] Getting startedResources:Learn more about SQL Server 2022​Register to apply for the SQL Server 2022 Early Adoption Program and stay informed Watch technical deep-dives on SQL Server 2022SQL Server 2022 YouTube Playlist

Query store hints enables changing query plan shapes without modifying application code. In this episode of Data Exposed with Denzil Ribeiro, we will look at an example of improving the performance of bulk loading data using query store hints. [00:30] Introduction Denzil Ribeiro[01:40] Memory Grants Overview [02:49] Demo[13:05] Getting Started Resources:Performance impact of memory grants on data loads into Columnstore tables

Geeks on Screens with Coffee Episode 63 - Scary. DBA. Look who I bumped into at the water cooler/tea room/corridor? It's only Grant Fritchey (@GFritchey) Welcome back to the first episode of season 4. I will be talking to Grant about life, the universe and almost everything. If you are lucky, we might talk a bit about PASS and ham radio. Bio: Grant Fritchey works for Red Gate Software as a Product Advocate. Grant has more than 30 years experience in the industry as a DBA and developer. Grant volunteers for the Professional Association of SQL Server Users (PASS) currently serving on the Board of Directors as the Executive Vice President. Grant is an active participant in the SQL Server Central discussion forums. He writes articles for SQL Server Central and Simple-Talk. He blogs regularly at scarydba.com. Grant is the author of the books "SQL Server Query Performance Tuning" and "SQL Server Execution Plans." He is co-author on the books "Query Store for SQL Server 2019", "SQL Server MVP Deep Dives 2," "Beginning SQL Server 2012 Administration," "Pro SQL Server 2012 Practices," and "Expert Performance Indexing in SQL Server." Grant teaches classes on data management and databases around the world. He teaches in the smallest user group settings and at the largest events. I must dash, the kettle has almost boiled. Love you! youtube: https://youtu.be/CarmpcVwlKs

In this episode of Data Exposed, Joe Sack, Principal Group Program Manager of SQL Server engine and SQL Hybrid, and Anna Hoffman, Data & Applied Scientist, talk about a new way in Azure SQL Database to optimize the performance of queries when you are unable to directly change the original query text. They will cover the new public preview feature Query Store Hints, which leverages queries already captured in Query Store to apply hints that would have originally required modifications to the original query text through the OPTION clause.[00:32] Introduction[01:10] What are Query Hints?[03:10] Applying Query Hints today[04:26] Introducing Query Store Hints[05:07] How to use Query Store Hints - Step 1[05:46] How to use Query Store Hints - Step 2[06:36] Demo[12:10] Query Store Hint Scope and Behavior[14:10] Use-cases for Query Store HintsFeedback? Email QSHintsFeedback@microsoft.com

In this episode of Data Exposed, Joe Sack, Principal Group Program Manager of SQL Server engine and SQL Hybrid, and Anna Hoffman, Data & Applied Scientist, talk about a new way in Azure SQL Database to optimize the performance of queries when you are unable to directly change the original query text. They will cover the new public preview feature Query Store Hints, which leverages queries already captured in Query Store to apply hints that would have originally required modifications to the original query text through the OPTION clause.[00:32] Introduction[01:10] What are Query Hints?[03:10] Applying Query Hints today[04:26] Introducing Query Store Hints[05:07] How to use Query Store Hints - Step 1[05:46] How to use Query Store Hints - Step 2[06:36] Demo[12:10] Query Store Hint Scope and Behavior[14:10] Use-cases for Query Store HintsFeedback? Email QSHintsFeedback@microsoft.com

How can Query Store help you participate in the DevOps cycle? Richard chats with Erin Stellato about the power of SQL Query Store - born out of Azure SQL, Query Store keeps a record of every unique query that is run, along with its query plan and stats. How does this help with DevOps? By providing data for DBAs to talk to developers about how to make improvements to applications that will have a real impact on customer value in the long run!

Conor Cunningham is a Microsoft Architect and he knows a great deal about data, storage, and everything Microsoft. He and Rob go way back and were even roommates for a couple of years during Rob's Microsoft days. There's quite a bit of history between Rob, Tom, and Conor. A history that fosters an insightful discussion and a little bit of busting chops! We discuss quite a bit including: What a Microsoft Architect does Organized storage and Data lakes Conor's celebrity status How the Query Store was almost killed, but Conor didn't give up on it Remote presentations and working remotely And so much more! Episode Timeline: 2:25 - Conor the Celebrity 4:40 - Conor The Architect, and his unusually organized kitchen 9:40 - Speaking of meticulous organization, we talk Organized Storage and the transition from row and column models to....something else 16:10 - Data Shape and Data Volume in selecting databases, and are the old dusty data warehouses being replaced 21:50 - Curves and Cliffs in warehousing, some avenues are easier and cheaper than others 25:25 - The Data lake has changed the analysis process 29:50 - Rob pushes Conor into a long-awaited breakthrough, some failed projects from their past, and how the name "SharePoint" was almost given to a different product 34:55 - Let's go back to Conor The Celebrity, some good stories from Tom's Microsoft MVP days, and how Conor had no fear of the salty MVPs 46:50 - The "Query Store" isn't a place you go to purchase queries 55:00 - Keeping up with the competition: AWS and Babelfish 1:02:00 - The (ORIGINAL) Windows Phone debacle, and Windows Media PCs 1:06:20 - Doing presentations in the COVID-19 era and the future of the remote workplace at Microsoft 1:14:30 - Redmond's new buildings, and getting caught in the infinite loop that was the old Redmond facility design

In this episode we talk with Tracy Boggiano and William Durkin about Query Store, Open Query Store, and the fun of writing books. We also introduce a new feature that Andrew abuses and encourages the guests to abuse as well. GUESTS Tracy Boggiano Blog: http://databasesuperhero.com/ Twitter: https://twitter.com/TracyBoggiano William Durkin Blog: https://datamasterminds.io/blog/ Twitter: https://twitter.com/sql_williamd LINKS FROM THE SHOW Mixed Extents T-Shirts: https://www.bonfire.com/store/eightkb/ Posts from Tracy: https://tracyboggiano.com/archive/2018/06/query-store-error-state/ https://tracyboggiano.com/archive/2018/06/query-store-usage-and-adaptive-plan-tuning-usage/ Tracy at PASS Summit: https://www.pass.org/summit/2020/Learn/Session-Details/sid/104557 Tracy's Book: https://www.amazon.com/Query-Store-SQL-Server-2019/dp/1484250036 Links from William: Company: https://datamasterminds.io/ Open Query Store: https://www.openquerystore.com/ Data Grillen: https://datagrillen.com/ William's Books: https://www.amazon.com/William-Durkin/e/B073722MP7 Intro sound from Freesound: https://freesound.org/people/Kleber_KGF/sounds/354019/

In this episode we talk with Tracy Boggiano and William Durkin about Query Store, Open Query Store, and the fun of writing books. We also introduce a new feature that Andrew abuses and encourages the guests to abuse as well. GUESTS Tracy Boggiano Blog: http://databasesuperhero.com/ Twitter: https://twitter.com/TracyBoggiano William Durkin Blog: https://datamasterminds.io/blog/ Twitter: https://twitter.com/sql_williamd LINKS FROM THE SHOW Mixed Extents T-Shirts: https://www.bonfire.com/store/eightkb/ Posts from Tracy: https://tracyboggiano.com/archive/2018/06/query-store-error-state/ https://tracyboggiano.com/archive/2018/06/query-store-usage-and-adaptive-plan-tuning-usage/ Tracy at PASS Summit: https://www.pass.org/summit/2020/Learn/Session-Details/sid/104557 Tracy's Book: https://www.amazon.com/Query-Store-SQL-Server-2019/dp/1484250036 Links from William: Company: https://datamasterminds.io/ Open Query Store: https://www.openquerystore.com/ Data Grillen: https://datagrillen.com/ William's Books: https://www.amazon.com/William-Durkin/e/B073722MP7 Intro sound from Freesound: https://freesound.org/people/Kleber_KGF/sounds/354019/

Within Azure SQL maintenance tasks such as backups and integrity checks are handled for you, and while you may be able to get away with automatic updates keeping your statistics up-to-date, sometimes it's not enough. Proactively managing statistics in Azure SQL requires some extra steps, and in this Data Exposed episode with Erin Stellato, we'll step through how you can schedule and automate regular updates to statistics. [01:15] Overview of statistics[02:00] Schedule & automate updates to statistics demo[07:02] Runbooks Resources:SQL Server Maintenance SolutionSQL Server Index and Statistics MaintenanceAbout Erin Stellato:Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.About MVPs:Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram

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!

SQL Server keeps getting smarter! Richard talks to Erin Stellato about Query Store and Automatic Tuning. First introduced in SQL Azure, these features showed up in SQL Server 2016 and improved substantially in 2017. Erin describes Query Store as a kind of black box for databases, similar to an aircraft, but you don't need to wait for a crash to value the data stored in it. Query Store is a real-time record of the queries happening in your database, along with the query plan and what caused the query to wait. This leads to a ton of tuning opportunities, including automated tuning, where SQL Server will recommend indexes and other performance features for itself!

They made their index maintenance job smarter, and their queries got slower in production afterward. Could the index maintenance have harmed performance? In this episode... 00:50 Thinking about plan freezing in Query Store and multi-team process 03:15 This week's question about index maintenance and query performance

What is coming in SQL Server 2016? Richard chats with Brent Ozar about his thoughts on the upcoming version of SQL Server. The conversation digs into how the cloud is impacting SQL Server - features like Query Store were available first in the cloud are now showing up in this new on-premise edition! Speaking of Query Store, who wouldn't want a record of query plans so you can find out exactly why a query in production took a long time? Brent discusses other features including the stretch table to azure, always encrypted, row level security... the list goes on! The question is, when do we get this great version?

One of the new features being added to SQL Server 2016 is the Query Store which will allow for greater access to the performance history of your databases.  This is going to be extremely helpful when you are approached about 'What happened this morning?'  With the Query Store feature, you will now be able to provide some insight into that question. I chat with Borko Novakovic, the program manager for Query Store feature, and he shares with you, Compañeros, details about the new feature and how those interested in performance monitoring will be able to use this for their benefit.  Even if you aren't going to run SQL Server 2016 as soon as it comes out, you will find this information interesting and I hope it helps you along the SQL trail.  Have fun out there. You can find the show notes for today's episode at http://sqldatapartners.com/2015/12/29/query-store/

PASS Summit 2014 is over, and wh’re here for a recap of what happened, what was announced, what we learned in the sessions we attended, and some thoughts on the direction Microsoft is heading. Among other topics, we talk about: The summit keynote and the Microsoft vision Parallelism The new Query Store feature The new Stretched Tables feature Improvements to Cluster Quorum Backup performance improvements Database corruption recovery techniques Interesting behavior of Sequence with Delayed Durability The various activities during the summit And more.. Items mentioned in the show: PASS Summit 2014 Day 1 Keynote PASS Summit 2014 Day 2 Keynote Adam Machanic – Manhandling Paralellism, 2014 Edition Paul Randal – Advanced Data Recovery Techniques Allan Hirt – Did You Vote Today? A DBA’s Guide to Cluster Quorum Guy Glantser – Working with Very Large Tables Like a Pro in SQL Server 2014