[db tech showcase Tokyo 2017] D21: ついに Red Hat Enterprise Linuxで SQL Serverが使...Insight Technology, Inc.
いよいよリリースが間近に迫ったSQL Server 2017 Linux版。SQL Serverの第一人者 Dr. Kこと熊澤 幸生がリリース版を待ちきれずにRed Hat Enterprise Linux上で検証してみました。
Windows版と Linux版で果たしてSQL Serverの処理性能に差があるのか?注目の検証結果をいち早くお知らせします。
61. わりと縁もゆかりもないところから☆
27
Lviv, Ukraine
Halifax, Canada
Munich, Germany
Darmstadt
Devon, UK
Maine
Bristol
Seattle, Wa
Russia
Seattle, WA
Melbourne, Australia
Berlin
Waffles
Seattle, WA
Toronto, ON, Canada
Gent
Silver Spring, MD
Italy
Hopewell, NJ
Hamburg, Germany
Porto
Porto and Madeira, Portugal
Rochester, NY
Berkeley, CA
Altanta, GA
なんか国外多いし
101. 自前のテスト、サンプルコード (1)
•これは…!?
49
1 describe package('telnetd') do
2 it { should_not be_installed }
3 end
4
5 describe inetd_conf do
6 its("telnet") { should eq nil }
7 end
~
102. 自前のテスト、サンプルコード (1)
•これは…!?
49
1 describe package('telnetd') do
2 it { should_not be_installed }
3 end
4
5 describe inetd_conf do
6 its("telnet") { should eq nil }
7 end
~
103. サンプル(1)を実行
50
$ inspec exec spec/telnet_spec.rb --backend ssh --host=myhost
—user=root --key-files ~/.ssh/id_rsa --format=doc
System Package telnetd
should not be installed
inetd.conf
telnet
should eq nil
Finished in 0.20249 seconds (files took 1.78 seconds to load)
2 examples, 0 failures
104. 自前のテスト、サンプルコード (2)
51
1 only_if do
2 command('sshd').exist?
3 end
4
5 rule "sshd-11" do
6 impact 1.0
7 title "Server: Set protocol version to SSHv2"
8 desc "
9 Set the SSH protocol version to 2. Don't use legacy
10 insecure SSHv1 connections anymore.
11 "
12 describe sshd_config do
13 its('Protocol') { should eq('2') }
14 end
15 end
105. 自前のテスト、サンプルコード (2)
51
1 only_if do
2 command('sshd').exist?
3 end
4
5 rule "sshd-11" do
6 impact 1.0
7 title "Server: Set protocol version to SSHv2"
8 desc "
9 Set the SSH protocol version to 2. Don't use legacy
10 insecure SSHv1 connections anymore.
11 "
12 describe sshd_config do
13 its('Protocol') { should eq('2') }
14 end
15 end
106. 自前のテスト、サンプルコード (2)
51
1 only_if do
2 command('sshd').exist?
3 end
4
5 rule "sshd-11" do
6 impact 1.0
7 title "Server: Set protocol version to SSHv2"
8 desc "
9 Set the SSH protocol version to 2. Don't use legacy
10 insecure SSHv1 connections anymore.
11 "
12 describe sshd_config do
13 its('Protocol') { should eq('2') }
14 end
15 end
127. `inspec shell`便利かも
56
$ inspec shell --backend ssh --host=以下略
Welcome to the interactive Inspec Shell
> usage
You can use resources in this environment to test the target machine.
For example:
command('uname -a').stdout
file('/proc/cpuinfo').content
You are currently running on:
OS family: ubuntu
OS release: 14.04
> package('apache2').installed?
=> true
> file('/etc/default/ntp').content
=> "NTPD_OPTS='-g'n"
128. `inspec shell`便利かも
56
$ inspec shell --backend ssh --host=以下略
Welcome to the interactive Inspec Shell
> usage
You can use resources in this environment to test the target machine.
For example:
command('uname -a').stdout
file('/proc/cpuinfo').content
You are currently running on:
OS family: ubuntu
OS release: 14.04
> package('apache2').installed?
=> true
> file('/etc/default/ntp').content
=> "NTPD_OPTS='-g'n"
129. `inspec shell`便利かも
56
$ inspec shell --backend ssh --host=以下略
Welcome to the interactive Inspec Shell
> usage
You can use resources in this environment to test the target machine.
For example:
command('uname -a').stdout
file('/proc/cpuinfo').content
You are currently running on:
OS family: ubuntu
OS release: 14.04
> package('apache2').installed?
=> true
> file('/etc/default/ntp').content
=> "NTPD_OPTS='-g'n"