Index Maintenance And Performance Dear SQL DBA podcast

Artwork

Tech News Sqlserver Sqlworkbooks News Web Development Tech Software Development Kendra Littles DBA Database

Player FM - Internet Radio Done Right

49 subscribers

Web Development

הוסף לפני nine שנים

תוכן מסופק על ידי Kendra Little. כל תוכן הפודקאסטים כולל פרקים, גרפיקה ותיאורי פודקאסטים מועלים ומסופקים ישירות על ידי Kendra Little או שותף פלטפורמת הפודקאסט שלהם. אם אתה מאמין שמישהו משתמש ביצירה שלך המוגנת בזכויות יוצרים ללא רשותך, אתה יכול לעקוב אחר התהליך המתואר כאן https://he.player.fm/legal.

A

All About Change

All About Change podcast artwork

All About Change podcast artwork

1
Eli Beer & United Hatzalah: Saving Lives in 90 seconds or Less 30:20

לפני 18 ימים30:20

הפעל מאוחר יותר

הפעל מאוחר יותר

30:20

Eli Beer is a pioneer, social entrepreneur, President and Founder of United Hatzalah of Israel. In thirty years, the organization has grown to more than 6,500 volunteers who unite together to provide immediate, life-saving care to anyone in need - regardless of race or religion. This community EMS force network treats over 730,000 incidents per year, in Israel, as they wait for ambulances and medical attention. Eli’s vision is to bring this life-saving model across the world. In 2015, Beer expanded internationally with the establishment of branches in South America and other countries, including “United Rescue” in Jersey City, USA, where the response time was reduced to just two minutes and thirty-five seconds. Episode Chapters (0:00) intro (1:04) Hatzalah’s reputation for speed (4:48) Hatzalah’s volunteer EMTs and ambucycles (5:50) Entrepreneurism at Hatzalah (8:09) Chutzpah (14:15) Hatzalah’s recruitment (18:31) Volunteers from all walks of life (22:51) Having COVID changed Eli’s perspective (26:00) operating around the world amid antisemitism (28:06) goodbye For video episodes, watch on www.youtube.com/@therudermanfamilyfoundation Stay in touch: X: @JayRuderman | @RudermanFdn LinkedIn: Jay Ruderman | Ruderman Family Foundation Instagram: All About Change Podcast | Ruderman Family Foundation To learn more about the podcast, visit https://allaboutchangepodcast.com/ Looking for more insights into the world of activism? Be sure to check out Jay’s brand new book, Find Your Fight , in which Jay teaches the next generation of activists and advocates how to step up and bring about lasting change. You can find Find Your Fight wherever you buy your books, and you can learn more about it at www.jayruderman.com .…

Dear SQL DBA « »
Index Maintenance and Performance

לפני 8 שנים 28:45

שתפו

MP3•בית הפרקים

תוכן מסופק על ידי Kendra Little. כל תוכן הפודקאסטים כולל פרקים, גרפיקה ותיאורי פודקאסטים מועלים ומסופקים ישירות על ידי Kendra Little או שותף פלטפורמת הפודקאסט שלהם. אם אתה מאמין שמישהו משתמש ביצירה שלך המוגנת בזכויות יוצרים ללא רשותך, אתה יכול לעקוב אחר התהליך המתואר כאן https://he.player.fm/legal.

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

… continue reading

82 פרקים

#Tech News #Sqlserver #Sqlworkbooks #News #Web Development #Tech #Software Development #Kendra Littles #DBA #Database

Artwork

Index Maintenance and Performance

49 subscribers

published לפני 8 שנים

שתפו

MP3•בית הפרקים

תוכן מסופק על ידי Kendra Little. כל תוכן הפודקאסטים כולל פרקים, גרפיקה ותיאורי פודקאסטים מועלים ומסופקים ישירות על ידי Kendra Little או שותף פלטפורמת הפודקאסט שלהם. אם אתה מאמין שמישהו משתמש ביצירה שלך המוגנת בזכויות יוצרים ללא רשותך, אתה יכול לעקוב אחר התהליך המתואר כאן https://he.player.fm/legal.

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

… continue reading

82 פרקים

