[ Football (American) ] Open Question : Has 1 quarterback for the AFC taken every snap in a Pro Bowl before?

I was hoping Patrick Mahomes would be the 1 and only quarterback for the AFC because if that was the case it would be an easy win for the AFC! 🙂 Patrick Mahomes is without a doubt the Greatest Quarterback in NFL History and it would be fun to watch him quarterback the AFC for the entire Pro Bowl!

Google Sheets SUM columns from other sheets and group by month, but also show the individual sheets values before doing SUM

Currently I have a Spreadsheet which has a number of customer sheets, each with a pivot table showing the month in row I and the total income for each month in row L.

On a separate sheet I have a query that sums all of the month totals (This just shows 2 Customer sheets, normally these sheets are given the name of the customer):

=query({'Sheet1'!I2:I,'Sheet1'!L2:L;'Sheet2'!I2:I,'Sheet2'!L2:L},"Select Col1, sum(Col2) group by Col1 label Col1 'Month'") 

Currently this shows:

| Month       | sum   |    | 2018/12     | £ 35.00  | 2019/01     | £ 155.00  | 2019/02     | £ 60.00  | 2019/03     | £ 210.00  | Grand Total | £ 460.00  

I have been asked to add a column for each customer sheet which shows the value the query took before it did the SUM, I want each column to be named as the Sheet the column came from. So it should look like:

| Month       | sum       | Sheet1  | Sheet2 |    | 2018/12     | £ 35.00   | £10     | £25 | 2019/01     | £ 155.00  | £100    | £55 | 2019/02     | £ 60.00   | £30     | £30 | 2019/03     | £ 210.00  | £110    | £100 | Grand Total | £ 460.00  

If the totals showed under each sheet name it wouldn’t hurt, but isn’t necessary. The sum could be on the left or right, I’m not worried about it’s positioning.

Is there any way to do this in Google Sheets? I have been playing around with query a bit, but haven’t managed to get it to display more than 2 Columns.

Find what domain is using the old Let’s Encrypt ACME TLS-SNI-01 validation method before the EOL on February 13th, 2019

I just got this email. However, I host many wabsites (not all of them on the same server). I guess that one of the server is using an old version on the certbot client, but I’m not sure which. I however have a list of all the domains I host. Is there a command available to know which of them is using the old validation method ?

For reference, here is the email I got from Let’s Encrypt on my contact email:

Hello,

Action is required to prevent your Let’s Encrypt certificate renewals from breaking.

Your Let’s Encrypt client used ACME TLS-SNI-01 domain validation to issue a certificate in the past 60 days.

TLS-SNI-01 validation is reaching end-of-life and will stop working on February 13th, 2019.

You need to update your ACME client to use an alternative validation method (HTTP-01, DNS-01 or TLS-ALPN-01) before this date or your certificate renewals will break and existing certificates will start to expire.

If you need help updating your ACME client, please open a new topic in the Help category of the Let’s Encrypt community forum:

https://community.letsencrypt.org/c/help

Please answer all of the questions in the topic template so we can help you.

For more information about the TLS-SNI-01 end-of-life please see our API announcement:

https://community.letsencrypt.org/t/february-13-2019-end-of-life-for-all-tls-sni-01-validation-support/74209

Thank you, Let’s Encrypt Staff

Can someone charge your Staff of the Magi before a long rest?

was looking for a similar question or answer but I didn’t see anything that related to this. The Staff of Magi allows you to absorb spells cast at you to replenish the charges.

I was wondering if it was possible, considering what the staff says and how the description doesn’t say that it has to be a hostile person… could say, a mage in your group just before you are about to take a long rest just throw a bunch of high level spells to charge the Staff almost to full, in case the magic user pretty much exhausted everything in the last big fight?

Can I use my valid B1/B2 visa for personal vacation, if it was originally applied and used once before for business meeting?

I have valid B1/B2 visa till 2022. The visa was originally applied for business travel and I had already travel once after that. Now I want to travel for family vacation. Is the current visa having “R-B1/B2” good enough or I have to apply for B2 visa again?

Is it normal to retest the entire sprint before pushing to UAT

I have <5 years experience in the software industry and this is my first time doing QA.

Before the stories in a sprint move to UAT, I am supposed to retest every single story in ~1 day in an environment between QA and UAT.

The purpose is that multiple teams have their own QA environment where they exclusively test their features. The extra environment is to make sure features developed by separate teams don’t interfere with each other.

This expectation seems surprising to me. I suppose this isn’t technically an entire sprints worth of work, since test cases have already been written, but it still seems like a lot for one or two days.

Is this normal/reasonable/typical for an agile project?

System restarted before transaction is committed

Consider the following log sequence of two transactions on a bank account, with initial balance 12000, that transfer 2000 to a mortgage payment and then apply a 5% interest.

T1 start  T1 B old=1200 new=10000 T1 M old=0 new=2000 T1 commit T2 start T2 B old=10000 new=10500 T2 commit 

Suppose the database system crashes just before log record 7 is written. When the system is restarted, which one statement is true of the recovery procedure?

(a) We must redo log record 6 to set B to 10500

(b) We must undo log record 6 to set B to 10000 and then redo log records 2 and 3

(c) We need not redo log records 2 and 3 because transaction T1 has committed

(d) We can apply redo and undo operations in arbitrary order because they are idempotent

According to me, the answer should be (a), as transaction T1 has been committed and has been written back into memory. But my solution says that the answer should be (b).

Am I right or what am I doing wrong?

Thanks in advance!