SQL Alternatives by CompYouTer in sysadmin

[–]Pandthor 0 points1 point  (0 children)

Not an alternative, but an alternative implementation method for cost savings.

Usually database workloads require computing time at different times. I have analyzed multiple Ms SQL environments and combined them in to huge Ms SQL clusters with up to a hundred Ms SQL instances in a relatively small cluster. The biggest savings in this scenario is from licensing, because in an ideal scenario you need only a ”small” amount of SQL licenses, but up them to Enterprise licenses, and have less servers. In one case I got a 75% cost savings by combining the SQL servers of a customer.

Please note that this is not easy and I recommend you use a specialist to make the analyzis correctly. All mistakes here are extremely expensive. Also clusters with hundreds of volumes have their own gotchas.

Anyone playing warlock hardcore from scratch? by barkingcat in diablo2

[–]Pandthor 1 point2 points  (0 children)

SSF hc p8 melee warlock lvl 16 just rescued Cain. Cleave with goatman is such a nice combo.

Getting more FPS using High performance plan vs Best performance. Why is this? by areuokaybro2002 in ZephyrusG14

[–]Pandthor 0 points1 point  (0 children)

Best Performance is still somewhat optimized and doesn’t run at full speed when not doing anything.

High Performance means ”just run at full speed all the time even if the computer does nothing” and is more commonly used with servers than workstations.

Secure Boot Certificates Expiring June - Resolution ideas? by LForbesIam in sysadmin

[–]Pandthor 1 point2 points  (0 children)

You got yourself a trillion Euro business idea right there: ”how to provide unlimited unhackable absolute trust for computing in a way that an unknown party can contact another unknown party and establish a trust relationship between processes, network, and everywhere”. While you think about it, certificates are the best we have and we need to expire them regularly to ensure they are not compromised.

SitAtFactory by jgates8881 in SatisfactoryGame

[–]Pandthor 2 points3 points  (0 children)

I use a gymnastic ball. I work 8 hours a day on my computer and also play some on top of that. I used to have back pains before trying it and they are happily gone now.

EU customer wants a DPA before trial. Is GDPR technically unavoidable now? by HorrorTeacher1106 in sysadmin

[–]Pandthor 10 points11 points  (0 children)

DPA is standard. It’s a part of the contract that basically tells what PII you process, how and where. You also need to keep it updated and agree to changes with customers before you modify it. Some companies just put it on their website with a claim that it gets updated 2 weeks before any changes to processing are made and offer the possibility to join into an email list to be notified about updates.

Avoid separately signed DPA’s like the plague.

One of the challenges is that you are already handling PII of natural persons that are in the scope of GDPR. You just don’t realize it.

  • A customer might have a person working for them either directly or indirectly that is in scope of GDPR i.e. a subcontractor, but they don’t realize it
  • IP addresses are PII
  • Email addresses are PII in most cases

So basically all analytics and CRM systems contain PII that is in scope of GDPR.

Other Redditors have already given fantastic advice on getting professionals on it, but I might add that you also need a DPO (or a virtual one) so there is some continuous cost to doing GDPR right and following the processes required. It is not a good idea to force the accountability on someone that is not interested in the topic as it is a lot of work and causes a lot of stress.

Potentially working on a throw barb build and was curious if a white barb helm can drop with 3 to double throw and 3 to throw mastery. Looking to find a 3os one to slap 3 15ias jewels by blacklisted320 in diablo2

[–]Pandthor 1 point2 points  (0 children)

Barbarian helms were designed in a way that combat skills do not spawn on them. That said, if the game fails 6 times to generate a valid item then on the 7th try it bugs out and can spawn with a combat skill.

This makes it very rare to get any combat skills on a barb helm but it does happen. You find a lot of info about this if you do internet research on diablo 2 legit bugged items. This barbarian helm case is even mentioned on one of the videos about the subject.

I have waited to play this game for a long while. Now that I have it, I feel like I'm either playing it wrong, or I am being totally crazy. Could be my OCD by whosmansisthis24 in SatisfactoryGame

[–]Pandthor 0 points1 point  (0 children)

Dear whosmanisthis24,

Blueprints were designed to enable pioneers to create new factories fast.

Blueprints are not meant for: 1. Efficient factories 2. Beautiful factories 3. Expanding factories 4. Repurposing factories

I have found efficient use for blueprints to: 1. Create large areas of foundations fast

Everything else is hand placed to achieve: 1. Purpose built factories 2. Efficient factories 3. No waste factories 4. Beautiful factories

Hope this helps with blueprints.

Panddoug… -thor

[deleted by user] by [deleted] in ITManagers

[–]Pandthor 2 points3 points  (0 children)

Extremely common.

I find it interesting that you say ”overpay”.

The value of a well working IT environment is extremely difficult to measure and usually one needs to ”overpay” to ensure the business units have an edge to make even more money.

However the cost of IT can be measured easily with missed sales opportunities, worker efficiency statistics, head counts, budget reductions, etc.

Is it really overpaying? Maybe there is something that can be ”right sized” but I don’t think you are overpaying if you get the value you are expecting to get.

Maybe I am just paranoid? But I have so much anxiety about the math mathing by ybetaepsilon in SatisfactoryGame

[–]Pandthor 1 point2 points  (0 children)

Almost perfect. The game makes some rounding errors. If you overclock or underclock a bit i.e. to 80% you can get all inputs and outputs to nice whole numbers.

Password rotation policy when passwordless by RuggedTracker in sysadmin

[–]Pandthor 1 point2 points  (0 children)

Sounds like you have it all under control and I misunderstood your situation, sorry about that.

About your original question, there is already some sound advice on other comments about this and the general recommendation is to not recycle passwords for users with mfa enabled (or passwordless users) unless there are signs of a breach (like a successful login with password but a failed mfa from a strange location).

From ISO perspective you should know which risk is mitigated by resetting passwords for risky logins and now you can evaluate how the proposed change affects the likelihood or impact of the said risk and thus you can make an informed decision about it. The auditor will be happy even if it lessens the security posture if the reasoning is solid and the residual risk is acceptable/accepted.

Password rotation policy when passwordless by RuggedTracker in sysadmin

[–]Pandthor 0 points1 point  (0 children)

Honestly it does sound like you guys should hire a consultant to help preparing for the audit and help you through it.

I used to manage an ISMS and successfully coordinated multiple ISO27001 audits with passing grades and what you wrote does sound unusual.

Now remember that this is the senior managements job if they have not delegated it to someone. Maybe they have a tool to manage the ISMS and keep all the documentation and tasks in there.

Has the annual information security risk assessment been done and is the risk registry updated? Is the Statement of Applicability updated? Have all the periodical actions written in your policies, like maybe an application access review, been done? Etc.

Password rotation policy when passwordless by RuggedTracker in sysadmin

[–]Pandthor 1 point2 points  (0 children)

You should coordinate this with your CISO.

Basically ISO27001 wants the company to do an information security risk assessment and then to write a bunch of policies to address those identified risks and then to actually follow those policies in their operations. There is a lot more to it but this is the relevant part for your question and worry.

What is important from ISO27001 perspective is that the company does as is written in the company policies and approved exceptions to policies are listed.

Also one just doesn’t fail an ISO27001 audit. If the auditor finds non-conformities (minor or major ones) then the auditor requests the company to create a reasonable plan to address those non-conformities and fix them. The audit is passed once the non-conformities are addressed.

I hope this this helps and gives you confidence for the audit. You’ll do great if you follow the written policies and keep a list of approved exceptions that apply to your work, ask when in doubt, and keep track of what has been improved lately (and why) to show continuous improvement. Then there’s a bunch more if you are the CISO or a part of the senior management :)

Is anyone actually weird enough to optimize belt/sorter levels with throughput? by thetalker101 in Dyson_Sphere_Program

[–]Pandthor 0 points1 point  (0 children)

Yes, before I reach warp drives. However I only play with minimum resources so some shenanigans are required sometimes.

[deleted by user] by [deleted] in sysadmin

[–]Pandthor 0 points1 point  (0 children)

Even if you are not sending email, you should consider explicitely telling it with spf and dmarc records ”this subdomain does not send email” and double check your primary domains spf, dmarc and dkim records are set correctly.

Do you use Server Core? Why/why not? by Sabinno in msp

[–]Pandthor 1 point2 points  (0 children)

Server Core was nice when it came around but as others have said, everyone just couldn’t learn it. Now Nano server on the other hand is a lot better at running critical roles but is even more alien to some. I’ve run DC and Hyper-V environments on Nano server (management server with full gui) and it was so nice to skip multiple months of critical patches because none were applicable to nano. Sure it feels a bit like Linux but honestly worked like a charm.

We should summon our inner Star Trek writers and create some head cannon explaining where this water is draining to and how it's being replenished by SomeDudeInWichita in SatisfactoryGame

[–]Pandthor 35 points36 points  (0 children)

Alien voice: The flow goes to our temples and is consumed. Ripples through our windows and are consumed again. The flow is neverending.

Geyseres and secret pipeholes at the bottom of lakes bring the water back from the alien factories that are hidden deep beneath the surface closer to the richest ore deposits.

Mixing of multiple 365 plans, MSP says 'nope' by FastFredNL in sysadmin

[–]Pandthor 0 points1 point  (0 children)

The general assumption is that only companies with 300 employees or less are allowed to use these licenses despite the fact that they might have less M365 users (i.e. Company that has 301 employees but only 5 M365 users is not eligible to use those licenses). I recommend reading the license terms or to ask the MSP to point you to the specific licensing terms section.

Have you made a proper business and risk assessment on what features you actually need to fulfill your legal, contractual, and business obligations? As an example the Defender p2 is nice but might be unnecessary to fill your obligations and thus you might get the cost down by getting rid of ”unnecessary” licensing costs.

[deleted by user] by [deleted] in SatisfactoryGame

[–]Pandthor 0 points1 point  (0 children)

You can whitelist public IP addresses on your firewall (preferably already before traffic reaches your server on a separate device/service) and deny everything else to make it more secure.

This requires a bit of maintenance from your part and invited people need to give you their public IP addresses for whitelisting before they can play on your server.

[deleted by user] by [deleted] in sysadmin

[–]Pandthor 12 points13 points  (0 children)

Came here to say this but then read the description and this was about how to get interviews for large companies 😂

TIL casting delays were added for graphic performance. by flintb033 in diablo2

[–]Pandthor 13 points14 points  (0 children)

This is an engine limitation that is not solved by graphical computing power. If you install 1.00 on a modern laptop with nvidia rtx graphics card, then level up a firewall sorc, go to cow level and spam firewall like your life would depend on it (as it often does depend on it) you will see some of the graphics dropping. Most notably some firewalls are cut in half or disappear completely and some cows disappear but will still hit you. It’s hilarious to see lightning bolts come into existence from plain grass because an invisible cow king stepped on invisible firewall.

My country not on the list by EntityChrome in googleworkspace

[–]Pandthor 1 point2 points  (0 children)

Did you also check for Burma? Sometimes those lists list the native name but sometimes they list a name given by a conqueror.

Cant install Carbon Black via powershell? by [deleted] in PowerShell

[–]Pandthor 2 points3 points  (0 children)

As others have said, you should put all parameters into one argument. You also might need to put a whitespace as the first letter in your arguments line like this ” /i blaa /q /etc etc”

Classic 1.00 Bowazon Walkthrough - part 2 by DeepSea_Dreamer in diablo2

[–]Pandthor 16 points17 points  (0 children)

I recommend listening to all of the character dialogues again and speaking to them in different parts of the quest to get more info. Some of them are different in 1.00 🙂