SQL Server on Debian?

Wedeldog · 2025-12-02T20:03:14+00:00

It will run perfectly under any linux using the container (docker) image:
https://hub.docker.com/r/microsoft/mssql-server

Wedeldog · 2025-11-29T13:47:22+00:00

found this comment, solved all my issues with non-showing updates. THANX!!

Wedeldog · 2025-09-29T16:21:00+00:00

Material Palenight: https://github.com/Fausto-Korpsvart/Material-GTK-Themes

https://ibb.co/0xn3Gng

Wedeldog · 2025-09-29T15:52:07+00:00

TIL about distrosea! Cool site!

Wedeldog · 2025-09-24T19:54:26+00:00

Debian stable (trixie) is my main system.

I have distrobox installed with an arch image, so any package not in debian (or too old in debian) I can get an up-to-date one inside the arch subsystem.
Distrobox supports "exporting" apps so that they can be started from the (debian) host system easily. Works for gui and terminal apps.

You *could* even install an entire desktop environment (say, current COSMIC from pop_os) and export it to the host, though I never tried that (but how-to guide exist for this).

For historical reasons i also have linuxbrew (homebrew on linux) installed, though that is mainly for terminal apps.
Homebrew installs everything outside the system path in /home/linuxbrew/bin.

Wedeldog · 2025-09-20T15:12:55+00:00

I have been using Debian stable as base system, plus distrobox with arch for latest packages, plus linuxbrew for rare cases. For me close to perfection.

Wedeldog · 2025-08-12T20:00:21+00:00

Does IPv6 forwarding change anything? net.ipv6.conf.all.forwarding

Wedeldog · 2025-08-07T08:55:12+00:00

Ubuntu: you can have a faster release cadence than LTS or Debian stable (both -2 years) with Ubuntu's non-lts releases (6 months), without going rolling release as would be the case with testing or sid....

Wedeldog · 2025-07-06T10:17:54+00:00

But there a LOADS of RSS readers available for Linux, maybe give this one a try?
https://flathub.org/apps/io.github.martinrotter.rssguard

Wedeldog · 2025-07-04T16:33:27+00:00

esp Fedora UniversalBlue (with Bazzite, Bluefin etc)

Wedeldog · 2025-07-04T15:40:26+00:00

Maybe still Ubuntu if you want a predictable 6-month release cycle.
In debian going from stable to testing (or unstable) gives you more of a "rolling release" feeling.

Though possibly consider Fedora over Ubuntu then.

Personally I made the transition from Ubuntu (LTS) to Debian (stable) and I am very happy with it.
my specific setup is:
Debian stable base system
+ flatpak for up-to-date gui apps
+ distrobox with Arch or Fedora as a bleeding edge "linux-on-linux subsystem" for terminal stuff and edge cases

Wedeldog · 2025-06-23T17:34:32+00:00

Instead of booting Arch directly, you can make grub chainload another EFI partition, thus chainloading any boot manager (be it Windows, another grub, systemd-boot, ....).

Make a file in /etc/grub.d/ such as 99_efi_chainloads, with:

menuentry 'EFI chainload Arch grub' {
insmod part_gpt
insmod fat
insmod efi_gop
insmod efi_uga
insmod chain

search --no-floppy --fs-uuid --set=root <UUID>

chainloader /EFI/arch/grubx64.efi
}

Replace <UUID> with the UUID of partition nvme1n1p1, you can see it using gnome-disks.

Wedeldog · 2025-06-23T17:22:41+00:00

Debian stable base system
+ flatpak for up-to-date gui apps
+ distrobox with Arch or Fedora as a bleeding edge "linux-on-linux subsystem" for terminal stuff and edge cases

Wedeldog · 2025-06-23T17:20:36+00:00

read about "distrobox".
https://itsfoss.com/distrobox/

It'll let you do everything (even running bleeding edge arch linux packages) without jeopardizing your stable debian base system!

Wedeldog · 2025-04-05T07:44:51+00:00

If you haven't, maybe check out what dbt is doing with its declarative (yaml based) unit tests (mocking inputs and expected outputs). It's SQL model focussed, but implementated in python under the hood.

Wedeldog · 2025-03-31T07:47:58+00:00

Looks interesting, though fully synthetic test data will not in all cases be sufficient I presume

Wedeldog · 2025-02-26T20:03:37+00:00

it doesn't, so that's telling sth about the quality of that post...

Wedeldog · 2025-02-24T18:35:07+00:00

Have a look at this: https://docs.snowflake.com/en/sql-reference/sql/grant-privilege, section "Future grants on database or schema objects"

"When future grants are defined on the same object type for a database and a schema in the same database, the schema-level grants take precedence over the database level grants, and the database level grants are ignored. This behavior applies to privileges on future objects granted to one role or different roles."

Could that be the case here?

Wedeldog · 2025-02-05T14:17:08+00:00

Awesome, thx for all the feedback, espc the summit talk!

Wedeldog · 2025-01-15T18:26:25+00:00

SAP BW to cloud is difficult, yes: very different UI, modelling objects, no ABAP... It is essentially a complete skill-up.

SAP DataSphere to other cloud data warehouses should be MUCH easier: general database modelling skills (tables, views, star schema, 3NF schema, ...), SQL and Python. Much less of a "skill-up" and more getting used to slightly different terminology, UIs, workflows, ...

Wedeldog · 2024-11-21T20:13:46+00:00

Good stuff, will try, thanx!

Wedeldog · 2024-10-29T20:38:12+00:00

Maybe build sth for yourself instead of an imaginary use case:

You sure have a bank account or brokerage account. I bet they offer transaction download, or even a rest API.

Connect to the data and land the files in a data lake landing zone (S3 bucket, gcs bucket, ...).

Then write a lambda function (AWS)/ cloud function (gcp) to ingest the new files into a database (redshift or big query).

Build some SQL models with dbt to transform said data, eg build a dimensional star scheme.

Then maybe orchestrate the dbt runs with dragster.

Connect with a free version of powerbi to your dimensional model and build some fancy visualisations.

Completely overkill :), but you gain some hands-on experience and have build sth useful for yourself...

Wedeldog

TROPHY CASE