RELOAD!

[rubberduck-vba/Rubberduck] 1 opened issue. 1 issue comment.

[SimonForsberg/minesweeper-server] 4 commits.

Minesweeper: Games Played: 113, Bombs Used: 63, Moves Performed: 13772

@IvenBach that means I need to work harder. Thank you for the motivation!

Aww I had no commits today :(

@bruglesco Me neither! Hey it's ok you had a great week/week-end!

Testing SE styling for inline code: test

Mug just posted this on Twitter (I'm not sure which of the two guys in the front he is). The man in the back is Oz du Soleil who is Microsoft MVP as well as a popular Excel YouTuber

He's the one on the left

Based on his profile pic I saw somewhere

Ah OK, I kind of thought he was, but didn't want to guess wrong

Yeah, Mat's on the left.

> Yup! With @LeilaGharani and @Option_Explicit!

Excel Twitter is the best Twitter!

Don’t know who @Option_Explicit is.

Oh. Heard of Jordan Goldmeier before. I don’t twitter that’s why.

Hope you will get lots of things done today @Marc-Andre

Hey good morning everyone! Have a nice day!

I have 3 things planned. Do a bit of programmation, play banished and go see Captain Marvel

I should be ok :)

I like small to do lists so I can do them and not feel like I've too much things to do

Have a good day @Marc-Andre. Everyone else too. Moonring all.

Thanks @bruglesco

I'm on two computers at the same time ! Perks from having a big desk

One computer and 3 screens here.

I only use 2 of them, though. The other just rotates through background pictures.

aahahhah wish I had 3 screens at work or two curved one

Working on cleaning up a complex SQL query.

Involving many joins.

Like, we have to join on three tables and then compare subsets of various mappings and stuff.

Like, we want a, and we have to do a - b - Role where Role intersects c - d - Role.

Sounds like a big query good luck!

Ugh.

So, I fixed two places of:

Well, hard to show it exactly.

But basically, we were doing collection.Where(w => w.Foo).Select(s => s.Id).Contains(userId)

It should be collection.Any(w => w.Foo && w.Id == userId)

Generates much cleaner SQL and is significantly faster.

Removed some Foo.StringVal.ToString() calls.

That dropped a couple seconds alone...

(This is Linq-to-Entities.)

If you write clean code, it generates clean SQL. It doesn't know how to optimize bad code to clean SQL, though, so...

Got it down to a 4-second page load in release build (5-6 in debug) and 1.2 second widget load in debug build.

It was at about 15 seconds. The requirement was 5 seconds.

I haven't done any code but I did something for my wife, I'm gaming and having a good time! Watching the baby sleep too! It's nice :)

Nice job @Hosch250

Thanks.

Have a nice day off, BTW.

Ohh i'm enjoying it a lot :)

Having a great time with Banished my colony is growing fast :)

A part of my small colony :)

@Marc-Andre Hmm... I've seen that game on Steam. I think it's one of the games I have in my wishlist, not because I absolutely have to have it but because "This looks interesting, let's keep an eye on it"

One of the game I like to play to relax

I strongly recommend this game and with the charter mode it's a good town building game

I liked bazola's.

The only issue is, I made my town fill pretty much the entire map and crashed my browser, LOL.

@Hosch250 Duh check: Why does this change make difference a difference? Is it because in the Any it already has a w variable that can access the Foo and ID methods? IE it doesn't have to do a Where().Select().Contains() which based on my understanding generates an additional variable 2 method calls.

Well, if it was pure C#, it wouldn't matter.

At least, not as much.

With pure C#, it generates a state machine.

It's more affected by it being SQL?

Yeah, basically.

Basically, when you do Where().Select().Contains(), the Linq-to-Sql thing generates that raw statement.

Well, when that's inside another Where clause, the SQL gets really messy.

Like, it starts having nested queries.

Instead of O(n) it was O(n^2), because of the nesting?

When you do .Any, it realizes it doesn't need to do as much nesting to get the result, since you just need the raw bool.

Not the intersection of the queries > 0 comparison.

Well, I can't say that.

I didn't check the execution plan.

Since I wasn't working directly with SQL.

hey

Hey!

@bruglesco Ctrl+Alt+J in VS brings up the object browser.

I have no clue what I'm looking at.

Me neither

Is big brother Simon recording all the games played? Using AI to train your minesweeper bot.

@IvenBach This was just profiling in my browser.

But yes, I am recording all games played. Only in text form though. Mine positions and all moves made are stored.

@SimonForsberg You're looking at too much information

@Hosch250 So far the head first book has been worth it. Exactly the same format I take with teaching people.

If you like it, that's great.

You might find their other books interesting too.

