crud.rb

require 'tiny_tds'
puts 'Connecting to SQL Server'
@client = TinyTds::Client.new(
  host: 'localhost', port: 1433,
  username: 'sa', password: ENV['SA_PASSWORD'],
  database: 'SampleDB'
)

def execute(sql)
  @client.execute(sql).do
  true
end

execute "CREATE TABLE Employees (Id INT IDENTITY(1,1) NOT NULL PRIMARY KEY, Name NVARCHAR(50), Location NVARCHAR(50))"
execute "INSERT INTO Employees (Name, Location) VALUES (N'Jared', N'Australia'), (N'Nikita', N'India'), (N'Tom', N'Germany')"

# ...