Guy talks about a recent migration project he was working on to move an on-prem SQL Server to AWS RDS.

Eitan talks about a new AI-related feature in Azure SQL Databases.

And we also discuss the new SNAPSHOT backup T-SQL command in SQL Server 2022.

Relevant links:

• Importing and exporting SQL Server databases using native backup and restore - Amazon Relational Database Service
• Learn about Amazon RDS maintenance window | AWS re:Post
• LLM Structured Output from Azure SQL Explained - Azure SQL Devs’ Corner
• Create a Transact-SQL snapshot backup - SQL Server | Microsoft Learn

Guy and Eitan worry about the decline in SQL Server feature quality. But maybe there's something else behind it?

Relevant links:

• Improving Azure SQL Database reliability with accelerated database recovery in tempdb | Microsoft Community Hub
• What the Decline of Sql Server Quality means for Developers and DBAs
• SLA for SQL Database | Azure
• AI will eliminate DBA Jobs faster than you think

Guy and Eitan discuss a few interesting topics. Including a fun new game called "SQL Noir", how to implement statistical clustering model in SQL, about surrogate and natural keys, and the recently announced deprecation of Azure Data Studio.

Relevant links:

• SQL Noir - A Detective SQL Game
• How to Write a Recursive CTE in SQL Server | LearnSQL.com
• Azure Data Studio Retirement - Azure SQL Devs’ Corner
• Relational Databases - Surrogate Keys and Logical Duplicates (by Ami Levin)