#Tech News #Sqlserver #Sqlworkbooks #News #Web Development #Tech #Software Development #Kendra Littles #DBA #Database

כל הפרקים

×

Artwork

1
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques 1:04:36

לפני 52 weeks1:04:36

הפעל מאוחר יותר

הפעל מאוחר יותר

1:04:36

Erik Darling joins Kendra Little to rate different SQL Server Performance Tuning Techniques in episode 81 of the Dear SQL DBA podcast. We share our opinions of... (deep breath) Recompile hints, Query Store hints and plan forcing, CTEs, Resource Governor, the legacy cardinality estimator, Table Variables, Automatic Plan Correction, Batch Mode, index rebuilds, Hekaton, NOLOCK, page compression, partitioning, filtered indexes, columnstore, join hints, PSPO, indexed hints, indexed views, optimize for unknown, RCSI, adding more memory, restarting the damn thing, scalar UDFs, and Persisted Memory Grant Feedback.…

Artwork

1
Power BI Performance Tuning with Eugene Meidinger 53:54

לפני 1 year53:54

הפעל מאוחר יותר

הפעל מאוחר יותר

53:54

Eugene Meidinger stops by to chat about Power BI Performance Tuning with Kendra. We talk about the various engines and languages used in Power BI and big-picture strategies for getting performance from the start. Eugene then talks about the community of tools and techniques that can be used to dig in and solve performance problems in Power BI. Eugene's new Pluralsight course on Perf tuning Power BI launches on February 5th, 2024. The first 50 sales will be only $20. If you don't get one of those lucky spots, use code RACOONS to get 50% off. Find more of Eugene's content at sqlgene.com.…

Artwork

1
Automated Deployments and the Art of the Database with Database Michael J Swart 1:05:28

לפני 2 years1:05:28

הפעל מאוחר יותר

הפעל מאוחר יותר

1:05:28

In this episode, Michael J Swart joins the Dear SQL DBA podcast to talk about databases, automation, and how he’s come to illustrate some of the coolest blog posts ever to be written about data. Check out Michael’s art and blog posts at michaeljswart.com, and explore his posts by illustration at https://michaeljswart.com/browse-articles-by-illustration/ .…

Artwork

1
Jer and Kendar Explore Optimized Locking 28:57

לפני 2 years28:57

הפעל מאוחר יותר

הפעל מאוחר יותר

28:57

SQL Server has a new feature that’s currently only available in Azure SQL Database: Optimized Locking. Jeremiah Peschka joins the podcast to talk through the docs and nerd out on locks, blocks, and how to pronounce the acronym “LAQ”. Learn more about this feature online: Optimized locking article from Microsoft Learn Transaction locking and row versioning guide…

Artwork

1
Advice for Technical Leaders with Alex Robson 1:00:28

לפני 2 years1:00:28

הפעל מאוחר יותר

הפעל מאוחר יותר

1:00:28

Ever wondered what it's like to be a VP or Director of Engineering? Kendra chats with Alex Robson about leadership in technology, what you can get out of coaching or an MBA program (should you be interested), and what makes a high performing team. We'll also chat about recommended content to hone your tech leadership skills. Alex Robson's site and blog: https://robsonconsulting.services Alex's content recommendations for folks who want to think more about technical leadership: "I believe Camille Fournier and Will Larson are wonderful writers with invaluable insights and advice. For product thinking, I recommend folks read The Lean Startup by Eric Ries, Principles of Lean Product Development Flow by Don Reinertsen, Safer Sooner Happier by Jonathan Smart, and Accelerate by Dr. Nicole Forsgren. Be sure to read books on leadership that are outside of engineering. Dan Pink’s Drive and Eliyahu Goldratt’s The Goal are two of my usual recommendations. Last but not least - read books that are about human behavior. Both economists and psychologists ask important questions that may help you unlock better ways to relate to and understand others. I love Daniel Kahneman’s Thinking Fast and Slow, and highly recommend Mistakes Were Made (but not by me) by Carol Tavins and Elliot Aronson."…

Artwork

1
Erik Darling on Performance Tuning 52:45

לפני 2 years52:45

הפעל מאוחר יותר

