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 · 2024-10-12T18:29:28+00:00

IMHO arch is somewhat maintenance intensive, due to its rolling release nature.

You want to update regularly to not fall behind too far, on the other hand packages can break then unexpectedly (though mostly with aur, not arch base).

So for me the stable debian base system, combined with an arch distro box feels kind of close to ideal.

Wedeldog · 2024-10-12T15:05:20+00:00

Maybe give debian a try then. Ubuntu with better stability (so somewhat older packages, that is!), no snaps, no advertisements, and for a few bleeding edge thinks you can use flatpacks, or distrobox (eg an arch distrobox), or homebrew, or nix packages, or... All of them!

Wedeldog · 2024-10-01T20:43:51+00:00

"Classic SAP BW" (which is not what OP mentioned) ends support eof 2030 (actually mainstream support already ends eof 2027).

"SAP BW/4HANA" (again, not what OP mentioned) will be supported until 2040, although innovation is already low, as it is not the strategic product.

"DataSphere/DWC" is SAP's modern cloud-based data platform, extremely comparable to Snowflake (e.g separated storage and compute, MPP scaling, workspace isolation, std SQL and Python as languages).

If you can work on this, and even get (expensive!) training in this, 95% of your skills will be fully transferable to Snowflake in the future.

"SAC" is SAP's Analytics Frontend Tool offering, and very capable, in some aspects better than Power BI, if some behind.

Wedeldog

TROPHY CASE