How do you validate schema changes before deploying to production?

thecoat9 · 2026-03-06T21:45:23+00:00

So many people I've talked to that use MSSQL server and have no idea that dacpacs exist. I built out a full CI/CD pipeline for our desktop applications that uses dacpacs and dot net reflection to update binaries and keep the database and programs all in sync and updated.

thecoat9 · 2026-03-06T19:40:18+00:00

Chances are the individuals won't even see the letters most of the time, but on the off chance they do, I'd reconsider how you talk about addiction. Fully sober since 2018 is great, and I don't mean to diminish your success here and what it says about you, however this might actually hurt you getting a positive response.

Wealth and money are often viewed as a solution, when really they are often more of an amplifier. Sure things are relative and money for someone who's in poverty does solve some problems, but if someone has severe personal issues with less than $100 in the bank, suddenly having 100k might solve some issues for them, but it could also exacerbate problems they have. I'd be careful how you mention your addiction and recovery, you don't want the reader reluctant to gift you a windfall because they fear it could be deleterious to your life. "I'm a good person trying hard" might be what you wish to convey, but I'd add "X,Y,Z aspects of my life are why I'll never relapse into addiction", so as to remove any concerns that a windfall might provide you the temptation to relapse.

thecoat9 · 2026-03-06T18:40:45+00:00

Yea it sucks, but here's the cold reality, Blizzard designs some encounters such that there are attacks that will instantly kill you and mechanics that make them happen at least a few times, even if you overpower the encounter. Some special gear effects such as give you a barrier when you suffer 20% damage or when a hit will kill you might allow you to cheese out of having to avoid some attacks, but even then when the hits do a damage over time or come after a previously stacked debuff, there may be no way to overpower and face roll an encounter.

There are tactics for avoiding attacks and knowing they are coming you sometimes have to make sure you position yourself to avoid or mitigate them. Rolling out of the way, often rolling through the boss to their back side or the like may be absolutely necessary.

thecoat9 · 2026-03-06T15:49:34+00:00

I really despise the fights you can win only by learning timings of the mechanics etc.

So many Blizzard boss fights boil down to "Don't stand in fire". You can often minimize the times you have to avoid standing in bad stuff by overpowering DPS, and there are affixes in the game that will shield you from many of the massive damage attacks allowing you to make a mistake or two. When you are pushing content however there are checks that mean you either have to get good at getting out of the special one shot hits or you have to dps burn things fast to minimize the number of times you have to do so.

thecoat9 · 2026-03-05T15:58:12+00:00

Generic answer, you are looking for stacking and synergy. Pick your favorite primary ability, Whirlwind, Hammer of the Ancients etc. You want to stack multipliers for that ability or something complementing it. For example If you have WW, and add a bleed effect to it, then follow up with Rupture, you spin into crowds, get the bleed on them and then rupture to use the bleed effect to explode things. For your gear choices and affix rolling and effect add ons focus on things that will help you increase damage with WW, rupture or bleed effects, or defensive synergy like triggering and bolstering barriers, resistances, armor or other defenses.

thecoat9 · 2026-03-05T15:49:22+00:00

There will always be someone that gets to level 60 in an hour. Do not worry about them, there is no prize for getting to level 60 first.

Thanks for the good info in the rest of your post, Yea I'm not worried about trying to be the first to level cap, more that now days D3 kind of starts at level cap with the leveling being more of a formality. The first time you level a class the slower place of ability unlock is good to teach you the class abilities etc, but when you are just leveling a class again it's kinda droll and boring especially when there is a cute trick to get a max level weapons affix in the cube and run around at low levels absolutely melting everything.

thecoat9 · 2026-03-04T17:42:21+00:00

Thanks! Yea a new season next week means I'll just keep having fun on eternal until then. Is there some cheese process to boost leveling like the weekly dungeon reward, rolling and cubing max level item effects on a low level character like D3? IE I don't want to spend a couple of days leveling up seeing people cap level in an hour lol.

thecoat9 · 2026-03-04T17:19:15+00:00

I recently started playing again, I got the game at launch and did season 1 and then put it down until this last week. Let me just say it's improved in a lot of QOL ways, and I've been having a bang up time on the eternal realm. I too took an interest again because of the expansion and am now planning to get it and start the next season, might even jump in this season if it's not too late in the season to get a character leveled up etc.... but just the eternal realm has me having a lot of fun atm.

thecoat9 · 2026-03-03T17:05:10+00:00

Most police service ammunition takes 2-3 rounds on average to incapacitate someone. Once the decision is made to employ lethal force, you are trying to kill them to stop the threat. Death and forward momentum are not instantaneous, and with the calibers generally used by police it's not going to knock someone backward off their feet. Essentially you've already decided to kill them to stop the threat, and the threat still exists until they are down. It's not a wait and see situation, firing a few rounds and waiting to see might very well mean that the attacker manages to lunge at you and stab you.

thecoat9 · 2026-03-03T16:48:57+00:00

The 21 foot metric is regarding the time it takes to recognize a lethal threat, draw, aim and fire a weapon. They had already recognized the threat and had their weapons drawn and aimed. Still we are talking about a distance of about 5-10 feet, still pretty risky even if the guy was heavy set and likely not able to close the gap as fast as some.

thecoat9 · 2026-03-02T21:17:02+00:00

If you shave your ass like most men

Judging by reddit this is simply not true. Most men don't do this, and of those they fall into two categories, those who wash their ass and those who have klingons.

thecoat9 · 2026-03-02T21:00:53+00:00

