aballiet

edit /usr/share/alsa/alsa.conf

with values :

defaults.ctl.card 1
defaults.pcm.card 1
defaults.pcm.device 0

aballiet

See video tutorial here

1. Update & install packages

sudo apt-get update
sudo apt-get install dnsmasq
sudo apt-get install iptables

aballiet

Convert Microsoft SQL Server Database to PostgreSQL

Converting Microsoft SQL Server Database to PostgreSQL may be a painful task, here is a tutorial that allows you to transfer your data while keeping a fairly decent mapping

Tutorials for Windows only

Setting up your Microsoft SQL Server

1. (if not installed yet) Install Microsoft® SQL Server® 2019 Express
2. (optional) Import your MSSQL DB to your server
3. put the dump file in C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Backup

aballiet

Stream any Audio source through any computer under any VPN blocking network using Bluetooth

Use Cases

Sometimes we may need to use computers (without Admin Privileges) connected to Corporate / Private networks with VPN that does not allow streaming audio from popular streaming websites : Spotify, YouTube, etc.

In such scenario we may also need to hear the sound directly form the computer (Skype Notifications / Microsoft Teams / Calls / System sounds...).

Listening to your music with your smartphone or any other external device, may not be the best solution as you will have to disconnect/reconnect your headphones between your computer & the external device you need to use.

Approaches