Microsoft Ignite 2024 SQL Server 2025

Key Features and Updates:

• Public announcement hints at the inclusion of Optimized Locking in SQL Server 2025, potentially beneficial for DBAs and workloads.
• Enhanced T-SQL functions including regular expression support and features missing in previous versions such as arrays datatype and index support for JSON.
• Improved CPU and memory limits are expected, addressing issues with limitations in previous versions.
• Dynamic plan compilation with runtime parameters.
• Anticipated features like optimized locking, fabric mirroring, and potential increase in CPU and memory limits generate excitement among users.

Pros:

• Anticipation for new features like Optimized Locking and enhanced T-SQL functions.
• Potential improvements in CPU and memory limits.
• Enthusiastic responses from users about expected enhancements.
• Reference to advancements seen in PostgreSQL and SQLite indicates a push for better functionalities in SQL Server 2025.

Cons:

• Concerns raised about existing issues in SQL Server:
  • Lack of support for regex in querying or extracting from values.
  • Issues with UTF-8 characters in openjson for keys.
  • Challenges in validating JSON in openjson.
  • Absence of interval type for deducing datetime and conducting group operations.
  • Missing arrays datatype and index support for JSON.

Other Discussion Points:

• Comments on the writing style in blog posts and humor observed in discussions.
• Some users express interest in updates related to vector search.
• Discussions on potential impacts and reactions to updates in SQL Server 2025.
• Comparisons with other technologies and functionalities in SQL Server.
• General excitement and anticipation for new releases.

By analyzing the Reddit comments, it is evident that users are eagerly anticipating Microsoft Ignite 2024 and the release of SQL Server 2025. Updates regarding features like Optimized Locking, enhanced T-SQL functions, and potential improvements in CPU and memory limits generate excitement among users. However, existing issues such as lack of support for regex and index deficiencies in JSON raise concerns. The community is actively discussing the pros and cons of the anticipated updates while expressing enthusiasm for the advancements in SQL Server 2025.