June 2023 – Run SQL Server BLOG

11th June 202311th June 2023

DBATools Get-DbaDatabase] Failure | The certificate chain was issued by an authority that is not trusted.

If you get the error:

Get-DbaDatabase] Failure | The certificate chain was issued by an authority that is not trusted.

You can set in dbatools:

Set-DbatoolsConfig -FullName sql.connection.trustcert -Value $true -Register

1	Set-DbatoolsConfig -FullName sql.connection.trustcert -Value $true -Register

# Set these defaults for all future sessions on this machine
Set-DbatoolsInsecureConnection

# Set defaults just for this session
Set-DbatoolsInsecureConnection -SessionOnly

# Set these defaults for all future sessions on this machine

Set-DbatoolsInsecureConnection

# Set defaults just for this session

Set-DbatoolsInsecureConnection -SessionOnly

dbatools sql The certificate chain was issued by an authority that is not trusted.

11th June 202311th June 2023

Docker build

Some usefull docker command in powershell windows :

Prerequisite: Visual Studio Code Remote Development Extension Pack

# 1. Build the infrastructur in github directory:
docker-compose build

# 2. Run the infrastructure
docker-compose up

# 3.When done, clean up the environement by running
docker-compose down

# 1. Build the infrastructur in github directory:

docker-compose build

# 2. Run the infrastructure

docker-compose up

# 3.When done, clean up the environement by running

docker-compose down