11/20/2018

Getting Started with SQL Server vNext Early Adoption Program Big Data Analytics Step 1

SQL Server 2019 is right around the corner.  Microsoft offers the ability to sign up for early adoption.  Simply go to this URL and register, if you are granted access, you'll receive an email such as this:





Here's a list of available option to experiment with:



Let's get started with Big Data Analytics.  

Can use this document to experiment with good example:

Configure Azure Kubernetes Service for SQL Server 2019 (preview) deployments



Logged on to Azure Portal using current Login:





It says to create a resource group using Bash:





Initiated a Bash shell window, it prompts to Create Storage:





So we've connected to Bash from within Azure Portal online window:






We're prompted to connect our Device and Login to Cross-Platform Command Line Interface in Azure:




Login to Azure Account:

Bash
az login az account list az account set --subscription az group create --name sqlbigdatagroup --location eastus az aks create --name kubcluster \
--resource-group sqlbigdatagroup \
--location eastus \
--generate-ssh-keys \
--node-vm-size Standard_A2 \
--node-count 3 \
--kubernetes-version 1.11.3







Proceed to enter commands in Bash, select our Subscription:





Set Account, then Created a Resource Group:






Next, attempt to Create a Kubernetes cluster:






We enter the command, it's Running...






Error.  The type of VM we selected exceeds our capacity:






Looking at the Pricing Structure in Azure, we need to select a different plan option:





Tried a different plan, error still...






So we pick one from the available list "Standard A1", which may be Previous Generation, not sure exactly:





And so, the Bash command completed, Success!  It generates a JSON which we copy and store in Notepad.  It generated quite a lot of Services / Resources:






Next, we connect to our newly created Cluster:

Bash
az aks get-credentials --resource-group=sqlbigdatagroup --name kubcluster kubectl get nodes


Enter the command in Bash:






Next command, get kubectl nodes:






So we've completed the first step.  


Next Steps...






https://docs.microsoft.com/en-us/sql/big-data-cluster/quickstart-big-data-cluster-deploy?view=sql-server-ver15


Download the CLI 2.0 for Azure:






Follow along for Step 2 of the process...

https://www.bloomconsultingbi.com/2018/11/getting-started-with-sql-server-vnext_20.html