Lock Timeouts & Memory

Dear SQL DBA

Player FM - Internet Radio Done Right

22 subscribers

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

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

Curated Questions: Conversations Celebrating the Power of Questions!

1
Ashley Kirsner 1:40:41

14 روز پیش1:40:41

پخش در آینده

لیست ها

پسندیدن

دوست داشته شد

1:40:41

Episode Notes [00:00] The Power of Vulnerability [01:57] Meet Ashley Kirsner [03:55] The Impact of Active Listening [05:02] A Transformative Call [06:25] The Magic of Open-Ended Questions [13:28] The Role of Basic Needs in Emotional Well-being [17:10] The Birth of Skip the Small Talk [25:18] The First Skip the Small Talk Event [28:39] The Evolution of Skip the Small Talk [32:56] Online Events During COVID-19 [34:58] Work At An Anxiety Lab [38:08] The Importance of Positive Questions [42:40] The Power of Repeated Questions [45:33] Attending a Skip the Small Talk Event [46:14] The Speed Dating Format [47:21] Encouraging Anxious Participants [48:45] The Power of Sharing Deeply [49:32] Consistent Findings on Vulnerability [50:13] Understanding Oversharing [51:11] Structure and Time Management [52:18] Facilitators and Norms [53:12] Contact Information Norms [55:06] Intentional Iteration and Safety [56:37] The Role of Participants [59:01] Financial Accessibility and Investment [01:00:43] Balancing Accessibility and Compensation [01:01:49] Compensating Facilitators [01:04:39] Physiological Benefits of Deep Conversations [01:07:00] Research on Loneliness and Connection [01:09:02] The Impact of Loneliness on Health [01:10:41] The Role of Sleep in Connection [01:13:42] The Importance of Group Interactions [01:15:10] The Power of Intentional Conversations [01:20:26] Learning from Gathering Experts [01:23:19] Right Now Question & Following Curiosity [01:30:18] Where You Can Find Skip The Small Talk [01:35:45] Takeaway Thoughts & Questions Resources Mentioned Skip The Small Talk Chris Voss Finding Good with Brian Fretwell Dr. Nicholas Epley DBT - Dialectical Behavioral Therapy Brene Brown How We Gather by Priya Parker Power of Ritual by Casper ter Kuile How We Gather by Dr. Angie Thurston - Harvard Divinity School Death of Rasputin Harvard Graduate School of Education Harvard Wharton Business School MIT GE Aviation Act Blue Beauty Pill Producer Ben Ford Questions Asked When did you first understand the power of questions? How would this possibly work? What are we doing here? How could this possibly be effective? What is it that asking questions actually does for us? In this deep end of the pool, for what you experience as a suicide hotline counselor, what does that look like? How did that impact you? Were there questions that you found most impactful on that end? Are you feeling suicidal right now? Do you have a weapon? Do you have a plan? Do you have any objects to complete that plan with you right now? Are you comfortable being in a different room from it while we're having this conversation? When's the last time you slept? When's the last time you ate? Can we get some food in you? Can we take a walk? Do they know anything you're experiencing right now? If the roles were reversed and it were your partner or your cousin or your parent who were going through something like this, would you want them to tell you about it? Do you think they wanna know if you're going through a tough time? What if we had a space where we were all on the same page? Can you take a moment to go home and be a little more vulnerable with your roommate, partner, family, or neighbors? Can you take that skill with you into the rest of your life? How are you doing right now? How did you decide to do your first skip-the-small-talk event? When's the next one gonna be? Is this even possible? How do you have people switch partners in a way that makes sense online? How do we do this? What do you got for us? How do we do this for like hundreds of people? Can you talk about that story of where you pulled the questions from, and why you chose the different questions that you did? Where do you live? What do you like about where you live? What's the worst thing you've ever experienced? When's the last time you cried? When's the last time you experienced awe? What's something you're proud of that you don't normally get to share with people or that might not be on a resume? Specifically asking what are pieces of yourself that you don't normally get to share? What is a favorite ice cream? What was something that this organization has done right to help you? What do you think it is about the structure that allows for that to happen? What other elements are at play here? Finances would be a barrier, can you help me out? Do you wanna do it for free? Due to your position in society, does it make you more or less likely to go to prison? How can we do subtle things so that you don't have to necessarily out yourself as having an invisible disability, but still get your needs met? How can we make people with marginalized identities feel comfortable opening up? How do we make those spaces feel safer? What is your right now question? What makes an experience awesome? What makes storytelling awesome? Why was this moment so powerful? Why do we dim the lights a little at dinner parties What little things can you do to trick your physiology to be more immersed in an experience? Does doing a new novel activity with someone, trick your brain into being more excited about hanging out with someone? How can you make these memories more tactile? What does the tablecloth feel like? What do the napkins feel like? Can you just do five more of these? Can we do this throughout the year? What assumptions are you making about how much others want to know about your inner world, and how might testing those assumptions change your relationships? How might your community benefit from structured opportunities to practice deeper connection, and what role could you play in creating those spaces? If you treated meaningful conversation as essential to your health, as sleep or exercise, how would that change your daily priorities and choices? Are your questions designed to extract information or to create conditions where others can share the best parts of themselves?…

۸ سال پیش 19:17

MP3•خانه قسمت

The dev server got bogged down during a deployment and lock timeouts were everywhere. Was the perfmon counter way off about how much memory was being used just for locks? In this episode...

00:33 What's new @ SQL Workbooks: Down the Rabbit Hole 03:00 This week's question about lock timeouts & memory in SQL Server

82 قسمت

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

Dear SQL DBA

Lock Timeouts & Memory

Dear SQL DBA

22 subscribers

published ۸ سال پیش

اشتراک گذاری

MP3•خانه قسمت

