Episode 154 - Beavers and very loud fart...

Guy talks about an interesting incident involving performance problems in a virtual environment. And also, we talk about the SSMS StatisticsParser extension and the question of SSMS extensions in general. Relevant links: vmware.com/docs/sql-server-on-vmware-best-practices-guide H ... Show More

Guy and Eitan discuss a few new things in the latest SSMS update, and Eitan tells about a very peculiar use case involving transactional replication and AlwaysOn Availability Groups, and Guy talks about a use case involving deletion triggers. Important note: The part about SQL Se ... Show More

Guy and Eitan discuss several very interesting new features recently announced by Microsoft. Relevant links for more info: Stop defragmenting and start living: introducing auto index compaction | Microsoft Community Hub Automatic Index Compaction - SQL Server | Microsoft Learn Da ... Show More

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

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. 

pgnanalyze helps users deliver consistent PostgreSQL performance and availability at any scale. Get started with a free trial or explore their docs. You can also find them on YouTube, where Lukas posts a weekly show called 5mins of Postgres.Lukas was a founding engineer of Citus ... Show More

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

SQL Server Service Packs are going away, starting with SQL Server 2017. I talk about why I think this is a good thing, and discuss Cumulative Updates, Service Packs, and the process of updating SQL Server. 

Researchers at Guardicore Labs have been tracking an unusual cryptominer that seems to be based in China and is targeting Windows MS-SQL and phpMyAdmin servers. Some elements of the exploit make use of sophisticated components previously associated with nation-state actors. Ophir ... Show More