SQL Server Big Data Cluster πŸ§­

This list of tools and resources are intended to help you manage a Big Data Cluster (SQL, PDW, HDFS, Spark, k8s) on SQL Server 2019. You can already start familiarizing yourself with them to better prepare your implementation.

Resources

VS Code

  1. Working with Docker in VS Code
  2. Working with Kubernetes in VS Code
  3. Remote Development Tips & Tricks
  4. Remote Development FAQ

Windows Environment

  1. Windows Terminal (Preview)
  2. WSL2 customization
  3. Install WSL on Windows Server

Cross-platform

  1. Zsh kubectl plugin
  2. Kubectl command completion
  3. Minikube command completion
  4. Kubectl plugins

Why VS Code?

  • Cross-platform support
  • Rich ecosystem & development experience
  • Built-in script editing can be leveraged easily
  • Extensions bridge the gap between learning CLI & doing everything through a GUI
  • Microsoft extensions:
    1. Docker
    2. Kubernetes
    3. Remote Development Pack
      • Remote – SSH
      • Remote – WSL
      • Remote – Containers

Shell Setup

  • Windows 10 or Windows Server
    • WSL or git bash provides rich shell experience
  • MacOS/Linux – Use built-in shell
  • ZSH can further improve the experience
  • Leverage VS Code for the remote administration
  • Work from your favorite OS! 😍

Common Tasks

Docker

  • Browse registry
  • Find images
  • Run images
  • Manage containers

Kubernetes

  • Debug & troubleshoot applications
  • Manage multiple clusters
  • Inspect k8s resources easily

Remote Development

  • Editing scripts using VS Code
  • SSH based experience
  • Git integration

Ref: Microsoft SQL Server 2019 Technical white paper

IntegrationDataHub-SQLServer2019DataVirtualizationSolutions-SQLServer2019IncreasePerformance-SQLServer2019BDCIntelligentDatabase-SQLServer2019SQLServer2019StreamingStructuredUnstructuredPredictiveApps-SQLServer2019BDC

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.