f# – How to apply multiple filters in one statement

Nope, that’s pretty much the way.

If you really, really want to make this shorter and less cluttered, and if you face similar situations multiple times in your codebase, you could make yourself a special operator for combining predicates:

let (.&&.) f g c = f c && g c

Then you can use this operator in your filter:

|> Seq.filter (needSpecialDocument .&&. wantToMoveTo)

But base on my own experience I wouldn’t advise this. You make the program slicker and cooler looking, but you’re losing some readability. Now whoever reads your program will have to look up the meaning of .&&.. Programs are read more often than they are written.

sql server – Steps to apply windows updates to sql failover cluster?

You do not need to stop any jobs or services to manually failover. Please see the Microsoft Docs – Perform a Forced Manual Failover on manually failing over.

These are the general steps you should follow for applying any updates to your failover cluster instances:

  1. Backup all databases.
  2. Failover all SQL cluster roles to Node A.
  3. Install the patches on Node B (passive).
  4. Restart Node B.
  5. Failover all SQL cluster roles to Node B.
  6. Install the patches on Node A (passive).
  7. Restart Node A

More information on the installing updates process can be found in these Microsoft Docs – Upgrade a failover cluster instance.

How do I apply Ambient Occlusion in Forward Rendering to the ambient term only?

I want to integrate Ambient Occlusion into my rendering which is a forward renderer.
How do I apply Ambient Occlusion to the ambient term only and thus not as a "post process" over the entire image (i.e. frambuffercolor * ambient occlusion)?

dnd 5e – Would the advantage against dragon breath weapons granted by dragon scale mail apply to Chimera’s dragon head breath attack?

Dragon is a specific creature type.

From the Monster Manual:

A monster’s type speaks to its fundamental nature. Certain spells, magic items, class features, and other effects in the game interact in special ways with creatures of a particular type. For example, an arrow of dragon slaying deals extra damage not only to dragons but also other creatures of the dragon type, such as dragon turtles and wyverns.


Dragons are large reptilian creatures of ancient origin and tremendous power. True dragons, including the good metallic dragons and the evil chromatic dragons, are highly intelligent and have innate magic. Also in this category are creatures distantly related to true dragons, but less powerful, less intelligent, and less magical, such as wyverns and pseudodragons.

Since a chimera does not have the Dragon creature type, it is a Monstrosity, it’s breath weapon doesn’t count for Dragon Scale Mail.

It wouldn’t be unreasonable to rule otherwise.

Above is the RAW ruling, but it seems perfectly reasonable for a DM to rule that the Dragon Scale Mail gives advantage against the chimera’s dragon head breath weapon. It fits thematically, for sure.

microsoft excel – Apply conditional formatting on different column as the column with the conditional formula

I have an excel table that looks like this (but bigger).

enter image description here

If the values in the 2nd, 4th and 6th column are bigger than 0.25, I want the value in the previous column to be red with conditional formatting, like so:

enter image description here

I got pretty far with this question
Conditional formatting based on several columns
using formula =$C$4>0,25 applied to =$B$4
But this only works for one cell. How do I apply this to the entire file?

dnd 5e – Does the Hexblade Warlock’s Hex Warrior feature apply to a magic weapon that is transformed into your Pact Weapon?


First of all, the weapon has been transformed into your pact weapon, so that checks out. But is it “conjured” when you make it appear?

Conjuration school of magic includes summoning spells, including spells like Instant Summons and Secret Chest , which kinda do similar things.

Also, the plain English meaning of “conjure” is

to make something appear by magic, or as if by magic

(From Cambridge Dictionary )

And this is clearly what is happening here. There is no clear definition of “conjuring” in 5th edition which would contradict this.

So, it would be extremely strange for a DM to rule that making your magic pact weapon appear would not count as conjuring a pact weapon with the Pact of the Blade feature.

8 – How to apply patches that are created in core-dev

If the patch weren’t already committed, you would need to reroll the desired patch against your Drupal Core version. This can be done by cloning the git repository of Drupal Core and generating a patch against the relevant revision of your version of Drupal.

The Drupal Core git repository can be found at https://www.drupal.org/project/drupal/git-instructions

See Making a patch on how to create a patch.

However in this case we can see that the issue has already been marked as “Fixed” and the patch of comment #19 was committed, so if you are on Drupal Core 8.1.x or up, you should already have the changes from that patch on your Drupal site.

Best way to save and apply template to a widget

I am working on a SAAS project where users create widgets to their websites.
One of their abilities is to create a messaging template and apply it to their widgets.

When saving a template, the user can name the template and apply it to one or several of their widgets.

Now the problem I am facing is how to save and apply the template.

Option 1:
Single button “Save & Apply” which opens a modal where the user types in the name of the template and a drop down of his widgets to apply

enter image description here

enter image description here

Option 2:

Two buttons – Save Draft and apply

enter image description here

Each one of the buttons will open a modal:

Save draft – The user will name his template and it will be saved without being applied to the widgets

Apply – The user will apply the template he is currently working on to a single or several widgets.

Which way is most correct?

How do I apply arrayformula on a hyperlink so that I can reference another cell in a different sheet?

I have a column on sheet2 where each cell has a hyperlink redirecting to cells of a column of sheet1.

I have manually gotten the “Link to this cell” and put in under hyperlink to be able to achieve the desired functionality. I understand that to access different cells I will just have to change the range.

I have created each of these links manually using the following format:

In Sheet2 A2:
=HYPERLINK("https://docs.google.com/spreadsheets/d/********************************************/edit#gid=**********&range=A2", "Sheet1-A2")

Sheet2 A3:
=HYPERLINK("https://docs.google.com/spreadsheets/d/********************************************/edit#gid=**********&range=A3", "Sheet1-A3")

I have a thousand rows in this sheet and so it becomes cumbersome to do this. Is it possible to do this using arrayformulas?

user interface – Why some softwares change language in real time but others require to restart to apply the change?

Software developers allow users to change the language of their software.

Some of them require the user to restart the application in order to apply the changes, whether others change it automatically, in real time.

My questions are:

  1. Is there a better option when developing a software? Better performance maybe?
  2. Why and how does this happen?
  3. How does this compare on web based applications (refresh page) vs desktop apps (close and open application)?

Extra question:

  1. In my opinion, changing language in real time is a better user experience besides having to close and open the app. Are there any objections to this?