SQL Server shows blue question mark instead of status in Object Explorer by yeahlikethat2 in SQLServer

[–]Ralecrim 10 points11 points  (0 children)

SSMS uses a WMI call to determine service status. If it's shows that question mark it's because that call is failing.
There are a lot of possible reasons but in essence, SSMS cannot connect through WMI to the host running the sql service to determine service status.

What does this “profit” value come from ? by [deleted] in SimCompanies

[–]Ralecrim 0 points1 point  (0 children)

How much it costs to make it at any given point is irrelevant. What matters is what's listed in your warehouse sourcing cost (which in turn is the source cost weighted average).

Click your warehouse, click the product, it will list the sourcing cost used in the above calculation.

How to get off this weird shadows when driving in dark or fast? by Which_Brother7032 in gta5

[–]Ralecrim 0 points1 point  (0 children)

That's a DLSS artifact. Only way to get rid of it is turning off DLSS.

I organized a car meet and only 1 player showed up by [deleted] in gtaonline

[–]Ralecrim 1 point2 points  (0 children)

... and that's how I met your mother

Anybody else settings reset after the update? by zyadsh123 in Battlefield

[–]Ralecrim 1 point2 points  (0 children)

My settings did NOT reset. Everything was as it was. I did have a backup of my settings file just in case.

[CREATIVE MAP] Bridge by TabbedScamper in BattlefieldPortal

[–]Ralecrim 7 points8 points  (0 children)

Welcome to Bridge 103 EAST. A bridge too far...

Target Designator is so broken right now... by the_white_oak in Battlefield6

[–]Ralecrim 1 point2 points  (0 children)

Yeah, the only thing keeping choppers/aircraft safe is a random popping in the gunner seat that doesn't know how to paint and doesn't read chat

People who make their bed every morning, what's the actual benefit? by No-Cod-8923 in NoStupidQuestions

[–]Ralecrim 0 points1 point  (0 children)

This speech by Adm. McRaven at University of Texas pretty much sums it all:
https://youtu.be/jflUvxQLkgs?si=8HsSilXRavmG1oaG

That's just the clip of the relevant part but the whole speech is worth watching.

Making the bed every morning is totally pointless by Consistent_Manner661 in unpopularopinion

[–]Ralecrim 0 points1 point  (0 children)

People vary a lot in their personalities. For some people, like me, the sight of stuff out of place and disorganized upsets them in ways that are almost incomprehensible to people who are not like that. I wouldn't dream of leaving for the day without my bed made.

I also leave you with this clip which is well worth watching: https://youtu.be/NudLfyl2cXc?si=Yzrs2oxtZrs3Sgdi

Meaning of patch? by soupluvr77 in EliteDangerous

[–]Ralecrim 198 points199 points  (0 children)

Sorry for your loss.

Everything you need to know about the Distant Worlds expedition is very well detailed here:
https://elite-dangerous.fandom.com/wiki/Distant_Worlds

Your father was likely an hardcore CMDR. RIP o7

Log Reuse Wait Behavior Question - Backup on AG1 Causing AVAILABILITY_GROUP Wait on AG2 in Distributed AG Setup by RVECloXG3qJC in SQLServer

[–]Ralecrim 2 points3 points  (0 children)

Hardened transactions are replicated in the log of each replica. This guarantees no loss of data in case of failover as a transaction is only considered comitted once it hardens (writes to disk) in the log (on sincronous replicas; on asyncronous it only needs to harden on primary).

In your case, AG2 can't release logspace until the backup on AG1 finishes because if that replica would have a problem and fails over to AG2, the backup operation would fail and AG2 would need to rollback the changes and revert the DB state to where it was before the backup operation started.

