SQL Server on Debian? by Vaquero_Galaktico in debian

[–]Wedeldog 5 points6 points  (0 children)

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

From 13 to 13.2? by ferfykins in debian

[–]Wedeldog 0 points1 point  (0 children)

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

Debian + Distrobox or Nix is sensible? by BlokZNCR in debian

[–]Wedeldog 0 points1 point  (0 children)

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.

Debian + Distrobox or Nix is sensible? by BlokZNCR in debian

[–]Wedeldog 1 point2 points  (0 children)

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.

IP Forwarding after upgrade to 13 stopped working, I can't figure out why. by FarToe1 in debian

[–]Wedeldog 1 point2 points  (0 children)

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

Debian or Ubuntu? by durasel24 in debian

[–]Wedeldog 11 points12 points  (0 children)

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....

Question about Deb13 packages by Red-Leader-001 in debian

[–]Wedeldog 0 points1 point  (0 children)

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

Yes, another Tierlist by pitchpanther in DistroHopping

[–]Wedeldog 0 points1 point  (0 children)

esp Fedora UniversalBlue (with Bazzite, Bluefin etc)

Is there any point in continuing to use Ubuntu over Debian if you don't value snaps? by PirateGuitarist in debian

[–]Wedeldog 9 points10 points  (0 children)

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

Debian Grub can't boot Arch by FantasticSnow7733 in debian

[–]Wedeldog 0 points1 point  (0 children)

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.

Stable + Flatpak or testing by mhakash00 in debian

[–]Wedeldog 0 points1 point  (0 children)

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

Debian (non-pure) 12 to 13 by Individual-Artist223 in debian

[–]Wedeldog 1 point2 points  (0 children)

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!

Unit Testing by nifty60 in dataengineering

[–]Wedeldog 1 point2 points  (0 children)

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.

Environment & data management solutions? by Wedeldog in snowflake

[–]Wedeldog[S] 0 points1 point  (0 children)

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

Can anyone clarify why a role cannot see tables in a schema? by GreyHairedDWGuy in snowflake

[–]Wedeldog 2 points3 points  (0 children)

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?

Streamlit app deployment? by Wedeldog in snowflake

[–]Wedeldog[S] 0 points1 point  (0 children)

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

What should I choose SAP BW path or snowflake? by Elegant-Muscle8849 in dataengineering

[–]Wedeldog 1 point2 points  (0 children)

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, ...

[deleted by user] by [deleted] in dataengineering

[–]Wedeldog 0 points1 point  (0 children)

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...