connect.rb

require 'tiny_tds'
puts 'Connecting to SQL Server'
@client = TinyTds::Client.new(
  host: 'localhost', port: 1433,
  username: 'sa', password: ENV['SA_PASSWORD'],
)
def execute(sql)
  @client.execute(sql).do
  true
end
puts 'Creating Database'
execute "CREATE DATABASE SampleDB"
@client.close
puts 'Done'

# Output
Connecting to SQL Server
Creating Database
Done