The dev server got bogged down during a deployment and lock timeouts were everywhere. Was the perfmon counter way off about how much memory was being used just for locks? In this episode...

00:33 What's new @ SQL Workbooks: Down the Rabbit Hole 03:00 This week's question about lock timeouts & memory in SQL Server

82 قسمت

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

همه قسمت ها

Dear SQL DBA

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

1 year پیش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

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

Dear SQL DBA

1
DBA Jobs: Threats and Opportunities 34:36

۷ years پیش34:36

34:36

Jobs change over time, and database administrator jobs are no different. In this 35 minute recorded Twitch livestream (my first ever!) I talk about threats to DBA jobs and the related opportunities.

Dear SQL DBA

1
DevOps Terms - and Why They Matter to Database Specialists 19:31

۷ years پیش19:31

19:31

In this session, I discuss scrum, continuous deployment, test driven development, DevOps, and related concepts. I close with a quick discussion of why Database Administrators and Developers should care about DevOps.

Dear SQL DBA

1
Employee Agreements & Contracts - Best Practices 23:00

۷ years پیش23:00

23:00

So you've got an employee agreement in front of you: now what? In this 23 minute episode, I talk about practical steps you should take to make sure that you understand the terms of your contract, and how to potentially negotiate the terms.

Dear SQL DBA

1
Employee Agreements & Contracts for DBAs & Developers - Anti-Patterns 31:20

۷ years پیش31:20

31:20

When you take a new job in software engineering or in IT, within the paperwork there often lurks an employee agreement: a contract between you and your employer. In this half-hour live episode we'll talk about why these contracts exist, and multiple anti-patterns you should avoid. This is the first of a two part series. In the next episode, we'll talk best practices for understanding and negotiating the contract.…

Dear SQL DBA

1
Remembering Robert Davis, DBA Hero 19:34

۷ years پیش19:34

19:34

What makes a person a DBA Hero? In this episode, I talk about how Robert Davis made a huge impact on the SQL Server community, and the traits that Robert displayed that I hope to emulate.

Dear SQL DBA

1
Why Don't You Teach Service Broker? 23:17

۷ years پیش23:17

23:17

I've gotten a few questions about whether I recommend learning Service Broker, and recently I was asked if I'm planning to make any courses on Service Broker. In this episode, I talk about why I personally haven't become an expert with Broker, the factors that I believe play into Service Broker adoption, and other resources online for learning Service Broker in SQL Server.…

Dear SQL DBA

1
Training Resources for SQL Noobs 29:10

۷ years پیش29:10

29:10

New to learning SQL Server? Get the scoop on free online resources to look up information, ask questions of community members, and learn SQL Server from the ground up. Links from the episode are at: https://sqlworkbooks.com/dear-sql-dba/training-resources-for-sql-noobs/

Dear SQL DBA

1
Dealing With a Lack of Control as a DBA 34:44

۷ years پیش34:44

34:44

This week I discuss a question that I've gotten in many forms over the years - a lot of the scenarios are so specific that it's hard to keep them anonymous, but they can be generalized as a bigger problem: how do I deal with being responsible for things that I can't fully control? DBAs have huge responsibilities, so this is a common, frustrating scenario. In this episode, I talk about a few times that I've experienced this in my own life, what techniques didn't work, and what strategies were more effective.…

Dear SQL DBA

1
Do DBAs Need College Degrees? 31:06

۷ years پیش31:06

31:06

Our question this week comes from someone who's excited to be on a healthy career path, building their work experience as a DBA. They're worried: will lacking a college degree block their career growth down the line? I talk about my experience and also check out current job listings to answer the question.…

Dear SQL DBA

1
How Do I Prepare for Certification Exams? 29:31

۷ years پیش29:31

29:31

In this episode, I talk about how to strategize for and prepare for Microsoft Certification exams, using the Database Fundamentals exam as an example.

Dear SQL DBA

1
I Want to Work for Myself 31:32

۷ years پیش31:32

31:32

Our question this week comes from an IT pro who would like to be self-employed. In this episode, I talk about three big things you need to think about to start working for yourself, and two possible paths to get there.

Dear SQL DBA

1
Auto-Tuning and the #1 Mindset Problem I had as a DBA 18:10

۸ years پیش18:10

18:10

A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs in SQL Server? In this week's episode, I talk about why I'm excited about those features rather than afraid of them. Digging into this problem, I share the #1 mindset problem I had as a DBA, why this mindset is so common among database professionals, and a daily habit that can change your approach to new technology.…

Dear SQL DBA

1
Slowing Down Your Motor Mouth - Presentation Tips for Fast Talkers 18:13

۸ years پیش18:13

18:13

Are you worried that you talk too fast when you give a speech, talk, or presentation? Is fear being a fast-talker one of the concerns that keeps you from getting started with public speaking? In this episode, I give you simple, practical tips that I've used to successfully improve the way I give presentations. Four years ago, I got frustrated feedback from listeners who had a hard time keeping up with my mouth; now I get congratulations that the pace was great.…

Dear SQL DBA

1
I Thought I Was An Introvert. Turns Out I Was Anxious as #@*( 43:46

۸ years پیش43:46

43:46

In this week's episode, I'm not answering a reader's question. Instead, I'm talking about my personal experience with anxiety. This episode touches on on healthcare, religion, and squishy emotions -- and there's at least one curse word. I don't talk tech in this episode. (Don't worry, there's more of that coming in future weeks.)…

Dear SQL DBA

1
The Death of SQL Server Service Packs 11:32

۸ years پیش11:32

11:32

SQL Server Service Packs are going away, starting with SQL Server 2017. I talk about why I think this is a good thing, and discuss Cumulative Updates, Service Packs, and the process of updating SQL Server.

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

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