Skip to content

Instantly share code, notes, and snippets.

View croblesm's full-sized avatar
😎
The beginning of all things to come 👍🚀

Carlos Robles croblesm

😎
The beginning of all things to come 👍🚀
View GitHub Profile
@croblesm
croblesm / CustomScript.ps1
Created July 25, 2022 21:01
DBA-VM-Scripts-v3
Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://community.chocolatey.org/install.ps1'))
choco feature enable -n allowGlobalConfirmation
choco install vscode -y
choco install azure-data-studio -y
choco install sql-server-management-studio -y
choco install azure-cli -y
choco install az.powershell -y
choco install microsoft-edge -y
Install-PackageProvider -Name NuGet -MinimumVersion 2.8.5.201 -Force
Install-Module -Name SqlServer -Force
@croblesm
croblesm / CustomScript.ps1
Last active July 21, 2022 23:50
CustomScript-v3
Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://community.chocolatey.org/install.ps1'))
choco feature enable -n allowGlobalConfirmation
choco install vscode -y
choco install azure-data-studio -y
choco install sql-server-management-studio -y
choco install dbatools -y
choco install azure-cli -y
choco install az.powershell -y
Install-PackageProvider -Name NuGet -MinimumVersion 2.8.5.201 -Force
Install-Module -Name SqlServer -Force
@croblesm
croblesm / CustomScript.ps1
Last active July 8, 2022 23:45
CustomScript-v2
Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://community.chocolatey.org/install.ps1'))
choco feature enable -n allowGlobalConfirmation
choco install git -y
choco install vscode -y
choco install azure-data-studio -y
choco install sql-server-management-studio -y
choco install dbatools -y
choco install azure-cli -y
choco install az.powershell -y
choco install wget -y
@croblesm
croblesm / CustomScript.ps1
Last active June 29, 2022 22:05
CustomVM-v1
Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://community.chocolatey.org/install.ps1'))
@croblesm
croblesm / Dockerfile
Last active December 7, 2021 18:14
msql-tools custom image using Alpine
# SQL Server Command Line Tools - custom image
# From Alpine 3.11 (~5 MBs)
FROM alpine:3.11
LABEL maintainer="@dbamastery"
# Installing system utilities
RUN apk add --no-cache curl gnupg
# Adding custom MS repository for mssql-tools and msodbcsql
RUN curl -O https://download.microsoft.com/download/e/4/e/e4e67866-dffd-428c-aac7-8d28ddafb39b/msodbcsql17_17.5.2.1-1_amd64.apk

MCR - SQL Server images

Ubuntu based images

Bash 👇

curl -L https://mcr.microsoft.com/v2/mssql/server/tags/list/

Powershell 👇 🔌🐚