Taicheng's Profile

SQL Server unavailable

The following features are unavailable in Cloud SQL and Google Cloud doesn’t support them:

  • SQL Server Analysis Services (SSAS)
  • SP_Configure settings. For more information about this feature, see Configure database flags.
  • Stretch database
  • Backing up to Microsoft Azure Blob Storage
  • Buffer pool extension
  • The OPENROWSET feature
  • Data Quality Services
  • Database Log Shipping
  • Database Mail
  • Distribution Transaction Coordinator (MSDTC)
  • File tables
  • FILESTREAM support
  • Maintenance Plans
  • Performance Data Collector
  • Policy-Based Management
  • PolyBase
  • Machine Learning and R Services
  • Resource Governor
  • Server-level triggers
  • Service Broker endpoints
  • T-SQL endpoints (all operations using CREATE ENDPOINT are unavailable)
  • WCF Data Services
  • The sysadmin role and system stored procedures that require it
  • Hybrid buffer pool
  • Memory-optimized tempdb metadata
  • In-memory OLTP support for database snapshots
  • Registering external languages
  • Row-level security
  • Transparent Data Encryption (TDE). For information about encryption on Google Cloud, see About customer-managed encryption keys (CMEK) and Default encryption at rest.
  • Object storage backup and restore
  • In-memory database: persistent memory
  • Real-time operational analytics
  • Integrated acceleration and offloading
  • Hybrid buffer pool with direct write
  • Multi-write replication
  • Link to Azure SQL Managed instance
  • Contained availability group
  • Always Encrypted with secure enclaves
  • Azure Active Directory authentication
  • Support for PFX certificates and other cryptographic improvements
  • MS-TDS 8.0 protocol and TLS 1.3

Taicheng