Training Resources for SQL Noobs

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

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

<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

<p>SQL is the most important data skill you can learn on your journey. And it doesn’t need to be complicated. In this episode, dive into a short SQL introduction, basic SQL commands and know how SQL can help you land your data job.</p> <p>Tune in now!</p> <p><br></p> <p><a href=" ... Show More

Guy and Eitan talk about some great things about SQL Server, and mostly Guy’s experience in digging into execution plans and generating synthetic IO workloads. Relevant links: What’s new in SQL Server and Azure SQL 2023 Year in Review Multi-Tenancy in the Real World | Eitan Blumi ... Show More

Did you know SSMS can make sounds? We start the show with some interesting things you might do with it. In addition, we talk about: SQL Server on Linux Hadoop fundamentals SQL Server 2016 eBook Changes to auto update statistics in SQL Server 2016 New SQL Server 2016 database leve ... Show More

Guy Glantser is co-hosting with Eitan Blumin for the first time, and we have a lot of topics to cover and catching up to do. PASS and SQLBits Conferences Storage Best Practices for SQL on IaaS in Azure SQL VM RP (Resource Provider) Guy's hopes for SQL Server setup options SQL Ser ... Show More

Guy tries to convince Eitan that OPTION(RECOMPILE) is the ultimate "Turbo" button in SQL Server, and that it's strongly underappreciated. Relevant links for more info: OPTION(RECOMPILE) (Transact-SQL) - SQL Server | Microsoft Learn Recompile a Stored Procedure - SQL Server | Micr ... Show More

<div class="wp-block-jetpack-markdown"><h2>Summary</h2> <p>When you build a machine learning model, the first step is always to load your data. Typically this means downloading files from object storage, or querying a database. To speed up the process, why not build the model in ... Show More

<div class="wp-block-jetpack-markdown"><h2>Summary</h2> <p>Data Engineering is a broad and constantly evolving topic, which makes it difficult to teach in a concise and effective manner. Despite that, Daniel Molnar and Peter Fabian started the Pipeline Academy to do exactly that ... Show More

Over the past 199 episodes of DataFramed, we’ve heard from people at the forefront of data and AI, and over the past year we’ve constantly looked ahead to the future AI might bring. But all of the technologies and ways of working we’ve witnessed have been built on foundations tha ... Show More

<p>Sabrina is a Commercial Software Engineer and serial hacker who has attended over 32 hackathons! She was also a guest lecturer at the University of Toronto on Machine Learning and Artificial Intelligence. Today she sits down and gets Scott (and you!) started with the basics of ... Show More

Replication is the process of pushing changes from the master node to worker replica nodes in a database system to allow for horizontal scalability. One of the methods of replication is statement-based which is popular in MySQL. In this episode of the Backend Engineering Show, I ... Show More