Dear Customers,

We are pleased to announce that Microsoft SQL Server 2025 Express Edition has increased its database size limit from 10GB to 50GB. Both BASSnet 2.11 and BASSnet Neo have been verified to support MS SQL Server 2025, including the expanded capacity in the Express Edition.

Do note that while SQL Server Express now supports a larger capacity, our data store designs will continue to focus on an optimized size and structure. Maintaining an optimized size remains critical, as oversized databases may impact replication performance and overall system responsiveness. 

Data Management in BASSnet

 The following are some of the methods BASSnet uses to manage data in the database:

• Image Handling
  • Image resolution in RTFs are re-rasterized and compressed for better storage efficiency.
  • In BASSnet Neo, images are extracted from the HTML rich text and stored in the document cache.
• File-Size Control
  • Configurable file-size control ensures better management of storage and data replication.

Key Features and Enhancements in SQL Server 2025

 1. Standard Edition Enhancements

• Increased CPU capacity: Supports up to 4 sockets or 32 cores
• Increased memory capacity: Up to 256 GB RAM

2. Express Edition Enhancements

• Increased relational database size limit: Now 50 GB (formerly 10 GB)

3. AI and Productivity

• Copilot integration in SQL Server Management Studio (SSMS) to assist with queries, diagnostics, and productivity tasks

4. JSON Enhancements

• Additional built-in functions and operators for JSON
• JSON now stored in a native binary format for improved performance

5. Engine and Query Optimizer Improvements

• Reduced blocking behavior
• Reduced lock memory consumption
• Better avoidance of lock escalation

For more information, please refer to What's New in SQL Server 2025.

Thank you.