MySQL is having a bumpy journey

I like SQL but the standard should have included ways to hint instead of the abstraction of "let me do it for you" 

In this episode I explore why you should take some time to examine the operation you are caching before doing so. And why caching is a cop-out 

<div class="wp-block-jetpack-markdown"><h2>Summary</h2>

The database market has seen unprecedented activity in recent years, with new options addressing a variety of needs being introduced on a nearly constant basis. Despite that, there are a handful of databases that continu ...

Guy and Eitan discuss various practices in SQL Server that hurt performance and possibly waste money, negative VarDecimal numbers, renumbering Identity columns, and the new Azure Database Fleet Manager. Relevant links: SQL Server IN Clause With Multiple Literal Values Performance ...  Show more

As companies look to update their databases, especially in a cloud native context, with so many different databases out there, it’s a huge challenge for developers when migrating from one environment to another. Learn more about your ad choices. Visit podcastchoices.com/adchoices 

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