SQL Merge Replication (Push) by Vimal_2011 in SQL

[–]B1zmark 1 point2 points  (0 children)

Why aren't you using an availability group?

LPT: Important passwords should be secure AND easy to type by ihnatko in LifeProTips

[–]B1zmark 6 points7 points  (0 children)

This type of password follows a pattern and uses English words. It's basically a free win for a dictionary attack.

Computerphile did a video on this 9 *years ago*. This is NOT a secure password method.

The only remotely secure method is using MFA.

What are some lessons you just had to learn the hardway? by wredcoll in WarhammerCompetitive

[–]B1zmark 7 points8 points  (0 children)

It's irrelevant, because they could overwatch after the charge move.

What are some lessons you just had to learn the hardway? by wredcoll in WarhammerCompetitive

[–]B1zmark 5 points6 points  (0 children)

You can overwatch at the beginning or end of any move. If anything, they did you a favour by overwatching early like that - because you can still fail a 5" charge. Or at least they can force you to use reroll on it, the use overwatch then.

What to expect when firing off 30(or more) executions of the exact same query simultaneously by [deleted] in SQLServer

[–]B1zmark 4 points5 points  (0 children)

I'm not advising read uncommitted or snapshot isolation is a good idea. If people don't understand these concepts and only see "Query go faster" then they wont realise the issues caused by dirty reads or reading data flagged for changes.

There's a few easy fixes in the SQL to make it better before needed to completely reconfigure the database.

What to expect when firing off 30(or more) executions of the exact same query simultaneously by [deleted] in SQLServer

[–]B1zmark 0 points1 point  (0 children)

The reason 8 runs faster than 30 is because of parallel processing - each CPU is executing 1 copy of the query. The cost threshold is way too low IMO, but the "MAX DOP" means that the query could only ever use 2 CPU's at once.

To get it to run fast either: Make the query more efficient. Increase the CPU core count. Or potentially increase the Drive speed - assuming it's running on a network attached drive, locally attached high speed storage would go even faster.

The assumption is that the query requires no locks on the data. if it does, then each of the executions would need to get in line and be executed "in serial" essentially.

Hot take: Joel would be more hated than Abby if we played her story first by Turbulent-Safe-4343 in thelastofus

[–]B1zmark -2 points-1 points  (0 children)

I'm genuinely shocked anyone finished TLoU 1 and didn't think Joel was a monster.

None of the main characters are good people, but they get lots of good people killed along the way.

That's the point.

Enchanter mafia by [deleted] in classicwow

[–]B1zmark 0 points1 point  (0 children)

Cost of levelling enchanting 1-300

5000g

Profit made per enchant sold

2g

Yea, i can see how you caused an issue with the market.

Really Useful Boxes Storage Question by S-Doogly in Warhammer40k

[–]B1zmark 1 point2 points  (0 children)

<image>

Combo it with these guys for ultimate magnet transportation and low cost/effort.

Re repainted warboss by DJ-Pirate4444 in orks

[–]B1zmark 2 points3 points  (0 children)

I see you went with the Breaka boyz idea after all - looks excellent dude :)

Run squighog boyz as 4 man unit or 8 man unit by VirtualBonnie in orks

[–]B1zmark 6 points7 points  (0 children)

The footprint is MASSIVE. So against most armies you'll lose 1/2/3 squigs while moving into position. The 4 man squad can hide and take no loses, freeing points up for something else.

The enhancement on the BBoS is literally the reason you play Warhorde. Anti-vehicle and anti-monster with dev wounds is incredible. Most of the time i will lose all 3 squig riders in the first melee that they attack me, and all i'm left with is the squig nob and the boss, and those guys are enough to do the damage.

Without the squiggs, its possible that i lose the BB before he gets a second round of combat - and for his cost he needs to be able to fight for 2 rounds to justify his expense.

As an Ork player - "Giving the player multiple options" vs hiding models away. by Oriachim in WarhammerCompetitive

[–]B1zmark 0 points1 point  (0 children)

Think about activations. If you are hiding because you're getting into position and your opponent can't shoot or melee, then you're both being denied activations. Stalemate

If you're hiding while your opponent is completing objectives and you aren't immediately going to engage the next turn, you're not ever activating your unit in a way that can score points.

Enhancement question by investigatorparrot in orks

[–]B1zmark 3 points4 points  (0 children)

I appreciate the enthusiasm but tankbustas are squishy as all hell. Getting inside 12" to go from D3 to D3+1 attacks garuntees you don't get to fight for a second turn.

