Uses ActiveRecord to manage opening and closing a connection to Cloud SQL for SQL Server and to insert data.

## Explore further


For detailed documentation that includes this code sample, see the following:

- [Manage database connections](https://docs.cloud.google.com/sql/docs/sqlserver/manage-connections.md.txt)

## Code sample

### Ruby


To authenticate to Cloud SQL for SQL Server, set up Application Default Credentials.
For more information, see

[Set up authentication for a local development environment](https://docs.cloud.google.com/docs/authentication/set-up-adc-local-dev-environment.md.txt).

```ruby
@vote = Vote.new candidate: candidate

# ActiveRecord creates and executes your SQL and automatically
# handles the opening and closing of the database connection.
if @vote.save
  render json: "Vote successfully cast for \"#{@vote.candidate}\" at #{@vote.time_cast} PST!"
else
  render json: @vote.errors, status: :unprocessable_entity
end
```

## What's next


To search and filter code samples for other Google Cloud products, see the
[Google Cloud sample browser](https://docs.cloud.google.com/docs/samples.md.txt?product=cloudsqlforsqlserver).