You can see the latest product updates for all of Google Cloud on the Google Cloud page, browse and filter all release notes in the Google Cloud console, or you can programmatically access release notes in BigQuery.
To get the latest product updates delivered to you, add the URL of this page to your
feed
reader, or add the feed URL directly: https://cloud.google.com/feeds/cloud-sql-server-release-notes.xml
August 15, 2022
By enabling instance deletion protection, you can prevent the accidental removal of Cloud SQL instances. This functionality is generally available.
For more information, see Prevent deletion of an instance.
July 11, 2022
The database major version upgrade feature of Cloud SQL for SQL Server is generally available. For more information, see Upgrade the database major version in-place.
July 08, 2022
The July maintenance changelog is now available. For more information, use the links at Maintenance changelog.
June 28, 2022
A second June maintenance changelog is now available. For more information, use the links at Maintenance changelog.
June 21, 2022
You can enable an instance to publish to a subscriber that is external (or internal) to Cloud SQL. In this scenario, Cloud SQL for SQL Server can act as a publisher to an external subscriber. This functionality, which is generally available, uses transactional replication.
For more information, see Configure external replicas.
In Cloud SQL, you can use SQL Server Audit capabilities to track and log server-level and database-level events. This functionality is generally available.
For more information, see SQL Server database auditing.
June 10, 2022
Cloud SQL now supports faster machine type changes, with connectivity dropping to less than 60 seconds. For more information, see Impact of changing instance settings.
June 09, 2022
The June maintenance changelog is now available. For more information, use the links at Maintenance changelog.
June 08, 2022
An addendum to the May maintenance changelog shows additional security patches. For more information, use the links at Maintenance changelog.
June 07, 2022
Support for us-south1 (Dallas).
May 24, 2022
Support for us-east5 (Columbus).
May 13, 2022
New maintenance versions are now available through self-service maintenance. See the maintenance changelog to learn more about these new maintenance versions.
May 04, 2022
Support for europe-west9 (Paris).
May 02, 2022
New maintenance versions are now available through self-service maintenance. See the maintenance changelog to learn more about these new maintenance versions.
April 28, 2022
The following Cloud SQL recommenders that help you optimize your database costs are now generally available:
Idle database instance recommender: Identifies idle database instances in your project and provides recommendations about the savings that you can make by shutting them down.
Overprovisioned database instance recommender: Identifies overprovisioned database instances in your project and provides recommendations about the savings that you can make by rightsizing these instances.
April 25, 2022
You can now accept a maintenance update on your instance outside of the normal flow of scheduled maintenance.
While Cloud SQL schedules maintenance updates once every few months to ensure you have the latest maintenance version, you might want to use self-service maintenance if:
- You need an update sooner than your next scheduled maintenance event.
- You want to catch up to the latest maintenance version after skipping your most recent scheduled maintenance event.
- You want to gain more control over when maintenance is applied
Cloud SQL now supports maintenance changelogs. Maintenance changelogs provide information about updates available in new maintenance versions, such as database minor version upgrades and patches for security vulnerabilities. For links to current maintenance changelogs for each major database version, see Cloud SQL maintenance changelogs.
April 20, 2022
Support for europe-west8 region (Milan).
April 12, 2022
Customer-managed encryption key (CMEK) organization policy constraints are now available in Preview.
constraints/gcp.restrictNonCmekServicesallows you to control which resources require the use of CMEK.constraints/gcp.restrictCmekCryptoKeyProjectsallows you to control the projects from which a Cloud KMS key can be used to validate requests.
You can use both constraints together to enforce the use of CMEK from allowed projects.
To learn more, see Customer-managed encryption keys (CMEK) organization policies. To add CMEK organization policies now, see Add Cloud SQL organization policies.
April 11, 2022
Cloud SQL for SQL Server supports in-place upgrades in Preview. You can upgrade your instance's major version or edition. For more information, see Upgrade the database major version in-place.
February 23, 2022
If your primary instance uses a private IP address, you can now select an allocated IP range for clones and replicas created from the instance.
February 17, 2022
Cloud SQL now supports the use of tags on instances. Tags are key-value pairs you can apply to your resources, such as a project or a Cloud SQL instance, which are used for fine-grained access control. To learn more, see Access control with Google Cloud tags. To use tags now, see Attach and manage tags on Cloud SQL instances.
February 08, 2022
Cross-region replication is now generally available in Cloud SQL for SQL Server.
You can use replication to scale the use of data in a database without degrading performance. Other reasons include migrating or maintaining data duplicates between regions.
For more information, see Replication in Cloud SQL.
February 07, 2022
SQL Server 2019 is now the default version. See Database versions and version policies.
January 31, 2022
The Key Access Justifications (KAJ) feature is now generally available in Cloud SQL. You can use KAJ as part of Cloud External Key Manager (EKM). KAJ enables you to view the reason for each Cloud EKM request. Additionally, based on the justification provided, you can automatically approve or deny a request. For related information, see the Overview.
December 16, 2021
You can now see the database minor version when viewing information about an instance. See Database versions and version policies for a list of the latest supported versions.
December 13, 2021
A new feature enables more flexibility for integrating Cloud SQL for SQL Server with Managed Service for Microsoft Active Directory. You can integrate your SQL Server instance with a managed AD domain located in a different project.
November 16, 2021
Support for southamerica-west1 (Santiago) region.
October 08, 2021
Access Approval is now GA for Cloud SQL. Access Approval enables you to require explicit approval before Google Support may access your database for support purposes.To learn about access approval, see Overview of Access Approval. To set up access approval now, see the Access Approval Quickstart.
September 28, 2021
Cloud SQL supports the preview version of two recommenders that help you optimize your database costs:
Idle database instance recommender: Identifies idle database instances in your project and provides recommendations about the savings that you can make by shutting them down.
Overprovisioned database instance recommender: Identifies overprovisioned database instances in your project and provides recommendations about the savings that you can make by rightsizing these instances.
When a database instance is nearly out of storage capacity, it's automatically stopped to prevent the loss of information. For more information, see Stopping an instance.
September 10, 2021
The Cloud SQL out-of-disk recommender is now generally available. This feature proactively generates recommendations that help you reduce the risk of downtime that might be caused by your instances running out of disk space.
August 21, 2021
Cloud SQL now supports IAM Conditions.
You can use IAM Conditions to define and enforce conditional, attribute-based access control for Google Cloud resources, including Cloud SQL instances. See Overview of IAM Conditions for more information.
August 09, 2021
The Cloud SQL Admin API v1 is now generally available. It is and will continue to be compatible with the v1beta4 version. There is no requirement to migrate from v1beta4 to the v1 Admin API.
August 03, 2021
Support for northamerica-northeast2-a,b,c (Toronto) region.
June 29, 2021
Support for asia-south2 (Delhi) region.
June 28, 2021
Integration of SQL Server with Managed Service for Microsoft Active Directory is generally available.
This provides capabilities for authentication, authorization, and more.
Joining an instance to a managed Active Directory domain enables you to log in to your SQL Server instances using Windows Authentication. Additionally, you can integrate with your on-premises AD domains by establishing a trust with the Managed Service for Microsoft Active Directory.
June 24, 2021
Cloud SQL for SQL Server now supports SQL Server 2019. The default version continues to be SQL Server 2017 Standard. See Database versions and version policies.
June 23, 2021
Cloud SQL storage limits are now increased to support up to 64 TB. See Cloud SQL storage limits for more information.
June 21, 2021
A preview enables you to use replication in Cloud SQL for SQL Server. Additionally, the preview enables you to make cross-region replicas.
You can use replication to scale the use of data in a database without degrading performance. Other reasons include migrating or maintaining data duplicates between regions.
For more information, see Replication in Cloud SQL.
Support for australia-southeast2 (Melbourne) region.
June 07, 2021
Cloud SQL now offers faster maintenance, with connectivity dropping for less than 120 seconds on average.
May 19, 2021
Cloud SQL supports the preview version of the out-of-disk recommender. This feature proactively generates recommendations that help you reduce the risk of downtime that might be caused by your instances running out of disk space. These recommendations can be applied when a Cloud SQL instance is trending towards the storage limit.
April 30, 2021
The following version upgrade applies to Cloud SQL for SQL Server:
- SQL Server 2017 is upgraded from 14.0.3257.3 to 14.0.3370.1
If you use maintenance windows, the new version will be available after your maintenance update. For information about maintenance windows, and to manage maintenance updates, see Finding and setting maintenance windows.
April 06, 2021
Cloud SQL for SQL Server enables you to perform change data capture (CDC) operations for your Cloud SQL instances. General information about CDC in SQL Server is here.
CDC is available for the following Cloud SQL for SQL Server database versions:
- SQL Server 2017 Standard
- SQL Server 2017 Enterprise
After connecting to an instance, the sqlserver user can do many CDC operations. The functions include (and are not limited to) the following:
To turn on this feature for a database, run this command:
exec msdb.[dbo].[gcloudsql_cdc_enable_db] 'demo'
To turn off this feature for a database, run this command:
exec msdb.[dbo].[gcloudsql_cdc_disable_db] 'demo'
Cloud SQL for SQL Server enables you to perform common operations on a tempdb database.
After you connect to an instance, the sqlserver user can manage the tempdb files. Specifically, the user has the CONTROL permission on the tempdb database, and can do many operations, including (and not limited to) the following:
* ALTER DATABASE [tempdb] ADD FILE
* ALTER DATABASE [tempdb] REMOVE
March 29, 2021
You can integrate Cloud SQL for SQL Server with Managed Service for Microsoft Active Directory.
Authentication, authorization, and more are available. For example, joining an instance to a managed Active Directory domain enables you to log in using Windows Authentication. Additionally, you can integrate with your on-premises AD domains by establishing a trust.
March 24, 2021
Support for europe-central2 (Warsaw ).
February 10, 2021
The Cloud SQL Admin API v1beta4 is now generally available. The URL for the Admin API will continue to refer to v1beta4 for backward compatibility. To start using the Cloud SQL Admin API now, see Using the Cloud SQL Admin API.
January 13, 2021
Cloud SQL now exposes the metric database/memory/total_usage. This metric provides visibility into the database working set (including buffer cache). You can find this metric in the Metrics explorer within the Monitoring dashboard.
For more information about database/memory/total_usage, see Cloud SQL Metrics.
November 19, 2020
Cloud SQL for SQL Server now supports retention settings for automated backups. You can configure retention of your automated backups for shorter or longer periods (1 to 365 days). The default setting remains 7 days.
October 12, 2020
Cloud SQL now offers "deny maintenance periods". With deny maintenance periods, you can prevent automatic maintenance from occurring during a specific time period. For example, the end-of-year holiday season is a time of peak load that requires heightened focus on infrastructure stability for many retail businesses. By setting a deny maintenance period from mid-October to mid-January, these businesses can prevent planned upgrades from Cloud SQL during their busiest time of year.
September 21, 2020
Cloud SQL for SQL Server enables you to set a default collation value for databases in an instance. This collation value is a default for sorting rules, case, and accent sensitivity. You can set this value through the Cloud Console, the gcloud command, and the Cloud SQL Admin API.
August 31, 2020
Cloud SQL for SQL Server supports cloning using the Cloud Console, the gcloud command, and the Cloud SQL Admin API. When you clone an instance, you create an independent copy of the source instance.
June 23, 2020
Committed use discounts (CUDs) are now available to purchase for Cloud SQL. CUDs provide discounted prices in exchange for your commitment to use a minimum level of resources for a specified term. With committed use discounts for Cloud SQL, you can earn a deep discount off your cost of use in exchange for committing to continuously use database instances in a particular region for a 1- or 3-year term. See the documentation for more details.
June 08, 2020
Support for asia-southeast2 region (Jakarta).
April 20, 2020
Support for us-west4 region (Las Vegas).
March 24, 2020
Cloud SQL now supports 96-core machine types for MySQL, Postgres, and SQL Server instances. For pricing-related information, see the Pricing page.
March 16, 2020
Cloud SQL instances using private IP are now accessible across regions, at the regular cross-region network egress cost.
February 24, 2020
Support for us-west3 region (Salt Lake City).
February 19, 2020
Cloud SQL for SQL Server now is generally available. Additionally, Cloud SQL for SQL Server includes new security and performance enhancements. To create SQL Server instances, see Creating Instances.
January 24, 2020
Support for asia-northeast3 region (Seoul).
December 17, 2019
Cloud SQL now supports VPC Service Controls, which let you add a service perimeter around the Cloud SQL Admin API and host project for Cloud SQL instances to reduce the risk of data exfiltration. To learn more about using VPC Service Controls with Cloud SQL, see Configuring VPC Service Controls.
December 13, 2019
You can now use Cloud VPN with Cloud SQL. To get started, see Using a VPN with Cloud SQL.
Connection organization policies for Cloud SQL give you the ability to set policies that control access to and from Cloud SQL instances. To learn more about this feature, see Connection organization policies. To use this feature, see Setting organization policies for Cloud SQL.
December 10, 2019
Cloud SQL now offers notifications for upcoming maintenance. See the Overview of maintenance on Cloud SQL instances. To find out how to sign up for notifications and check your instances for upcoming maintenance, see Finding and setting maintenance windows.
November 25, 2019
Cloud SQL now supports Access Transparency. As part of Google's long-term commitment to security and transparency, you can use Access Transparency, which provides you with logs of actions that Google staff have taken when accessing your data. To learn more about Access Transparency, see the Overview of Access Transparency.
November 19, 2019
Cloud SQL now supports customer-managed encryption keys (CMEK). With CMEK, you can encrypt Cloud SQL instances using a key you manage. To learn more about CMEK, see the Overview of customer managed encryption keys (CMEK). To start using CMEK, see Using customer-managed encryption keys (CMEK).
October 15, 2019
The beta version of Cloud SQL for SQL Server is available. To begin creating SQL Server instances, see Creating Instances.