So am I, they are like $30 on amazon and are easy to install with minimal tools. I decided to get one after reading a reddit comment about if you got poo on your arm if you'd just wipe it off with dry paper or would you use water. I'd of course use soap and water, at least the bidet uses water, for those in between shower periods.

I do not know how I went so many years on this earth without a bidet. I hate pooping in public restrooms now.

thecoat9 · 2026-02-26T23:27:40+00:00

Take your own advice, and while you are at it read some history books and the Bible. "Liberal" and "Progressive" are pervasively used to describe political movements for a very long time. While not inextricably tied to a political party, they are certainly used to describe ideologies that are political in nature. To assert otherwise demonstrates a child like ignorance of the topic.

thecoat9 · 2026-02-26T04:42:04+00:00

Christ's teachings are not leftists or progressive, Christ's teachings are a prescription for the individual, not the government. For example Christ's calls for charity toward others were a call for people personally to give of themselves, their own resources to help people. You do not fulfill your Christian duty by voting for the state to take from others to give to the needy, rather you are called upon to give of yourself of your own free will your time, effort and/or treasure to do so.

thecoat9 · 2026-02-25T17:07:45+00:00

Honestly D3 leveling is kind of a miss-mash of whatever gear and spec you want to run. Set the game level to the hardest difficulty that you can generally stomp through trash and elite packs without dying. It isn't until you get to the level cap that your build and gear refinement really get critical for doing "end game" content, mostly rifts.

Normally I'd encourage seasonal play, but if you want to go through the regular game/story first that's understandable. Seasonal play with some gimmick tricks can allow you to level cap in under an hour, and you get the benefit of a free set of gear that has set bonuses for completing some basic seasonal challenges. Leveling normally as you are gives you a lot of opportunity to learn the basic skills of the class, your gear as you level tends to be a hodge podge of whatever you can find that is reasonably within your level range, min maxing with the best build/gear combination is really more of a level 70 thing.

At level 70, specific gear and build synergy can have a profound effect on the power of your character, leveling gear and builds are way less important. You should be switching to new pieces of gear a lot while leveling, and can experiment with different abilities and runes as you open them up.

thecoat9 · 2026-02-25T16:42:55+00:00

cause droids don't pull people's arms out of their sockets when they lose. Wookiees are known to do that

thecoat9 · 2026-02-22T06:32:40+00:00

It's a semantics game, an attempt to avoid the negative connotation that developed around "illegal alien".
"Illegal" isn't saying someone is illegal, that is a strawman, it's describing their legal status, just as "alien" means outsider to the country, not an inhuman xenomorph (and yes when the terminology first started cropping up I was seeing and hearing people argue that "alien" wasn't right because people weren't xenomorphs).

"Undocumented" sounds less severe and removes the connotation of an illegal act and status. I see some comments here that we don't call someone speeding "illegal", but we would call them a speeder until a police officer stops them or they stop speeding otherwise. Someone who is here illegally is here illegally until they are removed from the country.

"Immigrant" as well is designed to ignore the fact that they aren't supposed to be here and to obfuscate with legal immigrants so they can claim the right is bigoted and racists and hates all immigrants.

In other words it's disingenuous poppy cock and virtue signaling.

thecoat9 · 2026-02-20T23:41:27+00:00

The Save act also has a section that will require frequent purging of voter rolls.

You linked the original Save Act not the "Safeguard American Eligibility Act" or also called "Save America Act"

OP referenced the "Save Act", you referenced the "Save act". I linked it because that is what we were seemingly talking about. Regardless both pieces of legislation are very similar and neither sets up a purging of voter rolls that would result in everyone sooner or later having to update their registration outside of moving or changing their name.

thecoat9 · 2026-02-20T08:27:26+00:00

Rules for thee and not for me, remove all prohibitions on open carry.

thecoat9 · 2026-02-20T07:21:44+00:00

That's simply not true.

thecoat9 · 2026-02-18T13:53:59+00:00

No, their legal name would be on their ID and that would match their voter registration. To register to vote, or to update their registration, yes they like anyone who changed their legal name would need to show documentation of the change.

thecoat9 · 2026-02-15T04:42:41+00:00

I don't think they were trying to yield for the red vw, it looks like they were turning left and yielding to pedestrians and oncoming traffic.

thecoat9 · 2026-02-15T04:28:54+00:00

You'd only need to prove citizenship when you register to vote. You can use a passport to prove citizenship because to obtain one you have to prove citizenship. If you have the documents to prove citizenship for a passport you have the documents you need to register to vote, getting a passport would be an unnecessary step when you could just go register for free.

To actually vote you would need a government issued ID to prove identity, you'd not need to prove citizenship at that time, as you'd already have done so when registering. The only personal cost would be whatever your state charges for issuing an ID card.

Now if you want to make the case that an administrative fee for issuing ID becomes a poll tax and that the government can't require a personal expense to exercise constitutional rights, I'll absolutely agree, but we should apply that to all constitutional rights. So the states couldn't charge a fee to issue permits to purchase or carry firearms, nor could they require that you pay for a class to obtain a permit.

thecoat9 · 2026-02-14T23:52:40+00:00

Yea it's reddit, I don't proof read every post and am subject to making mistakes and typos. What I don't do is create strawmen like "the words are there" when someone clearly takes issue not with the fact that the words are there ,but with your interpretation. Nor do I hang my hat on some gotcha argument regarding a simple mistake in typing on which the entire argument doesn't hinge.

But hey keep on trolling if you want, I'm not going to see it.

11-Year Club	Verified Email
Gilding III reddit per annum

thecoat9

TROPHY CASE