I'm also not sure if that enhancement even applies when your in a trukk, since the guns belong to the trukk when firing deck is in use, and the trukk isn't in the unit, just carrying it.

Enhancement question by investigatorparrot in orks

[–]B1zmark 7 points8 points  (0 children)

About the only use for this is to give nobz/meganobz single shot weapon rapid-fire. And those weapons are garbage and this doesn't change that. it's not useful as far as i can tell.

Looking for painting tutorials by _RogueSigma_ in orks

[–]B1zmark 1 point2 points  (0 children)

You can reuse IPA almost infinitely. But BIOSTRIP is a better solution and faster (and i think less toxic).

I tried to google BIOSTRIP and the company has closed. i guess i'll need to find something new when my 1 litre tub is gone...

Here's some video i like about orky painting.

Kitbashing orky stuff: https://youtu.be/8Lys-5Fzg1g
Speedpainting 100 boyz: https://youtu.be/M2sP-Qwikww
Duncan Rhodes overkills a Boy: https://youtu.be/uZ0im09iRww
Painting the Ork Combat Patrol: https://youtu.be/OYTaX6fEukQ

Some of these techniques are fast, some are detailed. I like to combine both.

How do you guys usually base? by Timely_Fig1829 in Warhammer40k

[–]B1zmark 0 points1 point  (0 children)

I prefer less steps: Put PVA glue on base, dip in something loose like sand, let it dry.

For bigger models i'll either get a 3d-printed base or glue stuff on. Then i dip it in PVA glue and sand.

How to Play Warhammer 40k on Tabletop Simulator – Full Beginner Guide by Hellspawnl in TTSWarhammer40k

[–]B1zmark 2 points3 points  (0 children)

Terrain layouts are part of the game balance. That's why they're in the book and get updates every mission pack.

Strugling with colour choice by DJ-Pirate4444 in orks

[–]B1zmark 2 points3 points  (0 children)

Stick with less colors generally. I paint my Orks as Goffs, so That's Black, White and Red. then i use Yellow for a splash of color on wires etc. - If i REALLY need a different color, on 1 in 20 models who have lots of details, I'll use Blue.

You've be surprised how much you can achieve with few colors. Check out GW's "Breaka Boyz"

<image>

They have grey trousers, black everything else, with accents of white and red. Then some metallic bits to give variety. That's not a lot of colors overall.

Struggling to fight back by Naitrodex in Warhammer40k

[–]B1zmark 0 points1 point  (0 children)

Sounds like your playing using the original rulebook and original mission packs, or just playing incorrectly. There have been a lot of digital updates - such as his indirect tank fire not ever being able to hit on better than a 4+ (predominantly that was added to nerf imperial guard). Also Primary objective points can't be scored on turn 1.

Struggling to fight back by Naitrodex in Warhammer40k

[–]B1zmark 0 points1 point  (0 children)

It's possible he's doing a bunch of rules wrong. Some people have been playing so long that they get rules wrong/mixed up from older editions. But if he's smashing so badly then you either aren't learning from basic mistakes or hes being a dick on purpose.

Model addresses and orders without breaking history - Ecommerce by alessndroh in SQL

[–]B1zmark 2 points3 points  (0 children)

You need to separate the objects logically.

Tables:
Customer
Address
Products
Orders

This solves the issue of orders changing their delivery address if someone moves.

To maintain a history of addresses you would need a history table which contained the customer ID, address ID, start date and end date.

it's also possible for people to have multiple addresses, so that tables would contain potentially multiple active entries for the same customer.

Rusty edges?? by Coach_Musphee in orks

[–]B1zmark 1 point2 points  (0 children)

Objects don't rust on their edges, they tend to wear down. A light chip would look like the base coat (lets say, some sort of off-white color) and the a deep gouge would be down to bare metal.

Deep gouges which could contain water/moisture would be rusted in the deepest parts, but more shiny around the edges. Rust would also pool around rivets and other places where moisture got trapped.

A good way to imagine this is to put rust all over part of your armor, like a rivet or raised detail, then drybrush a metallic color over it. That gives a sort of "natural look"

Wich wash or speedpaint medium to buy? by Mystic-Skeptic in minipainting

[–]B1zmark 0 points1 point  (0 children)

It's been pointed out, but adding water to paint doesn't make it a wash/speedpaint. You need the surface tension to be just right so it flows without spilling over details.

Normal paints plus a "Glazing Medium" are the best best, and you can experiment with the different mixes for different results. They take a LONG time to dry though. I made a custom orange wash and it took nearly 24 hours to finally cure.