Some of the code examples rub me the wrong way: if (foo == true) { ... }

I like standard textbooks better. I read those for fun, though, so.... Maybe I'm just weird.

@IvenBach Yeah, I learned a lot of bad practices from my HTML O'RLY book.

I now appreciate textbook style documentation. I guess I needed something do bridge the gap between non-programmer explanations and textbook style.

Do you ever use class diagrams before coding?

I won't say never, but pretty close to it.

Arggh, why is API development always so annoying

Monking!

Been having computer issues today, so I'm sitting at someone else's desk... on a Windows 7 machine :/

@Phrancis You like Win 10? Or is it Win XP?

Win7 is just fine, until EoL hits.

@IvenBach I dislike the menus. I have to explain that somehow the big squares are easier for me to hit with my mouse every time.

The taskbar is for my daily operations, and the start menu squares are for the ones I use periodically.

I give up, I cannot get the eBay finding API to work for some reason

@Hosch250 I prefer Win 10 to 7, yes

For some reason I thought you were one of the Win 7 fans.

I don't know why. Was just under that impression...

Win 7 is alright, def better than Win 8. I'm just kind of tired of Win 7 because I've used it so much

Yeah, 8 was definitely under-featured in the UWP area.

That weird split :(

I imagine if you strip out all the "tablet mode" stuff maybe you can make Win 8 to look like Win 7...

It didn't have a start menu, just a screen.

You could install programs to give yourself a start menu.

But yeah, it still had the full desktop like 7.

This computer is actually really fast (perhaps I got used to the Win 10 machine becoming sluggish)

[SimonForsberg/minesweeper-server] Simon Forsberg pushed commit fe214bc to master‌​: Add details HTTP check

[SimonForsberg/minesweeper-server] Simon Forsberg pushed commit 89432c2 to master‌​: Move cleanuser logging

[ZomisBitbucket/minesweeper-server/master] build 69 Build success.

[SimonForsberg/minesweeper-server] Simon Forsberg pushed commit adff575 to master‌​: Fix details HTTP check

That was stupid -.-

I just forgot to commit that...

[Zomis/minesweeper-flags-client] Zomis pushed commit 8c07d8f8 to develop: Add player and turn indicators

[Zomis/minesweeper-flags-client/develop] build 2 Build success.

[Zomis/minesweeper-flags-client] build for commit 8c07d8f8 on develop: This commit looks good

:click: I understood the ranges on a double data type.

[ZomisBitbucket/minesweeper-server/master] build 70 Build success.

This thread and all the replies are endless fun:

@Phrancis I'm on Ch4. :boogy-boogy-boogy: catching up.

@Phrancis Since when did headshots become half-the-upper-torso-shots?

@IvenBach I dunno, I guess since it's all online now there's less need to save physical space on paper by having just a tiny square with the head

[SimonForsberg/minesweeper-server] Simon Forsberg pushed commit bba1bd1 to master‌​: Fix Internal Server Error

[ZomisBitbucket/minesweeper-server/master] build 71 Build success.

Does anyone here from Europe need to deal with sites that need credit card info?

Looking at you, Google, with Google Vision

So no programming today but I installed a jenkins on a spare machine I had so I'll be ready to start the the cicd

I started to scrap the old chairs from our old table.

Played a ton of banished. I have a good town now

[SimonForsberg/minesweeper-server] Simon Forsberg pushed commit c2195c3 to master‌​: Jenkinsfile: Initialize serverStatus to make it run at least once

[SimonForsberg/minesweeper-server] Simon Forsberg pushed commit 9433b22 to master‌​: Jenkinsfile: Fix wait for deploy condition

[SimonForsberg/minesweeper-server] Simon Forsberg pushed commit ff4be29 to master‌​: Jenkinsfile: Only deploy if no games are running

And getting ready for the movie soon

[SimonForsberg/minesweeper-server] Simon Forsberg pushed commit 9a21145 to master‌​: Add /status endpoint to grab summary of server activity

[SimonForsberg/minesweeper-server] Simon Forsberg pushed commit 0c5968d to master‌​: Remove MfeUser.displayName field

So a nice day :)

[ZomisBitbucket/minesweeper-server/master] build 72 Build success.

It's been a bad day in Minesweeper land. I decided to rollback the server to an earlier version because it was just too buggy. :(

I've also lost a bit of motivation

Perhaps because of work

@Marc-Andre What movie?

Captain Marvel

Oh nice

Must be something in the water. Two birds have derped hard by flying into the windows of our building.

@IvenBach Hahaha... I often see dumb cardinals trying to fly through a car's side mirrors.

Both were birds of prey. Didn't see the first one but the second was a hawk.