Episode 154 - Beavers and very loud fart...

In this year's first episode of the new year, Guy and Eitan discuss the new Next-gen General Purpose tier of Azure SQL Managed Instance, which is now GA. They also discuss a few interesting customer stories, how they were resolved, and how they're not actually SQL Server's fault. ... Show More

Matan Yungman is our special host for today, who came especially to talk about his special project called "Rapido", which is capable of automatically tuning SQL queries at scale. Perhaps there is some inspiration in it for us? Relevant links: Matan Yungman | LinkedIn Matan Yungma ... Show More

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

<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