Erik Darling And Kendra Little Rate SQL Server Perf Tuning Techniques Dear SQL DBA podcast

Player FM - Internet Radio Done Right

128 subscribers

اضافه شده در seven سال پیش

محتوای ارائه شده توسط Kendra Little. تمام محتوای پادکست شامل قسمت‌ها، گرافیک‌ها و توضیحات پادکست مستقیماً توسط Kendra Little یا شریک پلتفرم پادکست آن‌ها آپلود و ارائه می‌شوند. اگر فکر می‌کنید شخصی بدون اجازه شما از اثر دارای حق نسخه‌برداری شما استفاده می‌کند، می‌توانید روندی که در اینجا شرح داده شده است را دنبال کنید.https://fa.player.fm/legal

Species Unite

1
Andrew Stein: Living with Lions 46:39

۶ روز پیش46:39

پخش در آینده

لیست ها

پسندیدن

دوست داشته شد

46:39

“If we march into that village and we start trying to persecute people for using poison, something that's very illegal, nobody's going to talk to us. We're not going to find out where the poison came from. We're not going to be able to shut anything down. We should take the approach that people are using poison because they're desperate, because they see no other alternative.” – Andrew Stein Andrew Stein is a wildlife ecologist who spent the past 25 years studying human carnivore conflict from African wild dogs and lions in Kenya and Botswana to leopards and hyenas in Namibia. His work has long focused on finding ways for people and predators to coexist. He is the founder of CLAWS , an organization based in Botswana that's working at the intersection of cutting-edge wildlife research and community driven conservation. Since its start in 2014 and official launch as an NGO in 2020, CLAWS has been pioneering science-based, tech-forward strategies to reduce conflict between people and carnivores. By collaborating closely with local communities, especially traditional cattle herders, CLAWS supports both species conservation and rural livelihoods—making coexistence not just possible, but sustainable.…

Dear SQL DBA »
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques

حدود یک سال پیش 1:04:36

اشتراک گذاری

MP4•خانه قسمت

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.

82 قسمت

#Prog Languages #Tech News #Sqlserver #Sqlworkbooks #Tech #News #Kendra Littles #DBA #Database

Dear SQL DBA

Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques

Dear SQL DBA

128 subscribers

published حدود یک سال پیش

اشتراک گذاری

MP4•خانه قسمت

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)

82 قسمت

#Prog Languages #Tech News #Sqlserver #Sqlworkbooks #Tech #News #Kendra Littles #DBA #Database

همه قسمت ها

Dear SQL DBA

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

47 weeks پیش1: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.…

Dear SQL DBA

1
Power BI Performance Tuning with Eugene Meidinger 53:54

1 year پیش53: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.…

Dear SQL DBA

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

۲ years پیش1: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/ .…

Dear SQL DBA

1
Jer and Kendar Explore Optimized Locking 28:57

۲ years پیش28: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…

Dear SQL DBA

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

۲ years پیش1: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."…

Dear SQL DBA

1
Erik Darling on Performance Tuning 52:45

۲ years پیش52: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…

Dear SQL DBA

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

۲ years پیش29: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.

Dear SQL DBA

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

۲ years پیش24: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/…

Dear SQL DBA

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

۲ years پیش14: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/…

Dear SQL DBA

1
Down Tools Week 2020 9:52

۵ years پیش9: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.…

Dear SQL DBA

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

۵ years پیش28: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.…

Dear SQL DBA

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

۵ years پیش13: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.…

Dear SQL DBA

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

۵ years پیش19: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/…

Dear SQL DBA

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

۶ years پیش41: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.…

Dear SQL DBA

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

۶ years پیش21: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.…

به Player FM خوش آمدید!

Player FM در سراسر وب را برای یافتن پادکست های با کیفیت اسکن می کند تا همین الان لذت ببرید. این بهترین برنامه ی پادکست است که در اندروید، آیفون و وب کار می کند. ثبت نام کنید تا اشتراک های شما در بین دستگاه های مختلف همگام سازی شود.

به بیش از 500 موضوع گوش کنید

128 subscribers

مشابه Dear SQL DBA

پادکست هایی که ارزش شنیدن دارند

Dear SQL DBA » Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques

Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques

پادکست هایی که ارزش شنیدن دارند

به Player FM خوش آمدید!

مشابه Dear SQL DBA

راهنمای مرجع سریع

Dear SQL DBA »
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques