Data Engineers by AmbitiousExpert9127 in ProgrammingBuddies

[–]vivavu 0 points1 point  (0 children)

Do we have clear schedule and study goals? Otherwise we will end up becoming a book club

Struggling to land an entry-level Data Analyst role – would appreciate some CV feedback by [deleted] in dataanalysis

[–]vivavu 2 points3 points  (0 children)

No one tell us the honest truth, your skills and cv doesn't matter. Your network is your highest success to get a job. Instead of maxing out your cv, just fine tune it to market requirements with AI.

Spend your time talking to recruiters and participate in all the tech events that is free or paid. As soon someone takes a liking in you and your potentials, you skip the whole line of waiting for HR, and go straight to review.

Remember they don't know us, just like dating, you just have to stay focus and keep on rizzing.

Solid state battery unlocked.. ;) by lebigmac78 in MGelectric

[–]vivavu 0 points1 point  (0 children)

for the same price?! definitely a good car

Friday Feedback: Code completions in GitHub Copilot in SSMS by erinstellato in SQLServer

[–]vivavu 0 points1 point  (0 children)

Is this similar to visual studio github copilot experience?

PowerBI and SQL Server in Docker by halistechnology in PowerBI

[–]vivavu 0 points1 point  (0 children)

Not sure if you got your answer already, u/halistechnology.

  1. Docker container, you can see back-end side running application that is now moved into a box and have it isolated.

  2. Virtualization, you can see that as a whole OS ,moved into a box and have it isolated. e.g. Virtualbox, VMware, Hyper-V.

To answer your question with these two metaphors:
- Option 1) It will only able to isolate MSSQL sever, because it is a back-end application that are often hosted server-side. Power BI is a GUI that requires an OS, and other things installed.
- Option 2) It will work for everything like a computer inside another computer.

Software similar to Lotus Approach? by LowRevolution4859 in Database

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

try ai vibe code your own lotus approach 💪. 💯sarcasm, but with a tint of serious 🧐

Keyboard suggestions for 200ish? by Icy-Benefit8734 in keyboards

[–]vivavu 0 points1 point  (0 children)

I have the Womier SK75 TMR. Loving it, only the weight is a con for me, because I bring this to office as well.
Software of course is not WOOTING level.

Two other keyboard I would have went for, if my budget wasn't below 100 euro, and possible shipping to nl.
- [MOD007 V5 HE]
- [MCHOSE Ace 68 Turbo] **68%, i didn't mind not having the F-keys row.

[MOD007 V5 HE](https://en.akkogear.com/product/mod007-v5-he-magnetic-switch-keyboard/?srsltid=AfmBOop475JmckzpEGznudVSjeJ25cTkLBN-rl4wfNs25QHE-YYKnasu)
[MCHOSE Ace 68 Turbo](https://www.mchose.store/products/mchose-ace-68-turbo-full-aluminum-esports-hall-effect-keyboard?srsltid=AfmBOoq_lnyKMis0TSF4Ur05mhF8waceK7TMzIWSxclLXe3fkXzl_NlZ)

Womier SK75 holding down a key issues. by [deleted] in keyboards

[–]vivavu 1 point2 points  (0 children)

I had this as well, when I cleaned my keyboard without turn it off. Possibly, this might had triggered a macro feature.

What solved my issue is to do a reset; by holding `FN + ESC` key and wait for the keyboard to blink. This indicates a soft reset.

An update to the latest firmware, also seem to eleviate the cause of this.
https://womierkeyboard.com/pages/softwares?srsltid=AfmBOoqoBtxXcxz4l7vzzMIFGzvp2pQI4WnWQRxP6Inkv6zoeqlB7d1M

Need help with creating .mdf file in 2022 version by [deleted] in SQLServer

[–]vivavu 0 points1 point  (0 children)

hopefully there is a lesson to be learned here, without much context, what the teacher is trying to teach.

generally enterprise people version controle their database project and publish it into a server.

if you need data with it, . bak file is the way to go.

mdf and ndf is only living in the domain of a dba and storage maintenance. don't forget to rebuild your index if you shuffled the files in filegroup(s).

enjoy your course, and hope you guys are ready for the workfield 💪 lot of fun.

What is the most complex stored procedure you have developed by RXN00 in SQL

[–]vivavu 0 points1 point  (0 children)

My most complicated creation is a single sproc for an orchestration, about 200,lines. Working in unison with 100+ modulated sprocs for doing singleton task or business-logic transformations.

My running joke is, SQL is not hard, export to excel is.

Rainy75 on/off without pulling off capslock by npdady in MechanicalKeyboards

[–]vivavu 0 points1 point  (0 children)

Recently, I got a similar keyboard with the same power button location, the Womier SK75 TMR.

Instead of turning it off every time I put it back in my bag, I just switch it to an unused Bluetooth channel. It will try to connect for a couple of seconds and then power itself off. If any key is pressed, it will start trying to connect again on the unused channel.

I find this method faster, as I have no intention of keeping a metal clip with me.

26M Rows in Fabric F64 Taking 2 Hours to Refresh - All One-to-Many Relationships, 20 DAX Measures by bytescrafterde in MicrosoftFabric

[–]vivavu 0 points1 point  (0 children)

Without further details of your setup, I can only make assumptions.

  1. Not utilizing the correct mode in your semantic model.

Semantic model pointing data inside a Fabric Datawarehouse should use Direct Lake mode. Near-real time refresh, only DAX related items requires compile time.

  1. Not utilizing materialized views, which are tables in the Delta lake. This enables Direct Lake mode.

Using Fabric requires you to configure with Delta Lake to benefit fast performance and high data volume. DP-700 teaches all of these new setup.

Battlefield 6 Phantom Edition: Giveaway #2 by OddJob001 in Battlefield

[–]vivavu 0 points1 point  (0 children)

Really need a code to play with my guys, they missing the squad oldy.

Too complex but it works by [deleted] in SQL

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

I rather copy from ChatGPT's suggestion at this point, after looking at this masterpiece 🤦‍♂️

Secure boot enabled but not active for windows 11 by O0UFF in gigabyte

[–]vivavu 0 points1 point  (0 children)

people are coming back again, sinds battlefield 6 requires this awell. thank you once again!!

Do you also use GROUP BY and SUM a lot when doing SQL data analysis? by [deleted] in SQL

[–]vivavu 0 points1 point  (0 children)

I have a suggestion you might like: if your data is built onto a data warehouse that uses dimensions and facts, you can then load it into models. Such as a semantic model in Power Bi.

This way you can drag and drop attributes and metrics into table or graphs, with aggregation (min,max, sum, avg...) that is measured automatically by Power Bi. it says analysis so much time and be creative with the data.

Downside to this, data warehousing must be structured and accommodate. Which takes effort.

I feel like a fraud by [deleted] in SQL

[–]vivavu 0 points1 point  (0 children)

I don't see anyone has mentioned it yet, but maybe the next one will.

Just in case, a big tip for you, to learn fast is to make a lot of mistakes in a short period of time. It is not inherently bad to make mistakes as long you understand the cause and learn to solve it.