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
Aug 2023
Advice for Technical Leaders with Alex Robson
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 recommende ... Show More
1 h
Aug 2023
Erik Darling on Performance Tuning
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 la ... Show More
52m 45s
Aug 2023
What's up with Tech Interviews in 2023? With Jeremiah Peschka.
Tech interviews are weird and wacky. How did they get this way, and how SHOULD they be? Jeremiah Peschka joins us to discuss. 
29m 6s
Recommended Episodes
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
Sep 2024
126: You’ll Never Land a Data Job If You Do This
Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!  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! 💌 Join 10k+ aspiring data analysts & get my tips ... Show More
12m 54s
May 31
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 57s
Oct 2024
The 4 Step Framework My Client Used To Win His Google Interview | Ep #610
Austin shares the 4 step framework that one of his clients used to turn an interview at Google into a job offer!Time Stamped Show Notes:[0:25] - Interview preparation is important[0:46] - Go get the job description[1:19] - Look for qualifications and skills[1:38] - Come up with q ... Show More
4m 38s
Sep 2024
Effective Networking Is Making Friends, Not Asking For A Job | Ep #589
Austin shares his thoughts on why networking is all about making friends and not about asking for a job!Time Stamped Show Notes:[0:25] - Make friends instead of asking for a job[1:47] - The truth about networking[2:30] - A different way to look at networking[3:35] - What you shou ... Show More
6m 33s
Jul 2024
One Trick To Beat Anxiety Before An Interview | Ep #569
Austin shares one amazing trick to beat that feeling of anxiety before your job interview!Time Stamped Show Notes:[0:25] - Having anxiety means that you care[1:15] - Austin’s experience with interview anxiety[2:28] - Memorization can help[3:00] - Try meditation before the intervi ... Show More
6m 34s
Aug 2024
Improve Your Chances In Your Engineering Job Search Using the Scientific Method with Brian Pulliam
I'm joined today by Brian Pulliam. I've personally engaged Brian as a career coach. In this discussion we'll talk a bit about coaching, and about how you can set yourself up to become a much better candidate in your job search as an engineering leader.Introduction to Career Coach ... Show More
1h 27m
Feb 2025
We've finally figured out an easier way for you to learn languages
Learning a new language is famously very hard and usually takes years. Could all that be about to change?  While we now have apps like Duolingo to help, it’s still likely to take a long time and a lot of effort to be anything close to fluent. What usually helps is spending time i ... Show More
14m 37s