Summary of Reddit Comments on Microsoft Ignite 2024 SQL Server

• Optimized Locking: The release may feature Optimized Locking, currently available only in Azure SQL DB, which can be beneficial for database administrators and workloads.
  "The public announcement seems to indicate that Optimized Locking (currently Azure SQL DB only) will be in this release. That has the potential to be beneficial for us meat & potatoes DBAs & workloads."

• Missing Features: Users reported certain issues with SQL Server 2022, such as lack of support for regex, utf8 characters in openJSON, interval type, and arrays datatype. They also mentioned features like arrays datatype and index support for JSON being missing, which could be compared to how PostgreSQL handles them.
  "Not supporting regex when querying or extracting from values..."

• Desired Features: Users expressed interest in new T-SQL functions like regular expression support, as well as CPU and memory limit increases, which would address limitations in the current version.
  "Regular expression support in T-SQL and other new T-SQL functions."

• Comparison with Other Databases: Some users considered PostgreSQL as a viable alternative to SQL Server due to issues like memory limits and expensive Enterprise edition usage.
  "It really makes you look at PostgreSQL as a viable alternative."

• Performance Improvements: Users welcomed dynamic plan compilation with runtime parameters and were anticipating features like Optimized Locking.
  "They made the engine compile plans dynamically with runtime parameters. Alleluia?"

• Critical Review: Some users criticized the blog post for its buzzword-heavy language without providing substantial information.
  "The blog post reads like it was written by an AI trained to pack as many buzzwords as possible into each sentence without any substantive explanation or information."

In conclusion, the discussions around Microsoft Ignite 2024 SQL Server highlight the anticipation for new features and improvements, alongside critiques of existing issues and comparisons with alternative database solutions like PostgreSQL.