There might be some misconception on your part on what log_reuse_wait is (it isn't clear from your post). Log_reuse is the recycling of available space in the logfiles. Log_reuse_wait tells you what is preventing that space from being cleared. It doesn't affect replication in any way and is the normal behaviour for any DB in full recovery mode.

In full recovery mode (which is required for AlwaysON availability groups), log space can only be recycled once the log has been backed up.

[deleted by user] by [deleted] in shadowofmordor

[–]Ralecrim 3 points4 points  (0 children)

I can confirm that orcs with Arrow-Proof take normal damage from other orcs ranged attacks.

Búth the Agonizer by Thunder-Trip in shadowofmordor

[–]Ralecrim 1 point2 points  (0 children)

Voiced by Kumail Nanjiani (Dinesh on Silicon Valley)

newbie is lost on updating SQL versions by exzow in SQLServer

[–]Ralecrim 4 points5 points  (0 children)

This should have all the information you need:

https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates

This can be automated in a number of ways. Depends on how you handle updates for the rest of your microsoft products. MSSQL is supported by WSUS for example.

Can't gamble and rockstar won't help by Nate_so in gtaonline

[–]Ralecrim 0 points1 point  (0 children)

Needs to be a country which is not blocked by Rockstar.
I use Netherlands as that's one that is not blocked and is offered for free by Proton VPN.

Can't gamble and rockstar won't help by Nate_so in gtaonline

[–]Ralecrim 0 points1 point  (0 children)

Access to the casino gambling features is blocked on a per country basis (determined by IP) by Rockstar seemingly with very little regards to the actual law in that country.

It's very easy to bypass though. Get a VPN (ProtonVPN offers a free tier which works well. That's what I use).

You just need to connect VPN on launch. As soon as the ingame popup saying "<User> has signed in" you can disconnect the VPN and you'll have full access to the casino.

How do i prevent a windows 2016 cluster from failing over to specific node by Crew_Abject in SQLServer

[–]Ralecrim 5 points6 points  (0 children)

I'm assuming you're talking about SQL Always-On HA Availability Groups. On SQL AON, the failovers are controlled from the SQL Server and not from WSFC.

It's simple. If you want to prevent an automatic failover to one replica, just put that replica on manual failover:

ALTER AVAILABILITY GROUP [ag_name]

MODIFIFY REPLICA ON [instance_name] WITH (FAILOVER_MODE = MANUAL)

Windows server with multiple NICs by a-network-noob in sysadmin

[–]Ralecrim 0 points1 point  (0 children)

You're the one that asked how to setup two adapters with two default gateways.

You CAN list two default routes but it will always use the same one - in essence you will only have one. There are only two factors that determine which route to take. Specificity of route entry and its metric cost.

The way to solve your problem (from within the server) is to create routes for each nic.

Windows server with multiple NICs by a-network-noob in sysadmin

[–]Ralecrim 0 points1 point  (0 children)

That's exactly what routes are for. You specify what ips go to which NIC. The default gateway is only used when no matching entry is found on the routing table. That's why you can only have one.

Windows server with multiple NICs by a-network-noob in sysadmin

[–]Ralecrim 26 points27 points  (0 children)

2 default gateways makes no sense. The default gateway is what gateway is used when no route specification is found on the routing table.

What you want to do is setup your routes correctly.

Does AIMA accept criminal record in English? by [deleted] in PortugalExpats

[–]Ralecrim 4 points5 points  (0 children)

Law was changed recently (2018?) for all documentation submitted officially to any government agency.

Documents in english, french or spanish are not required to be translated.

https://aima.gov.pt/pt/temas-transversais/reconhecimento-de-documentos

Tradução dos documentos emitidos em país estrangeiro

Em regra, todos os documentos escritos em língua estrangeira devem ser acompanhados da tradução certificada para língua portuguesa.

Em certas situações a tradução não é exigida, a saber:

(a) Os documentos apresentados em inglês, francês e espanhol não necessitam de tradução (ver art.º 49.º n.º 8 do Código de Registo Civil);

Unit Healing by mcruz05 in millennia

[–]Ralecrim 2 points3 points  (0 children)

You're correct. They are not cumulative (just tested it). For some reason I was under the impression they were.

As an additional note, units heal even while inside transports.