logo
episode-header-image
Aug 2016
19m 49s

Teach Yourself SQL Server Performance Tu...

Kendra Little
About this episode

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.

Up next
May 2024
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
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 ... Show More
1h 4m
Jan 2024
Power BI Performance Tuning with Eugene Meidinger
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 ... Show More
53m 54s
Sep 2023
Automated Deployments and the Art of the Database with Database Michael J Swart
<p>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.</p> <p>Check out Michael's art and blog posts at <a href= "https://michaeljswart.c ... Show More
1h 5m
Recommended Episodes
Jul 2023
Episode 154 - Beavers and very loud farts
Guy and Eitan discuss several interesting topics and recent experiences that you'd want to hear about! Relevant links: Trigram Wildcard String Search in SQL Server The Story of DBeaver, PostgreSQL, and the silly data engineer SQL Server Error Log Management High VLF Counts Got Yo ... Show More
37m 14s
Sep 2019
Episode 286: 286: SQL Smart with Nancy Sheleheda
<p>Nancy Sheleheda, Senior Director of Application Development at PCT, joined Brittany to discuss why it is important to learn SQL, to engage in a debate on differences between a developer and a DBA and introduce some great resources to leveling up on SQL.</p> <p>Links for this e ... Show More
30m 28s
Jul 2024
Episode 165 - News in Azure SQL and Woes of Excel
Guy and Eitan discuss some important and interesting news from Microsoft about SQL Server, Straight Path Solutions publish 30 articles about SQL Server security checks, Guy talks about his experience with Excel, and Eitan is irritated about people still not doing SQL jobs correct ... Show More
38m 44s
Aug 2024
Episode 166 - DR Planning for SQL Server and Loading Large CSV Files
Guy and Eitan discuss the recent CrowdStrike incident and what it would mean for DBAs, and discuss options to load huge CSV files into SQL Server as fast as possible. Relevant links: 101 of Troubleshooting SQL Server on Linux - Microsoft Community Hub bcp utility - SQL Server | M ... Show More
35m 32s
Dec 2024
736: Difference between learning and practicing (Case Interview & Management Consulting classics)
99% of clients misunderstand learning and practicing. At its essence, you cannot practice McKinsey cases until you learn McKinsey cases. Most candidates start of their case interview preparation by reaching out to colleagues and consultants to practice cases, not having gone thro ... Show More
10m 38s
Feb 2015
Show 15 – March Madness
<p>2015 started well, fast, and furious.</p> <p>We start the show by congratulating Guy for <strong>earning the MVP title,</strong> and Guy explains what he did in order to get this achievement, and what you can do to earn it too.</p> <p>We also talk about the crazy March we're g ... Show More
41m 29s
Sep 2024
126: You’ll Never Land a Data Job If You Do This
<p>Help us become the #1 Data Podcast by leaving a rating &amp; review! We are 67 reviews away! </p><p> There's one thing that will kill a data career analyst job hunt faster than anything else...and it's really easy to do. Please don't do it! </p><p>💌 Join 30k+ aspiring data an ... Show More
12m 18s
May 2025
How to handle each stage of the interview process: ft a dating analogy!
From stressing about repeating yourself, to wondering if the hiring team is comparing notes behind your back, progressing through multiple rounds of interviews can leave you second-guessing what you're supposed to say each time.In this week’s episode, Sarah and Emma answer a list ... Show More
27m 59s
Oct 2024
The 4 Step Framework My Client Used To Win His Google Interview | Ep #610
tail spinning
4m 38s
Sep 2024
Effective Networking Is Making Friends, Not Asking For A Job | Ep #589
tail spinning
6m 33s