הפעל מאוחר יותר

52:45

SQL Server performance tuning expert Erik Darling joins the podcast today to chat about how good queries can go bad, how bad queries can get better, and the question on everyone's mind: if he was a database, what database would he be? This episode contains some mildly explicit language. Erik's blog: https://erikdarlingdata.com/blog/ Erik's YouTube: https://www.youtube.com/@ErikDarlingData…

Artwork

1
What's up with Tech Interviews in 2023? With Jeremiah Peschka. 29:06

לפני 2 years29:06

הפעל מאוחר יותר

הפעל מאוחר יותר

29:06

Tech interviews are weird and wacky. How did they get this way, and how SHOULD they be? Jeremiah Peschka joins us to discuss.

Artwork

1
Data Roles: DBA, DBRE, and Data Engineer 24:52

לפני 2 years24:52

הפעל מאוחר יותר

הפעל מאוחר יותר

24:52

There are lots of jobs for data folks. In this episode, I'm discussing three hot job titles: Database Administrator (DBA), Database Reliability Engineer (DBRE), and Data Engineer (DE) To see the venn diagrams I made for these roles, visit https://catalyzesql.com/blog/1/01/01/dear-sql-dba-data-roles-dba-dbre-de/…

Artwork

1
When NOT to choose SQL Server to store your data 14:19

לפני 2 years14:19

הפעל מאוחר יותר

הפעל מאוחר יותר

14:19

I wrote a blog post inspired by Stephen Vakil 's excellent suggested interview question, but I inverted it: When should you NOT choose SQL Server to store your data? My thoughts: * When you don't actually need a database * When you're not using structured data * When you want pure analytics, or something other than a workload involving OLTP * When you need to write to multiple nodes for a single database * When your team wants a PAAS solution (lil pedantic on this, the hosted versions are slightly different) * When your team needs a cheap solution What do you think? This podcast is available in blog post form: https://littlekendra.com/2023/06/21/when-not-to-choose-sql-server/…

Artwork

1
Down Tools Week 2020 9:52

לפני 5 years9:52

הפעל מאוחר יותר

הפעל מאוחר יותר

9:52

It's Down Tools Week at Redgate. I share what "Down Tools Week" is, what I'm working on this week, and why I think it's a terrific experience for fostering creativity, innovation, and teamwork. In closing I share some thoughts on variations of this kind of project which you might use in your own organization, whether you are a developer, DBA, or have another role.…

Artwork

1
3 Things That Shouldn't Be Normal in Database Development 28:12

לפני 5 years28:12

הפעל מאוחר יותר

הפעל מאוחר יותר

28:12

Many people use entrenched processes for database development that have been in place so long that it's hard to imagine doing it any other way. In this episode, I share three things that should NOT be normal for database development-- but which are incredibly common. This episode is inspired by the book, "The Unicorn Project", by Gene Kim.…

Artwork

1
Everything I Never Wanted to Know about Collation 13:53

לפני 5 years13:53

הפעל מאוחר יותר

הפעל מאוחר יותר

13:53

I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way. In this episode I share the basics, along with helpful resources to learn more. One small localization correction: the default collation on a SQL Server install will be "the oldest available version that's associated with each specific locale." So if your Windows installation has a different localization than mine (which are generally English USA), then you'll see a different default collation -- but it still won't be the recommended collation for *new* development.…

Artwork

1
The Manager's Guide to Git Training for DBAs 19:02

לפני 5 years19:02

הפעל מאוחר יותר

הפעל מאוחר יותר

19:02

Learning Git can be daunting for DBAs. In this 20 minute episode, I discuss why learning a VCS is necessary for DBAs, then give three tips on scoping your project, choosing the right tools, and making sure the project is successful. The cheat sheet I mention in the episode is at https://littlekendra.com/2019/11/27/my-git-cli-cheat-sheet/…

Artwork

1
How Do Developers and DBAs Collaborate in a DevOps World? 41:07

לפני 6 years41:07

הפעל מאוחר יותר

הפעל מאוחר יותר

41:07

