When you’re using a Cloud SQL instance as a development server you likely don’t need to have it running constantly. If so, you can greatly reduce the cost of using Cloud SQL by scheduling your development server to start every morning when your work day starts and stop it each evening when you’re done with your development work. Configuring your instances to run this way can save you up to 75% of the cost to run an instance per week versus having it continuously running.
This blog post will walk you through the steps to configure your Cloud SQL instance…
Cloud SQL offers an easy way to perform a database export for any of your databases right from the Cloud Console. Database export files are saved to Google Cloud Storage and can be used via the Cloud SQL import process to be recreated as new databases.
Creating a one-time export file is good but setting up an automated process to do this weekly is even better. This blog post will walk through the steps required to schedule a weekly export of a Cloud SQL database to Cloud Storage. …
Knowing the exact changes made to a SQL Server database on Google Cloud is now possible with the release of support for Change Data Capture (CDC) in Cloud SQL for SQL Server. The following SQL Server versions now support CDC in Cloud SQL:
This blog post will walk through the steps required to enable CDC along with an example query to view captured changes.
First you will need to create a SQL Server instance in Cloud SQL which you can do from the Google Cloud Console.
SQL Server instances in Google Cloud SQL now integrate with Microsoft Active Directory (AD) as a pre-GA feature that you can try out for yourself right now. This post describes the steps required to create a SQL Server instance with this new functionality. If you’re looking for complete details see the official documentation.
Create a domain with Managed Service for Microsoft Active Directory
The first step is to create a domain with Managed Service for Microsoft AD. This can be done easily via the “Managed Microsoft Active Directory” section in the Google Cloud Console. …
Here’s an affordable way to try out SQL Server on Google Cloud at your own pace.
We’re going to walk through the steps required to create a Google Cloud Platform project and start up a Cloud SQL for SQL Server instance. Next, we’ll use Azure Data Studio to create a database with a single table, insert some sample data into the table and then confirm that we can query data from the new table. Finally we’ll shutdown the SQL Server to stop getting charged for it until we’re ready to use it again.
Create a Google Cloud Platform project
Developer Programs Engineer for Google Cloud Databases