Episode 154 - Beavers and very loud fart...

Guy and Eitan talk about the new preview version of SSMS, application locks, and stupid troubles with TempDB shrinkage. Relevant links: Announcing the Release of SQL Server Management Studio 22 Preview 3 | Microsoft Community Hub Release Notes for SQL Server Management Studio (SS ... Show More

We let a dice roll decide today's topic, and the winner ended up being: Computed Columns with PERSISTED and Indexed Expressions. We give our thoughts about it, best practices, pit falls, and tips. Relevant links: SQL Server 2025 Preview RC1: Now Supporting Red Hat Enterprise Linu ... Show More

Guy and Eitan discuss several interesting announcements and updates from Microsoft related to SQL Server and VS Code. And also Eitan talks about a weird issue he encountered involving page latch time-outs during DBCC CHECK command. Please fill out the SQL Server on Linux adoption ... Show More

<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

Fundamentals of Database Engineering udemy course https://databases.win MySQL has been having bumpy journey since 2018 with the release of the version 8.0. Critical crashes that made to the final product, significant performance regressions, and tons of stability and bugs issues. ... Show More

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. 

Shannon Morse joins the show to talk about how a data breach might impact you, as well as to clear up a few things the media tends to get wrong about data breaches. Plus, we have news about AI, NASA and more!See omnystudio.com/listener for privacy information. 

Scott and Wes talk with Søren Bramer Schmidt, Founder and CEO of Prisma, about database best practices, including the latest developments in serverless, local-first, and typed SQL solutions. Show Notes 00:00 Welcome to Syntax! 02:55 Søren’s thoughts on GraphQL 03:53 Brough ... Show More

<p>A common challenge in data-rich organizations is that critical context about the data is often hard to capture and even harder to keep up to date. As more people across the organization use data and data models get more complex, simply finding the right dataset can be slow and ... Show More

<p>This week we open with a question from a listener who is dealing with a crashing account. Chris discusses how to fix a Google Ads search campaign that is failing. Then another email from a listener who reminds us why it is important to focus on the core basics of Google Ads ma ... Show More

Summary In this episode of the Data Engineering Podcast Andrew Luo, CEO of OneSchema, talks about handling CSV data in business operations. Andrew shares his background in data engineering and CRM migration, which led to the creation of OneSchema, a platform designed to automate ... Show More

<p>Julian LaNeve (<a href='https://x.com/JulianLaneve'>@JulianLaneve</a>, CTO <a href='https://x.com/astronomerio'>@astronomerio</a>) discusses data pipelines, Apache Airflow, Astronomer’s managed offering, and the benefits of data pipelines for both developers and operations.</p ... Show More