dbafromthecold

Title:
How to provision n >TB virtual SQL Server environments from scratch in seconds on a laptop with limited diskspace using containers and clones

Abstract:
Provisioning dev environments is often a slow, complicated and manual process. Often devs simply don't have the diskspace to host a full production dataset locally.

You can solve many of the these problems with virtualisation technologies and source controlled powershell scripts. 

We'll show you how by talking you through:

dbafromthecold

apiVersion: apps/v1beta1
kind: Deployment
metadata:
  name: sqlserver
  labels:
    app: sqlserver
spec:
  replicas: 1
  template:
    metadata:

dbafromthecold

apiVersion: apps/v1beta1
kind: Deployment
metadata:
  name: sqlserver
  labels:
    app: sqlserver
spec:
  replicas: 1
  template:
    metadata:

dbafromthecold

apiVersion: apps/v1beta1
kind: Deployment
metadata:
  name: sqlserver
  labels:
    app: sqlserver
spec:
  replicas: 1
  template:
    metadata:

dbafromthecold

System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 31 - Encryption(ssl/tls) handshake failed) ---> Interop+Crypto+OpenSslCryptographicException: error:2006D080:BIO routines:BIO_new_file:no such file
   at Interop.Crypto.CheckValidOpenSslHandle(SafeHandle handle)
   at Internal.Cryptography.Pal.StorePal.LoadMachineStores()
   at Internal.Cryptography.Pal.StorePal.FromSystemStore(String storeName, StoreLocation storeLocation, OpenFlags openFlags)
   at System.Security.Cryptography.X509Certificates.X509Store.Open(OpenFlags flags)
   at Internal.Cryptography.Pal.OpenSslX509ChainProcessor.FindCandidates(X509Certificate2 leaf, X509Certificate2Collection extraStore, HashSet`1 downloaded, HashSet`1 systemTrusted, TimeSpan& remainingDownloadTime)
   at Internal.Cryptography.Pal.ChainPal.BuildChain(Boolean useMachineContext, ICertificatePal cert, X509Certificate2Collection 

dbafromthecold

Keybase proof

I hereby claim:

• I am dbafromthecold on github.
• I am dbafromthecold (https://keybase.io/dbafromthecold) on keybase.
• I have a public key ASAEQ0Gj3j6xdHe2LG11L72fdCrBIfcFQFk4SpJ0riVUYQo

To claim this, I am signing this object:

dbafromthecold

FROM centos

RUN yum update -y && yum install -y curl sudo

RUN sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo

RUN yum install -y mssql-server

CMD /opt/mssql/bin/sqlservr

dbafromthecold

# create directory for helm
cd C:\git\dbafromthecold\PrivateCodeRepo\Azure\Helm



# create new chart
helm create testsqlchart

dbafromthecold

# create a resource group
az group create --name containers1 --location westeurope


# create a virtual network
az network vnet create --resource-group containers1 --name aci_vnet1


# list available delegations
az network vnet subnet list-available-delegations --resource-group containers1

dbafromthecold

# hack to use PsDatabaseClone to mount a cloned database into a container
# this only works with a local SQL instance to initially host the cloned database
# which is then detached and mounted to a container

# import required powershell modules
import-module dbatools
import-module psframework
import-module psdatabaseclone