viernes, 26 de marzo de 2021

How to Create a SQL Server in Containers with WSL2

Welcome file

How to Configure WSL for Containers

The Windows Subsystem Linux version 2 feature allows the integration of different Linux distributions to be managed in Windows through the hyper-v hypervisor. The WSL2 difference than just being merely virtual machines, this feature allows a real integration with Windows host O.S. by accesing the resources, accessing Windows API’s, allowing executing bash shells, and having full compatilibity with Windows O.S. kernel.

Requirements for WSL

  • 64 Bit Windows 10.04 O.S.

  • VT-X Bios Enabled

  • Virtual Machine Platform feature enabled

  • (Additionally) Docker Requirements:

  • SLT or Second Level Adress Translation

viernes, 5 de marzo de 2021

Configure Nvidia CUDA with WSL2 for SQL Server in Containers

Welcome file

Using NVidia CUDA Toolkit for SQL Server in Containers in WSL2.

NVidia has developed the CUDA Toolkit library designed for developers, aimed to efficiently use the hardware resources. The CUDA Toolkit provides a different set of tools as well as programming guidelines for the different programming languages for the interoperability with the hardware.

Now NVida has released in the v11.2.1 a surprise that is a CUDA on WSL.

This feature is designed for the WSL Images to use of the GPU’s resource.

This is a great impowering for NVIDIA users to utilize their resources in their Windows Subsystem Linux boxes.

Setting up the CUDA Toolkit

First we will Open the Windows Terminal and get inside the WSL default box that we require to configure.

NOTE: This example is configured for distributions based on Apt.

Because the purpose for this excersise is to configure SQL Server in Containers using WSL2, then the distro to use here is Ubuntu, so that the Apt will work here.

Secondly will configure the CUDA repository keys and update the list to re