You're a DBA, and your development team is all-in on doing DevOps, and they want to include the database. Should your DBA team limit the permissions or options for automation? Or should you instead re-think how your two teams work together? In this episode, Kendra discusses DevOps team topologies, the changing role of DBA teams in DevOps, and the opportunities available in creating communities of practice around database development.…

Artwork

1
What a Software Evangelist Does - and Where the Job is Going 21:25

לפני 6 years21:25

הפעל מאוחר יותר

הפעל מאוחר יותר

21:25

I've been working as an 'Evangelist' at Redgate for close to six months now, and one question keeps coming up: what exactly does an Evangelist do at a software company? In 21 minutes, I explain the core mission of Evangelists, and why I think being part of the sales process is an important part of the future of software evangelism.…

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
Love and Hate for SSMS 17:21

לפני 8 years17:21

הפעל מאוחר יותר

הפעל מאוחר יותר

17:21

People have strong feelings about SQL Server Management Studio: they love it AND they hate it. In this week's episode, I talk about why people have such conflicting feelings about SSMS, and how to work it all out.

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
How Do I Analyze a SQL Server Execution Plan? 26:18

לפני 8 years26:18

הפעל מאוחר יותר

הפעל מאוחר יותר

26:18

A query is slow, and you figure out how to collect the query execution plan. Now what? In this episode I talk "big picture" about what execution plans are, what "cost" is, why to collect "compiled for" values, and the steps I take to analyze execution plans while performance tuning queries.

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
Do I Need to Master PowerShell? 9:06

לפני 8 years9:06

הפעל מאוחר יותר

הפעל מאוחר יותר

9:06

As a SQL Server DBA, do you need to be a killer with scripts? In this episode I talk about how much you need to know about PowerShell, and examples of ways I personally use (and struggle with) PowerShell.

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
SQL PASS Summit 2017: Why I'm Excited, and Tips on Attending 18:25

לפני 8 years18:25

הפעל מאוחר יותר

הפעל מאוחר יותר

18:25

I'll be attending and presenting at the SQL PASS Summit in Seattle Washington this year from Oct 31-Nov 3. In this week's episode, I share why I'm excited about going, and why I've purchased a seat for a pre-conference session. (Spoiler: pre-cons are awesome!) I also give my tips on how to get the MOST value out of a big conference like the PASS Summit.…

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
How Do You Stay Motivated? 14:51

לפני 8 years14:51

הפעל מאוחר יותר

הפעל מאוחר יותר

14:51

Over the years, readers have asked me: "How do you stay motivated?" Sticking with a learning plan, blogging, or becoming a public speaker isn't easy. In this episode I share how I think about motivation and what keeps me going.

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
"I faked my resume... now what?" 13:34

לפני 8 years13:34

הפעל מאוחר יותר

הפעל מאוחר יותר

13:34

This week's question from a reader: how do I deal with interview questions asking about real-world scenarios when I've faked three years of experience on my resume?

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
Interview Advice from the SQL Server Community 8:25

לפני 8 years8:25

הפעל מאוחר יותר

הפעל מאוחר יותר

8:25

In this episode, I talk about three articles written by members of the SQL Server community on interviewing that I can't stop thinking about: "Playing the Third Party Recruiter Game", by Adam Machanic - http://sqlblog.com/blogs/adam_machanic/archive/2017/08/08/playing-the-third-party-recruiter-game-t-sql-tuesday-093.aspx "I Hate Interviews", by Rob Sewell - https://sqldbawithabeard.com/2017/08/08/i-hate-interviews-tsql2sday/ "Learning to say 'No'" by Mark Broadbent - https://tenbulls.co.uk/2017/08/08/learning-to-say-no/…

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
Interview Patterns and Anti-Patterns 15:38

לפני 8 years15:38

הפעל מאוחר יותר

הפעל מאוחר יותר

15:38

Hear the story of an interview where my dreams were crushed - and what I learned about interviewing from the experience.

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
Which Queries are Causing my Wait Stats? 34:45

לפני 8 years34:45

הפעל מאוחר יותר

הפעל מאוחר יותר

34:45

