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

Dear SQL DBA

Player FM - Internet Radio Done Right

49 subscribers

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

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

TED Business

1
The trick to powerful public speaking | Lawrence Bernstein 17:27

לפני 19 weeks17:27

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

רשימות

לייק

אהבתי

17:27

Why do so many of us get nervous when public speaking? Communication expert Lawrence Bernstein says the key to dealing with the pressure is as simple as having a casual chat. He introduces the "coffee shop test" as a way to help you overcome nerves, connect with your audience and deliver a message that truly resonates. After the talk, Modupe explains a similar approach in academia called the "Grandma test," and how public speaking can be as simple as a conversation with grandma. Want to help shape TED’s shows going forward? Fill out our survey ! Become a TED Member today at ted.com/join Hosted on Acast. See acast.com/privacy for more information.…

לפני 8 שנים 18:10

MP3•בית הפרקים

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.

82 פרקים

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

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

Dear SQL DBA

49 subscribers

published לפני 8 שנים

שתפו

MP3•בית הפרקים

82 פרקים

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

כל הפרקים

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

לפני 1 year1: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.…

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.…

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/ .…

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…

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."…

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…

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.

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/…

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/…

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.…

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.…

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.…

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/…

לפני 8 years18:10

18:10

Dear SQL DBA

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

לפני 8 years18: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

לפני 8 years43: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

לפני 8 years11: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.

Dear SQL DBA

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.

Dear SQL DBA

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.

Dear SQL DBA

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.

Dear SQL DBA

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.…

Dear SQL DBA

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.

Dear SQL DBA

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?

Dear SQL DBA

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/…

Dear SQL DBA

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.

Dear SQL DBA

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.…

Dear SQL DBA

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/…

Dear SQL DBA

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/

Dear SQL DBA

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.

Dear SQL DBA

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.

Dear SQL DBA

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…

Dear SQL DBA

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…

Dear SQL DBA

1
Lock Timeouts & Memory 19:17

לפני 8 years19:17

19:17

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…

Dear SQL DBA

1
Why is my Transaction Log Growing in My Availability Group? 29:45

לפני 8 years29:45

29:45

A database transaction log is expanding, even though the DBA is running log backups and doesn't see an open transaction? What's going on with this Availability Group? Timestamps in this episode if you want to skip ahead: 00:49 What's new @ SQL Workbooks 03:22 Info on SQLPASS Summit Content Survey & a heads-up for aspiring precon speakers 05:35 This week's question about t-log growth…

Dear SQL DBA

1
When SQL Server Does NOT Use Write Ahead Logging 23:28

לפני 8 years23:28

23:28

A few episodes ago, I talked about how learning about Write Ahead Logging was a light bulb moment for me, and helped me learn tons of concepts about backups and recovery. This week, we talk about when SQL Server turns things upside down and doesn't use write ahead logging: and what it has to do for recovery in these special cases.…

Dear SQL DBA

1
Using a Tail Log Backup in a SQL Server Migration 13:32

לפני 8 years13:32

13:32

When you migrate a database, it can be useful to prove that you moved all the data and didn't miss any transactions. Learn how to use a tail log backup in a migration scenario.

Dear SQL DBA

1
Stack Dumps in SQL Server 20:57

לפני 8 years20:57

20:57

Learn what a Stack Dump is in SQL Server. Hear what happens when Kendra causes a stack dump against a test SQL Server instance under load. Learn how to find information about stack dumps on your SQL Server, and how to escalate them when required.

Dear SQL DBA

1
WAL: The concept that makes recovery models & backups make sense 18:04

לפני 8 years18:04

18:04

When you're a Junior DBA, it's really hard to take in all the information out there. Learn about write ahead logging: the concept that can help you make sense of recovery models and backup strategies in SQL Server. Kendra tells the story of the "Wow!" moment when she learned about write ahead logging from Kimberly Tripp of SQLSkills.com, and explains how this all works in SQL Server.…

