Configure Nvidia CUDA with WSL2 for SQL Server in Containers

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

Speaking in VGs about WSL2 for Database Development Environment

In this 2020 I've had the oportunity to talk about WSL2 and its uses for databases (Specially for SQL Server). It is always a good chance to contribute to the community, and in that search you always want to explain as many tools and technics as you possibly can. I've encounter myself in this dilema, while trying to explain step by step the use of Containers for SQL server and the visual tools around it.

In this effort trying to show the use of Visual Studio Code and Azure Data Studio as primary tools around the use of Containers for SQL Server for some time now. This year I've tried to incorporate the use of Windows Subsystem Linux (WSL2) as a real interface to use Containers instead of the traditional Docker Distros (Boot2Docker and MobyLinux). Using WSL2 interacting in both worlds Linux and windows as a host OS, creating scenarios for data use in stateful solutions to have data persistance for containerized pactices in your coding.

Participando para COECYS 2020

Participando por segunda vez para el Congreso de Ciencias y Sistemas (COECYS), participar para mi Alma-mater es muy especial. Realmente apoyar en la medida de lo posible a las nuevas generaciones de estudiantes en las mismas aulas que uno habito es muy bueno. En este tiempo tan complejo, es interesante ver como COECYS ha cambiado, tambien es importante ver que es una oportunidad para ampliar la gama de expositores hacia espacios internacionales, pero mas importante que sea en pro de un alto nivel academico.

COECYS XX

COECYS XX - 2020 | Congreso de Estudiantes de Ciencias y Sistemas 

I'm Speaking at SQL Saturday 1016 - Sao Paulo

With all that had happened this year, it is good to see that SQL Saturday still goes on for the region, it is great to be at this event!. It's applaudable the effort made by the local team to make this event happen.

 

Being at the Canonical - WSL Conf 2020

I'm honored and happy to participate at the WSL2 Conf!. A few months ago Microsoft has launched the WSL2 and Canonical has embraced it with effort and joy, in the second edition of WSL Conf Canonical has invited a pool of guest speakers of different nationalities and specialties to share collective knowledge on the subject for the comunity in which Im happy and thrilled to be part of.

Windows Subsystem Linux has a lot of potential to offer to the Windows world, by bringing the Open Source world to the Windows system as guest, infinity of possiblities are opened, as a part of that inclusion SQL Server is in those posibilities.

Winning the MVP Award

It’s been quite a week and surprisingly good news receiving this prestigious award.  I feel very honored and happy. I can remember the work made for the community and all the path behind me, In which without a doubt I couldn’t have done without the help and support of all my work friends specially my community colleges specially Carlos Robles who have mentored me and help me all the way.

How to check the integrity of your SQLServer media installer

Have you ever have an issue where you are pressed with limited time to deliver media took forever to be placed at target new server and everybody is expecting the release? not to mention you still need time to configure monitoring and best practices configurations settings to the new asset. Because of your precious time, it is a good practice to verify the media installer prior to do anything as it might be corrupted by many factors during download, transportation..

Being a moderator on 24HOP

Definetly it was a great chance and experience to be moderator at this great session having the opportunity with Kellyn Gorman's session.

Migration Tour 2019 - Guatemala

Es muy emocionante anunciar que PASS nos ha dado la oportunidad como grupo local de SQL Server de ser organizadores de un evento llamado “Modern Migration Tour”.
Este evento se llevara a cabo el proximo 26 de Junio a partir de las 9 AM , sera un dia completo de training GRATUITO.
El fin del soporte para SQL Server 2008 esta cerca (9 de Julio), significa que es tiempo de trabajar en su estrategia de migracion.