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 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
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. Links for this episode:SQL ... 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
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