Dear SQL DBA

1
Will the Cloud Eat My DBA Job? 28:29

לפני 8 years28:29

28:29

Will cloud services render DBAs obsolete? Does the cloud mean that developers will use less of SQL Server? Kendra talks about the future of database administration and gives tips on strategizing your career.

Dear SQL DBA

1
Confused by sp_Who2 14:38

לפני 8 years14:38

14:38

Learn why the output from the built-in procedure sp_who2 can be so confusing, how to get more information, and free tools that can make it easier to figure out what you need to pay attention to in SQL Server.

Dear SQL DBA

1
Should I Learn Full-Text Indexing? 18:19

לפני 8 years18:19

18:19

Learn where full-text search shines, a common problem which full-text search does NOT solve, where full-text can run into performance problems.

Dear SQL DBA

1
Index Types: Heaps, Primary Keys, Clustered and Nonclustered Indexes 26:45

לפני 8 years26:45

26:45

Learn the difference between heaps, clustered and nonclustered indexes, primary keys, and columnstore indexes in SQL Server.

Dear SQL DBA

1
What's that Garbage in my Execution Plan? 17:46

לפני 8 years17:46

17:46

Learn how to approach the unexpected in a mysterious execution plan that contains way more operators than expected for a very simple SQL Server query.

Dear SQL DBA

1
Why You Should Switch in Staging Tables Instead of Renaming Them 11:24

לפני 8 years11:24

11:24

Performing a switcharoo between new and old tables can cause blocking nightmares. Partition switching may help, surprisingly even on non-partitioned tables.

Dear SQL DBA

1
Limiting Downtime for Schema Changes in SQL Server 27:44

לפני 8 years27:44

27:44

You need to release schema changes while the SQL Server is in use. Learn why code generation tools write odd scripts and how to stay sane amid rapid releases.

Dear SQL DBA

1
Signs Your SQL Server is Running with Scissors 22:56

לפני 9 years22:56

22:56

Does your team know what it's doing with SQL Server? Learn what a consultant looks for when assessing a team, and signs that SQL Server may be badly configured.

Dear SQL DBA

1
Why is My Query Faster on the Second Run? 25:31

לפני 9 years25:31

25:31

The first time you test a query it's slow, but when you run it again, it's much faster. Learn how SQL Server uses memory to make the second run much faster.

Dear SQL DBA

1
Should I Upgrade to SQL Server 2016? 23:59

לפני 9 years23:59

23:59

Learn why SQL Server 2016 SP1 is a game changer, and how to take best advantage of all the cool features now in Standard and Web Editions.

Dear SQL DBA

1
What's Adaptive Query Processing? 23:49

לפני 9 years23:49

23:49

Learn about new features to speed up SQL Server queries. Kendra talks about automatic index tuning and speculates about Adaptive Query Processing.

Dear SQL DBA

1
Where Do You Get Your Creativity? (Dear SQL DBA Episode 20) 22:26

לפני 9 years22:26

22:26

As a database administrator or developer, you'll get into trouble fast if you try to force all your code and processes into a database shaped hole. You have to be creative when you problem solve -- and when you communicate! So how do you cultivate creativity?

Dear SQL DBA

1
Should You Rebuild or Reorganize Large Indexes? 23:23

לפני 9 years23:23

23:23

The bigger your indexes are, the harder your index maintenance falls. Is it better to rebuild big indexes? Or should you reorganize? Learn the pros and cons of each command and other options.

Dear SQL DBA

1
Can I Use Statistics to Design Indexes? 19:43

לפני 9 years19:43

19:43

Should you look at automatically created statistics on your tables in SQL Server to help you design better indexes?

Dear SQL DBA

1
Setting up Free Blocking Alerts and Deadlock Monitoring 20:53

לפני 9 years20:53

20:53

What tools in SQL Server will notify you about blocking and help track the queries behind your toughest blocking and deadlocking problems?

Dear SQL DBA