You've got some troubling wait stats in SQL Server. How can you tell which queries are causing those waits? Kendra discusses the pros and cons of different techniques to track down the cause of both common and tricky waits in SQL Server, including CXPACKET, PAGEIOLATCH, LCK, RESOURCE_SEMAPHORE, and THREADPOOL waits.…

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
Removing Query Hints with Plan Guides 29:49

לפני 8 years29:49

הפעל מאוחר יותר

הפעל מאוחר יותר

29:49

If you need to add, remove, or replace hints from ad-hoc queries and you can't change the code, plan guides can help. See a demo of removing hints from parameterized TSQL run from an application, and get tips on how to make your plan guides work in SQL Server. Get code samples from this episode here: https://sqlworkbooks.com/2017/05/removing-query-hints-with-plan-guides-dear-sql-dba-episode-43/…

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
Batch Mode Hacks in SQL Server 30:33

לפני 8 years30:33

הפעל מאוחר יותר

הפעל מאוחר יותר

30:33

Learn what batch mode is in SQL Server, and how you can trick SQL Server into using it (even without a "real" columnstore index). For clickable links and demo code, head to https://sqlworkbooks.com/2017/05/batch-mode-hacks-for-rowstore-queries-in-sql-server/

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
Should I Get Certified as a DBA? 17:30

לפני 8 years17:30

הפעל מאוחר יותר

הפעל מאוחר יותר

17:30

Find out if getting certified will help you land an entry level DBA job, and if you do want to get certified, get Kendra's tips on preparing for the exam.

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
How Does a DBA Build Confidence After Making Mistakes? 19:32

לפני 8 years19:32

הפעל מאוחר יותר

הפעל מאוחר יותר

19:32

Ever had a database change go horribly wrong? It can feel awful in the moment, then eat away at your confidence for days afterward. In this 20 minute episode Kendra gives you practical steps that help you cope with change over the course of your DBA career.

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
Are Bad Statistics Making My Query Slow? 35:02

לפני 8 years35:02

הפעל מאוחר יותר

הפעל מאוחר יותר

35:02

An important query is suddenly slow. Is it because statistics are out of date? This is tricky to figure out, and updating statistics right away can make troubleshooting even harder. Learn how to use query execution plans to get to the heart of the question and find out if stats are really your problem, or if it's something else. In this 35 minute episode: 00:39 SQL Server 2017 Announced 01:10 New video from Microsoft's Joe Sack demonstrating Adaptive Query Processing 03:05 This week's question: Are bad stats making my query slow? 05:26 Demo of finding plan in cache and analyzing stats begins 28:17 What to do when stats ARE the problem Code samples: https://gist.github.com/LitKnd/f07848d59cedc61fd057d12ab966f703 Links from the episode: SQL Server 2017 Adaptive Query Processing video by Joe Sack: https://www.youtube.com/watch?v=szTmo6rTUjM&feature=youtu.be Michael J Swart on finding Dark Matter Queries: http://michaeljswart.com/2017/04/finding-your-dark-queries/ Got a question for Dear SQL DBA? https://SQLWorkbooks.com/ask…

D

Dear SQL DBA

Dear SQL DBA podcast artwork

1
Index Maintenance and Performance 28:45

לפני 8 years28:45

הפעל מאוחר יותר

הפעל מאוחר יותר

28:45

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…

ברוכים הבאים אל Player FM!

Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.

תקשיבו ל-500+ נושאים

מדריך עזר מהיר

פודקאסטים מובילים

מכביבול ברדיו תל אביב

הזווית - פודקאסט

בכל יום נתון - אוריאל דסקל וראם שרמן

עושים חשבון Osim Heshbon

טייכר וזרחוביץ' ברדיו תל אביב

טייכר וזרחוביץ' - מערכונים

גיבור תרבות Culture Hero

סרטים זה אנחנו - מגזין קולנוע

עושים תוכנה Osim Tochna

השבוע - פודקאסט הארץ

המשחק הגדול

חושבים טוב

המעבדה The Lab

מדע בגובה האוזניים

סליחה על השאלה - ההסכת You Can't Ask That Podcast

סיפור ישראלי

עבר פלילי

Lets Talk Murder | בואי נדבר רצח

Lets Talk Murder | בואי נדבר רצח

האזן לתוכנית הזו בזמן שאתה חוקר