Dear SQL DBA

By: Kendra Little
  • Summary

  • Kendra Little's podcast discussing database performance tuning, software development, and working with data.
    Kendra Little 2023
    Show More Show Less
activate_Holiday_promo_in_buybox_DT_T2
Episodes
  • Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
    May 20 2024

    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.

    Show More Show Less
    1 hr and 5 mins
  • Power BI Performance Tuning with Eugene Meidinger
    Jan 15 2024

    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.

    Show More Show Less
    54 mins
  • Automated Deployments and the Art of the Database with Database Michael J Swart
    Sep 26 2023

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

    Show More Show Less
    1 hr and 5 mins

What listeners say about Dear SQL DBA

Average customer ratings

Reviews - Please select the tabs below to change the source of reviews.