Today, Guy has a lot of tips to share after reviewing one of those... "problematic" customer environments. Let's just say that he's got his hands full. But it's still fun, and you get to learn as well!

Relevant links:

• Forced Parameterization | Microsoft Docs
• Forced Parameterization Can Lead to Poor Performance | Microsoft Tech Community
• Why Multiple Plans for One Query Are Bad | Brent Ozar
• Relevant scripts from our Madeira Toolbox:
  • Find Unused Indexes
  • Find Redundant Indexes
• Join, Query, and Table Hints (Transact-SQL) | Microsoft Docs
• Indexed Views | Microsoft Docs
• Second Normal Form

Guy and Eitan discuss their favorite upcoming new features in SQL Server 2022, and talk about some major upcoming events and summits.

Relevant links:

• SQL Server 2022 public preview is now available on Linux
• Introducing the SQL Server 2022 blog series by Bob Ward
• Contained Availability Groups in SQL Server 2022 | Eitan Blumin
• What is a contained availability group? | Microsoft Docs
• Erik Darling Blog series about Parameter Sensitive Plans
• XML Data Compression in SQL Server 2022
• Link feature in Azure SQL MI for SQL Server
• Welcome to the new Azure SQL Database local development experience
• Planning new scenarios and use cases for Azure SQL Database local development experience
• DOP Feedback In SQL Server 2022
• Upcoming community events:
  • Data Platform Virtual Summit (by Data Platform Geeks)
  • PASS Data Community Summit
• Madeira Toolbox Scripts:
  • Compare SQL Server instance properties
  • Change Tracking Generic Synchronization.sql 

Guy and Eitan talk about a lot of exciting announcements and announcements about a lot of excitements! Does this even make sense? I don't know! Listen to the show to find out!

Relevant links:

• How to HADR Your SQL Jobs
• Contained AlwaysOn Availability Groups Overview
• Pedro Lopes's Slides Deck for SQL Bits 2022
• How to Identify and Fix TempDB Contention
• The Best Solution for SQL Server Partitioning Sliding Window
• Roll_Forward_Transaction_Log_Backups.sql
• Restore-DbaDatabase (DbaTools)
• Tsql2sday - My First Technical Job

Also, we talk about performance considerations of partitioning in SQL Server, a blog post series about how to tune performance, and new scripts in our Madeira Toolbox on GitHub.

Relevant links:

• Data-tier Applications (DACPAC and BACPAC)
• About: Snapshot Replication
• Generally available: Azure Virtual Machines increase storage throughput by up to 300%
• Generally available: Announcing Azure SQL Migration extension for Azure Data Studio
• Public preview: Reverse Migration of Azure SQL Database Hyperscale tier to General Purpose tier
  • Limitations for Reverse Migration
• SQL SERVER – Table Partitioning for Slow Performance | Pinal Dave
• How To Tune Performance - Chapter 4: Common Problems | Sagi Amichai
• Find Redundant Indexes with Recommendations for all Databases | Madeira Toolbox

Guy and Eitan discuss upcoming events and conferences in 2022, and also about new features in SQL Server 2022, and more.

Relevant links:

• Conferences:
  • SQL Server & Azure SQL Conference
  • Data Platform Virtual Summit 2022
  • DataGrillen
  • PASS Data Community Summit 2022 (registration is open!)
• Get Ready for SQL Server 2022
• Get Azure recommendation in Azure SQL Migration extension
• Madeira Toolbox Roundup:
  • Linked Server Vulnerability.sql
  • Maintenance of Azure SQL Databases via Azure Automation and Powershell
  • Balance CPU Cores Across NUMA Nodes.sql
  • Database Design Best Practice Checks.sql

In today's show, Guy and Eitan host the co-founders of EverSQL, Oded Valin and Tomer Shay. We talk about their automated SQL tuning solution and SQL tuning best practices in general.

