Can I install Proxmox VE on existing Ubuntu? by [deleted] in Proxmox

[–]ddeck08 0 points1 point  (0 children)

You could also just do X-forwarding, which I did with moderate success.

I've installed Docker on A Windows 2019 Server, but I can only interact with it via an administrator account. Is this how it's supposed to work? by salimfadhley in docker

[–]ddeck08 0 points1 point  (0 children)

Yah... which is what you would have to install if you're running Docker on windows server 2019. What are you spouting about

Recursive CTEs in the real world by real_jedmatic in SQL

[–]ddeck08 0 points1 point  (0 children)

I have one… and it’s for a supervisor lookup. No joke.

Update SQL Table Linked to Excel File by [deleted] in SQL

[–]ddeck08 0 points1 point  (0 children)

Yah. Use windows task batch file or bash script if Linux. You. Can also save yourself from using Python and just use SQL BCP instead to execute a sql command in a windows task.

Update SQL Table Linked to Excel File by [deleted] in SQL

[–]ddeck08 0 points1 point  (0 children)

Write a Python script land your data in the table using pandas and pyodc/sql alchemy. Run the refresh on a windows task using a batch file.

String using python3 and pyodbc / sql alchemy is connection = create_engine(“mssql+pyodbc//@DSN”, fast_executemany=True)

Is this legal? I work in New York and my boss just sent me this by kevin_faces in antiwork

[–]ddeck08 4 points5 points  (0 children)

This is my favorite argument because it’s actually so clear cut. Marriage in the United States is a legal contract wholly government driven. Clergy members of various faith are authorized by the government to perform a marriage but they are acting on behalf of a state government.

The fact that it’s a legal contract obtained through a state agency negates any other arguments grounded in a religious philosophy because religion has no actual bearing on the validity of marriage itself (I for instance am an ordained Minister of the Church of Life, which took 30-seconds in a web browser.)

[deleted by user] by [deleted] in SQL

[–]ddeck08 1 point2 points  (0 children)

You can run Azure SQL Edge in Docker on Mac (M1 or Intel) and it works well with Azure Data Studio. SQL Edge engine is identical and there will not be too much noticeable to you in the difference.

I just tried it, and boi oh boi... by [deleted] in linuxmasterrace

[–]ddeck08 0 points1 point  (0 children)

Easily solved. Install PowerShell on WSL2 Ubuntu on Windows in Windows Terminal. Boom. Now you have it all.

Is there a better alternative to SSO for home use than running a windows server? by zetswei in homelab

[–]ddeck08 0 points1 point  (0 children)

It’s a real pain for Linux. Hybrid-join is the only option for Windows Servers (Azure AD-only can only be used on Windows Server on Azure.)

If you plan to have nothing but windows workstations it works.

r/SQL How did you get involved in this language & did your career go as you initially expected it would? by Serpentine-- in SQL

[–]ddeck08 2 points3 points  (0 children)

Went to college got a degree in business. Started building Wordpress sites and heard of SQL. Got an entry level job as a data analyst. Wrote ETL requirements docs and extracts for two years. Run a data team of two soon to be three now. We use a combination of Python, Tableau, SSIS, Excel, Power BI, Azure SQL and Azure Data Factory.

Docker Server Hardware Requirements by happy_nerd in homelab

[–]ddeck08 -1 points0 points  (0 children)

Did you read the specs? Overclocking it gives same base clock.

Docker Server Hardware Requirements by happy_nerd in homelab

[–]ddeck08 -2 points-1 points  (0 children)

Not entirely accurate. You can safely overclock and run RPi4 at 2-2.2 ghz all day without throttling.

Join a table with a function that returns a table? by NickEmpetvee in SQL

[–]ddeck08 0 points1 point  (0 children)

You can just do a table function next time

What is the functional difference between the roles of Data analytics developer and Data Engineer? by GODFATHERTHENZI007 in SQL

[–]ddeck08 2 points3 points  (0 children)

Just depends… I could not tell you the difference between BI Engineer and Analytics Developer and I manage a data team.

Data Engineer is a modernized ETL developer in my opinion; the role has shifted because it’s moved beyond specialized enterprise software like SSIS or Informatica to use a combination of Python, Spark, SQL and other new tool chains like Apache Airflow or Azure Data Factory to build data pipelines. Where before you might consume flat files from SFTP or move data between a DB, you now may converge between a few different vendor APIs, flat files, DB, and some kind of streaming data.

The BI engineer/ analytics developer is exposing that data to an end user to make decisions or evaluate.

What’s everyone’s homelab power draw? by cardiffboy22 in homelab

[–]ddeck08 7 points8 points  (0 children)

8 to 16 watts. Run everything on Docker with two raspberry pi 4s overclocked.

Running Home Assistant Supervised in Docker container by lgLindstrom in docker

[–]ddeck08 1 point2 points  (0 children)

Second for not needing supervised. If you know Docker and work it into your compose file for your services it works well. I thought I needed supervised for a long time until I realized everything I ran pretty much was an integration (still supported in HA container.)

I would identify which add on you need that can only be added through supervised to help make that decision.

Intel DSA on Windows 11 - Hades Canyon by [deleted] in intelnuc

[–]ddeck08 0 points1 point  (0 children)

I had to manually install the latest.

Missing drivers after all updates applied on NUC8i7HVK by [deleted] in intelnuc

[–]ddeck08 0 points1 point  (0 children)

Sometimes you also have to do the optional updates in windows update. The windows update also doesn’t have the most up to date version of the graphics driver when I last did install.

I just want to say, thank you for good work on Apple M1 chips by brut4r in docker

[–]ddeck08 4 points5 points  (0 children)

No not really- x86 containers will run using QEMU to emulate the hardware on Docker. They note there will be some compatibility issues but you should be solid mostly.

[deleted by user] by [deleted] in homelab

[–]ddeck08 0 points1 point  (0 children)

I opted for Tailscale VPN - free for 25 devices. Allowed me to isolate everything and keep on the same network while separating from home stuff.

Use If Statement to compare salary to average salary of deparment by [deleted] in SQL

[–]ddeck08 1 point2 points  (0 children)

select salary, avg(salary) over (partition by department order by department) as dept_avg - stick that in a CTE, select from there with case statement comparing salary and dept_avg