1
Which is Worse: an Unused Index, or an Un-Indexed Foreign Key? 17:02

לפני 9 years17:02

17:02

Should you always index your foreign keys? What if you index them, and then the index never gets used?

Dear SQL DBA

1
Finding Your Voice as a Speaker 11:37

לפני 9 years11:37

11:37

Learn what it's like to find and develop your voice as a technical speaker in this week's episode.

Dear SQL DBA

1
Collect and Baseline Wait Statistics 17:24

לפני 9 years17:24

17:24

What are the best tools to collect and baseline wait statistics? Should you write your own?

Dear SQL DBA

1
Developer Seeks DBA Career 15:08

לפני 9 years15:08

15:08

A C# developer wants to be a DBA, but is having a hard time landing a job. Should they take a pay cut and go for a Junior level job? Or could there be another path?

Dear SQL DBA

1
Teach Yourself SQL Server Performance Tuning 19:49

לפני 9 years19:49

19:49

You'd love to have a job tuning SQL Servers, but you don't have an environment to practice in. Here's how to teach yourself performance tuning and prepare yourself to land and succeed in job interviews.

Dear SQL DBA

1
Altering an INT Column to a BIGINT 20:39

לפני 9 years20:39

20:39

You need to change an INT column to a BIGINT in a large table. Learn why this schema change can make your transaction log explode, and how to avoid it.

Dear SQL DBA

1
Should I Automate Windows Updates for SQL Server? 16:49

לפני 9 years16:49

16:49

Your boss wants you to automate patching for your SQL Servers. Is that a good idea? How far should you take it? Find out a DBAs perspective.

Dear SQL DBA

1
Why Upgrades can Cause Performance Regression 27:05

לפני 9 years27:05

27:05

Learn what can cause performance regressions after migrating to a new SQL Server version, and how to troubleshoot it.

Dear SQL DBA

1
Max Degree of Confusion 19:54

לפני 9 years19:54

19:54

Learn how to configure the Max Degree of Parallelism and Cost Threshold for Parallelism settings in SQL Server - and about how SQL Server 2014 SP2 and SQL Server 2016 change the way that SQL Server automatically configures some SQL Servers with lots of cores.

Dear SQL DBA

1
How to Level Up Your DBA Career 26:53

לפני 9 years26:53

26:53

You're a Junior or mid-level Database Administrator with no obvious career path. How do you grow the right skills to level up your DBA career?

Dear SQL DBA

1
Index Usage Stats Insanity 23:18

לפני 9 years23:18

23:18

SQL Server’s “index usage stats” dynamic management view is incredibly useful-- but does it tell you what you THINK it tells you? Kendra explains the quirks of how sys.dm_db_index_usage_stats works, as well as why she thinks the information is so valuable.

Dear SQL DBA

1
Fail Over, Fail Again, Fail Better - Preparing for Disaster Recovery 29:25

לפני 9 years29:25

29:25

You’re setting up SQL Server log shipping for disaster recovery. What else do you need to do to best prepare for a failure?

Dear SQL DBA

1
Outside the Big SAN Box 36:20

לפני 9 years36:20

36:20

You believe that your expensive SAN is slowing down the SQL Server. How can you make your case without making enemies?

Dear SQL DBA

1
Next Door to Derpton 14:05

לפני 9 years14:05

14:05

What do you do when your fellow DBA is a ticking time-bomb of bad decisions, waiting to explode your production environment?

Dear SQL DBA

1
Lost in Performance Troubleshooting 25:23

לפני 9 years25:23

25:23

The SQL Server is slow, what should you do? Kendra shares her strategy for performance troubleshooting.

Dear SQL DBA

1
Bleeding in Edgevile 21:24

לפני 9 years21:24

21:24

Kendra Little answers a question about early adoption of SQL Server, discusses why testing in production isn't necessarily crazy, and recommends how to handle requests to upgrade your SQL Server to use new features.

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

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