New SQL Server Permissions and Script Management

‍New Features

Exadata @ AWS

Support for Exadata infrastructure in AWS is now generally available. Tessell provides the only unified control plane offering both cloud-native IaaS and Exadata as a choice of infrastructure.

The following are supported on Exadata

• Provision Databases - Effortlessly create and configure databases on Exadata systems through Tessell’s intuitive console.
• Clone Databases Across Environments - Instantly clone databases:
  
  • Within Exadata
  • From Exadata to cloud-native VM environments, simplifying dev/test setup.
• Unified Backup & Restore - Protect critical data with Tessell-managed backups and perform point-in-time restores across Exadata and cloud-native VMs
• Monitoring & Management - Gain unified visibility and control across all Exadata databases, along with Tessell’s other supported platforms, from a single management interface.

Script Library Enhancements - Scoped Subscription Support

Previously, any script created in the Script Library was automatically available to all subscriptions within the account. With this enhancement, customers can now select specific subscriptions where each script should be accessible.

Key Benefits

• Granular Access Control: Limit script access to only the subscriptions you choose.
• Improved Governance: Prevent unintended usage of scripts across subscriptions.
• Operational Flexibility: Design scripts for specialised use cases (subscriptions) without exposing them broadly.

This enhancement ensures that customers have the flexibility to manage script usage in a way that best aligns with their organisational structure.

Enable log rotation for Tessell libraries on Windows

Overview

This release introduces automatic log rotation for all Tessell Windows services. Previously, log files could grow indefinitely, causing disk space issues and service failures. Logs are now automatically rotated when they reach 20MB, with automatic cleanup of old files.

What's New‍‍

• Automatic log rotation: Logs rotate at 20MB without service downtime
• Automatic cleanup: Retains 7 newest log files, deletes older files every 2 hours
• Timestamped files: Rotated logs include timestamp for easier troubleshooting

Benefits‍

• Prevents disk space exhaustion and service failures
• Zero downtime during log rotation
• No manual intervention required
• Easier troubleshooting with timestamped log files

SQL Server Sysadmin Role Access for Master Users‍‍

Overview

This release introduces automatic sysadmin server role access for SQL Server master users across all new and existing Tessell SQL Server instances. This enhancement ensures parity with industry-standard DBaaS offerings and provides customers with greater control, improved operability, and simplified database management workflows.

Note: The master user is not a Windows (AD) account. It is a SQL-authenticated login, and sysadmin privileges are granted specifically to this SQL-authenticated master user.

Released Feature

1. Sysadmin Role for Newly Provisioned Instances

All SQL Server instances provisioned after this release will automatically grant the master user the sysadmin server role.

Benefits

Immediate elevated permissions for common administrative tasks

Consistent behavior across Single Instance (SI), SI+HA, SI+DR, and Switch-over deployments

Simplified provisioning workflow with no additional steps required from customers

2. Upgrade Support for Existing Instances

Existing SQL Server services will receive this capability through a dedicated upgrade script.

3. Improved User Experience

During provisioning or upgrade flows, the UI now clearly informs the customer that the master user will receive sysadmin privileges, ensuring full transparency and control.

Sysadmin access is granted only to the designated master user.

No impact to existing user roles or database permissions.

Customer Impact‍

This Feature allows customers to perform a wider range of administrative operations directly, reducing dependency on support, improving operational agility, and aligning with capabilities commonly offered by other cloud database platforms.

Monitoring Metrics

Overview

We have introduced new monitoring metrics for MySQL and InnoDB Cluster services to improve detection of database restarts, cluster node health issues, and unexpected read-only states. These metrics enhance alerting accuracy, reduce detection gaps, and provide better visibility during transient outages or configuration anomalies.

The enhancements are fully integrated into the existing monitoring and alerting framework, ensuring proactive detection and faster troubleshooting across managed MySQL deployments.

Key Benefits

• Improves reliability of uptime-based alerts by detecting recent database restarts.
• Provides real-time visibility into cluster node health, including offline and standalone states.
• Ensures immediate detection when a primary node becomes read-only.
• Minimizes false positives during provisioning or expected maintenance windows

‍