• eversql.com - Official Website
• Software Vendor Mistakes - Erik Darling Data

Relevant links:

• Cardinality Estimation: Combining Density Statistics | Paul White
• SQL Server CE: Multiple single-column statistics connected by AND
• SQL Server CE: Multiple single-column statistics connected by OR
• Detect Low PAGE Compression Success Rates in all Databases | Eitan Blumin
• The Curious Case of… tracking page compression success rates | Paul Randal
• The Ultimate Compression Savings Estimation Script for an Entire Database | Eitan Blumin
• SQLBits 2022 Conference
• Enterprise Data World 2022 Conference
• Buffer Pool Distribution by Tables | Guy Glantser
• Track Failed Logins in Azure SQL DB using RING_BUFFER_CONNECTIVITY
• Is SQL Server Profiler in Azure Data Studio? – SQLServerCentral
• Using the SSMS XEvent Profiler

Guy and Eitan discuss some interesting announcements and focus on the topic of Security in SQL Server.

Relevant links:

• Announcing new features for the SQL IaaS Agent Extension! - Microsoft Tech Community
• Troubleshooting SQL Server made easy via Notebooks – seeking your feedback - Microsoft Tech Community
• Veeam security breach: Backup “Removal” Solutions - From Conti Ransomware With Love
• sp_helprotect is very useful in permission issue - Microsoft Tech Community
• Databases and Guests - Vitaly Bruk
• Performance Tuning Like a Pro - with Hypothetical Indexes - Eitan Blumin
• Dynamic Data Masking in SQL Server
• Madeira Toolbox Roundup:
  • GUEST user with database permissions.sql
  • PUBLIC role with excessive permissions.sql
  • DBCC CLONEDATABASE (Transact-SQL)
  • Audit trace file binary search by timestamp.sql
  • Security_Audit_Default_Trace.sql
  • SQLSecurityAudit.sql
  • Detect Weak Passwords in SQL Server
  • track_logins_in_use_extended_events.sql

Guy and Eitan talk about the interesting new features announced in SQL Server 2022, a new sp_whoisactive version, and a bunch of Microsoft blog posts on Tech Community.

Relevant links:

• SQL Server 2022:
  • Announcing SQL Server 2022 preview: Azure-enabled with continued performance and security innovation
  • Introducing SQL Server 2022 | Bob Ward
  • Announcing the SQL Server 2022 Early Adoption Program
  • SQL Server 2022 | Official Microsoft
• The new version of sp_whoisactive - v12.00
• Extended Events to the Rescue - by Guy Glantser on SQLFriday
• New Microsoft support troubleshooting articles:
  • SQL Server CE: Multiple single-column statistics
  • SQL Server CE: Multiple single-column statistics connected by OR
  • Update Stats Sample Rate does not work
  • Use Orca.exe Tool to Verify Corrupted MSI/MSP file in Failed SQL Patching
  • Use Trace Flag 902 (TF902) to Bring Up Your SQL Service in Failed Post Upgrade Script
  • Prevent SQL Server Dump Generation in Hot Cases: Common Ways & Scenarios
  • Recover TDE Databases in Disaster : Recover Steps for 3 Common Scenarios

Guy and Eitan talk about some important news, about Availability Sets in Azure, and several useful T-SQL scripts in our Toolbox.

Relevant links:

• Azure Feedback is back!
• Troubleshooting SQL Server made easy via Notebooks – seeking your feedback
• Open sourcing the .NET 5 C# Language Extension for SQL Server
• Replication enhancements in the SQL Server 2019 CU13 release
• This episode was recorded on October 25th, before the important announcement about the release of SQL Server 2022. Check it out here.
• Availability Sets for Virtual Machines in Azure
• Madeira Toolbox Round-Up:
  • Certificate Management Scripts
  • Shrink All Shrinkable Transaction Logs.sql
  • Ola Hallengren Recommended IndexOptimize Examples